Skip to main content
SpringerLink
Log in

A logical approach to multidimensional databases

  • Conference paper
  • First Online:
Advances in Database Technology — EDBT'98 (EDBT 1998)

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

Included in the following conference series:

Abstract

In this paper we present MD, a logical model for OLAP systems, and show how it can be used in the design of multidimensional databases. Unlike other models for multidimensional databases, MD is independent of any specific implementation (relational or proprietary multidimensional) and as such it provides a clear separation between practical and conceptual aspects. In this framework, we present a design methodology, to obtain an MD scheme from an operational database. We then show how an MD database can be implemented, describing translations into relational tables and into multidimensional arrays.

This work was partially supported by CNR and by MURST.

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. R. Agrawal, A. Gupta, and S. Sarawagi. Modeling multidimensional databases. In 13th Int. Conf. on Data Engineering, pages 232–243, 1997.

    Google Scholar 

  2. C. Batini, S. Ceri, and S. Navathe. Conceptual Database Design. Benjamin/Cummings, 1992.

    Google Scholar 

  3. L. Cabibbo and R. Torlone. Querying multidimensional databases. In 6th Int. Workshop on Database Programming Languages (DBPL'97), 1997.

    Google Scholar 

  4. S. Chaudhuri and U. Dayal. An overview of Data Warehousing and OLAP technology. ACM SIGMOD Record, 26(1):65–74, March 1997.

    Article  Google Scholar 

  5. E.F. Codd, S.B. Codd, and C.T. Salley. Providing OLAP (On Line Analytical Processing) to user-analysts: an IT mandate. Arbor Software White Paper, http://www.arborsoft.com.

    Google Scholar 

  6. M. Golfarelli, D. Maio, and S. Rizzi. Conceptual design of data warehouses from E/R schemes. In 31st Hawaii Intl. Conf. on System Sciences, 1998.

    Google Scholar 

  7. M. Gyssens and L.V.S. Lakshmanan. A foundation for multi-dimensional databases. In 33rd Int. Conf. on Very Large Data Bases, pages 106–115, 1997.

    Google Scholar 

  8. W.H. Inmon. Building the Data Warehouse. John Wiley & Sons, 2nd ed., 1996.

    Google Scholar 

  9. R. Kimball. The Data Warehouse Toolkit. John Wiley & Sons, 1996.

    Google Scholar 

  10. A. O. Mendelzon. Data warehousing and OLAP: a research-oriented bibliography. http://www.cs.toronto.edu/~mendel/dwbib.html.

    Google Scholar 

  11. N. Pendse and R. Creeth. The OLAP Report, http://www.olapreport.com.

    Google Scholar 

  12. A. Shoshani. OLAP and statistical databases: 6imilarities and differences. In 16th ACM SIGACT SIGMOD SIGART Symp. on Principles of Database Systems, pages 185–196, 1997.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dipartimento di Informatica e Automazione, Università di Roma, Tre Via délla Vasca Navale, 79-I-00146, Roma, Italy

    Luca Cabibbo & Riccardo Torlone

Authors
  1. Luca Cabibbo
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Riccardo Torlone
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Hans-Jörg Schek Gustavo Alonso Felix Saltor Isidro Ramos

Rights and permissions

Reprints and permissions

Copyright information

© 1998 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Cabibbo, L., Torlone, R. (1998). A logical approach to multidimensional databases. In: Schek, HJ., Alonso, G., Saltor, F., Ramos, I. (eds) Advances in Database Technology — EDBT'98. EDBT 1998. Lecture Notes in Computer Science, vol 1377. Springer, Berlin, Heidelberg . https://doi.org/10.1007/BFb0100985

Download citation

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

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-64264-0

  • Online ISBN: 978-3-540-69709-1

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation