Design and realization of OLAP data warehouse in air ticket system
Luo Xiao-pei · Jisuanji gongcheng yu sheji · 2009
How to analyze the accumulated massive data of air ticket system and provide support for decision-making,has become a problem which urgent need to resolve.By the research of air ticket system,the technology of on-line analytical processing and data wa-rehouse applies to decision-making system solutions.Besides the data extraction,transformation,loading and the front-end show of analysis results,the establishment of data warehouse model and multidimensional datasets is discussed in detail.Emphatically,the ap-plication of partitioned tables in the massive data storage is elaborated.