Oracle Airline Data Model

The Oracle corporation announced in the spring of 2012 release of a data model of Oracle Airline Data Model which as an option of databases supplements an extensive portfolio of the applications and technological solutions helping airlines with cost reduction and business risks.

Oracle Airline Data Model represents the database scheme (database schema) based on standards, previously created which helps airlines to optimize collecting, storage and information analysis about passengers, the sale of tickets, management systems for business operations arriving from booking systems, points, programs for often flying passengers, support services, financial systems and other sources, in corporate data warehouses.

The new industry data model of Oracle Airline Data Model available as DBMS Oracle Database option 11g Enterprise Edition provides the exhaustive database scheme for the information about passengers, difficult analytics, assessment of trends and the automated extraction of the hidden information from data arrays (data mining).

Oracle Airline Data Model is a part of industry solution for Oracle Passenger Data Management airlines which also includes the optimized hardware and software system Oracle Exadata Database Machine and the corporate platform for the business analysis of Oracle Business Intelligence Enterprise Edition 11g. The solution Oracle Passenger Data Management provides to airlines the ready data warehouse about passengers.

Oracle Airline Data Model and Oracle Passenger Data Management are developed to help airlines to reduce and simplify process of data migration about passengers from legacy systems and to consolidate the data obtained from numerous separate repositories.

"To save and expand the customer base in extremely competitive business environment, airlines should be able quickly and easily collect and analyze data on passengers. So they will be able to provide the best service quality, – Cetin Ozbutun, the vice president of Oracle for the Data Warehousing Technologies direction emphasized. – Oracle Airline Data Model facilitates this task, providing an exhaustive data model about passengers together with a ready set of industry key performance indicators (KPI), the preconfigured OLAP cubes for the multidimensional analysis and the data mining procedures for the predictive analysis. Having built the data warehouse on technologies of Oracle, airlines will quickly feel advantages of the made choice".

The extensive portfolio of applications and technological solutions of Oracle for the sphere of air transportation allows airlines to upgrade transaction platforms, to increase flexibility, efficiency and a customer loyalty and also to facilitate observance of legislative directives.

With industry solution of Oracle Passenger Data Management and a data model of Oracle Airline Data Model of airline will be able:

Benefit from rapid implementation and the predicted costs – the data model of Oracle Airline Data Model developed and optimized for Oracle data warehouses (including Oracle Exadata Database Machine), also facilitates expansion and configuring of the existing environments of databases. To quickly analyze data on passengers and business information – Oracle Airline Data Model includes more than 370 tables, 8500 attributes and 250 industry parameters and also the built-in OLAP cubes for the fast multidimensional analysis. Detailed and exact information on passengers will help airlines to segment effectively clients, to analyze data on them and to improve their service.

"The solution for data management about passengers provides to airlines a crucial reference platform for creation and use of service management systems of clients, – Vijay Anand, the senior director and the head of the global Oracle Travel, Transportation and Logistics direction noted. – The solution Oracle Passenger Data Management provides airlines ready to deployment, the powerful data warehouse for migration in it of data on passengers – as historical, placed in data marts and legacy business systems, and operational – arriving from the most different sources, including armoring points, the websites of airlines, mobile devices and social networks. The built-in analytical Passenger Data Management tools will provide airlines with the key knowledge of clients necessary for personalisation of aviaservices".