决策支持系统中数据仓库的研究与实现

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

1、中南大学硕士学位论文决策支持系统中数据仓库的研究与实现姓名：蒋韶生申请学位级别：硕士专业：计算机应用技术指导教师：陈松乔;张祖平20050101决策支持系统中数据仓库的研究与实现ABSTRACTDataV，arehouse(DW)isanewtechnologyofdataprocessinganddatamaIlagingchatdeVelopsVe巧fastinrecentyears．ItsappearallcehasgreatlyacceleratedthedeVelopmentofDecisionSupportSystems’(DSS)theoryr

2、esearcha11dap—ication．ByusingDwtechnologyintheconstructionofDSS，theexistingdata坨sourcecanbemadefulluseofandtllemallagememleVelcanbeimprovede伍ciently．ThetheoⅨmethodandapplicationdiscussionbasedonDWtechnologyhasbecomearesearchhotspotofDSScurrently．ThispaperisbasedonmebackgrouIldofthe

3、WEBDecisionSupportSystemforBall虹ng．TheDWmodelinganditsapplicationinDSSarestudied．Atfirst，thebimlanddevelopingstatllsofDSSa11dthenewestdevelopmentofthedatabasetecllIl0109yaredesc舶ed．ThereasonwhyDWtechnologycomesintobeing⋯-theneedoftheDSS’sdeVelopment，isanaJyzed．ThebuildingofDWisnotm

4、eanttoreplacethedatabase，buttobuildanaIlalysisenViromentbasedona11entireaIldperfectinfbmationapplicationtosupport11igh—leveldecision．Thent11etechllicaltheouofDwisexpouIlded，thememodsofDwsystemtsdesignanditssoRwaredeVelopingarediscussed．MeanwKle，ancw仔ameworkofDSSispresented．Thestres

5、softhispaperismemOdelillgresearchoftheDWsystema11doptimizingquer)，ofits．7nleDWmodelingmemodandrealizationtecllllologywhichmiddle—dimensionalon印叭-regiononDWwithMultidimensionalStarSchema(MSS)arebroughtforwardaRerdetaileddiscussionofObject-OrientedAnalysisandSubject-OrientedAnalysis．

6、IntheapplicationofmeaforementionedtheoⅨThedeSignofDatabase’ssystemmodelonDSSiselaborated，includingdatamodeling，thechoiceandrealizationofrelationaldatabaSe．OnmebaSisoft11at，someproblemsint11emanagementofDWsuchasMetada：tam锄agement，dataextracting，dataintegratingandhowtoimpr0Vetlleperf

7、omanceof也eDWarediscussedindetail．Meanwhile，tlledataaIlalysisofDWlike0LAPand也edatadiSplayofDWaretakent11eo巧research．Theref．ore，ananalysinganddisplaying缸吼eworkbasedonputdyn锄icregionandstaticregioninDWisputfbr吼协rd．Keywords：DataWarehouse；DecisionSupportSystems；R-elationalDatabase；0n—li

8、neAnalyticalProcessing"一二l