維建模方法PPT學(xué)習(xí)教案

1、會計學(xué)1第1頁/共77頁第2頁/共77頁第3頁/共77頁第4頁/共77頁第5頁/共77頁計算每一個商場，每一產(chǎn)品銷售額產(chǎn)品、商場交叉表產(chǎn)品、商場交叉表第6頁/共77頁第7頁/共77頁第8頁/共77頁第9頁/共77頁第10頁/共77頁CountryStateCountyCity第11頁/共77頁第12頁/共77頁第13頁/共77頁第14頁/共77頁第15頁/共77頁第16頁/共77頁第17頁/共77頁第18頁/共77頁2002年2003年1季度2季度3季度4季度1季度2季度3季度4季度北京市123564566134562355上海市13410398871021399782天津市677359967

2、3696294旋轉(zhuǎn) 改變一個報告（或頁面）顯示的維方向第19頁/共77頁北京市上海市天津市2002年1季度123134672季度56103733季度4598594季度6687962003年1季度134102732季度56139693季度2397624季度558294第20頁/共77頁第21頁/共77頁第22頁/共77頁第23頁/共77頁關(guān)系數(shù)據(jù)庫中的數(shù)據(jù)組織多維數(shù)據(jù)庫中的數(shù)據(jù)組織第24頁/共77頁第25頁/共77頁RDB中數(shù)據(jù)組織MDB中數(shù)據(jù)組織第26頁/共77頁第27頁/共77頁第28頁/共77頁第29頁/共77頁ER模型模型維模型維模型數(shù)據(jù)組織一張表代表一個實體數(shù)據(jù)組織以事實表為核心要求目

3、標(biāo)最少的數(shù)據(jù)冗余最大的可理解性優(yōu)化策略面向Update操作進行優(yōu)化面向檢索進行優(yōu)化面向系統(tǒng)面向事務(wù)處理的模型面向數(shù)據(jù)倉庫的模型第30頁/共77頁Product TableProduct_idProduct_disc,. Time TableDay_idMonth_idYear_id,.Sales Fact TableProduct_idStore_idItem_idDay_idSales_amountSales_units, .Item TableItem_idItem_desc,.Store TableStore_idDistrict_id,.Central fact tableDenorm

4、alizeddimensions第31頁/共77頁第32頁/共77頁Year Product Type Sales Region Marketing Campaign Buyers Age Total Sales 2003Mythic WorldNortheastHistory Mag Spring Ad02556,3422003Mythic WorldNortheastHistory Mag Spring Ad2535104,5472003Mythic WorldNortheastHistory Mag Spring Ad3545234,3852003Mythic WorldNortheas

5、tHistory Mag Spring Ad4555534,5322003Mythic WorldNortheastHistory Mag Spring Ad5565829,2822003Mythic WorldNortheastHistory Mag Spring Ad65+284,540第33頁/共77頁第34頁/共77頁第35頁/共77頁第36頁/共77頁第37頁/共77頁Time TableWeek_idPeriod_idYear_idDept TableDept_idDept_descMgr_idMgr TableDept_idMgr_idMgr_nameProduct TableP

6、roduct_idProduct_descItem TableItem_idItem_descDept_idSales Fact TableItem_idStore_idProduct_idWeek_idSales_amountSales_unitsStore TableStore_idStore_descDistrict_idDistrict TableDistrict_idDistrict_desc第38頁/共77頁第39頁/共77頁第40頁/共77頁SourceTargetStaging Area第41頁/共77頁Operational systemsETLData WarehouseP

7、rogramsToolsGateways第42頁/共77頁Operationalsystems相關(guān)性相關(guān)性實用性實用性可靠性可靠性準(zhǔn)確性準(zhǔn)確性操作性操作性Data WarehouseETL抽取抽取清洗清洗整合整合重構(gòu)重構(gòu)裝載裝載維持維持更新更新第43頁/共77頁WarehousedatabaseData mappingTransformOperationaldatabasesData staging area第44頁/共77頁第45頁/共77頁第46頁/共77頁第47頁/共77頁第48頁/共77頁ExtractWarehouseLoadOperationalsystemsData Stagin

8、g AreaTransform:Clean upConsolidateRestructure第49頁/共77頁第50頁/共77頁第51頁/共77頁OperationaldatabasesWarehousedatabaseStaging areaExtractTransformTransport,Load第52頁/共77頁第53頁/共77頁數(shù)據(jù)倉庫的使用和維護DSS應(yīng)用開發(fā)的步驟第54頁/共77頁第55頁/共77頁Inmon提出的設(shè)計步驟第56頁/共77頁第57頁/共77頁PropertyData WarehouseData MartScopeEnterpriseDepartmentSubjec

9、tsMultipleSingle-subject, LOBData SourceManyFewImplementation timeMonths to yearsMonths第58頁/共77頁OperationalSystemsExternal DataOperations DataLegacy DataData WarehouseData MartsFlat FilesMarketingSalesFinanceMarketingSalesFinanceHRExternal Data第59頁/共77頁Sales orMarketingFlat FilesOperationalSystemsEx

10、ternal DataOperations DataLegacy DataExternal Data第60頁/共77頁第61頁/共77頁第62頁/共77頁第63頁/共77頁第64頁/共77頁第65頁/共77頁第66頁/共77頁Measure OLTP Fields Number of Accepted ProductsReject FlagNumber of Rejected ProductsReject FlagElapsed Minutes for Molding and HardeningNOT AVAILABLEElapsed Minutes for Painting and Curi

11、ngNOT AVAILABLE第67頁/共77頁Measure OLTP Fields Data Type Formula Number of Accepted ProductsReject FlagIntCount when reject flag is falseNumber of Rejected ProductsReject FlagIntCount when reject flag is trueElapsed Minutes for ManufacturingStart of manufacture date and time, End of manufacture date an

12、d timeDecimal(6.2)DATEDIFF( mi. Start of manufacture date and time. End of manufacture date and time)第68頁/共77頁Dimension OLTP Fields ProductProductProduct SubtypeNOT AVAILABLEProduct TypeNOT AVAILABLEBatchBatchMachineMachineMachine TypeNOT AVAILABLEMaterialNOT AVAILABLEPlantNOT AVAILABLECountryNOT AV

13、AILABLEDayStart of Manufacture Date and TimeMonthStart of Manufacture Date and TimeQuarterStart of Manufacture Date and TimeYearStart of Manufacture Date and TimePaint TypeNOT AVAILABLE第69頁/共77頁Dimension OLTP Fields Data Type Parent Dimension ProductProductIntProduct SubtypeProduct SubtypeAccounting

14、 System.ProductSubtypeIntProduct TypeProduct TypeAccounting System.ProductTypeIntNoneBatchBatchIntNoneMachineMachineIntMachine Type, PlantMachine TypeAccounting System.MachineTypeVarchar(30)MaterialMaterialAccounting System.Material Varchar(30)NonePlantAccounting System.PlantIntCountryCountryAccounting System.Country Char(3)NoneDayStart of Manufacture Da