CHAPTER 2 DATA WAREHOUSE: THE BUILDING BLOCKS
CHAPTER OBJECTIVES
CHAPTER OBJECTIVES
- Review formal definitions of a data warehouse
- Discuss the defining features
- Distinguish between data warehouses and data marts t
- Study each component or building block that makes up a data warehouse
- Introduce metadata and highlight its significance
As we have seen 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 formal 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 lemon, considered to be the father of Data Warehousing provides the following definition: "A Data Warehouse is a subject oriented. Integrated, nonvolatile, and lime variant collection of data in support of management's decisions." Sean Kelly, another leading data warehousing practitioner defines the data warehouse in the following way.
The data in the data warehouse is:
Separate
Available
Integrated
Time Stamped
Subject oriented
Nonvolatile
Accessible
DEFINING FEATURES
Let us examine some of the key defining features of the data warehouse based on these definitions. What about the nature of Mc data in the data warehouse? how is this data ferent from the data in any operational system'? Why does it have to be different? how is the data content in the data warehouse used'?
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 lemon, considered to be the father of Data Warehousing provides the following definition: "A Data Warehouse is a subject oriented. Integrated, nonvolatile, and lime variant collection of data in support of management's decisions." Sean Kelly, another leading data warehousing practitioner defines the data warehouse in the following way.
The data in the data warehouse is:
Separate
Available
Integrated
Time Stamped
Subject oriented
Nonvolatile
Accessible
DEFINING FEATURES
Let us examine some of the key defining features of the data warehouse based on these definitions. What about the nature of Mc data in the data warehouse? how is this data ferent from the data in any operational system'? Why does it have to be different? how is the data content in the data warehouse used'?
No comments:
Post a Comment