数据仓库及应用-数据仓库.ppt

Determining the Class Speed of movement of data into the ODS Volume of data that must be moved Volume of data that must be stored in intermediate location during I T processing Update of data and integrity of transaction processing The time of day the movement needs to occur Data Architecture Data Warehouse Operational Data Store ODS Operational Data Store ODS Legacy System Legacy System Legacy System Legacy System Call Center Web Email ATM SFA Support Operational CRM Support Analytical CRM Example: The Content of a Customer ODS Identification Name Address Phone E-mail Preferences Opt in/out Medium Data sharing Transactions Purchases Cancellations Returns HH/Company Affiliation Events Complaints Pre-approvals Inquiries Sales calls Customer ODS Corporate Hierarchy Household link 数据仓库系统的体系结构 两层架构 （Generic Two-Level Architecture） 独立型数据集市 （Independent Data Mart） 依赖型数据集市和操作型数据存储 （Dependent Data Mart and Operational Data Store） 两层数据仓库体系结构 基于独立数据集市的数据仓库体系结构 基于依赖型数据集市和操作型数据存储(ODS)的数据仓库体系结构 数据仓库 杭诚方 教授 What is Data Warehouse Data warehouse is a very large database that stores integrated data of one or more business subject areas Data warehouse is built to support data analysis for decision making Integrated customer data warehouse is a necessary step to the success of the business intelligence strategy Data warehouses are also used for many other purposes such as product manufacturing data warehouses Data warehouses become the focal point in the enterprise-wide IT infrastructure What is Data Warehouse? What is Data Warehouse A data warehouse is simply a single, complete, and consistent store of data obtained from a variety of sources and made available to end users in a way they can understand and use in a business context. What is Data Warehouse Data Warehouse Definitions The key elements in the definitions: Subject-Oriented: Presentation as business subjects, not as computer files. Integrated: A single source of information for