1、會計學(xué)1數(shù)據(jù)倉庫及應(yīng)用數(shù)據(jù)倉庫及應(yīng)用(yngyng)數(shù)據(jù)倉庫無錫數(shù)據(jù)倉庫無錫第一頁，共37頁。第1頁/共37頁第二頁，共37頁。第2頁/共37頁第三頁，共37頁。第3頁/共37頁第四頁，共37頁。第4頁/共37頁第五頁，共37頁。第5頁/共37頁第六頁，共37頁。第6頁/共37頁第七頁，共37頁。網(wǎng)管系統(tǒng)財務(wù)管理系統(tǒng)市場分析決策系統(tǒng)Telcom DWSystem分析型大客戶CRM系統(tǒng)信用度管理客服系統(tǒng)( C a l l C e n t e r 1000/180/112/170）系統(tǒng)其它電信專業(yè)網(wǎng)業(yè)務(wù)系統(tǒng)“九七工程”之營業(yè)管理生產(chǎn)調(diào)度系統(tǒng)（配線/配號/開通）112故障查修系統(tǒng)資源管理系統(tǒng)170/

2、催繳系統(tǒng)營業(yè)系統(tǒng)本地公司/IC卡/磁卡管理系統(tǒng)網(wǎng)上營業(yè)系統(tǒng)商務(wù)管理層省級計費結(jié)算計費帳務(wù)系統(tǒng)中心業(yè)務(wù)管理層網(wǎng)絡(luò)及網(wǎng)元管理層電信網(wǎng)網(wǎng)元第7頁/共37頁第八頁，共37頁。第8頁/共37頁第九頁，共37頁。第9頁/共37頁第十頁，共37頁。第10頁/共37頁第十一頁，共37頁。PropertyOperationalData WarehouseResponse TimeSub-second to secondsSeconds to hoursData OperationDMLPrimarily read onlyNature of Data30-60 daysSnapshots over timeDa

3、ta OrganizationApplicationSubject, TimeSizeSmall to largeLarge to very largeData SourcesOperational, InternalOperational, Internal, ExternalActivitiesProcessesAnalysis第11頁/共37頁第十二頁，共37頁。第12頁/共37頁第十三頁，共37頁。第13頁/共37頁第十四頁，共37頁。第14頁/共37頁第十五頁，共37頁。第15頁/共37頁第十六頁，共37頁。ApplicationAdministrationStorage Manag

4、ementAnalysisData ManagementData ModelingData AcquisitionData Warehouse第16頁/共37頁第十七頁，共37頁。第17頁/共37頁第十八頁，共37頁。a specific department.第18頁/共37頁第十九頁，共37頁。PropertyData WarehouseData MartScopeEnterpriseDepartmentSubjectsMultipleSingle-subjectData SourceManyFewSize (Typical) TB TBImplement Time Months to y

5、earsMonths第19頁/共37頁第二十頁，共37頁。第20頁/共37頁第二十一頁，共37頁。Control: A department can completely control the data and processing that occurs inside a data mart.Cost: The cost of storage and processing is less, because the data marts machine is smaller than DWsCustomization: The data marts data is customized to

6、 suit the peculiar needs of the department.第21頁/共37頁第二十二頁，共37頁。第22頁/共37頁第二十三頁，共37頁。第23頁/共37頁第二十四頁，共37頁。Dependent Data Mart: The source is the data warehouse. The extraction, transformation, and loading process is easy. The data mart is part of the enterprise plan.Independent Data Mart: The source ar

7、e operational system external source. The extraction, transformation, and loading process is difficult. The data mart is built to satisfy analytical needs.第24頁/共37頁第二十五頁，共37頁。第25頁/共37頁第二十六頁，共37頁。第26頁/共37頁第二十七頁，共37頁。ODS looks very much like a data warehouse, such as subject-oriented, and integration.

8、 However, the remaining characteristics of an ODS are quite different from a data warehouse:Volatile: An ODS can be updated as a normal part of processing.Current-Values: An ODS typically contains daily, weekly, or even monthly data, but the data ages very quickly.Detailed Data: An ODS contains deta

9、iled data only.第27頁/共37頁第二十八頁，共37頁。Class I: A synchronous interface in which a very, very small amount of time lapses between an applications transaction and the reflection of the transaction in the ODS.Class II: If an hour or two passes from the time a transaction is created and interacted in the a

10、pplication environment until that transaction is reflected in the ODS.Class III: There may be a time lag between 12 hours and a day as transaction data is collected in the I&T interface.Class IV: The data is fed into the ODS directly from the data warehouse.第28頁/共37頁第二十九頁，共37頁。第29頁/共37頁第三十頁，共37頁

11、。Data WarehouseOperational Data Store ODSOperational Data Store ODSLegacy System Legacy System Legacy System Legacy System Call CenterWebEmailATMSFASupport Operational CRMSupport Analytical CRM第30頁/共37頁第三十一頁，共37頁。Identification Name Address Phone E-mailPreferences Opt in/out Medium Data sharingTransactions Purchases Cancellations ReturnsHH/Company AffiliationEvents Complaints Pre-approvals Inquiries Sales callsCustomer