Skip to Main Content
Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition
book

Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition

by Craig S. Mullins
October 2012
Intermediate to advanced content levelIntermediate to advanced
936 pages
23h 23m
English
Addison-Wesley Professional
Content preview from Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Database Administration: The Complete Guide to Practices and Procedures

Database Administration: The Complete Guide to Practices and Procedures

Craig S. Mullins

Publisher Resources

ISBN: 9780133012743Purchase book