集装箱码头数据仓库的设计与实现论文.docVIP

集装箱码头数据仓库的设计与实现 摘要 随着信息技术的迅猛发展，数据仓库技术在信息技术领域已经成为了研究的热点，并且日益成熟，成为信息技术领域的前沿技术。实践证明，数据仓库的建立给企业带来丰厚的收益，集装箱码头也期望能通过数据仓库的建立来提升企业的核心竞争力。 本论文以集装箱码头数据仓库项目需求为基础，致力于研究集装箱码头数据仓库吞吐量主题的设计方法与应用，通过对集装箱码头业务的分析和整理，选择合适的技术路线和数据仓库架构，实现数据仓库的建立。 ETL设计是数据仓库的核心，在本论文中也不例外，论文使用大量的篇幅介绍了ETL的设计方法。为了减少对源系统的影响，设计合适的ETL显得尤为重要。作者在充分分析集装箱码头业务和数据仓库技术的基础上，设计了基于时间的ETL方式。 项目中采用维度建模的方式实现了集装箱码头吞吐量多维数据集，最后选择微软公司的SQL Server2008作为数据仓库存储系统，对外提供吞吐量多维数据集进行查询与分析。 关键词：　数据仓库，集装箱码头，ETL，维度建模，吞吐量 Abstract With the rapid development of information technology, data warehouse technology in the field of information technology has become a research focus, and more mature. Practice has proved that data warehouse bring the huge profits to the enterprise, through the container terminal is also expected to establish a data warehouse to improve the core competitiveness. Though the data warehouse requements of the project at container terminal ,the author dedicated to the research the data warehouse design method and applications for container terminal on theme of container throughput,then choose the appropriate technology roadmap and data warehouse architecture to finish the establishment of the warehouse. ETL is the most important part in data warehouse constructing,its also in this paper,the author spend a large amount of space to describe the design method of ETL. In order to reduce the impact on the source systems, ETL design is particularly important.The requirements of Container terminal is fully analysis by author,and then study on the basis data warehouse technology,so the ETL based on time was choose. Dimensional modeling was used to design the multi-dimension cube of container terminal throughput in this project. Finally,the source data were stored in Microsoft SQL Server2008 ,and supply the multi-dimension cube to view and analysis. Key Words：dw,container terminal,ETL, dimensional modeling, throughput 目录 摘要 i Abstract ii 图目录 III 表目录 IV 第1章 绪论 1 1.1 课题背景 1 1.2 主要的研究内容 2 1.3本章小结 3 第2章 数据仓库相关技术