数据仓库讲义之Recent Developments in Data Warehousing.ppt

Recent Developments in Data Warehousing Hugh J. Watson Terry College of Business University of Georgia hwatson@ /~hwatson/dw_tutorial.ppt Tutorial Objectives Provide an overview of data warehousing Provide materials to support the teaching of data warehousing Discuss recent developments in data warehousing The Importance of Data Warehousing Provide a “single version of the truth” Improve decision making Support key corporate initiatives such as performance management, B2C and B2B e-commerce, and customer relationship management Estimated to be a $113.5 billion market in 2002 for systems, software, services, and in-house expenditures (Palo Alto Management Group) Data Warehouse Characteristics Subject oriented -- data are organized around sales, products, etc. Integrated -- data are integrated to provide a comprehensive view Time variant -- historical data are maintained Nonvolatile -- data are not updated by users Topics Covered Definitions and concepts Two case studies: Harrah’s Entertainment (first) and OwensMinor (last) The data mart and enterprise-wide data warehouse strategies Data extraction, cleansing, transformation and loading Meta data Data stores Online analytical processing (OLAP) Warehouse users, tools, and applications Harrah’s Entertainment Harrah’s Entertainment -- data warehousing supported a successful shift to a CRM oriented corporate strategy. Winner of the 2000 TDWI Leadership Award Operates 21 casinos across the country In 1993, the gaming laws changed, which allowed Harrah’s to expand Harrah’s decided to compete using a brand strategy supported by information technology Needed to know their customers exceptionally well Harrah’s Data Warehousing Architecture WINet sources data from the casino, hotel, and event systems The patron data base serves as an operational data store The marketing workbench serves as the data warehouse Sample Applications Operational personnel use PDB to check the preferences, history, and value of custo