Consider the architectural components. For example, let us take the technical architecture of the data staging component. This part of the technical architecture for your data warehouse does a number of things. First of all, it indicates that there is a section of the architecture called data staging. Then it notes that this section of the architecture contains an area where data is staged before it is loaded into the data warehouse repository. Next, it denotes that this section of the architecture performs certain functions and provides specific services in the data warehouse. Among others, the functions and services include data transformation and data cleansing.

Let us now ask a few questions. Where exactly is the data staging area? What are the specific files and databases? How do the function s get performed? What enables the services to be provided? What is the underlying base? What is the foundational structure? Infrastructure is the foundation supporting the architecture. Figure 8-1 expresses this fact in a simple manner.

What are the various elements needed to support the architecture? The foundational infrastructure includes many elements. First, it consists of the basic computing platform. The platform include s all the required hardware and the operating system. Next, the database management system (DBMS) is an important element of the infrastructure. All other types of software and tools are also part of the infrastructure. ...

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.