資源描述:
《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