Previous | Page 4 of 4 | Next

The OADM Platform

What Does OADM Deliver?

Predefined, Airline-Specific Models

Oracle Airline Data Model is a pre-built, pre-tested solution designed by industry experts to help airline organizations maximize the value of their Oracle data warehouse.

For example, a partial view of the Subject Booking area ERD is shown below.

Using sophisticated trending and data mining capabilities based on Oracle's OLAP and data mining technology, organizations in the FFP, VIP & Booking Office, SSR and Booking Series now have the data analysis capabilities to develop insights that are relevant, actionable, and can improve both top-line and bottom-line results.

With Oracle Airline Data Model, you can jump-start the design and implementation of a Airline data warehouse to quickly achieve a positive ROI for your data warehousing and business intelligence project with a predictable implementation effort.

Naming Convention for Tables

When examining the predefined tables, keep in mind the naming convention using DW (Data Warehouse) prefixes to identify the types of tables:

• DWR_ : Reference data tables
• DWL_ : Lookup tables
• DWB_ : Base transaction data (3NF) tables
• DWD_ : Derived (data mining) tables
• DWA_ : Aggregate (ROLAP and MOLAP) tables

Previous | Page 4 of 4 | Next