Skip to main content
SpringerLink
Log in

Database architecture for data warehousing: An evolutionary approach

  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 1998)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1460))

Included in the following conference series:

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. ANSI/X3/SPARC Database System Study Group: Reference Model for DBMS Standardisation. ACM SIGMOD Record, Vol. 15, No. 1 (March 1986) 19–58

    Article  Google Scholar 

  2. Baralis, E., Paraboschi, S., Teniente, E.: Materialized View Selection in a Multidimensional Database. Proc. 23rd VLDB Conf. (Athens, 1997), Morgan Kaufmann, 156–165

    Google Scholar 

  3. Bertino, E., Ferrari, E., Guerrini, G.: T_Chimera: A Temporal Object-Oriented Data Model. TAPOS, Vol. 3, No. 2 (1997) 103–125

    Google Scholar 

  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–314

    Google Scholar 

  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–64

    Google Scholar 

  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–121

    Google Scholar 

  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. Harinarayan, V., Rajaraman, A., Ullman, J.: Implementing Data Cubes Efficiently. Proc. of ACM SIGMOD Conf. (Montreal, 1996)

    Google Scholar 

  9. Inmon, W.: Building the Data Warehouse. Wiley-QED (1992)

    Google Scholar 

  10. Inmon, W.: What is a Data Warehouse?. PRISM Tech Topic, Vol.1, No.1 (1992)

    Google Scholar 

  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. Inmon, W.: The Operational Data Store. PRISM Tech Topic, Vol.1, No.17 (1993)

    Google Scholar 

  13. Labio, W., Quass, D., Adelberg, B.: Physical Database Design for Data Warehouses. Proc. Int'l. Conf. on Data Engineering (Birminghan, 1997), IEEE, 277–288

    Google Scholar 

  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–15

    Article  Google Scholar 

  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–771

    Google Scholar 

  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–166

    Google Scholar 

  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–332

    Google Scholar 

  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. 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. Snodgrass, R.: Temporal Object-Oriented Databases: A Critical Comparison. In: Kim, W. (ed.): Modern Database Systems, ACM Press (1995) 386–408

    Google Scholar 

  21. Tsichritzis, D., Klug, A. (eds.): The ANSI/X3/SPARC Framework. AFIPS Press, Montvale, N.J. (1978)

    Google Scholar 

  22. Widom, J.: Research Problems in Data Warehousing. Proc. of the Int'l. Conf. on Information and Knowlege Management (Baltimore, 1995)

    Google Scholar 

  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–33

    Google Scholar 

  24. Wuu, G., Dayal, U.: A Uniform Model for Temporal Object-Oriented Databases. Proc. IEEE Data Engineering Conf. (Feb. 1992)

    Google Scholar 

  25. Yang, J., Widom, J.: Maintaining Temporal Views over Non-Historical Information Sources for Data Warehousing. Technical note, Stanford University, 1997.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Informática Ibérica, Winterthur Ibérica, Barcelona, Spain

    José Samos & Agusti Bardés

  2. Departament de Llenguatges i Sistemes Informàtics, Universitat Politècnica de Catalunya, Spain

    Fèlix Saltor & Jaume Sistac

Authors
  1. José Samos
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Fèlix Saltor
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Jaume Sistac
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Agusti Bardés
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Gerald Quirchmayr Erich Schweighofer Trevor J.M. Bench-Capon

Rights and permissions

Reprints and permissions

Copyright information

© 1998 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Samos, J., Saltor, F., Sistac, J., Bardés, A. (1998). Database architecture for data warehousing: An evolutionary approach. In: Quirchmayr, G., Schweighofer, E., Bench-Capon, T.J. (eds) Database and Expert Systems Applications. DEXA 1998. Lecture Notes in Computer Science, vol 1460. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0054530

Download citation

  • DOI: https://doi.org/10.1007/BFb0054530

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-64950-2

  • Online ISBN: 978-3-540-68060-4

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation