Database architecture for data warehousing: An evolutionary approach

  • José Samos
  • Fèlix Saltor
  • Jaume Sistac
  • Agusti Bardés
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1460)


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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    ANSI/X3/SPARC Database System Study Group: Reference Model for DBMS Standardisation. ACM SIGMOD Record, Vol. 15, No. 1 (March 1986) 19–58CrossRefGoogle Scholar
  2. 2.
    Baralis, E., Paraboschi, S., Teniente, E.: Materialized View Selection in a Multidimensional Database. Proc. 23rd VLDB Conf. (Athens, 1997), Morgan Kaufmann, 156–165Google Scholar
  3. 3.
    Bertino, E., Ferrari, E., Guerrini, G.: T_Chimera: A Temporal Object-Oriented Data Model. TAPOS, Vol. 3, No. 2 (1997) 103–125Google Scholar
  4. 4.
    Castellanos, M., Saltor, F., García, M.: A Canonical Model for the Interoperatibility among Object Oriented and Relational Models. In: Ozsu, T. et al. (eds.): Distributed Object Management (Edmonton, 1992), Morgan Kaufmann (1994), 309–314Google Scholar
  5. 5.
    Chu, W., Ieong, Y., Taira, R., Breant, C.: A Temporal Evolutionary Object-Oriented Data Model and Its Query Language for Medical Image Management. Proc. 18th VLDB Conf. (Vancouver, 1992), Morgan Kaufmann, 53–64Google Scholar
  6. 6.
    Fauvet, M., Canavaggio, J., Scholl, P.: Modeling Histories in Object DBMS. In: Hameurlain, A., Tjoa, A. (eds.): Proc. 8th Int'l. Conf. DEXA (Toulouse, 1997), LNCS 1308, Springer-Verlag, 112–121Google Scholar
  7. 7.
    Hammer, J., García-Molina, H., Widom, J., Labio, W., Zhuge, Y.: The Stanford Data Warehousing Project. IEEE Data Engineering Bulletin (June 1995)Google Scholar
  8. 8.
    Harinarayan, V., Rajaraman, A., Ullman, J.: Implementing Data Cubes Efficiently. Proc. of ACM SIGMOD Conf. (Montreal, 1996)Google Scholar
  9. 9.
    Inmon, W.: Building the Data Warehouse. Wiley-QED (1992)Google Scholar
  10. 10.
    Inmon, W.: What is a Data Warehouse?. PRISM Tech Topic, Vol.1, No.1 (1992)Google Scholar
  11. 11.
    Inmon, W.: Information Architecture for the 90's: Legacy Systems, Operational Data Store. Data Warehouse. PRISM Tech Topic, Vol.1, No.13 (1993)Google Scholar
  12. 12.
    Inmon, W.: The Operational Data Store. PRISM Tech Topic, Vol.1, No.17 (1993)Google Scholar
  13. 13.
    Labio, W., Quass, D., Adelberg, B.: Physical Database Design for Data Warehouses. Proc. Int'l. Conf. on Data Engineering (Birminghan, 1997), IEEE, 277–288Google Scholar
  14. 14.
    Pissinou, N., Makki, K., Yesha, Y.: On Temporal Modeling in the Context of Object Databases. ACM SIGMOD Record, Vol. 22, No. 3 (Sep. 1993) 8–15CrossRefGoogle Scholar
  15. 15.
    Saltor, F., Campderrich, B., Rodriguez, E., Rodriguez, L.: On Schema Levels for Federated DB Systems. In Yetongnon & Hariri (eds.): Proc. of the ISCA Int'l. Conf. on Parallel and Distributed Computing Systems (Dijon, 1996), ISCA, 766–771Google Scholar
  16. 16.
    Samos, J.: Definition of External Schemas in Object Oriented Databases. In: Murphy, J., Stone, B. (eds.): Proc. Int'l Conf. on Object Oriented Information Systems (Dublin, 1995), Springer-Verlag, 154–166Google Scholar
  17. 17.
    Samos, J., Saltor, F.: External Schema Generation Algorithms for Object Oriented Databases. In: Patel, D. et al. (eds.): Proc. Int'l Conf. on Object Oriented Information Systems (London, 1996), Springer-Verlag, 317–332Google Scholar
  18. 18.
    Samos, J., Saltor, F.: Integration of Derived Classes in Object Schemas. IADT'98 — Int'l. Workshop on Issues and Applications of Database Technology (Berlin, July 1998)Google Scholar
  19. 19.
    Sheth, A., Larson, J.: Federated Database Systems for Managing Distributed, Heterogeneous and Autonomous Databases.” ACM Computing Surveys, Vol. 22, No. 3 (Sep. 1990)Google Scholar
  20. 20.
    Snodgrass, R.: Temporal Object-Oriented Databases: A Critical Comparison. In: Kim, W. (ed.): Modern Database Systems, ACM Press (1995) 386–408Google Scholar
  21. 21.
    Tsichritzis, D., Klug, A. (eds.): The ANSI/X3/SPARC Framework. AFIPS Press, Montvale, N.J. (1978)Google Scholar
  22. 22.
    Widom, J.: Research Problems in Data Warehousing. Proc. of the Int'l. Conf. on Information and Knowlege Management (Baltimore, 1995)Google Scholar
  23. 23.
    Wiener, J., Gupta, H., Labio, W., Zhuge, Y., García-Molina, H., Widom, J.: A System Prototype for Warehouse View Maintenance. Proc. of the ACM Workshop on Materialized Views: Techniques and Applications (Montreal, 1996) 26–33Google Scholar
  24. 24.
    Wuu, G., Dayal, U.: A Uniform Model for Temporal Object-Oriented Databases. Proc. IEEE Data Engineering Conf. (Feb. 1992)Google Scholar
  25. 25.
    Yang, J., Widom, J.: Maintaining Temporal Views over Non-Historical Information Sources for Data Warehousing. Technical note, Stanford University, 1997.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • José Samos
    • 1
  • Fèlix Saltor
    • 2
  • Jaume Sistac
    • 2
  • Agusti Bardés
    • 1
  1. 1.Informática IbéricaWinterthur IbéricaBarcelonaSpain
  2. 2.Departament de Llenguatges i Sistemes InformàticsUniversitat Politècnica de CatalunyaSpain

Personalised recommendations