oracle数据仓库最佳实践白皮书.pdf

《oracle数据仓库最佳实践白皮书.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、BestpracticesforaDataWarehouseonOracleDatabase11gAnOracleWhitePaperSeptember2008NOTE:Thefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotbereli

2、eduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.BestPracticesforaDataWarehouseonOracleDatabase11gPage2BestPracticesforaDataWarehouseonOracleDatabase11gNote:..................................

3、..................................................................................2ExecutiveSummary..........................................................................................4Introduction.................................................................................................

4、......4BalancedConfiguration....................................................................................5Interconnect..................................................................................................6DiskLayout.................................................................

5、..................................7LogicalModel....................................................................................................9PhysicalModel.................................................................................................10Staginglayer...........................

6、......................................................................10EfficientDataLoading..........................................................................11Foundationlayer-ThirdNormalForm.................................................14Optimizing3NF....................................

7、.................................................15Accesslayer-StarSchema........................................................................19OptimizingStarQueries......................................