基于数据仓库和OLAP的综合决策支持系统的研究与实现

《基于数据仓库和OLAP的综合决策支持系统的研究与实现》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、广东工业大学硕士学位论文基于数据仓库和OLAP的综合决策支持系统的研究与实现姓名：夏成文申请学位级别：硕士专业：计算机应用技术指导教师：韩坚华20070501￡至二些奎兰：耋堡圭兰竺鲨三AbstractWiththepopularizationofcomputersandrelationaldatabasesystemstremendoussuccess，variousdatabasesystemwithunprecedentedspeedupdevelopmentinallsectorsandextensivea

2、pplicationwhichmakesbusinessbecomenloreaccurate、efficientandmoreaccumulateddataontheexponentialrateofgrowth；facedwithmassivedatamanagementandanalysis，dataspreadbutinformation—poortroublingpolicy-makers．SowemustfindanewtechnologyandmethodstoMiniupusefulinformat

3、ionfromMassiveDataforthepeople’Sdecisiontoprovidesupport．withDataWarehousetechnologyandon—lineanalyticalprocessingtoolforthecontinuousdevelopmentandimprovement，basedonresearchandthedesignofthedatawarehousedecisionsupportsystemEnteredanewdirectionofdevelopment．

4、Atpresent，therearedifferenturbanmanagementinformationsystemsdatawhichhaveproblemssuchasincompatible、howtoshareresourcesandaccumulatedthelargeamountofhistoricaldataovertheyearsbutthatcannotbeeffectively1earn，analysisandotherissues．Therefore，Itishightimethatthee

5、stablishmentoftheGuangzhouCitymanagementdecisionsupportsystembasedondatawarehouseandOLAPtechnologyfortheadministrateranddecisionsprovideassistance．First，thepaperanalyzesthecurrentstateofdevelopmentofthedecisionsupportsystem(DSS)，introuduceddatawarehouseandOLAP

6、concepts，comparisonandanalysisthedatawarehouseandOLAPwiththetraditionaltechnology，Notetheiradvantage．Thento6uangzhouCitymanagementdecisionsupportsystemforexample，describedindetailtheoperationalmanagementstatusofcity，mainbusinessdataandthemaindemandofdecisionsu

7、pportsystem,andgiyentheGuangzboucitymanagementⅡdecisionsupportsystemarchitectureandmodulardesign．Detailsonthedesignandimplementationprocess：first，throughthedataconversionservices(DTS)realizethevariousdatasources’sdataextraction，purification，transformationandlo

8、ading；throughtheOLAPServicestoolprovidedbyMicrosoft，andthefacttablesanddimensionaltablesestablishepart—analysismultidimensionalcubeanalysisdatamodeltomeettheneedsofmulti-dimensiona