节点文献
航空票务系统OLAP数据仓库设计与实现
Design and realization of OLAP data warehouse in air ticket system
【摘要】 如何对航空票务系统中累积的海量数据进行分析处理从而为决策提供支持,已经成为航空票务系统亟待解决的问题。通过对航空票务系统的研究,提出了利用联机分析处理和数据仓库技术建立决策支持系统的解决方案。详细论述了航空票务决策分析系统中数据仓库模型与多维数据集的建立,以及数据的抽取、转换、加载和分析结果的前端展现,并且对利用表分区技术解决决策系统中海量数据的存储问题进行了重点论述。
【Abstract】 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.
【Key words】 on-line analytical processing; data warehouse; partitioned tables; multidimensional datasets; air ticket system;
- 【文献出处】 计算机工程与设计 ,Computer Engineering and Design , 编辑部邮箱 ,2009年02期
- 【分类号】TP311.13
- 【被引频次】18
- 【下载频次】584