Construction of a Data Warehouse

Abstract

This chapter is devoted to illustrate a new three level Data Warehouse architecture whose core is constituted by a data repository and which is particularly suited when the operational schemes of the Data Warehouse to be constructed are numerous and complex. The plan of the chapter is as follows: in the first section we define the Data Warehouses and compare three Data Warehouse architecture types. The general characteristics of the Data Warehouse architecture we propose are illustrated in the second section whereas the third one presents the corresponding technical details and pinpoints the difierences between classical three level architectures and the one we are proposing in this chapter. Finally a method for automatically synthesizing a Data Warehouse based on the proposed architecture is described in the fourth section.

The material presented in this chapter can be found in [86,84].