dimensional modeling for data warehouse

ID:34369785

大?。?7.02 KB

頁數(shù):5頁

時間:2019-03-05

dimensional modeling for data warehouse_第1頁
dimensional modeling for data warehouse_第2頁
dimensional modeling for data warehouse_第3頁
dimensional modeling for data warehouse_第4頁
dimensional modeling for data warehouse_第5頁
資源描述:

《dimensional modeling for data warehouse》由會員上傳分享,免費在線閱讀,更多相關內(nèi)容在教育資源-天天文庫。

1、DimensionalModelingforDataWarehouseUmashankerSharma,AnjanaGosainGGS,IndraprasthaUniversity,DelhiAbstractstoresinformationinordertosatisfydecision-making2Manysurveysindicatethatasignificantpercentageofrequests.ThiskindofDBhasthefollowingparticularDWsfailtomeetbusinessobjectivesorareoutrig

2、htfeatures.Itcontainsdatathatistheresultoffailures.Inthispaper,wearedescribingabouttransformations,qualityimprovement,andintegrationofmultidimensionaldatamodelfortheDWs,whichwillhelpdatathatcomesfromoperationalbases,alsoincludinginsurroundfactswithasmuchrelevantcontextindicatorsthatgivei

3、tadditionalvalue.TheDWshavetodimensions.Multidimensionalityisjustadesignsupportcomplexquerieshoweveritsmaintenancedoestechniquethatseparatestheinformationintofactsandnotsupposetransactionalload.Thesefeaturescausethedimensions.Itgivesrisetoschemawithstarshape,designtechniquesandtheusedstr

4、ategiestobedifferentConsistsofafacttablewithasingletableforeachfromthetraditionalones.dimension.SnowflakeSchemaisavariationofstar?EnterpriseDW-AnenterpriseDWprovidesacentralschema,inwhichthedimensionaltablesfromastardatabasefordecisionsupportthroughouttheenterprise.schemaareorganizedinto

5、ahierarchybynormalizing?OperationalDataStore-Thishasabroadenterprisethem.Multidimensionalmodelpresentinformationtothewidescope,butunlikethereal.EnterprisesDW,dataisend-userinawaythatcorrespondstohisnormalrefreshedinnearrealtimeandusedforroutinebusinessunderstandingofhisbusiness,keyfigure

6、sorfactsfromactivity.thedifferentperspectivesthatinfluencethem.Weare?DataMart-Datamartisasubsetofdatawarehouseandsurveyedonpresentdifferentmultidimensionaldataitsupportsaparticularregion,businessunitorbusinesscubes,whicharethebasiclogicalmodelforOLAPfunction.applications.1.1-Characterist

7、icsofDW-ThemaincharacteristicsKeyWords:MultidimensionalModeling,dataofdatawarehouseare:warehouse,OLAP,FactSchema,Separate,TheDWisseparatefromtheoperationalsystemsinthecompany.Itgetsitsdataoutofthese1.Introductionlegacysystems.Available.ThetaskofaDWistomakedataaccessiblefo

當前文檔最多預覽五頁,下載文檔查看全文

此文檔下載收益歸作者所有

當前文檔最多預覽五頁,下載文檔查看全文
溫馨提示:
1. 部分包含數(shù)學公式或PPT動畫的文件,查看預覽時可能會顯示錯亂或異常,文件下載后無此問題,請放心下載。
2. 本文檔由用戶上傳,版權歸屬用戶,天天文庫負責整理代發(fā)布。如果您對本文檔版權有爭議請及時聯(lián)系客服。
3. 下載前請仔細閱讀文檔內(nèi)容,確認文檔內(nèi)容符合您的需求后進行下載,若出現(xiàn)內(nèi)容與標題不符可向本站投訴處理。
4. 下載文檔時可能由于網(wǎng)絡波動等原因無法下載或下載錯誤,付費完成后未能成功下載的用戶請聯(lián)系客服處理。
关闭