Data Warehouse 商务智能概论课件培训讲解.pptVIP

Customer data include transactional records that are stored in back-end ERP, SCM, front-office CRM and e-commerce applications. We also need unstructured data from nontraditional sources such as emails, comments in blogs, wikis and other data. Customer data is highly fragmented across multiple data sources inside and outside the organization. A data warehouse is A non-volatile store of data, transactions, and events . It includes both corporate, operational data, and external data. The data and information in the data warehouse should be integrated, consolidated, secured, and cleansed so that it is a sound source for corporate-wide decision support. Data warehouse characteristics and properties Data organized by business subject with a corporate-wide scope of use for decision support and informational applications Nonvolatile store of business data, transactions and events Built on the basis of a historical (temporal) data model, possibly combined with other information dimensions Integrated, consolidated, secured, and cleansed data Data in a data warehouse is organized subject-oriented such as Customers, sales, supplies, products, and so forth rather than application-oriented. A data warehouse must consolidate primitive data, and it must provide all facilities to derive information from it, as required by the users. It is difficult to locate the relevant data. What is available is often not formatted correctly. Mostly only raw, detail data rather than history and summaries. It may be incorrect or inconsistent. It is not easy to correlate data from different processes. A data warehouse is a logically integrated store of data, originating from disparate operational sources. It is (ultimately) the one and only source for deriving information needed by users. Integrated, consolidated, secured, and cleansed data IBM领导信息集成 发布新的集成软件: DB2 Information Integrator DB2 Information Integrator 8.1 DB2 Information Integrator for Content 8.2 关键商业价值: -优化IT投资，提供数据访问的更多选择