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.2. INFRASTRUCTURE SUPPORTING ARCHITECTURE

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

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