Special Offers

Microsoft® SQL Server™ 2000 Resource Kit
Author Microsoft Corporation
Pages 1200
Disk 2 Companion CD(s)
Level Advanced
Published 03/28/2001
ISBN 9780735612662
ISBN-10 0-7356-1266-8
Price(USD) $69.99
To see this book's discounted price, select a reseller below.

More Information

About the Book
Table of Contents
Sample Chapter
Related Series
Related Books
About the Author

Support: Book & CD

Rate this book
Barnes Noble Amazon Quantum Books


Chapter 17: Data Warehouse Design Considerations

Chapter 17 Data Warehouse Design Considerations

Data warehouses support business decisions by collecting, consolidating, and organizing data for reporting and analysis with tools such as online analytical processing (OLAP) and data mining. Although data warehouses are built on relational database technology, the design of a data warehouse database differs substantially from the design of an online transaction processing system (OLTP) database.

The topics in this chapter address approaches and choices to be considered when designing and implementing a data warehouse. The chapter begins by contrasting data warehouse databases with OLTP databases and introducing OLAP and data mining, and then adds information about design issues to be considered when developing a data warehouse with Microsoft® SQL Server 2000.


Top of Page

Last Updated: Saturday, July 7, 2001