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

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.

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