1 Introducing Oracle Airlines Data Model

What is Oracle Airlines Data Model?

Oracle Airlines Data Model is a standards-based, pre-built approach to airline data warehousing enabling an airline company to realize the power of insight more quickly. Oracle Airlines Data Model reduces costs for both immediate and on-going operations by leveraging out-of-box Oracle based Data Warehouse and Business Intelligence solutions, making world-class database and business intelligence technology solutions available with an airline business specific data model.

Oracle Airlines Data Model offers a single-vendor solution package that is tightly integrated with the business intelligence platform. With pre-built data mining, Oracle Online Analytical Processing (Oracle OLAP) and dimensional models, Oracle Airlines Data Model provides you with industry-specific metrics and insights that you can act on immediately to improve your bottom line. These business intelligence solution offerings take advantage of Oracle's scalability and reliability, using Oracle's familiar optimization, parallelism, and performance engineering within the database.

Oracle Airlines Data Model can be used in any application environment and is easily extendable.

Oracle Airlines Data Model, combined with Oracle technology, provides all of the components required for a complete and extendable Airlines Data Warehouse and Business Intelligence framework to eliminate complex and costly integration requirements, all designed to reduce your total cost of ownership.

What Are the Benefits of Using Oracle Airlines Data Model?

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

Oracle Airlines Data Model provides the following features:

• Query and Reporting for information: provides extraction of detailed and summary data.

• OLAP for data analysis: provides summaries, trends, and forecasts.

• Data Mining for insight and prediction: provides knowledge discovery of hidden patterns and insights.

Oracle Airlines Data Model provides an off-the-shelf data warehouse framework that is both adaptable and extendable. Alignment with Airline industry standards ensures interoperability with other systems. The pre-built, pre-tuned data model with intelligent insight into detailed airline and market data, allows you to quickly gain value from your data warehousing effort, supports diverse analytical requirements, and assists in building future analytical applications. Fast, easy and predictable implementation reduces risks and enables you to achieve strategic value more rapidly by eliminating deployment delays and expenses associated with built-from-scratch or proprietary data warehouse solutions.

What Are the Components of Oracle Airlines Data Model?

Oracle Airlines Data Model includes the following components:

• Logical Model and Dimensions

  Chapter 2, "Logical Data Model" describes the logical data model and the dimensions entities.

• Physical Model

  Chapter 3, "Oracle Airlines Data Model Physical Data Model" describes the physical data model. The logical to physical mapping is detailed in Chapter 4, "Oracle Airlines Data Model Logical to Physical Mapping". Chapter 5, "Oracle Airlines Data Model Partitioning" provides the partitioning strategy for the Oracle Airlines Data Model physical base, derived, and aggregate tables.

• Intra-ETL database packages and SQL scripts to extract, transform, and load (ETL) data from one layer of Oracle Airlines Data Model to another.

  The intra-ETL packages and SQL scripts are described in detail in Chapter 6, "Oracle Airlines Data Model Intra-ETL".

• OLAP Models for Oracle Airlines Data Model

  Chapter 7, "Oracle Airlines Data Model OLAP Model Dimensions" and Chapter 8, "Oracle Airlines Data Model OLAP Model Cubes" describe the OLAP Models.

• Pre-defined Data Mining Models

  These models are described in detail in Chapter 9, "Oracle Airlines Data Model Data Mining Models".

• Utility Scripts

  The utility scripts are described in Chapter 10, "Oracle Airlines Data Model Utility Scripts".

• Sample reports and sample dashboards

  Chapter 11, "Oracle Airlines Data Model Sample Reports" shows sample reports.

• Installation scripts

  For more information on installation, refer to the Oracle Airlines Data Model Installation Guide.

Oracle Products That Make Up Oracle Airlines Data Model

Several Oracle technologies are involved in building the infrastructure for Airline business intelligence.

Oracle Database with OLAP, Data Mining and Partitioning Option

Oracle Airlines Data Model utilizes a complete Oracle technical stack. It leverages the following data warehousing features of the Oracle database: SQL model, compression, partitioning, data mining, and online analytical processing (OLAP).

Oracle Development Tools

Table 1-1 shows the tools you use to customize the predefined physical models provided with Oracle Airlines Data Model, or to populate the target relational tables and OLAP cubes.

Oracle Business Intelligence Suite Enterprise Edition Presentation Tools

Oracle Business Intelligence Suite Enterprise Edition is a comprehensive suite of enterprise Business Intelligence products that delivers a full range of analysis and reporting capabilities. You can use Oracle Business Intelligence Suite Enterprise Edition Answers and Dashboard presentation tools to customize the predefined sample dashboard reports that are provided with Oracle Airlines Data Model.