Ron Rhoades FAA gov Briefing Agenda NASDAC Mission

Ron. Rhoades@FAA. gov

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 Data Visualization Natural Language Processing Spotfire Display 100, 000 DBMS Domain Knowledge (Customer) 80, 000 Statistics Data Mining 60, 000 40, 000 20, 000 Data Reporting 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 Sept. 02 W. 4. 1 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 ASYled team ¯ Deliver Process Knowledge [Comments - Oral and Written] ¯ Deliver Airworthiness Certification Decision Knowledge [same] Team Objectives November 2002 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 AW Briefing EAPAS Analysis Capability 6

EADM Composition Merged Datasets SDR Data Air. Claims 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 Air. Claims Data 30 -day Update Cycle OLAP nn 97 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 AW s ru esau Th. 1 Ver 0 § 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 − Provide state-of-the-art technologies for safety issue analysis NASDAC Management Data Mission progression: Information Timely Field 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