Data Warehouses and the Technical Business Intelligence Architecture

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 environment remains the data warehouse.