Chapter 8

Data Warehouses and the Technical Business Intelligence Architecture

Introduction

Production application systems are designed to execute business transactions or manage operational systems, but are not designed to support reporting and ad hoc queries, and certainly are not engineered to support the kinds of analytical applications that most organizations now seek to deploy. And even with new developments in performance-oriented database systems and analytical appliances, the hub of the business intelligence (BI) environment remains the data warehouse.

A data warehouse is a centralized repository of data that has been compiled from a number of disparate data sources and is in turn used to power the analytical processing from which ...

Get Business Intelligence, 2nd 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.