Database Architecture for Data Warehousing: An Evolutionary Approach

In recent years, data warehouses have reached a prominent position in the database field, especially in the database industry. There are many issues in common between data warehouses and other database fields such as federated databases; in our opinion this fact has not been explored in its entirety. In this paper, an integrated database architecture in which data warehouses are part of the database is put forward. Instead of having data warehouses built using a database, we propose to have data warehouses defined as part of the database architecture; this architecture is defined as an extension of a federated database architecture.

[1]  José Samos.  Definition of External Schemas in Object Oriented Databases , 1995, OOIS.

[2]  Peter Gluchowski,et al.  Data Warehouse , 1997, Informatik-Spektrum.

[3]  Richard T. Snodgrass,et al.  Temporal Object-Oriented Databases: A Critical Comparison , 1995, Modern Database Systems.

[4]  Wilburt Labio,et al.  Physical database design for data warehouses , 1997, Proceedings 13th International Conference on Data Engineering.

[5]  José Samos,et al.  Integration of Derived Classes in Object Schemas , 1998, IADT.

[6]  Nick Roussopoulos,et al.  Reference Model for DBMS Standardization, Database Architecture Framework Task Group (DAFTG) of the ANSI/X3/SPARC Database System Study Group , 1986, SIGMOD Rec..

[7]  Jeffrey D. Ullman,et al.  Implementing data cubes efficiently , 1996, SIGMOD '96.

[8]  Jennifer Widom,et al.  Maintenance of Materialized Views: Problems, Techniques, and Applications , 1999, IEEE Data Eng. Bull..

[9]  Jennifer Widom,et al.  Maintaining Temporal Views over Non-Temporal Information Sources for Data Warehousing , 1998, EDBT.

[10]  Jennifer Widom,et al.  A System Prototype for Warehouse View Maintenance , 1996, VIEWS.

[11]  Niki Pissinou,et al.  On temporal modeling in the context of object databases , 1993, SGMD.

[12]  Elizabeth N. Fong,et al.  Reference model for DBMS standardization , 1986, SGMD.

[13]  Marie-Christine Fauvet,et al.  Modeling histories in object DBMS , 1997 .

[14]  Fèlix Saltor,et al.  A Canonical Model for the Interoperability Among Object-Oriented and Relational Databases , 1992, IWDOM.

[15]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[16]  José Samos,et al.  External Schema Generation Algorithms for Object Oriented Databases , 1996, OOIS.

[17]  Ricky K. Taira,et al.  A Temporal Evolutionary Object-Oriented Data Model and Its Query Language for Medical Image Management , 1992, VLDB.

[18]  Sandra Heiler,et al.  Distributed Object Management , 1992, Int. J. Cooperative Inf. Syst..

[19]  Jennifer Widom,et al.  Research problems in data warehousing , 1995, CIKM '95.

[20]  Elena Baralis,et al.  Materialized Views Selection in a Multidimensional Database , 1997, VLDB.

[21]  Umeshwar Dayal,et al.  A uniform model for temporal object-oriented databases , 1992, [1992] Eighth International Conference on Data Engineering.

[22]  Elisa Bertino,et al.  T_Chimera: A Temporal Object-Oriented Data Model , 1997, Theory Pract. Object Syst..