Skip to main content
SpringerLink
Log in

Multidimensional Data Models and Aggregation

  • Chapter
Fundamentals of Data Warehouses

Abstract

This chapter is devoted to the modeling of multidimensional information in the context of data warehousing and knowledge representation, with a particular emphasis on the operation of aggregation.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 74.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Aberdeen Group: Data warehouse query tools: Evolving to rela-tional OLAP. White paper at the Aberdeen Group,1995.

    Google Scholar 

  2. S. Chaudhuri, U. Dayal: Data warehousing and OLAP for decision support. Tutorials of 22“d International Conference on Very Large Data Bases (VLDB), Mumbai, India, September 1996.

    Google Scholar 

  3. E.X. Dejesus: Dimensions of data. BYTE, April 1995.

    Google Scholar 

  4. G. De Giacomo, M. Lenzerini: What’s in an aggregate: Foundations for description logics with tuples and sets. Proceedings of the 14“ International Joint Conference on Artificial Intelligence (IJCAI), Montreal, Canada, pp. 801–807, Morgan Kaufmann, 1995.

    Google Scholar 

  5. R. Finkelstein: Multidimensional databases: Where relational fears to tread. Database Programming and Design, April 1995.

    Google Scholar 

  6. Olap Council: The OLAP glossary. http://www.olapcouncil.org/ research/glossaryly.htm, January 1995.

    Google Scholar 

  7. N. Raden: Data, data everywhere. Information Week, October, 1995.

    Google Scholar 

  8. N. Raden: Technology tutorial — Modeling a data warehouse. In-formation Week, January 29, 1996.

    Google Scholar 

  9. M. Rafanelli, F.L. Ricci: A functional model for macro-databases. SIGMOD Record, 20 (1), March 1991.

    Google Scholar 

  10. Red Brick Systems, Inc.: Data warehouse applications, 1996.

    Google Scholar 

  11. Red Brick Systems, Inc.: Data warehouse applications, 1996.

    Google Scholar 

  12. G. Colliat: OLAP, relational, and multidimensional database sys-tems. SIGMOD Record, 25 (3), September 1996.

    Google Scholar 

  13. R. Finkelstein: Understanding the Need for Online Analytical Serv-ers. White paper from Arbor Software, Inc., 1996.

    Google Scholar 

  14. R. Agrawal, A. Gupta, S. Sarawagi: Modeling multidimensional databases. Technical report, IBM Almaden Research Center, San Jose, CA, 1995.

    Google Scholar 

  15. J. Gray, A. Bosworth, A. Layman, H. Pirahesh: Data cube: A relational aggregation operator generalizing group-by, cross-tabs, and sub-totals. Proceedings of the 12th International Conference on Data Engineering (ICDE), New Orleans, pp. 152–159, IEEE Computer Society, February 1996. Also Microsoft Technical Report, MSRTR-95–22, available at http://www.research.microsoft. com/-gray.

    Google Scholar 

  16. R. Agrawal, A. Gupta, S. Sarawagi: Modeling multidimensional databases. Technical report, IBM Almaden Research Center, San Jose, CA, 1995.

    Google Scholar 

  17. M. Gyssens, L.V.S. Lakshmanan: A foundation for multi-dimen-sional databases. In: [VLDB97], pp. 106–115.

    Google Scholar 

  18. L. Cabibbo, R. Torlone: Querying multidimesional databases. Proceedings of 6th International Workshop on Database Programming Languages (DBPL-6), Estes Park, CO, pp. 319–335, Lecture Notes in Computer Science, Volume 1369, Springer-Verlag, 1997.

    Google Scholar 

  19. L. Cabibbo, R. Torlone: A logical approach to multidimensional databases. In: [EDBT98], pp. 183–197.

    Google Scholar 

  20. L. Cabibbo, R. Torlone: From a procedural to a visual query language for OLAP. In: [SSDB98], pp. 74–83.

    Google Scholar 

  21. W. Lehner, J. Albrecht, H. Wedekind: Normal forms for multidimensional databases. In: [SSDB98], pp. 63–72.

    Google Scholar 

  22. G. Özsoyoglu, Z.M. Özsoyoglu, F. Mata: A language and a physical organization technique for summary tables. Proceedings of the ACM SIGMOD International Conference on Management of Data, Austin, Texas, pp. 3–16, ACM Press, 1985.

    Google Scholar 

  23. G. Özsoyoglu, Z.M. Özsoyoglu, V. Matos: Extending relational algebra and relational calculus with set-valued attributes and aggregation functions. ACM Transactions on Database Systems, 12 (4), pp. 566–592, 1987.

    Article  Google Scholar 

  24. G. De Giacomo, M. Lenzerini: What’s in an aggregate: Foundations for description logics with tuples and sets. Proceedings of the 14“ International Joint Conference on Artificial Intelligence (IJCAI), Montreal, Canada, pp. 801–807, Morgan Kaufmann, 1995.

    Google Scholar 

  25. A. Gupta, V. Harinarayan, D. Quass: Aggregate query processing in data warehouses. In: [VLDB95], pp. 358–369.

    Google Scholar 

  26. A.Y. Levy, I.S. Mumick: Reasoning with aggregation constraints. In: [EDBT96], pp. 514–534.

    Google Scholar 

  27. I.S. Mumick, O. Shmueli: How expressive is stratified aggregation. Annals of Mathematics and Artificial Intelligence, 15 (3–4), 1995.

    Google Scholar 

  28. A.Y. Levy, A. Rajaraman, J.J. Ordille: Query answering algorithms for information agents. Proceedings of the 13th National Conference on Artificial Intelligence (AAAI), Portland, OR, pp. 40–47, AAAI Press/MIT Press, 1996.

    Google Scholar 

  29. G. De Giacomo, P. Naggar: Conceptual data model with structured objects for statistical databases. Proceedings of 8fll International Conference on Statistical Database Management Systems (SSDBM), Stockholm, Sweden, pp. 168–175, IEEE Computer Society Press, 1996.

    Google Scholar 

  30. D. Calvanese, M. Lenzerini, D. Nardi: A unified framework for class based representation formalisms. In: J. Doyle, E. Sandewall, P. Torasso, (eds): Proceedings of the Fourth International Conference on the Principles of Knowledge Representation and Reasoning (KR), Bonn, Germany, pp. 109–120, Morgan Kaufmann, 1994.

    Google Scholar 

  31. G. De Giacomo, M. Lenzerini: What’s in an aggregate: Foundations for description logics with tuples and sets. Proceedings of the 14“ International Joint Conference on Artificial Intelligence (IJCAI), Montreal, Canada, pp. 801–807, Morgan Kaufmann, 1995.

    Google Scholar 

  32. A. Borgida: Description logics for querying databases: In: F. Baader, M. Lenzerini, W. Nutt, P. F. Patel-Schneider (eds): Working Notes of the 1994 Description Logics Workshop, Bonn, Germany, 1994.

    Google Scholar 

  33. M. Buchheit, M.A. Jeusfeld, W. Nutt, M. Staudt: Subsumption of queries over object-oriented databases. Information Systems, 19 (1), pp. 33–54, 1994.

    Article  Google Scholar 

  34. F. Baader, P. Hanschke: A schema for integrating concrete domains into concept languages, Proceedings of the 12h International Joint Conference on Artificial Intelligence (IJCAI), Sydney, pp. 452–457, Morgan Kaufmann, 1991.

    Google Scholar 

  35. F. Baader, P. Hanschke: Extensions of concept languages for a me-chanical engineering application. Proceedings of the 16th German AI-Conference (GWAI), Bonn, Germany, pp. 132–143, Lecture Notes in Computer Science, Volume 671, Springer-Verlag, 1993.

    Google Scholar 

  36. G. Kamp, H. Wache: CTL — a description logic with expressive concrete domains. Technical report LKI-M-96/01, Labor für Künstliche Intelligenz, Universität Hamburg, Germany, 1996.

    Google Scholar 

  37. A. Goni, J. Bermúdez, J. M. Blanco, A. Illarramendi: Using rea-soning of description logics for query processing in multidatabase systems. In Working notes of the ECAI-96 Workshop on Knowledge Representation Meets Databases (KRDB), Budapest, Hungary, 1996.

    Google Scholar 

  38. G. De Giacomo, M. Lenzerini: TBox and ABox reasoning in expressive description logics. Proceedings of the 5th International Conference on the Principles of Knowledge Representation and Reasoning (KR), Cambridge, MA, pp. 316–327. Morgan Kaufmann, 1996.

    Google Scholar 

  39. D. Rudloff: Terminological reasoning and conceptual modeling for data warehouse. In Working Notes of the ECAI-96 Workshop on Knowledge Representation Meets Databases (KRDB), 1996.

    Google Scholar 

  40. A. Artale, E. Franconi, N. Guarino, L. Pazzi• Part-whole relations in object-centered systems: An overview. Data and Knowledge Engineering, 20 (3), pp. 347–383, 1996.

    Article  MATH  Google Scholar 

  41. A. Artale, E. Franconi: Temporal description logics. In: L.Vila, P.van Beek, M.Boddy, M.Fisher, D.Gabbay, A.Galton, R.Morris (eds): Handbook of time and temporal reasoning in AI. MIT Press, 1998.

    Google Scholar 

  42. F. Baader, P. Hanschke: A schema for integrating concrete domains into concept languages, Proceedings of the 12h International Joint Conference on Artificial Intelligence (IJCAI), Sydney, pp. 452–457, Morgan Kaufmann, 1991.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept. of Computer Science V (Information Systems), RWTH Aachen, Ahornstr. 55, D-52056, Aachen, Germany

    Matthias Jarke

  2. Dipartimento di Informatica e Sistemistica, Università di Roma “La Sapienza”, Via Salaria 113, 00198, Rome, Italy

    Maurizio Lenzerini

  3. Dept. of Electrical and Computer Engineering Computer Science Division, National Technical University of Athens, 15773, Zographou Athens, Greece

    Yannis Vassiliou & Panos Vassiliadis

Authors
  1. Matthias Jarke
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Maurizio Lenzerini
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Yannis Vassiliou
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Panos Vassiliadis
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P. (2000). Multidimensional Data Models and Aggregation. In: Fundamentals of Data Warehouses. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-04138-3_5

Download citation

  • DOI: https://doi.org/10.1007/978-3-662-04138-3_5

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-662-04140-6

  • Online ISBN: 978-3-662-04138-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation