Skip to main content

2024 | OriginalPaper | Buchkapitel

Ontological Analysis of Dimensional Modeling Concepts in Data Warehousing/Business Intelligence Systems

verfasst von : Petr Prokop, Robert Pergl

Erschienen in: Advances in Enterprise Engineering XVII

Verlag: Springer Nature Switzerland

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literatur
1.
Zurück zum Zitat Devens, R.M.: Cyclopædia of Commercial and Business Anecdotes. D. Appleton and Company, London, New York (1865) Devens, R.M.: Cyclopædia of Commercial and Business Anecdotes. D. Appleton and Company, London, New York (1865)
2.
Zurück zum Zitat Castells, M.: The Information Age: Economy, Society and Culture Volume 1: The Rise of the Network Society, 2nd edn. Wiley Blackwell, Oxford (2010) Castells, M.: The Information Age: Economy, Society and Culture Volume 1: The Rise of the Network Society, 2nd edn. Wiley Blackwell, Oxford (2010)
3.
Zurück zum Zitat Sherman, R.: Business Intelligence Guidebook: From Data Integration to Analytics. Elsevier, Morgan Kaufmann is an Imprint of Elsevier, Amsterdam (2015) Sherman, R.: Business Intelligence Guidebook: From Data Integration to Analytics. Elsevier, Morgan Kaufmann is an Imprint of Elsevier, Amsterdam (2015)
4.
Zurück zum Zitat 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 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
5.
Zurück zum Zitat 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 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
9.
Zurück zum Zitat Husserl, E., Moran, D.: Logical Investigations, International Library of Philosophy. Routledge, London, New York (2001) Husserl, E., Moran, D.: Logical Investigations, International Library of Philosophy. Routledge, London, New York (2001)
10.
Zurück zum Zitat Inmon, W.H.: Building the Data Warehouse, 4th edn. Wiley, Indianapolis (2005) Inmon, W.H.: Building the Data Warehouse, 4th edn. Wiley, Indianapolis (2005)
11.
Zurück zum Zitat Inmon, W.H., Strauss, D., Neushloss, G.: DW 2.0: The Architecture for the Next Generation of Data Warehousing. Morgan Kaufmann, Amsterdam, Boston (2008) Inmon, W.H., Strauss, D., Neushloss, G.: DW 2.0: The Architecture for the Next Generation of Data Warehousing. Morgan Kaufmann, Amsterdam, Boston (2008)
12.
Zurück zum Zitat Kimball, R., Caserta, J.: The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. Wiley, Indianapolis (2004) Kimball, R., Caserta, J.: The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. Wiley, Indianapolis (2004)
13.
Zurück zum Zitat Linstedt, D., Olschimke, M.: Building a Scalable Data Warehouse with Data Vault 2.0. Morgan Kaufmann, An Imprint of Elsevier, Amsterdam, Boston, Heidelberg (2015) Linstedt, D., Olschimke, M.: Building a Scalable Data Warehouse with Data Vault 2.0. Morgan Kaufmann, An Imprint of Elsevier, Amsterdam, Boston, Heidelberg (2015)
14.
Zurück zum Zitat Corr, L., Stagnitto, J.: Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema, revised edn. Decision Press, Leeds (2014) Corr, L., Stagnitto, J.: Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema, revised edn. Decision Press, Leeds (2014)
15.
Zurück zum Zitat 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)CrossRef 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)CrossRef
18.
Zurück zum Zitat 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 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
19.
Zurück zum Zitat Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edn. Wiley, Indianapolis (2013) Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edn. Wiley, Indianapolis (2013)
Metadaten
Titel
Ontological Analysis of Dimensional Modeling Concepts in Data Warehousing/Business Intelligence Systems
verfasst von
Petr Prokop
Robert Pergl
Copyright-Jahr
2024
DOI
https://doi.org/10.1007/978-3-031-58935-5_3

Premium Partner