Skip to main content
SpringerLink
Log in

Conceptual Multidimensional Modeling for Data Warehouses: A Survey

  • Conference paper
Book cover Proceedings of the 3rd International Conference on Frontiers of Intelligent Computing: Theory and Applications (FICTA) 2014

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 327))

Abstract

Conceptual multidimensional modeling aims at providing high level of abstraction to describe the data warehouse process and architecture, independent of implementation issues. It is widely accepted as one of the major parts of overall data warehouse development process. In the last several years, there has been a lot of work devoted to conceptual multidimensional modeling for data warehouses. This paper presents a survey of various proposed conceptual multidimensional models for core as well as advanced features supported. Hereafter, a comparison of the models is done based on the criteria broadly categorized as: general aspects, relationship aspects and implementation aspects, showing the evolution in this area. General aspects involve basic features of the multidimensional model. The relationships among various constructs used in the multidimensional model are referred under relationship criteria. The implementation criteria relate aspects such as mathematical formalism and guidelines to define complex multidimensional structures.

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 169.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

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. Inmon, W.: Building the Data Warehouse, 4th edn. John Wiley & Sons, Inc., New York (2005)

    Google Scholar 

  2. Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP technology. ACM Sigmod Record 26(1), 65–74 (1997)

    Article  Google Scholar 

  3. Kimball, R.: The data warehouse toolkit. John Wiley & Sons (2006)

    Google Scholar 

  4. Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP, pp. 3–10. ACM (2006)

    Google Scholar 

  5. Mazón, J.N., Lechtenbörger, J., Trujillo, J.: Solving summarizability problems in fact-dimension relationships for multidimensional models. In: Proceedings of the ACM 11th International Workshop on Data Warehousing and OLAP, pp. 57–64. ACM (2008)

    Google Scholar 

  6. Mazón, J.N., Lechtenbörger, J., Trujillo, J.: A survey on summarizability issues in multidimensional modeling. Data & Knowledge Engineering 68(12), 1452–1469 (2009)

    Article  Google Scholar 

  7. Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of Data Warehouses, 2nd edn. Springer (2003)

    Google Scholar 

  8. Herreman, D., Schau, D., Bell, R., Kim, E., Valencic, A.: Data modeling techniques for data warehousing. IBM (1998)

    Google Scholar 

  9. Lehner, W.: Modeling large scale OLAP scenarios. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 153–167. Springer, Heidelberg (1998)

    Google Scholar 

  10. Cabibbo, L., Torlone, R.: A logical approach to multidimensional databases. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 183–197. Springer, Heidelberg (1998)

    Chapter  Google Scholar 

  11. Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: a conceptual model for data warehouses. International Journal of Cooperative Information Systems 7(02-03), 215–247 (1998)

    Article  Google Scholar 

  12. Trujillo, J.: The GOLD model: An Object Oriented multidimensional data model for multidimensional databases. In: Proc. of the ECOOP Workshop for Ph.D. Students in Object Oriented Systems, Lisbon, Portugal (1999)

    Google Scholar 

  13. Nguyen, T.B., Tjoa, A.M., Wagner, R.R.: An object oriented multidimensional data model for OLAP. In: Lu, H., Zhou, A. (eds.) WAIM 2000. LNCS, vol. 1846, pp. 69–82. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  14. Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual data warehouse design. In: Proc. of 2nd Int. Workshop on Design and Management of Data Warehouses (DMDW), Stockholm, Sweden, pp. 6–1 (2000)

    Google Scholar 

  15. Sen, A., Sinha, A.P.: A comparison of data warehousing methodologies. Communications of the ACM 48(3), 79–84 (2005)

    Article  MathSciNet  Google Scholar 

  16. Romero, O., Abelló, A.: A survey of multidimensional modeling methodologies. International Journal of Data Warehousing and Mining (IJDWM) 5(2), 1–23 (2009)

    Article  Google Scholar 

  17. Pérez, J.M., Berlanga, R., Aramburu, M.J., Pedersen, T.B.: Integrating data warehouses with web data: A survey. IEEE Transactions Knowledge and Data Engineering 20(7), 940–955 (2008)

    Article  Google Scholar 

  18. Talwar, K., Gosain, A.: Hierarchy Classification for Data Warehouse: A Survey. Procedia Technology 6, 460–468 (2012)

    Article  Google Scholar 

  19. Abelló, A., Samos, J., Saltor, F.: A data warehouse multidimensional data models classification. In: Proceedings of the International Conference on Database and Expert Systems Applications, Munich, pp. 668–677 (2000)

    Google Scholar 

  20. Rizzi, S.: Conceptual modeling solutions for the data warehouse. Data Warehouses and OLAP: Concepts. Architectures and Solutions, 1–26 (2007)

    Google Scholar 

  21. Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: A foundation for capturing and querying complex multidimensional data. Information Systems 26(5), 383–423 (2001)

    Article  MATH  Google Scholar 

  22. Jensen, C.S., Kligys, A., Pedersen, T.B., Timko, I.: Multidimensional data modeling for location-based services. The VLDB Journal-The International Journal on Very Large Data Bases 13(1), 1–21 (2004)

    Article  Google Scholar 

  23. Sánchez, A.: Multidimensional conceptual model IDEA. Ph. D. Thesis, in spanish (2001)

    Google Scholar 

  24. Konovalov, A.: Object-oriented data model for data warehouse. In: Manolopoulos, Y., Návrat, P. (eds.) ADBIS 2002. LNCS, vol. 2435, pp. 319–325. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  25. Golfarelli, M., Maio, D., Rizzi, S.: Conceptual design of data warehouses from E/R schemes. In: Proceedings of the Thirty-First Hawaii International Conference on System Sciences, vol. 7, pp. 334–343. IEEE (1998)

    Google Scholar 

  26. Golfarelli, M., Rizzi, S.: A methodological framework for data warehouse design. In: Proceedings of the 1st ACM International Workshop on Data Warehousing and OLAP, pp. 3–9. ACM (1998)

    Google Scholar 

  27. Golfarelli, M., Rizzi, S.: Designing the data warehouse: Key steps and crucial issues. Journal of Computer Science and Information Management 2(3), 88–100 (1999)

    Google Scholar 

  28. Trujillo, J., Palomar, M.: An object oriented approach to multidimensional database conceptual modeling (OOMD). In: Proceedings of the 1st ACM international workshop on Data warehousing and OLAP, pp. 16–21. ACM (1998)

    Google Scholar 

  29. Trujillo, J., Gómez, J., Palomar, M.S.: Modeling the behavior of OLAP applications using an UML compliant approach. In: Yakhno, T. (ed.) ADVIS 2000. LNCS, vol. 1909, pp. 14–23. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  30. Trujillo, J., Palomar, M.S., Gómez, J.: Applying object-oriented conceptual modeling techniques to the design of multidimensional databases and OLAP applications. In: Lu, H., Zhou, A. (eds.) WAIM 2000. LNCS, vol. 1846, pp. 83–94. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  31. Trujillo, J., Palomar, M., Gómez, J.: Detecting patterns and OLAP operations in the GOLD model. In: Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, pp. 48–53. ACM (1999)

    Google Scholar 

  32. Trujillo, J., Palomar, M., Gomez, J., Song, I.Y.: Designing data warehouses with OO conceptual models. IEEE Computer 34(12), 66–75 (2001)

    Article  Google Scholar 

  33. Sapia, C., Blaschka, M., Höfling, G., Dinter, B.: Extending the E/R model for the multidimensional paradigm. In: Kambayashi, Y., Lee, D.-L., Lim, E.-p., Mohania, M., Masunaga, Y. (eds.) ER Workshops 1998. LNCS, vol. 1552, pp. 105–116. Springer, Heidelberg (1999)

    Chapter  Google Scholar 

  34. Tryfona, N., Busborg, F., Borch Christiansen, J.G.: starER: a conceptual model for data warehouse design. In: Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, pp. 3–8. ACM (1999)

    Google Scholar 

  35. Franconi, E., Sattler, U.: A data warehouse conceptual data model for multidimensional aggregation: a preliminary report. In: Proc. of the Workshop on Design and Management of Data Warehouses (1999)

    Google Scholar 

  36. Lechtenbörger, J.: Data warehouse schema design, vol. 79. IOS Press (2001)

    Google Scholar 

  37. Tsois, A., Karayannidis, N., Sellis, T.K.: MAC: Conceptual data modeling for OLAP. In: Proceedings of the International Workshop on Design and Management of Data Warehouses, vol. 1, p. 5 (2001)

    Google Scholar 

  38. Luján-Mora, S., Trujillo, J., Song, I.Y.: Extending the UML for multidimensional modeling. In: Jézéquel, J.-M., Hussmann, H., Cook, S. (eds.) UML 2002. LNCS, vol. 2460, pp. 290–304. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  39. Luján-Mora, S., Trujillo, J., Song, I.Y.: Multidimensional modeling with UML package diagrams. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, pp. 199–213. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  40. Abelló, A., Samos, J., Saltor, F.: YAM2: a multidimensional conceptual model extending UML. Information Systems 31(6), 541–567 (2006)

    Article  Google Scholar 

  41. Abelló, A., Samos, J., Saltor, F.: YAM2 (Yet Another Multidimensional Model): An Extension of UML. In: Database Engineering and Applications Symposium, International, pp. 172–172. IEEE Computer Society (2002)

    Google Scholar 

  42. Lenz, H.J., Shoshani, A.: Summarizability in OLAP and statistical data bases. In: Proceedings of Ninth International Conference on Scientific and Statistical Database Management, pp. 132–143. IEEE (1997)

    Google Scholar 

  43. Abelló, A., Samos, J., Saltor, F.: Implementing operations to navigate semantic star schemas. In: Proceedings of the 6th ACM International Workshop on Data Warehousing and OLAP, pp. 56–62. ACM (2003)

    Google Scholar 

  44. Blaschka, M., Sapia, C., Hofling, G., Dinter, B.: Finding your way through multidimensional data models. In: Proceedings of Ninth International Workshop on Database and Expert Systems Applications, pp. 198–203. IEEE Computer Society (1998)

    Google Scholar 

  45. Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering 59(3), 725–769 (2006)

    Article  Google Scholar 

  46. Prat, N., Akoka, J., Comyn-Wattiau, I.: A UML-based data warehouse design method. Decision Support Systems 42(3), 1449–1473 (2006)

    Article  Google Scholar 

  47. Malinowski, E., Zimányi, E.: OLAP hierarchies: A conceptual perspective. In: Persson, A., Stirna, J. (eds.) CAiSE 2004. LNCS, vol. 3084, pp. 477–491. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  48. Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data & Knowledge Engineering 59(2), 348–377 (2006)

    Article  Google Scholar 

  49. Mansmann, S., Scholl, M.H.: Extending the Multidimensional Data Model to Handle Complex Data. JCSE 1(2), 125–160 (2007)

    Google Scholar 

  50. Mansmann, S., Scholl, M.H.: Empowering the OLAP technology to support complex dimension hierarchies. International Journal of Data Warehousing and Mining (IJDWM) 3(4), 31–50 (2007)

    Article  Google Scholar 

  51. Kamble, A.S.: A conceptual model for multidimensional data. In: Proceedings of the Fifth Asia-Pacific Conference on Conceptual Modelling, vol. 79, pp. 29–38. Australian Computer Society, Inc. (2008)

    Google Scholar 

  52. Franconi, E., Kamble, A.: A Data Warehouse Conceptual Data Model. In: Proceedings of the International Conference on SSDBM, vol. 4, pp. 435–436 (2004)

    Google Scholar 

  53. Franconi, E., Kamble, A.: The GMD Data Model and Algebra for Multidimensional Information. In: Persson, A., Stirna, J. (eds.) CAiSE 2004. LNCS, vol. 3084, pp. 446–462. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  54. Sarkar, A., Choudhury, S., Chaki, N., Bhattacharya, S.: Conceptual Level Design of Object Oriented Data Warehouse: Graph Semantic Based Model. International Journal of Computer Science (INFOCOMP) 8(4), 60–70 (2009)

    Google Scholar 

  55. Choudhury, S., Chaki, N., Bhattacharya, S.: Gdm: a new graph based data model using functional abstraction. Journal of Computer Science and Technology 21(3), 430–438 (2006)

    Article  Google Scholar 

  56. Sarkar, A., Bhattacharya, S.: The graph object oriented multidimensional data model: A conceptual perspective. In: Proceedings of the 16th International Conference on Software Engineering and Data Engineering, pp. 165–170 (2007)

    Google Scholar 

  57. Giovinazzo, W.A.: Object-oriented data warehouse design: building a star schema. Prentice Hall PTR (2000)

    Google Scholar 

  58. Hurtado, C.A., Mendelzon, A.O.: Reasoning about summarizability in heterogeneous multidimensional schemas. In: Proceedings of the 21st ACM Int. Conf. on Management of Data and Symposium on Principle of Databases Systems, pp. 169–179 (2001)

    Google Scholar 

  59. Rowen, W., Song, I.Y., Medsker, C., Ewen, E.: An analysis of many-to-many relationships between fact and dimension tables in dimensional modeling. In: Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW 2001), Interlaken, Switzerland (2001)

    Google Scholar 

  60. Jagadish, H.V., Lakshmanan, L.V.S., Srivastava, D.: What can hierarchies do for data warehouses? In: Proceedings of the 25th International Conference on Very Large Databases, pp. 530–541 (1999)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University School of Information and Communication Technology, Guru Gobind Singh Indraprastha University, New Delhi, 110078, India

    Anjana Gosain & Jaspreeti Singh

Authors
  1. Anjana Gosain
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jaspreeti Singh
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Anjana Gosain .

Editor information

Editors and Affiliations

  1. Department of Computer Science and Engineering, Anil Neerukonda Institute of Technology and Sciences, Vishakapatnam, Andhra Pradesh, India

    Suresh Chandra Satapathy

  2. Bhubaneswar Engineering College, Bhubaneswar, Odisha, India

    Bhabendra Narayan Biswal

  3. University of Hyderabad, Hyderabad, Andhra Pradesh, India

    Siba K. Udgata

  4. Department of Computer Science and Engineering, University of Kalyanai, Faculty of Engg., Tech. & Management, Kalyanai, West Bengal, India

    J.K. Mandal

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Gosain, A., Singh, J. (2015). Conceptual Multidimensional Modeling for Data Warehouses: A Survey. In: Satapathy, S., Biswal, B., Udgata, S., Mandal, J. (eds) Proceedings of the 3rd International Conference on Frontiers of Intelligent Computing: Theory and Applications (FICTA) 2014. Advances in Intelligent Systems and Computing, vol 327. Springer, Cham. https://doi.org/10.1007/978-3-319-11933-5_33

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-11933-5_33

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-11932-8

  • Online ISBN: 978-3-319-11933-5

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation