Abstract
One of the key success points of a data warehousing project is the design of the multidimensional schema. Many researches shows that the use of ontologies in information system design is becoming more and more promising. In this paper, we propose a method for multidimensional design of data warehouses, from an operational data source, using ontologies. Furthermore, we introduce the concept of multidimensional ontology as a tool for the specification of multidimensional knowledge. In addition, we present an ontology-based method for data modeling schema that eventually covers different phases of the data warehouse life cycle, and takes into account the users by considering their personalized needs as well as their knowledge of the domain.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Abran, A., Cuadrado, J.J., Barriocanal, E.G., Mendes, O., Alonso, S.S., Sicilia, M.Á.: Engineering the ontology for the SWEBOK: issues and techniques. In: Ontologies for Software Engineering and Software Technology, pp. 103–121 (2006)
Bellatreche, L., Valduriez, P., Morzy, T.: Advances in databases and information systems. Inf. Sys. Front. 20(1), 1–6 (2018)
Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., Paraboschi, S.: Designing data marts for data warehouses. ACM Trans. Softw. Eng. Methodol. 10(4), 452–483 (2001)
Borgo, S., Hitzler, P., Kutz, O. (ed.): Formal Ontology in Information Systems - Proceedings of the 10th International Conference, FOIS 2018, Cape Town, South Africa, 19–21 September 2018, volume 306 of Frontiers in Artificial Intelligence and Applications. IOS Press (2018)
Boussaid, O, Bentayeb, F., Maïz, N. (ed.): A publishing system based on ontologies for the virtual storage Hammamet-Tunisie, 31 May–3 June 2006
Cabibbo, L., Torlone, R.: A logical approach to multidimensional databases. In: Schek, H.-J., Alonso, G., Saltor, F., Ramos, I. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 183–197. Springer, Heidelberg (1998). https://doi.org/10.1007/BFb0100985
Gallinucci, E., Golfarelli, M., Rizzi, S.: Schema profiling of document-oriented databases. Inf. Syst. 75, 13–25 (2018)
Giorgini, P., Rizzi, S., Garzetti, M.: GRAnD: a goal-oriented approach to requirement analysis in data warehouses. Decis. Support Syst. 45(1), 4–21 (2008)
Golfarelli, M., Maio, D., Rizzi, S.: Conceptual design of data warehouses from E/R schema. In: Thirty-First Annual Hawaii International Conference on System Sciences, Kohala Coast, Hawaii, USA, 6–9 January 1998, pp. 334–343 (1998)
Golfarelli, M., Rizzi, S.: A survey on temporal data warehousing. IJDWM 5(1), 1–17 (2009)
Kimball, R.: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. Wiley (1996)
Mazón, J.N., Lechtenbörger, J., Trujillo, J.: A survey on summarizability issues in multidimensional modeling. Data Knowl. Eng. 68(12), 1452–1469 (2009)
Mazón, J.N., Trujillo, J.: A hybrid model driven development framework for the multidimensional modeling of data warehouses!. SIGMOD Rec. 38(2), 12–17 (2009)
Moody, D.L. Kortink, M.A.R.: From enterprise models to dimensional models: a methodology for data warehouse and data mart design. In: Proceedings of the Second International Workshop on Design and Management of Data Warehouses, DMDW 2000, Stockholm, Sweden, p. 5, 5–6 June 2000
Ovchinnikova, E., Kühnberger, K., Thiele, M., Lehner, W.: Aspects of automatic ontology extension: adapting and regeneralizing dynamic updates. In: Proceedings of the 6th of the Second Australasian Workshop on Advances in Ontologies, vol. 72, pp. 51–60 (2006)
Phipps, C., Davis, K.C.: Automating data warehouse conceptual schema design and evaluation. In: Design and Management of Data Warehouses 2002, Proceedings of the 4th International Workshop DMDW 2002, Toronto, Canada, 27 May 2002, pp. 23–32 (2002)
O. Romero and A. Abelló
Soussi, A., Feki, J., Gargouri, F.: Automatic generation and validation of schemas of data marts. In: Entrepôts Tunisie, 10 Juin 2005
Thenmozhi, M., Vivekanandan, K.: A tool for data warehouse multidimensional schema design using ontology. Int. J. Comput. Sci. Issues (IJCSI) 10(02), 161–168 (2013)
Zekri, M., Marsit, I., Abdellatif, A.: A new data warehouse approach using graph theory. In: IEEE International Conference on e-Business Engineering (ICEBE 2011), 19–21 Octobre 2011, China (2011)
Zekri, M., Marsit, I., Abdellatif, A.: Query history based approach for data warehouse design. In: 1st International Conference on Model & Data Engineering (MEDI 2011), 28–30 Septembre 2011, Obidos, Portugal (2011)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Zekri, M., Yahia, S.B., Hilali-Jaghdam, I. (2019). A Software Prototype for Multidimensional Design of Data Warehouses Using Ontologies. In: Nguyen, N., Chbeir, R., Exposito, E., Aniorté, P., Trawiński, B. (eds) Computational Collective Intelligence. ICCCI 2019. Lecture Notes in Computer Science(), vol 11684. Springer, Cham. https://doi.org/10.1007/978-3-030-28374-2_24
Download citation
DOI: https://doi.org/10.1007/978-3-030-28374-2_24
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-28373-5
Online ISBN: 978-3-030-28374-2
eBook Packages: Computer ScienceComputer Science (R0)