20. Data Warehouse Administration

The ongoing quest for more and better business intelligence has caused many organizations to develop data warehouses and data marts to serve their analytical needs. Although, at the most basic level, a data warehouse is simply a database that has been designed and optimized for a specific type of processing, DBAs need to administer them differently from typical databases. This chapter outlines why this is so.

A data warehouse is designed and optimized for a specific type of processing.

What Is a Data Warehouse?

So, just what is a data warehouse, and why should you treat it differently from a DBA perspective? William H. Inmon, recognized as the father of the data warehouse, defines data warehouse in his book ...

Get Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.