数据仓库过程开发以及案例开发

Whatis...y(DataWarehouse)/(DataMart)y(DecisionSupportSystem)y(OLAP)/ROLAP/MOLAPy(MetaData)y(Measure)/(Dimension)y(StarSchema)/(SnowSchema)y/(DrillDown/DrillUp)y(TableRotation)y(DataMining)yQuery/ReportyDrillup/DrillDownyCompareyExceptionyForcast,WhatifyDataMiningyyyyyyyyyyyUseaBuildingEstateOLTPdatabaseasanexampletoillustratetheconceptsandhowtobuildasuccessfulDataWarehousewhichusedtocheckandforecasttherentalrateandsellamountinHongKong.yyyyyyyŠ••••yyyyyyy3:92.4%65.2%65.2%(Source:DataWarehouseInstitute-February96)ClientinterfaceMetadataOLAPengineMDDBDataWarehouseOperationalDataDataloadingDataloadingOLAPserverOLAPserverSQLpassthroughSQLpassthroughOLAPengineOLAPserverOLAPserverDataWarehouseMetadataClientinterfaceMOLAPMOLAPROLAPROLAPMiddle-tierserverCLIENTDatabaseserverSQLSQLLegacy/Operational/ExternalSystemsTransactionSystemsDecisionSupportSystemsKnowledgeWorkersStrategicTacticalWhat-IfAnalysisCustomizedApplicationsDrill&PivotAnalysisForecastingModelingTime-SeriesQuery&ReportingMOLAPROLAPMDBMDBRDBMSRDBMSDataCachelinkage#Code_noNo_of_transactionConstructor_IDDeveloper_IDBuildingdatePurchasedatePurchasepriceAddressAreaApartment#Code_no#Transaction_noName/CompanyHKIDContactPhone#ContactAddressPurchaseDatePurchasePriceOwner#Code_no#Flat#Transaction_noNameHKIDOccupy_type(P,R)ContactPhone#ContactAddressDatePriceOccupantContractor_IDCompanyNameAddressContactPhone#Constructor#Code_no#FlatNo_of_transTypeFloorArea(Building)Area(Actual)FlatDetailsDeveloper_IDCompanyNameAddressContactPhone#DeveloperDayMonthQuarterYearTimeTerritoryDistrictRegionBuilding/EstateGeographicLocationTypeSizeAreaHousingTypes#Code_noNo_of_transactionConstructor_IDDeveloper_IDBuildingdatePurchasedatePurchasepriceAddressAreaApartment#Code_no#Transaction_noName/CompanyHKIDContactPhone#ContactAddressPurchaseDatePurchasePriceOwner#Code_no#Flat#Transaction_noNameHKIDOccupy_type(P,R)ContactPhone#ContactAddressDatePriceOccupantContractor_IDCompanyNameAddressContactPhone#Constructor#Code_no#FlatNo_of_transTypeFloorArea(Building)Area(Actual)FlatDetailsDeveloper_IDCompanyNameAddressContactPhone#DeveloperDayMonthQuarterYearTimeTerritoryDistrictRegionBuilding/EstateGeographicLocationTypeSizeAreaHousingTypesDate1-Jan-9413-Jun-9512-Jan-9612-Apr-9615-Apr-9620-Oct-9620-Oct-9612-Dec-961-Jan-9731-Mar-9715-Apr-97?.TimeYearQuarterMonthDayTimeHierarchyClassSSMMMLLLSMLSMAreasq.m10-39.940-49.950-69.970-99.9100-129.9130-159.9160-199.9Over20010-129.9130-299.9Over30010-49.950-129.9SizeABCDETypeDomesticIndustrialShops&CommercialOthers/MiscAreasq.m2563035125400810400300100210300?.TypeSizeAreaClass:AttributesofHousingTypeHousingTypeHousingTypeOccupantOccupantHousingTypedimensionlookuptableHousingTypedimensionlookuptableAttributesTimeLocationTypeAreaOccupantNamePurchasePriceRent?.SalesFactTableBuildingEstateOLTPEnvironmentTimeLocationTypeAreaOccupantNamePurchasePriceRent?.SalesFactTableDayMonthQuarterYearTimeTerritoryDistrictRegionBuilding/EstateGeographicLocationTypeSizeAreaHousingTypes#Code_noNo_of_transactionConstructor_IDDeveloper_IDBuildingdatePurchasedatePurchasepriceAddressAreaApartment#Code_no#Transaction_noName/CompanyHKIDContactPhone#ContactAddressPurchaseDatePurchasePriceOwner#Code_no#Flat#Transaction_noNameHKIDOccupy_type(P,R)ContactPhone#ContactAddressDatePriceOccupantContractor_IDCompanyNameAddressContactPhone#Constructor#Code_no#FlatNo_of_transHousingTypeFloorArea(Building)Area(Actual)FlatDetailsDeveloper_IDCompanyNameAddressContactPhone#DeveloperTransformBuildingEstateDataWarehouseOLAPEnvironmentTerritoryDistrictTimeLocationTypeAreaOccupantNamePurchasePriceRent?.SalesFactTableSalesFactTableTypeSizeAreaDistrictDiatrictRegionRegionRegionBuilding/EstateYearQuarterQuarterYearQuarterMonthQuarterMonthDayMonthDayHousingTypesHousingTypesTimeLocationTypeAreaOccupantNamePurchasePriceRent?.SalesFactTableSalesFactTableDayMonthQuarterYearTimeTimeTerritoryDistrictRegionBuilding/EstateGeographicGeographicLocationLocationTypeSizeAreaHousingTypesHousingTypesStarschemaSnowflakeschemay()y(3-5)yIDcodeyI/OyX=sizeofonerowinthefacttableTherefore,SalesFactTable=98TimeLocationTypeAreaOccupantNamePurchasePriceRent?.SalesFactTableSalesFactTableDayMonthQuarterYearTimeTimeTerritoryDistrictRegionBuilding/EstateGeographicGeographicLocationLocationTypeSizeAreaHousingTypesHousingTypesBuildingPropertyDWDesignDimensionEstimated#Time96monthHousingTypeGeographicLoc.20types1000locs.Y=sparsity(densityfactor)-0.75Estimatedsizeofdatabase=98*96*20*1000*0.75=141.12MbyyyyyyyyDEMO