Chapter 30. Introduction to Data Warehousing

by Kevin Viers

IN THIS CHAPTER

  • Why Warehouse?

  • What Is a Data Warehouse?

  • Warehouse Data Versus Operational Data

  • Data Warehousing Components

  • What Is a Data Mart?

  • Transforming Operational Data

  • Planning the Warehouse Design

  • Important Design Considerations

  • Managing a Data Warehouse or Data Mart

  • Microsoft and SQL Server 2000 Contributions to Data Warehousing

  • Data Warehousing FAQ

You might be asking yourself, “What is a data warehouse, and what does it mean to me?” Well, data warehousing has become one of largest buzzes around the database industry today. Most organizations are either planning or embarking on some sort of data warehousing effort. Because of the large shift of organizations toward the construction of ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.