The Application Of Data Warehouse Technology In The Management Of The Airport

In recent years, data warehouse technique is more and more in the domestic and foreign enterprises. In addition, with the further opening of market and growing of competition in the business, the demand of analysis on business-to-market, monitoring and evaluation on operational status are increasing. There will be more enterprises to build data warehouse system. How to build data warehouse systems to meet enterprise's requirement of flexible and various statistic and analysis is an important issue of data warehouse construction.Through a data warehouse system-building process in an airport management system, the paper put forward some methods in the establishment data warehouse processing. And it analyzed the application background of the data warehouse, summarized the basic technique of data warehouse, and investigated the airport of data warehouse with reference to the characteristics of airport management. According to the demands of data warehouse in the airport management, joining together the future probably of change. I set up a data mart taking the data of the flight schedule as the example, analyzing operation in airport, income of identical route and operation of identical airport in various airlines, and so on. The data mart and data modeling completes in ODS (Operational Data Store) and data warehouse. Each type of data modeling in data warehouse adopts star structure. Proceeded the verification, tidy up and sample the original scheduled flight data, the sample data storage in the ODS table, which making use of the advantage of ODS technique that it is Very easy to gather dynamic loading to the fact table and the dimension table after gathering together data sources, checking unity and integrity, at the same time it guarantees data security. The sample data uses ETL(pdi-open-3.1.0-826) tool, dynamic loading through the storage process to program realization, the cube modeling uses schema workbench, making use of Mondrian tool(the OLAP engine) carried to display, that schema workbench takes the XML document form load front-end through our re-development to Mondrian, through front-end load the rule of the XML to access the fact table and the dimension table of the database to carry to display active enrich reports and graphs. This thesis contents for studying to design and implementation the data warehouse have the widespread meaning, is a kind of very practical data warehouse solution, have the extensive application value to set up business enterprise the data warehouse.