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