7.6. CHAPTER SUMMARY

  • Architecture is the structure that brings all the components together.

  • Data warehouse architecture consists of distinct components with the read-only data repository as the centerpiece.

  • The architectural components support the functioning of the data warehouse in the three major areas of data acquisition, data storage, and information delivery.

  • Data warehouse architecture is wide, complex, expansive, and has several distinguishing characteristics.

  • The architectural framework enables the flow of data from the data sources at one end and the user's desktop at the other.

  • The technical architecture of a data warehouse is the complete set of functions and services provided within its components. It includes the procedures and rules needed to perform the functions and to provide the services. It encompasses the data stores needed for each component to provide the services.

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals 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.