Data Warehouse Technology

Jupiter Data Warehouse

Overview
The participants of CDM, a joint government/industry initiative, have worked together to foster concepts to enhance the safety and efficiency of the National Airspace System (NAS). A major hurdle in performing analysis on CDM related efforts has been the lack of an integrated data source. The Jupiter Data Warehouse gives users the ability to perform in depth data analysis utilizing one central integrated data source spanning a long period of time. The merge of the data sources is made possible through a process known as the ETL (extraction, transformation, and loading). During the ETL process, the data is extracted from the data sources and then put through numerous transformations and quality checks before finally being loaded in the Data Warehouse. The front end of the Data Warehouse is a 3rd party reporting and analysis business intelligence tool called Business Objects. Business Objects allows users to do analysis and create professional reports both quickly and easily.

Capability Features
Integrated data source ETL data source merge Business Objects front end analysis business intelligence Long range of integrated flight data Report and analysis capability without user understanding of SQL or database structure Contains ADL and ETMS flight data

Benefits
The Data Warehouse offers a long range of integrated flight data to be available at all times. The warehouse is designed in a way that will optimize query performance, particularly with data mining efforts. In addition, it offers improved data quality and data access and provides the data infrastructure to support the development of future CDM analytical tools and processes.

The Business Objects front end tool allows users to access the Data Warehouse and other data sources to create reports and perform analysis without having to understand the database structures or SQL. This results in greater productivity, consistency, and efficiency across CDM analysis efforts.

Deployment
The first version of the Flight Data Warehouse was deployed in Spring 2004. This version combines flight data from both the ADL and ETMS feeds. Anticipated future enhancements include incorporating more data sources such as GDPE and ASPM. Training on Business Objects occurred in the first quarter of 2004. Users access both FSA and POET with the Business Objects tool and connect and create reports against the Flight Data Warehouse.

Jupiter Data Warehouse GUI

Download Overview