【作者】 陆忠良；

【导师】 苏厚勤；

【作者基本信息】 东华大学 ， 计算机应用技术， 2008， 硕士

【摘要】 数据仓库是面向主题的、集成的、稳定的、随时间变化的数据集合,旨在支持管理者决策。数据仓库技术在国外已经取得广泛的应用,而在我国的应用属起步阶段。轨道交通AFC(自动售检票)系统随着我国城市轨道交通事业的发展,得到了相当大的发展,并且己经建立了较完善的联机事务处理系统。多年的应用也使得轨道交通运营公司积累了大量的数据,其中隐含着大量有价值的信息。如何利用这些数据,深层次地挖掘信息,为运营决策服务,己成为轨道交通运营公司的当务之急。作者通过查阅资料了解了国内轨道交通行业在数据仓库技术和数据挖掘分析应用方面的现状,发现该行业信息化基础建设己经做得比较好,AFC系统也正在广泛应用,其数据库中存储了大量的数据。但由于各种原因,在数据仓库技术应用和数据分析方面一直处在观望状态,没有真正开展起来。本文分析了这种现状,针对应用上的问题,较为详细介绍了数据仓库方面的知识,如数据仓库的定义、结构,ETL(抽取、转换和装载)的定义、工具和应用过程,以北京和南京轨道交通AFC系统为基础,研究分析在该业务系统上建立数据仓库的一些过程和技术。本文介绍了数据仓库技术的发展现状和基本原理以及构建数据仓库的相关技术。根据AFC的特殊情况解决了建立数据仓库系统的基本问题,设计建立了符合DSS(Decision Support System)分析需求的数据仓库模型,重点提出并完成了两种针对AFC系统的ETL程序,实现了在数据仓库多维模型上的在线分析和数据分析报表展现,为数据仓库在轨道交通运营公司的应用提供了基本理论依据和解决方案。最后对系统进行了测试,系统运行平稳,性能良好,表明设计的ETL工具可较好的完成数据仓库的ETL需求,且具有易于使用,灵活性强的特点。更多还原

【Abstract】 Data warehouse is a data set which is subject-oriented, integrated, steady and time-variant, it is suitable for manager to support decisions. Data warehouse technology has been abroad made a wide range of applications, and its application in China just belongs to start. Automatic fare collection (AFC) system of rail transit has been considerably developedt with city’s rail transit development in China, and the on line transaction processing system more completed has been builded. Large amounts of data have been accumulated of AFC operation company of rail transit after application in many years, which implied a large number of valuable information. How to use these data to mine informations in depth for servicing the operation decisions is becoming the important things at present of the operation company of rail transit.Through refering to the materials to understand the application status at present of the data warehouse technology and data mining analysis of rail transit industry in China, finding the infrastructure of the information system has been doing well of the industry, AFC system is also widely used, and its database has stored a large number of data. But for a variety of reasons, the status is still in a wait-and-see in the aspects of technology applications of data warehouse and data analysis, and without really carrying out.This paper analyses the status and makes a detailed introduction of the knowledges on data warehouse, such as the definition of the data warehouse, structure, ETL (extract, transform, loading), ETL tools and application process. In terms of the basis of the AFC systems in Beijing and Nanjing rail transit, the author had researched of and analysed some process and relative techniques to building a data warehouse on the business systems.The paper introduces the technique development status at present and basic principles of data warehouse as well as the relative thchniques to construct a data warehouse. In terms of the special circumstances of AFC, the author resolves the basic problems of constructing data warehouse, designs and establishes a data warehouse model that is suitable for the analysis demands of Decision Support System (DSS), proposes and completes in highlight two sets of ETL program aimed at the AFC systems, implements the on-line analysis and data analysis report displays on multi-dimensional data warehouse model, provids basic theorys and solutions on the application of data warehouse for operation company of rail transit.Finally, the system has been tested. The system runs smoothly, and has good performance. It proves that the ETL tools designed can complete ETL requirements of the data warehouse very well, and has features of easy-to-use and good flexibility.更多还原