aging wiring trend analysis

8/8/2019 Aging Wiring Trend Analysis

1/20

[email protected]@FAA.gov


2/20

November 2002 EAPAS AW Briefing 2

Briefing Agenda

NASDAC Mission and VisionEAPAS-AW ObjectivesEA Data Mart Features AW Data Cube Features Accessing NASDAC


3/20


NASDAC Mission

NASDAC enhances system safety decision-making byproviding high quality safety information, analytical capabilit ies,services, and technology to the aerospace community.

DomainKnowledge

(Customer)

DataPreparation

DataMining

Statistics

DBMSDataWarehouse

- OLAP

DataVisualization

Reporting

NaturalLanguageProcessing

HOURS

100,000

80,000

60,000

40,000

20,000

0 20,000 40,000 60,000 80,000 100,000

CYCLES

Spotfire Display


4/20


EAPAS-AW Objectives

Section W.4; EAPAS Plan:Strategy - developautomated SDR reporting system, allowingtrend analysis.1. SDR system data dictionary [update] to FAA metadata

repository

2. Produce NASDAC Data Mart Prototype DesignEnhanced Airworthiness Data Mart now available at NASDAC Aging Wiring Data Cube prototype now available at NASDAC

3. Conduct Pre-NPRM Trend AnalysisDemonstration w/Prototype

4. Perform Post-NPRM Trend AnalysisDemonstration w/ Mart & Tools


5/20


Aging Wiring Trend Analysis Development Schedule

EAPAS-AW Requirements Development

NASDAC Extranet Portal Operations

Beta Site Prototype & Test

Sept. 02 May 03Jan. 03

Implement Requirements and Operate OLAP

Install, Test, Announce to Users

Collect Requirements, Demo Prototype

* EADM = Enhanced Airworthiness Data Mart

EADM*Operations

(June)

W.4.2

W.4.3

W.4.4

W.4.1 = EAPAS Plan Paragraph

W.4.1


6/20


Requirements Team Activity

ACO Representative Individual Role & ObjectivesProvide certification engineering expertise (SME) to the ASY-led team Deliver Process Knowledge [Comments - Oral and Written] Deliver Airworthiness Certification Decision Knowledge [same]

Team ObjectivesDefine 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 commentBeta software exercise, review and commentAffirm and validate Trend Analysis Capability

Enable a predictive analytical mode


7/20


EADM Composition

SDR DataAirClaims Data*

Aircraft N, Make, Model, Series

Exposure:Aircraft Mfr DateAircraft Flight Hours

Aircraft Cycles

*Large Transport Aircraft

Merged Datasets


8/20


Overview of Technical Approach

AWDatasetMm/yy

AirClaimsData

EAPASKey-basedIntegration

AFS-600SDRData

nn97Filter

30-dayUpdateCycle

TextAssessment

ProcessAW

Thesaurus

Ver N.n

Analysis&

Review

DesignedReports

AW Dataset(Preprocessing30-day Cycle)

ACOUsers

NASDACUser Group

(Thesaurus Mgmt)

NASDACStaging Area

NASDAC

Portal

(Workstation)OLAP


9/20


NASDAC EADM

Secondly, we offerthe Cube View

Metadata about the

data set

There are two strategies toapproaching the database:

One is the queryapproach.


10/20


Simple Query Illustration

This field is for textsearches of the SDR

narrative.

This active field isused to select amanufacturer.

This active field isused to specify themodel 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))?


11/20


Results of Query

This size of thedatabase in records.

The number of recordsmatching the query .This is a copy of the SQL

Code in the query.

This link will takeyou to the specific

record.


12/20


Prototype Aging Wiring Thesaurus Specifications

Specifications 900 Terms

425 Synonymous Relationships

Maximum of 3 hierarchical levels

275 Top Terms

270 Narrower/BroaderTerms Relationships

315 Related TermRelationships

A W

T h e s a u r u s

V e r 0 . 1

SME Domain: Electrical Wiring Systems


13/20


Prototype On-line User Interface

Thesaurus Menu OptionsThis selection invokes

synonyms to broken, e.g.,

broke, break


14/20


Prototype On-line Results

This Result 5 RecordsOther result w/o Thesaurus (exact match) 3 Records

Also expect to investigate Oracles fuzzylogic for typos and stem [term] matching.


15/20


Data Cube View Worksheet Aircraft by Age

Aircraft Age in Years (Row)

Worksheet Viewsmay be customized

to user specifications

Manufacturer(Column)

Manufacturer SDRTotal


16/20


Aging Wiring Sheet View

This is the selectedsheet The user may select

an operators fleet


17/20


Cube Drill-down Results

This line shows totalrecords with wire

specifiedThis blank line shows

system wiring records total

The - indicates drill-down complete.

The + indicates recordsbelow for drill-down.

The few records in thedatabase show early

voluntary participation


18/20


Trend Analysis Illustration

The Pareto principledescribes aphenomenon inwhich 80 percent of variation observedin everydayprocesses can beexplained by a mere20 percent of thecauses of thatvariation.

Pareto Chart


19/20


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 AwarenessData ManagementTimely Field Information

NASDAC Mission progression:- Provide state-of-the-art

technologies for safety issueanalysis

Welcome to Visit our Demonstration Table andNASDAC [HQ Room 1006]


20/20


Questions?

Questions ?

aging wiring trend analysis

Documents