Page 109 -

Cha P ter
3

Data Warehousing

Learning Objectives
■ Understand the basic definitions and ■ Explain the role of data warehouses in
concepts of data warehouses decision support
■ Understand data warehousing ■ Explain data integration and the
architectures extraction, transformation, and load
■ Describe the processes used in (ETL) processes
developing and managing data ■ Describe real-time (active) data
warehouses warehousing
■ Explain data warehousing operations ■ Understand data warehouse
administration and security issues

he concept of data warehousing has been around since the late 1980s. This chapter
provides the foundation for an important type of database, called a data ware-
T house, which is primarily used for decision support and provides improved analyti-
cal capabilities. We discuss data warehousing in the following sections:

3.1 Opening Vignette: Isle of Capri Casinos Is Winning with Enterprise Data
Warehouse 109
3.2 Data Warehousing Definitions and Concepts 111
3.3 Data Warehousing Process Overview 117
3.4 Data Warehousing Architectures 120
3.5 Data Integration and the Extraction, Transformation, and Load (ETL)
Processes 127
3.6 Data Warehouse Development 132
3.7 Data Warehousing Implementation Issues 143
3.8 Real-Time Data Warehousing 147
3.9 Data Warehouse Administration, Security Issues, and Future Trends 151
3.10 Resources, Links, and the Teradata University Network Connection 156
108

M03_SHAR9209_10_PIE_C03.indd 108 1/25/14 7:35 AM