Abstract
Collecting, processing and utilizing data information plays an increasingly important role in data warehousing/business intelligence (DWH/BI) systems. Currently, these systems are predominantly described using natural text, informal diagrams, or UML (Unified Modeling Language) diagrams. These potentially imprecise methods for describing new or complex DWH/BI topics can in combination with variations in naming and interpretations of concepts between different authors lead to miscommunication issues. This paper shows the possibility and benefits of using a more formal approach in documenting and describing such systems or their parts, which results in a more precise form of communication between researchers or industry experts. The conceptual analysis of selected parts of the DWH/BI domain is done using the OntoUML modeling language.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Devens, R.M.: Cyclopædia of Commercial and Business Anecdotes. D. Appleton and Company, London, New York (1865)
Castells, M.: The Information Age: Economy, Society and Culture Volume 1: The Rise of the Network Society, 2nd edn. Wiley Blackwell, Oxford (2010)
Sherman, R.: Business Intelligence Guidebook: From Data Integration to Analytics. Elsevier, Morgan Kaufmann is an Imprint of Elsevier, Amsterdam (2015)
Khan, S., Qader, M.R., Thirunavukkarasu, K., Abimannan, S.: Analysis of business intelligence impact on organizational performance. In: 2020 International Conference on Data Analytics for Business and Industry: Way Towards a Sustainable Economy (ICDABI). Presented at the 2020 International Conference on Data Analytics for Business and Industry: Way Towards a Sustainable Economy (ICDABI). IEEE, Sakheer, Bahrain, pp. 1–4 (2020). https://doi.org/10.1109/ICDABI51230.2020.9325610
Martins, A., Martins, P., Caldeira, F., Sá, F.: An evaluation of how big-data and data warehouses improve business intelligence decision making. In: Rocha, Á., Adeli, H., Reis, L.P., Costanzo, S., Orovic, I., Moreira, F. (eds.) Trends and Innovations in Information Systems and Technologies, vol. 1, pp. 609–619. Springer, Cham (2020). https://doi.org/10.1007/978-3-030-45688-7_61
Guizzardi, G., Benevides, A., Fonseca, C., Porello, D., Almeida, J., Prince Sales, T.: UFO: Unified foundational ontology. Appl. Ontol. (2021). https://doi.org/10.3233/AO-210256
Studer, R., Benjamins, V.R., Fensel, D.: Knowledge engineering: principles and methods. Data Knowl. Eng. 25, 161–197 (1998). https://doi.org/10.1016/S0169-023X(97)00056-6
Nardi, J.C., et al.: Towards a commitment-based reference ontology for services, pp. 175–184. IEEE (2013). https://doi.org/10.1109/EDOC.2013.28
Husserl, E., Moran, D.: Logical Investigations, International Library of Philosophy. Routledge, London, New York (2001)
Inmon, W.H.: Building the Data Warehouse, 4th edn. Wiley, Indianapolis (2005)
Inmon, W.H., Strauss, D., Neushloss, G.: DW 2.0: The Architecture for the Next Generation of Data Warehousing. Morgan Kaufmann, Amsterdam, Boston (2008)
Kimball, R., Caserta, J.: The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. Wiley, Indianapolis (2004)
Linstedt, D., Olschimke, M.: Building a Scalable Data Warehouse with Data Vault 2.0. Morgan Kaufmann, An Imprint of Elsevier, Amsterdam, Boston, Heidelberg (2015)
Corr, L., Stagnitto, J.: Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema, revised edn. Decision Press, Leeds (2014)
Guizzardi, G., Baião, F., Lopes, M., Falbo, R.: The role of foundational ontologies for domain ontology engineering: an industrial case study in the domain of oil and gas exploration and production. Int. J. Inf. Syst. Model. Des. (IJISMD) 1, 1–22 (2010)
Griffo, C., Almeida, J.P.A., Guizzardi, G.: A pattern for the representation of legal relations in a legal core ontology. Front. Artif. Intell. Appl. 294, 191–194 (2016). https://doi.org/10.3233/978-1-61499-726-9-191
Dhaouadi, A., Bousselmi, K., Gammoudi, M.M., Monnet, S., Hammoudi, S.: Data warehousing process modeling from classical approaches to new trends: main features and comparisons. Data 7, 113 (2022). https://doi.org/10.3390/data7080113
Yessad, L., Labiod, A.: Comparative study of data warehouses modeling approaches: Inmon, Kimball and Data Vault. In: 2016 International Conference on System Reliability and Science (ICSRS). Presented at the 2016 International Conference on System Reliability and Science (ICSRS), pp. 95–99. IEEE, Paris, France (2016). https://doi.org/10.1109/ICSRS.2016.7815845
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edn. Wiley, Indianapolis (2013)
Acknowledgments
This research was supported by the Czech Technical University in Prague grant No. SGS23/206/OHK3/3T/18.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2024 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Prokop, P., Pergl, R. (2024). Ontological Analysis of Dimensional Modeling Concepts in Data Warehousing/Business Intelligence Systems. In: Malinova Mandelburger, M., Guerreiro, S., Griffo, C., Aveiro, D., Proper, H.A., Schnellmann, M. (eds) Advances in Enterprise Engineering XVII. EDEWC 2023. Lecture Notes in Business Information Processing, vol 510. Springer, Cham. https://doi.org/10.1007/978-3-031-58935-5_3
Download citation
DOI: https://doi.org/10.1007/978-3-031-58935-5_3
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-58934-8
Online ISBN: 978-3-031-58935-5
eBook Packages: Computer ScienceComputer Science (R0)