基于OLTP數(shù)據(jù)庫的數(shù)據(jù)分析建模過程的研究.pdf

1、重慶大學碩士學位論文基于OLTP數(shù)據(jù)庫的數(shù)據(jù)分析建模過程的研究姓名：王蘭申請學位級別：碩士專業(yè)：計算機系統(tǒng)結構指導教師：程代杰19990301重慶大學硬圭學健論文Abstract豳Abstract四Today，OnLineAnalyticalProcessing(OLAP)，which趣alsocalledMulti—DimonsionalAnalysis(～匠A)，isapopularchoiceforbusinessanalysis

2、problemsThispaperpresentsanintegratedschemeofanalyzing，&signingandimplementing0瑚systembased011勰existing0簸PsysteminClient／ServerenvironmentItaimsate)(tendingthecurrentfunctionali押ofOLTPsystematthelowestcostsothatthe_118螺c

3、镕trtanalyzethemultidimensionaldatain盤丑捌僦andintuitiveway鈾eprojectthepaperbasedonis“曩站ManagementInformationSystemforChortgqingLianglukouDepartmentStoreCoLl吐”Duringtheimplementationofthesystemweadoptthe轉p瑤雛andsophisticatedt

4、echnologyandSoftwaredevelopingplatform，includingClient／Serversystemarchitecture，WindowsNToperatingsystem，MicrosoftSQLServerDBMS，WarehouseArchitectCASEtoolandPowerBuilderdevelopingt001Inordertoprovidethemaaagerswithdecisi

5、onsupportsinMISsystemtthemethodof劃粉ABasedollOLTP(MultiDimensionalAnalysisBasedonOL謹)hasbeenproposedinthispaper，Itappliesauserdriven，subjectorientedandmultidimensionaldatamodelingtechniqueFirstly，aERmodeldescribingtheOL黯s

6、ystemneed埝betransformedtoa∞搿l崧瀚匪dammodel一轟葒》AT(MultidimensionalAnalysisTree)modelThen，theMDATmodelcanbeeasilymapwdtoaStarSch黜namodel，whichisdesignedforqueryoptimizedpatternandcanbeoptimized酶storingpreaggregateddatainmidd

7、letables，F(xiàn)inally，thephyrsicaldatamodelandtheMDAdatabasecanbebuiltthroughWarehouseArchitectBystoreddatainthe∞瑚￡躺醚K黔Adatabase，theperformanceoftheoL下PdatabasewillnotbecompromisedT蛔appficationsbasedollthismethodaleveryflexib

8、leintranslatingtheuser’smulfidiruensionalqueriestoSQL碼emiddletablesstoredpreaggregateddatacaneliminmetherepeatingresourrⅪintensivecalculationsandimprovetheperformanceofcomplexqueries，Withthismethod，we’vefinished“TheSales