DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals

2.1. CHAPTER OBJECTIVES

• Review formal definitions of a data warehouse

• Discuss the defining features

• Distinguish between data warehouses and data marts

• Study each component or building block that makes up a data warehouse

• Introduce metadata and highlight its significance

As we have seen in the last chapter, the data warehouse is an information delivery system. In this system, you integrate and transform enterprise data into information suitable for strategic decision making. You take all the historic data from the various operational systems, combine this internal data with any relevant data from outside sources, and pull them together. You resolve any conflicts in the way data resides in different systems and transform the integrated data content into a format suitable for providing information to the various classes of users. Finally, you implement the information delivery methods.

In order to set up this information delivery system, you need different components or building blocks. These building blocks are arranged together in the most optimal way to serve the intended purpose. They are arranged in a suitable architecture. Before we get into the individual components and their arrangement in the overall architecture, let us first look at some fundamental features of the data warehouse.

Bill Inmon, considered to be the father of Data Warehousing provides the following definition: "A Data Warehouse is a subject oriented, integrated, nonvolatile, and time variant collection of data ...