This chapter introduces Oracle Airlines Data Model.
Parent topic: Logical and Physical Data Model
Oracle Airlines Data Model is a standards-based, pre-built approach to airline data warehousing enabling an airline 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 On-Line Analytical Processing (Oracle OLAP), Oracle Airlines Data Model provides you with industry-specific metrics and insights that you can act on immediately to improve your bottom line.
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.
Parent topic: Introducing 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.
Parent topic: Introducing Oracle Airlines Data Model
Oracle Airlines Data Model includes the following components:
Logical Model: describes the logical data model.
Physical Model: describes the physical data model, the logical to physical mapping, and the partitioning strategy for the Oracle Airlines Data Model physical base, derived, and aggregate tables.
Intra-ETL scripts to extract, transform, and load (ETL) data from one layer of Oracle Airlines Data Model to another.
OLAP Models for Oracle Airlines Data Model.
Pre-defined Data Mining Models.
Sample reports and sample dashboards shows sample reports.
Parent topic: Introducing Oracle Airlines Data Model
Describes the Oracle technologies that are involved in building the infrastructure for Airline business intelligence.
Oracle Database with OLAP, Advanced Analytics and Partitioning Options
Compression
Partitioning
Data mining
Online Analytical Processing (OLAP)
Oracle Development Tools
The following table 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.
Table 1-1 Oracle Development Tools Used with Oracle Airlines Data Model
| Name | Use |
|---|---|
|
SQL Developer or SQL*Plus |
To create or modify database objects |
|
Analytic Workspace Manager |
To populate the target OLAP cubes |
Oracle Business Intelligence Suite Extended Edition Presentation Tools
Oracle Business Intelligence Suite Extended 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 Extended Edition Answers and Dashboard presentation tools to customize the predefined sample dashboard reports that are provided with Oracle Airlines Data Model.
Parent topic: Introducing Oracle Airlines Data Model