O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

8.6. CHAPTER SUMMARY

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required