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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Inmon, W.: Building the Data Warehouse, 4th edn. John Wiley & Sons, Inc., New York (2005)
Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP technology. ACM Sigmod Record 26(1), 65–74 (1997)
Kimball, R.: The data warehouse toolkit. John Wiley & Sons (2006)
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)
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)
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)
Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of Data Warehouses, 2nd edn. Springer (2003)
Herreman, D., Schau, D., Bell, R., Kim, E., Valencic, A.: Data modeling techniques for data warehousing. IBM (1998)
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)
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)
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)
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)
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)
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)
Sen, A., Sinha, A.P.: A comparison of data warehousing methodologies. Communications of the ACM 48(3), 79–84 (2005)
Romero, O., Abelló, A.: A survey of multidimensional modeling methodologies. International Journal of Data Warehousing and Mining (IJDWM) 5(2), 1–23 (2009)
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)
Talwar, K., Gosain, A.: Hierarchy Classification for Data Warehouse: A Survey. Procedia Technology 6, 460–468 (2012)
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)
Rizzi, S.: Conceptual modeling solutions for the data warehouse. Data Warehouses and OLAP: Concepts. Architectures and Solutions, 1–26 (2007)
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)
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)
Sánchez, A.: Multidimensional conceptual model IDEA. Ph. D. Thesis, in spanish (2001)
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)
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)
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)
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)
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)
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)
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)
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)
Trujillo, J., Palomar, M., Gomez, J., Song, I.Y.: Designing data warehouses with OO conceptual models. IEEE Computer 34(12), 66–75 (2001)
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)
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)
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)
Lechtenbörger, J.: Data warehouse schema design, vol. 79. IOS Press (2001)
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)
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)
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)
Abelló, A., Samos, J., Saltor, F.: YAM2: a multidimensional conceptual model extending UML. Information Systems 31(6), 541–567 (2006)
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)
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)
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)
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)
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)
Prat, N., Akoka, J., Comyn-Wattiau, I.: A UML-based data warehouse design method. Decision Support Systems 42(3), 1449–1473 (2006)
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)
Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data & Knowledge Engineering 59(2), 348–377 (2006)
Mansmann, S., Scholl, M.H.: Extending the Multidimensional Data Model to Handle Complex Data. JCSE 1(2), 125–160 (2007)
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)
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)
Franconi, E., Kamble, A.: A Data Warehouse Conceptual Data Model. In: Proceedings of the International Conference on SSDBM, vol. 4, pp. 435–436 (2004)
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)
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)
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)
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)
Giovinazzo, W.A.: Object-oriented data warehouse design: building a star schema. Prentice Hall PTR (2000)
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)
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)
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)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)