On the Application of Ontological Patterns for Conceptual Modeling in Multidimensional Models

• Published in: Advances in Databases and Information Systems Vol. 11695; pp. 215 - 231
• Main Authors: Amaral, Glenda, Guizzardi, Giancarlo
• Format: Book Chapter
• Language: English
• Published: Switzerland Springer International Publishing AG 2019; Springer International Publishing
• Series: Lecture Notes in Computer Science
• Subjects: Conceptual modeling; Data warehouse; Multidimensional modeling; Ontological patterns
• ISBN: 9783030287290; 3030287297
• ISSN: 0302-9743; 1611-3349
• DOI: 10.1007/978-3-030-28730-6_14

Data warehouses (DW) play a decisive role in providing analytical information for decision making. Multidimensional modeling is a special approach to modeling data, considered the foundation for building data warehouses. With the explosive growth in the amount of heterogeneous data (most of which external to the organization) in the latest years, the DW has been impacted by the need to interoperate and deal with the complexity of this new type of information, such as big data, data lakes and cognitive computing platforms, becoming evident the need to improve the semantic expressiveness of the DW. Research has shown that ontological theories can play a fundamental role in improving the quality of conceptual models, reinforcing their potential to support semantic interoperability in its various manifestations. In this paper we propose the application of ontological patterns, grounded in the Unified Foundational Ontology (UFO), for conceptual modeling in multidimensional models, in order to improve the semantic expressiveness of the models used to represent analytical data in a DW.