基于ANALYSISSERVICES的OLAP系统的设计与实现

《基于ANALYSISSERVICES的OLAP系统的设计与实现》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、南开大学硕士学位论文基于AnalysisServices的OLAP系统的设计与实现姓名：迟凯申请学位级别：硕士专业：计算机软件与理论指导教师：袁晓洁20040501南开人学硕i。论文ABSTRACTTitleoftheMasterDegree'sThesis：TheDesignandDevelopmentofanOLAPSystemBasedOnAnalysisServicesIntroductionoftheAuthor：KaiChi，bomin1978，wasawardedtheBachelorDegreeinPhy

2、sicsinJune2001andenteredtheSoftwareLaboratory4oftheCollegeofInformationTechnicalScienceofNankaiUniversityinSeptemberthesameyear,undertheguidanceofProf．XiaojieYuan．ACandidateforMasterinComputerSoftwareandTheoryinJune2004ABSTRACTWiththecomingofInformationTimes，mana

3、gersandITstaffsindifferententerpriseshavetomakebeaerUSeofthehistoricaldata．Thetraditionaldatabasesystems，aimingaton-linetransactionprocessingapplications，cannotmeettheveryneedofmodementerprisesanylonger．Datawarehouseanddecisionsupportsystemissuchatechnologythathe

4、lpsthepeoplewiththeseproblemsmentionedabove．Ithasmadetheknowledgeworkersshiftedtheirfocusonon。lineanalyticalprocessing(OLAP)whichwillhelpthemnlakemoreeffectivedecisions．Inthisthesis．wemakeastudyofthedatawarehouseandOLAPtechnologyandcomeupwithasolutionagainstthene

5、edofdecisionsupportsystemsofthemodementerprises，involvedwiththebuildingofdatawarehouseandthedevelopmentofOLAPapplications．WiththeanalysisandsummarizationofdifferentkindoftraditionalOLAPsystems，weadoptanewarchitecturebasedonWebServicewhichoffsetstheshortcomingsoft

6、raditionalsystemssuchasbadportabilityanddevelopanOLAPsystemwiththesupporcofAnalysisServicesastheOLAPServer．Andtheclientsystemmakesitpossiblefortheuserstoaccessthedatawarehouseandcompletemostofthemultidimensionalanalyticaloperations．Thesolutioninthisthesispossesse

7、smanymeritssuchaslowcost，goodportability,flexiblearchitectureandiseasytodevelop．It'sapplicabletothemiddle·sizedandsmall—sizedenterprisesandhasexcellentmarketwithfurtherimprovementinthefuture．KeyWords：DataWarehouse，OLAP,DecisionSupportSystem(DSS)南开人学倾I‘论文第一章绪论当今人类

8、社会已经步入信息化时代，信息资源逐渐成为激烈市场竞争中的主导因素。人们对积累下来的数据、信息、知识进行管理和利用的要求越来越高，这就对原有的数据管理方法提出了挑战。从20世纪末开始，数据仓库和联机分析处理(On—LineAnalyticalProcessing，OLAP)技术悄然兴起，为上述问题提出了一种技术方案，并