搜索
浙江大学硕士学位论文Abstracti集装箱码头数据仓库的设计与实现摘要随着信息技术的迅猛发展，数据仓库技术在信息技术领域已经成为了研究的热点，并且日益成熟，成为信息技术领域的前沿技术。实践证明，数据仓库的建立给企业带来丰厚的收益，集装箱码头也期望能通过数据仓库的建立来提升企业的核心竞争力。本论文以集装箱码头数据仓库项目需求为基础，致力于研究集装箱码头数据仓库吞吐量主题的设计方法与应用，通过对集装箱码头业务的分析和整理，选择合适的技术路线和数据仓库架构，实现数据仓库的建立。ETL设计是数据仓库的核心，在本论文中也不例外，论文使用大量的篇幅介绍了ETL的设计方法。为了减少对源系统的影响，设计合适的ETL显得尤为重要。作者在充分分析集装箱码头业务和数据仓库技术的基础上，设计了基于时间的ETL方式。项目中采用维度建模的方式实现了集装箱码头吞吐量多维数据集，最后选择微软公司的SQLServer2008作为数据仓库存储系统，对外提供吞吐量多维数据集进行查询与分析。关键词：数据仓库，集装箱码头，ETL，维度建模，吞吐量浙江大学硕士学位论文AbstractiiAbstractWiththerapiddevelopmentofinformationtechnology,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浙江大学硕士学位论文目录I目录摘要...............................................................................................................................iAbstract........................................................................................................................ii图目录........................................................................................................................III表目录.......................................................................................................................IV第1章绪论................................................................................................................11.1课题背景.............................................................................................................11.2主要的研究内容.................................................................................................21.3本章小结..............................................................................................................3第2章数据仓库相关技术介绍................................................................................42.1数据仓库的发展.................................................................................................42.2数据仓库的实现过程.........................................................................................52.3新兴数据仓库解决方案.....................................................................................52.4本章小结.............................................................................................................8第3章业务整理与项目规划....................................................................................93.1业务状况介绍.....................................................................................................93.1.1信息系统应用状况....................................................................................103.1.2报表数据的需求........................................................................................103.1.3其他需求.....................................................................................................113.2数据仓库系统阶段规划....................................................................................113.3预期产出成果....................................................................................................113.4架构设计...........................................................................................................123.5本章小结...........................................................................................................15第4章数据存储结构设计......................................................................................164.1数据定义的统一...............................................................................................164.2数据源结构描述...............................................................................................164.3企业数据标准化...............................................................................................184.4数据仓库数据结构...........................................................................................194.4.1数据仓库表结构........................................................................................194.4.2目标数据与源数据的对应关系................................................................214.5本章小结...........................................................................................................22