1 / 20

Ron.Rhoades@FAA

Aging Wiring Trend Analysis extranet.NASDAC.faa.gov. Ron.Rhoades@FAA.gov. Briefing Agenda. NASDAC Mission and Vision EAPAS-AW Objectives EA Data Mart Features AW Data Cube Features Accessing NASDAC. Data Warehouse - OLAP. DBMS. Data Visualization. Domain Knowledge (Customer).

lucy-burt
Download Presentation

Ron.Rhoades@FAA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Aging Wiring Trend Analysis extranet.NASDAC.faa.gov Ron.Rhoades@FAA.gov

  2. Briefing Agenda • NASDAC Mission and Vision • EAPAS-AW Objectives • EA Data Mart Features • AW Data Cube Features • Accessing NASDAC EAPAS AW Briefing

  3. Data Warehouse - OLAP DBMS Data Visualization Domain Knowledge (Customer) Statistics Natural Language Processing Data Mining Data Preparation Reporting NASDAC Mission “NASDAC enhances system safety decision-making by providing high quality safety information, analytical capabilities, services, and technology to the aerospace community.” HOURS 100,000 80,000 60,000 40,000 20,000 Spotfire Display 0 20,000 40,000 60,000 80,000 100,000 CYCLES EAPAS AW Briefing

  4. 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 EAPAS AW Briefing

  5. Aging Wiring Trend Analysis Development Schedule EAPAS-AW Requirements Development W.4.1 W.4.3 Sept. 02 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 W.4.1 = EAPAS Plan Paragraph EAPAS AW Briefing

  6. 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 EAPAS AW Briefing

  7. 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 EAPAS AW Briefing

  8. Overview of Technical Approach Analysis & Review (Workstation) NASDAC Staging Area OLAP AFS-600 SDR Data NASDAC Portal nn97 Filter AW Dataset Mm/yy EAPAS Key-based Integration Designed Reports AirClaims Data Text Assessment Process 30-day Update Cycle ACO Users AW Thesaurus Ver N.n AW Dataset (Preprocessing 30-day Cycle) NASDAC User Group (Thesaurus Mgmt) EAPAS AW Briefing

  9. 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. EAPAS AW Briefing

  10. 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))? EAPAS AW Briefing

  11. Results of Query The number of records matching the query . This is a copy of the SQL Code in the query. This size of the database in records. This link will take you to the specific record. EAPAS AW Briefing

  12. 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 AW Thesaurus Ver 0.1 SME Domain: Electrical Wiring Systems EAPAS AW Briefing

  13. Prototype On-line User Interface This selection invokes synonyms to “broken”, e.g., broke, break Thesaurus Menu Options EAPAS AW Briefing

  14. 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. EAPAS AW Briefing

  15. 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) EAPAS AW Briefing

  16. Aging Wiring Sheet View This is the selected sheet The user may select an operator’s fleet EAPAS AW Briefing

  17. Cube Drill-down Results The few records in the database show early voluntary participation This line shows total records with “wire” specified This “blank” line shows system wiring records total The “-” indicates drill-down complete. The “+” indicates records below for drill-down. EAPAS AW Briefing

  18. 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. EAPAS AW Briefing

  19. 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] EAPAS AW Briefing

  20. Questions ? Questions? EAPAS AW Briefing

More Related