Skip to main content

Conceptual Multidimensional Data Model Based on MetaCube

  • Conference paper
  • First Online:
Advances in Information Systems (ADVIS 2000)

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

Included in the following conference series:

Abstract

In this paper, we propose a conceptual multidimensional data model that facilitates a precise rigorous conceptualization for OLAP. First, our approach has strong relation with mathematics by applying a new defined concept, i.e. H-set. Afterwards, the mathematic soundness provides a foundation to handle natural hierarchical relationships among data elements within dimensions with many levels of complexity in their structures. Hereafter, the multidimensional data model organizes data in the form of metacubes, the concept of which is a generalization of other cube models. In addition, a metacube is associated with a set of groups each of which contains a subset of the metacube domain, which is a H-set of data cells. Furthermore, metacube operators (e.g. jumping, rollingifp and drillingDown) are defined in a very elegant manner.

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

Access this chapter

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as 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.

Similar content being viewed by others

References

  1. Agrawal, R., Gupta, A., Sarawagi, A.: Modeling Multidimensional Databases. IBM Research Report, IBM Almaden Research Center, September 1995.

    Google Scholar 

  2. Albrecht, J., Guenzel, H., Lehner, W.: Set-Derivability of Multidimensiona Aggregates. First International Conference on Data Warehousing and Knowledge Discovery. DaWaKld99, Florence, Italy, August 30–September 1.

    Google Scholar 

  3. Buzydlowski, J. W., Song, II-Y., Hassell, L.: A Framework for Object-Oriented On-Line Analytic Processing. DOLAP 1998

    Google Scholar 

  4. Cabibbo, L., Torlone, R.: A Logical Approach to Multidimensional Databases. EDBT 1998

    Google Scholar 

  5. Chaudhuri, S., Dayal, U.: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record Volume 26, Number 1, September 1997.

    Google Scholar 

  6. Codd, E. F., Codd, S.B., Salley, Providing OLAP (On-Line Analytical Processing) to user-analysts: An IT mandate. Technical report, 1993.

    Google Scholar 

  7. Connolly, T., Begg, C: Database system: a practical approach to design, implementation, and management. Addison-Wesley Longman, Inc., 1999.

    Google Scholar 

  8. Gyssens, M., Lakshmanan, L.V.S.: A foundation for multi-dimensional databases, Proc. VLDB97.

    Google Scholar 

  9. Hurtado, C, Mendelzon, A., Vaisman, A.: Maintaining Data Cubes under Dimension Updates. Proc IEEE/ICDE’ 99.

    Google Scholar 

  10. Kimball, R.: The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, Inc., 1998.

    Google Scholar 

  11. Lehner, W.: Modeling Large Scale OLAP Scenarios. 6th International Conference on Extending Database Technology (EDBT’98), Valencia, Spain, 23–27, March 1998.

    Google Scholar 

  12. Li, C, Wang, X.S.: A Data Model for Supporting On-Line Analytical Processing. CIKM 1996.

    Google Scholar 

  13. Mangisengi, O., Tjoa A.M., Wagner R.R.: Multidimensional Modelling Approaches for OLAP. Proceedings of the Ninth International Database Conference “Heterogeneous and Internet Databasesrd” 1999, ISBN 962-937-046-8. Ed. J. Fong, Hong Kong, 1999

    Google Scholar 

  14. McGuff, F., Kador, J.: Developing Analytical Database Applications. Prentice Hall PTR, 1999.

    Google Scholar 

  15. Nguyen, T.B., Tjoa, A M., Wagner, R.R.: Conceptual Object Oriented Multidimensional Data Model for OLAP. Technical Report, IFS, Vienna 1999.

    Google Scholar 

  16. Samtani, S., Mohania, M.K., Kumar, V., Kambayashi, Y.: Recent Advances and Research Problems in Data Warehousing. ER Workshops 1998.

    Google Scholar 

  17. Shoshani, A.: OLAP and Statistical Databases: Similarities and Differences. Tutorials of PODS 1997.

    Google Scholar 

  18. Shukla A., Deshpande, P., Naughton, J. F., Ramasamy, K.: Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies. VLDB 1996: 522–531

    Google Scholar 

  19. Thomsen, E.: OLAP solutions: Building Multidimensional Information Systems. John Wiley& Sons, Inc., 1997.

    Google Scholar 

  20. Trujillo, J., Palomar, M.: An Object Oriented Approach to Multidimensional Database. Conceptual Modeling (OOMD), DOLAP 1998.

    Google Scholar 

  21. Vassiliadis, P.: Modeling Multidimensional Databases, Cubes and Cube operations. In Proc. 10th Scientific and Statistical Database Management Conference (SSDBM’ 98), Capri, Italy, June 1998.

    Google Scholar 

  22. Wang, M., Iyer, B. Efficient roll-up and drill-down analysis in relational database. In 1997 SIGMOD Workshop on Research Issues on Data Mining and Knowledge Discovery, 1997.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Nguyen, T.B., Tjoa, A.M., Wagner, R. (2000). Conceptual Multidimensional Data Model Based on MetaCube. In: Yakhno, T. (eds) Advances in Information Systems. ADVIS 2000. Lecture Notes in Computer Science, vol 1909. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-40888-6_3

Download citation

  • DOI: https://doi.org/10.1007/3-540-40888-6_3

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

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

  • Online ISBN: 978-3-540-40888-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics