零售业数据仓库的设计与实现

TheDesignandImplementofDataWarehouseofRetail1DWRDataWarehouseofRetailDWRDWR2......................................................................................11.1......................................................................................11.2......................11.3......................................................................3OLAP.....................................................42.1..............................................................42.2OLAP....................................52.3OLAP...............................................................7DWR...............................................83.1..............................................83.1.1.........................................................................83.1.2............................................................................93.1.3.....................................................................93.2............................123.2.1.....................................................123.2.2.......................................................................133.2.3.......................................................................143.2.4................................................................153.2.5OLAP......................................................15DWR.......................................................214.1DWR..............................................................214.2....................................................234.3............................................254.3.1.........................................................254.3.2..................................................26DWR............................................275.1....................................................275.1.1..........................................................................275.1.2................................................................295.2............................................3135.2.1..............................................................................315.2.2................................................................325.2.3.........................................................345.3DWR..............................................................36......................41..................................................................................42............................................................................................44................................................................................................46................................................................................................47ABSTRACT.......................................................................................4911.1POSOLAPOLAPOLAPDataMining1.2OLTP2DSSDSSDBDBOLTP1.2.3.DBDSSDSSDBDBW.H.Inmon”“OLAPOLAPOLAPOLAPMicrosoftOracleSybaseIBMInformixOracleOracleWarehouseBuilderOracle8iOracleExpressMicrosoftDTSRepositoryOLAP3MicrosoftOfficeBackOfficeVisualStudioSQLServer2000OLEDBODBCOLAPOLAPOLAPOLAP1.3DataWarehouseofRetailDWRDWRDWROLAP42.1W.H.Inmon??subject-oriented??integrated??time-variant5-10??nonvolatileOLAP50LTPMulti-DimensionalAnalysisDataMining2.2OLAPOLAPOnLineMulti-DimensionAnalysisOLAP6OLTPOLAPOLTPOLAP??OLTPOLAP??OLTPOLAP??OLTP-EROLAP??OLTPOLAPOLAPOLAP??OLTPOLAPOLTPOLAP1-1OLTPOLAPDBA()OLAP7DBE-R///DB100MBGB100GBTB2.3OLAPOLAPOLTPOLAPOLAPOLAPDWR83.1??????????DWR92-5DWR-DWR10StarSchema1.2.3-1{}SnowflakeSchema3-2DWR11DWRDWRDWRDWRDBRERD3-3ERDERDDWR123.2OLAPDataCubeDWR133-Dn-D3-4OLAPOLAPOLAPDWR14OLAP??????110103-7OLAPOLAPDWR15OLAPROLAPMOLAPHOLAPMOLAPROLAPMOLAPHOLAPMOLAPROLAPCPUROLAPMSOLAPMOLAPMSOLAPDWR16OLAP3-8OLAPDWR172DWR18DWR192030DWR203050DWR214.1DWR????DWR22??????DWR4-1DBMSSQLOLAP/DWR234.2DWRSQLServerDTSDTSDWR24????MaleMaleM0MaleOLTP??DTSDWRDWR254.3SQLServer2000AnalysisServicesDWRDWR3.2.53.2.5DWRDWR26??????????DWR275.1DTSDTSDTSOLEDB/ODBCDTSMicrosoftOLEDBMicrosoftOLEDBAPIOLEDBDTSOLEDBODBCSQLServer2000OLEDBSQLServerOracleExcelAccessASCIIODBCODBCOLEDBODBCMicrosoftDTSDTS1ImportExportWizards2DTSDesigner3DTSCOMDTSDTSDTSDTSDTSMicrosoftRepositoryMSDBDWR28EnterpriseManagerDTS??????Repository??DTSDesigner??????1DTSOLE-DBDTSWizard5-12345DTSDesigner????????6repositorySQLServerDWR297DTSDTSDTSWizardDTSDesignerCOMDTSDTSOLEDBDWR30DWRDTSAnalysisServices??????DWR315.2DWR324.3.113.2.523DWR33DWR34OLAPOLAP??roll-up??????CubeGridDWR35DWR365.3DWRDWR2.??DWR37??DWR38??OLAP??DWR39??2030??3050??DWR1.2.3.4.5.DWR406.DWRDWRDWR41POSDataMiningDWRDWR??????DWRDWRDWRDWR42DWRDWR??OLAPOLAP??????DWRDWR43441S.ChaudhuriandU.Dayal.AnoverviewofdatawarehousingandOLAPtechnology.ACMSIGMODRecord,26:65{74,1997.2Han,J.,Chiang,J.,Chee,S.,Chen,J.,Chen,Q.,Cheng,S.,Gong,W.,Kamber,M.,Liu,G.,Koperski,K.,Lu,Y.,Stefanovic,N.,Winstone,L.,Xia,B.,Zaiane,O.R.,Zhang,S.&Zhu,H.(1997),DBMiner:Asystemfordatamininginrelationaldatabasesanddatawarehouses,in`Proc.CASCON'97:MeetingofMinds',Toronto,Canada,pp.249--260.3S.Geffner,D.Agrawal,A.ElAbbadi,T.Smith.RelativePrefixSums:AnEf