集装箱码头数据仓库的设计与实现摘要随着信息技术的迅猛发展，数据仓库技术在信息技术领域已经成为了研究的热点，并且日益成熟，成为信息技术领域的前沿技术。实践证明，数据仓库的建立给企业带来丰厚的收益，集装箱码头也期望能通过数据仓库的建立来提升企业的核心竞争力。本论文以集装箱码头数据仓库项目需求为基础，致力于研究集装箱码头数据仓库吞吐量主题的设计方法与应用，通过对集装箱码头业务的分析和整理，选择合适的技术路线和数据仓库架构，实现数据仓库的建立。ETL设计是数据仓库的核心，在本论文中也不例外，论文使用大量的篇幅介绍了ETL的设计方法。为了减少对源系统的影响，设计合适的ETL显得尤为重要。作者在充分分析集装箱码头业务和数据仓库技术的基础上，设计了基于时间的ETL方式。项目中采用维度建模的方式实现了集装箱码头吞吐量多维数据集，最后选择微软公司的SQLServer2008作为数据仓库存储系统，对外提供吞吐量多维数据集进行查询与分析。关键词：数据仓库，集装箱码头，ETL，维度建模，吞吐量AbstractWiththerapiddevelopmentofinformationtechnology,datawarehousetechnologyinthefieldofinformationtechnologyhasbecomearesearchfocus,andmoremature.Practicehasprovedthatdatawarehousebringthehugeprofitstotheenterprise,throughthecontainerterminalisalsoexpectedtoestablishadatawarehousetoimprovethecorecompetitiveness.Thoughthedatawarehouserequementsoftheprojectatcontainerterminal,theauthordedicatedtotheresearchthedatawarehousedesignmethodandapplicationsforcontainerterminalonthemeofcontainerthroughput,thenchoosetheappropriatetechnologyroadmapanddatawarehousearchitecturetofinishtheestablishmentofthewarehouse.ETListhemostimportantpartindatawarehouseconstructing,it'salsointhispaper,theauthorspendalargeamountofspacetodescribethedesignmethodofETL.Inordertoreducetheimpactonthesourcesystems,ETLdesignisparticularlyimportant.TherequirementsofContainerterminalisfullyanalysisbyauthor,andthenstudyonthebasisdatawarehousetechnology,sotheETLbasedontimewaschoose.Dimensionalmodelingwasusedtodesignthemulti-dimensioncubeofcontainerterminalthroughputinthisproject.Finally,thesourcedatawerestoredinMicrosoftSQLServer2008,andsupplythemulti-dimensioncubetoviewandanalysis.KeyWords：dw,containerterminal,ETL,dimensionalmodeling,throughput目录摘要...............................................................................................................................iAbstract.........................................................................................................................ii图目录........................................................................................................................III表目录........................................................................................................................IV第1章绪论.................................................................................................................11.1课题背景...............................................................................................................11.2主要的研究内容...................................................................................................21.3本章小结...............................................................................................................3第2章数据仓库相关技术介绍.................................................................................42.1数据仓库的发展...................................................................................................42.2数据仓库的实...
