• Infrastructure acts as the foundation supporting the data warehouse architecture.

  • Data warehouse infrastructure consists of operational infrastructure and physical infrastructure.

  • Hardware and operating systems make up the computing environment for the data warehouse.

  • Several options exist for the computing platforms needed to implement the various architectural components.

  • Selecting the server hardware is a key decision. Invariably, the choice is one of the four parallel server architectures.

  • Parallel processing options are critical in the DBMS. Current database software products are able to perform interquery and intraquery parallelization.

  • Software tools are used in the data warehouse for data modeling, data extraction, data transformation, data loading, data quality assurance, queries and reports, and online analytical processing (OLAP). Tools are also used as middleware, alert systems, and for data warehouse administration.

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with O’Reilly online learning.

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