達夢數據庫塊級壓縮方案的設計與實現.pdf

1、華中科技大學碩士學位論文達夢數據庫塊級壓縮方案的設計與實現姓名：柯軍申請學位級別：碩士專業(yè)：計算機軟件與理論指導教師：馮玉才20070606VAbstractDatabasecompression(DBCfsht)whichhasbeenputfwardfthelastfewyearsisanewtechnologytoimprovetheperfmanceofDatabaseManagementSystem(DBMS).Sinceme

2、recdscanbeedintooneblockDBCcancompressthedatabasesystemnotonlyfstagesavingsbutalsoftheimprovementinDBMS’sperfmance.ComparedwiththenoncompressedsystemoneIOoperationincompressedsystemcanreadmerecds.Thatmayimplyabigimprovem

3、entintheDataWarehousewhichhasalotofrecds.AfterthestudyonDamengDBMS’sPAGE3blockstyleREC3recdstyletraditionaldatacompressionmethodsfourdifferentcompressiongranularities(attributetupleblocktable)indatabaseFinallyDM’sdatabas

4、ecompressionschemeisedtoimplementonblocklevel.Thefeasibilityprocessofblockienteddatabasecompressionalgithmtheopptunitytodecompressthefmalproofonblockcompressionfactareanalyzedsubsequently.Therewillbeagreatimpactontraditi

5、onaldatabaseoperationafterusingblockienteddatabasecompression.ParticularlycomplexunnecessaryfrequentdecompressionoperationscouldswallowtheproceedsofdatabasecompressionSoweintroduceadelaydecompressmodeltoresolvethisproble

6、m.Finallywegiveourspecificalgithmsfquerydatabaseoperationsoncompressionblock.Intheendofthispaperwedesigntheprogramftheblockienteddatabasecompressionalgithmthedatabaseoperationsoncompressedblock.Theblockientedcompressionh

7、asagoodperfmanceoncompressionfactbytheanalysisonthedataobtainedfromtheprogram.Withthedatablocksizeincreasedsingleblockcompressionratecanfurtherenhance.Theexperimentaldatashowsthatcompresseddatabase’squeryefficiencymaybeb