資源描述：
《數(shù)據(jù)倉庫基礎(chǔ)ppt課件.ppt》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、Chapter2:FundamentalsofDataWarehouse第二章：數(shù)據(jù)倉庫基礎(chǔ)1Chapter2:FundamentalsofDataWarehouseDefinitionofdatawarehouseMulti-dimensionaldatamodelEfficientDataCubeComputationandOLAPoperationsSummery2DefinitionofDataWarehouseAdecisionsupportrepository（存儲）thatismaintaine
2、dseparatelyfromtheorganization’soperationaldatabaseSupportinformationprocessingbyprovidingasolidplatform(平臺)ofsummarized,historicaldataforanalysis.3DefinitionofDataWarehouse“Adatawarehouseisasubject-oriented(面向主題),integrated(集成),time-variant(隨時間變化),andnonvo
3、latile(非易失)collectionofdatainsupportofmanagement’sdecision-makingprocess.”—W.H.Inmon4SubjectOrientedIntegratedTimeVariantNonVolatileDataWarehouseFourFeaturesofDataWarehouseDataWarehouse—Subject-OrientedOrganizedaroundmajorsubjects,suchasproduct,sales，etc.Fo
4、cusingonthemodelingandanalysisofdatafordecisionmakers,notondailyoperationsortransactionprocessing.Provideasimpleandconciseviewaroundparticularsubjectissuesbyexcludingdatathatarenotusefulinthedecisionsupportprocess.6OLTPApplicationsCustomer financial informa
5、tionDataWarehouseSubjectEquity PlansSharesInsuranceLoansSavingsSubject-OrientedDataiscategorizedandstoredbybusinesssubjectratherthanbyapplication.DataWarehouse—IntegratedConstructedbyintegratingmultiple,heterogeneousdatasourcesrelationaldatabases,flatfiles,
6、etc.Dataextractionandintegrationtechniquesareapplied.Ensureconsistency(一致性)innamingconventions,structures,attributemeasures,etc.amongdifferentdatasources8DataWarehouseOLTPApplicationsSavingsCurrentaccountsLoansCustomerIntegratedDataWarehouse—TimeVariantThet
7、imehorizonforthedatawarehouseissignificantlylongerthanthatofoperationalsystems.Operationaldatabase:currentdata.Datawarehouse:provideinformationfromahistoricalperspective(e.g.,past5-10years)EverykeystructureinthedatawarehouseContainsanelementoftime,explicitl
8、yorimplicitlyButthekeyofoperationaldatamayormaynotcontain“timeelement”.1001/9702/9703/97JanuaryFebruaryMarchDataWarehouseTimeData199719971997TimeVariant(時變性)Dataisstoredasaseriesofsnapshots,eachreprese
