數(shù)據(jù)倉(cāng)庫(kù)查詢優(yōu)化方法及索引技術(shù)研究.pdf

1、合肥工業(yè)大學(xué)碩士學(xué)位論文數(shù)據(jù)倉(cāng)庫(kù)查詢優(yōu)化方法及索引技術(shù)研究姓名：郭峻峰申請(qǐng)學(xué)位級(jí)別：碩士專業(yè)：信息管理與信息系統(tǒng)指導(dǎo)教師：倪志偉20100401ResearchofQueryOptimizationandIndexofDataWarehouseAbstractBusinessintelligencemarketscaleflourishesunconventionallyThethreemainsupportingtechnologie

2、sofBI，datawarehousing，onlineanalyticalprocessinganddatamining，arealsothehottopicofacademicresearchanddiscussionDatawarehouseswhichstoresvolumesofhistoricaldataarethestructureddataenvironmentofdecisionsupportsystemandonli

3、neanalyticalprocessing，andonlineanalyticalprocessingalsoinvolvesthecomplexqueriesinmassdataTherefore，toenhancetheefficiencyofdatawarehousequeriesbecomesoneofthekeyissuesofimprovingtheefficiencyofdatawarehousingapplicatio

4、nsandonlineanalyticalprocessingapplicationsThisdissertationintroducesthetheoreticalbasisofdatawarehouseandonlineanalyticalprocessingtechnologyatfirst，thenthediscussionsfocusontheanalysisofdatawarehouse’SqueryperformanceT

5、herearemainlythreemethodstosolvetheproblematcurrent：materializedview，queryoptimizationandindextechnologyThispaperintroducestheclassificationofindexandgivesadetaileddescriptiononbasicconcepts，principlesandmethodsofcommonl

6、yusedindextechnologiesindatawarehouse，includingtheBtree，B—tree，Btree，B木tree，bitmap，invertedindex，joinindexandhashtableBasedontheabove，thispaperproposesanewintegrativeindexmodelwhichiscalledBBIandgivesthemethodstobuildand

7、usethemodelBasedonthefeatureofDataWarehouseandOLAPqueries，thisindexmodelisbuiltwithinvertedindex，aggregationtable，bitmapindexandbtreeItnotonlygreatlypromotestheefficiencyoffrequentlyusedqueriesbutalsoimprovestheperforman

8、ceofotherqueriesAtlastafurtheroptimizationmethodisproposedtoimprovetheindexmodelandanalysesaregivenonthetimeandspaceperformanceTheanalyticalandexperimentalresultsdemonstratetheutilityofBBIKeywords：datawarehouse；onlineana