Transcript No Slide Title

[email protected]
Briefing Agenda
NASDAC Mission and Vision
EAPAS-AW Objectives
EA Data Mart Features
AW Data Cube Features
Accessing NASDAC
November 2002
EAPAS AW Briefing
2
NASDAC Mission
“NASDAC enhances system safety decision-making by
providing high quality safety information, analytical capabilities,
services, and technology to the aerospace community.”
HOURS
Data
Warehouse
- OLAP
100,000
DBMS
80,000
Data
Visualization
Natural
Language
Processing
Domain
Knowledge
(Customer)
Reporting
Spotfire Display
Statistics
60,000
40,000
Data
Mining
20,000
Data
Preparation
0
20,000
40,000
60,000
80,000 100,000
CYCLES
November 2002
EAPAS AW Briefing
3
EAPAS-AW Objectives
Section W.4; EAPAS Plan: Strategy - develop
automated SDR reporting system, allowing
trend analysis.
1. SDR system data dictionary [update] to FAA metadata
repository
2. Produce NASDAC Data Mart Prototype Design
Enhanced Airworthiness Data Mart now available at NASDAC
Aging Wiring Data Cube prototype now available at NASDAC
3. Conduct Pre-NPRM Trend Analysis
Demonstration w/Prototype
4. Perform Post-NPRM Trend Analysis
Demonstration w/ Mart & Tools
November 2002
EAPAS AW Briefing
4
Aging Wiring Trend Analysis Development Schedule
EAPAS-AW Requirements Development
W.4.1
Sept. 02
W.4.3
Jan. 03
May 03
Collect Requirements, Demo Prototype
Beta Site Prototype & Test
Implement Requirements and Operate OLAP
NASDAC Extranet Portal Operations
W.4.4
W.4.2
Install, Test, Announce to Users
EADM*
Operations
(June)
* EADM = Enhanced Airworthiness Data Mart
November 2002
EAPAS AW Briefing
W.4.1 = EAPAS Plan Paragraph
5
Requirements Team Activity
ACO Representative Individual Role & Objectives
Provide certification engineering expertise (SME) to the ASY-led team
 Deliver Process Knowledge [Comments - Oral and Written]
 Deliver Airworthiness Certification Decision Knowledge [same]
Team Objectives
Define computer-based data Trend Analysis Requirements
 Examine Text Mining Thesaurus Technology
 Examine Text Mining Categorization Technique
 Examine Text Mining Data Extraction Technique
Prototype software review and comment
Beta software exercise, review and comment
Affirm and validate Trend Analysis Capability
 Enable a predictive analytical mode
November 2002
EAPAS AW Briefing
6
EADM Composition
Merged Datasets
SDR Data
AirClaims Data*
Exposure:
Aircraft Mfr Date
Aircraft Flight Hours
Aircraft Cycles
Aircraft N, Make, Model, Series
*Large Transport Aircraft
November 2002
EAPAS AW Briefing
7
Overview of Technical Approach
AFS-600
SDR
Data
NASDAC
Staging Area
EAPAS
Key-based
Integration
AirClaims
Data
OLAP
30-day
Update
Cycle
nn97
Filter
Analysis
&
Review
(Workstation)
NASDAC
Portal
AW
Dataset
Mm/yy
Designed
Reports
Text
Assessment
Process
AW
Thesaurus
Ver N.n
ACO
Users
AW Dataset
(Preprocessing
30-day Cycle)
NASDAC
User Group
(Thesaurus Mgmt)
November 2002
EAPAS AW Briefing
8
NASDAC EADM
There are two strategies to
approaching the database:
Metadata about the
data set
Secondly, we offer
the “Cube” View
One is the query
approach.
November 2002
EAPAS AW Briefing
9
Simple Query Illustration
This field is for text
searches of the SDR
narrative.
This active field is
used to select a
manufacturer.
This active field is
used to specify the
model of interest.
Query Purpose:
• Which parts/components are failing,
• Where (aircraft make, model, location)
• When (aircraft age, hours, cycles), and
• How (poor design (chafing)) (poor technique
(incorrect attachment, abrasion))?
November 2002
EAPAS AW Briefing
10
Results of Query
The number of records
matching the query .
This size of the
database in records.
This is a copy of the SQL
Code in the query.
This link will take
you to the specific
record.
November 2002
EAPAS AW Briefing
11
Prototype Aging Wiring Thesaurus Specifications
Specifications
 900 Terms
 425 Synonymous Relationships
 Maximum of 3 hierarchical levels
 275 Top Terms
 270 Narrower/Broader
Terms Relationships
 315 Related Term
Relationships
SME Domain: Electrical Wiring Systems
November 2002
EAPAS AW Briefing
12
Prototype On-line User Interface
This selection invokes
synonyms to “broken”, e.g.,
broke, break
Thesaurus Menu Options
November 2002
EAPAS AW Briefing
13
Prototype On-line Results
This Result – 5 Records
Other result w/o Thesaurus (exact match) – 3 Records
Also expect to investigate Oracle’s “fuzzy
logic” for typo’s and stem [term] matching.
November 2002
EAPAS AW Briefing
14
Data Cube View – Worksheet Aircraft by Age
Worksheet Views
may be customized to
user specifications
Aircraft Age in Years (Row)
Manufacturer SDR
Total
Manufacturer
(Column)
November 2002
EAPAS AW Briefing
15
Aging Wiring Sheet View
This is the selected
sheet
November 2002
EAPAS AW Briefing
The user may select
an operator’s fleet
16
Cube Drill-down Results
This “blank” line shows
system wiring records total
This line shows total
records with “wire”
specified
The few records in the
database show early
voluntary participation
The “-” indicates drilldown complete.
The “+” indicates records
below for drill-down.
November 2002
EAPAS AW Briefing
17
Trend Analysis Illustration
Pareto Chart
The Pareto principle
describes a
phenomenon in
which 80 percent of
variation observed
in everyday
processes can be
explained by a mere
20 percent of the
causes of that
variation.
November 2002
EAPAS AW Briefing
18
Conclusion
AW Requirements Team to complete an examination of:
−
−
−
Thesaurus – Text Mining Technology
Unstructured Data Categorization – Text Mining
Data Visualization – Data Mining-type Examination for Trend Analysis
NASDAC [ASY] Role consistent with CPSRT Direction:
−
Safety Information Awareness
Data Management
Timely Field Information
NASDAC Mission progression:
−
Provide state-of-the-art
technologies for safety issue
analysis
Welcome to Visit our
Demonstration Table and
NASDAC [HQ Room 1006]
November 2002
EAPAS AW Briefing
19
Questions ?
Questions?
November 2002
EAPAS AW Briefing
20