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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Agrawal, R., Gupta, A., Sarawagi, A.: Modeling Multidimensional Databases. IBM Research Report, IBM Almaden Research Center, September 1995.
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.
Buzydlowski, J. W., Song, II-Y., Hassell, L.: A Framework for Object-Oriented On-Line Analytic Processing. DOLAP 1998
Cabibbo, L., Torlone, R.: A Logical Approach to Multidimensional Databases. EDBT 1998
Chaudhuri, S., Dayal, U.: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record Volume 26, Number 1, September 1997.
Codd, E. F., Codd, S.B., Salley, Providing OLAP (On-Line Analytical Processing) to user-analysts: An IT mandate. Technical report, 1993.
Connolly, T., Begg, C: Database system: a practical approach to design, implementation, and management. Addison-Wesley Longman, Inc., 1999.
Gyssens, M., Lakshmanan, L.V.S.: A foundation for multi-dimensional databases, Proc. VLDB97.
Hurtado, C, Mendelzon, A., Vaisman, A.: Maintaining Data Cubes under Dimension Updates. Proc IEEE/ICDE’ 99.
Kimball, R.: The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, Inc., 1998.
Lehner, W.: Modeling Large Scale OLAP Scenarios. 6th International Conference on Extending Database Technology (EDBT’98), Valencia, Spain, 23–27, March 1998.
Li, C, Wang, X.S.: A Data Model for Supporting On-Line Analytical Processing. CIKM 1996.
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
McGuff, F., Kador, J.: Developing Analytical Database Applications. Prentice Hall PTR, 1999.
Nguyen, T.B., Tjoa, A M., Wagner, R.R.: Conceptual Object Oriented Multidimensional Data Model for OLAP. Technical Report, IFS, Vienna 1999.
Samtani, S., Mohania, M.K., Kumar, V., Kambayashi, Y.: Recent Advances and Research Problems in Data Warehousing. ER Workshops 1998.
Shoshani, A.: OLAP and Statistical Databases: Similarities and Differences. Tutorials of PODS 1997.
Shukla A., Deshpande, P., Naughton, J. F., Ramasamy, K.: Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies. VLDB 1996: 522–531
Thomsen, E.: OLAP solutions: Building Multidimensional Information Systems. John Wiley& Sons, Inc., 1997.
Trujillo, J., Palomar, M.: An Object Oriented Approach to Multidimensional Database. Conceptual Modeling (OOMD), DOLAP 1998.
Vassiliadis, P.: Modeling Multidimensional Databases, Cubes and Cube operations. In Proc. 10th Scientific and Statistical Database Management Conference (SSDBM’ 98), Capri, Italy, June 1998.
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.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights 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