Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design

《Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、IntegratingVerticalandHorizontalPartitioningintoAutomatedPhysicalDatabaseDesign*SanjayAgrawalVivekNarasayyaBeverlyYangMicrosoftResearchMicrosoftResearchStanfordUniversitysagrawal@microsoft.comviveknar@microsoft.combyang@stanford.eduABSTRACToperationssuchasbackupandr

2、estorebecomemucheasier.Therefore,thereisaneedtoincorporatemanageabilitywhileInadditiontoindexesandmaterializedviews,horizontalandarrivingattherightphysicaldesignfordatabases.Thus,databaseverticalpartitioningareimportantaspectsofphysicaldesigninaadministrators(DBAs)i

3、ntoday’senterprisesarefacedwiththerelationaldatabasesystemthatsignificantlyimpactperformance.challengingtaskofdeterminingtheappropriatechoiceofphysicalHorizontalpartitioningalsoprovidesmanageability;databasedesignconsistingofpartitionedtables,indexesandmaterializeda

4、dministratorsoftenrequireindexesandtheirunderlyingtablesviewsthat(a)optimizestheperformanceoftheSQLqueriesandpartitionedidenticallysoastomakecommonoperationssuchasupdatesand(b)iseasiertomanageatthesametime.backup/restoreeasier.Whilepartitioningisimportant,incorporat

5、ingpartitioningmakestheproblemofautomatingOurgoalistooptimizetheperformanceofadatabaseforagivenphysicaldesignmuchhardersince:(a)Thechoicesofpartitioningrepresentativeworkload,whileconsideringalignmentcanstronglyinteractwithchoicesofindexesandmaterializedrequirements

6、.Whiletherehasbeenworkintheareaofviews.(b)Alargenewspaceofphysicaldesignalternativesmustautomatingphysicaldatabasedesign[2,4,17,22,24],wearenotbeconsidered.(c)Manageabilityrequirementsimposeanewawareofanyworkthataddressestheproblemofincorporatingconstraintontheprobl

7、em.Inthispaper,wepresentnovelbothhorizontalandverticalpartitioningaswellasalignmenttechniquesfordesigningascalablesolutiontothisintegratedrequirementsinanintegratedmanner.Thenoveltechniquesphysicaldesignproblemthattakesbothperformanceandpresentedinthispaperaremotiva

8、tedbythekeydesignchallengesmanageabilityintoaccount.Wehaveimplementedourtechniquesthatarisewiththeinclusionofhorizontalandverticalpartitio