Towards the design of a unified semantics model for OLTP and OLAP systems

Opoku-Anokye, S. and Tang, Y. ORCID: https://orcid.org/0000-0002-1134-4170 (2013) Towards the design of a unified semantics model for OLTP and OLAP systems. In: 14th International Conference on Informatics and Semiotics in Organisation (ICISO), 25 -27 Mar 2013, Stockholm, Sweden, pp. 106-112.

Abstract/Summary

The concepts of on-line transactional processing (OLTP) and on-line analytical processing (OLAP) are often confused with the technologies or models that are used to design transactional and analytics based information systems. This in some way has contributed to existence of gaps between the semantics in information captured during transactional processing and information stored for analytical use. In this paper, we propose the use of a unified semantics design model, as a solution to help bridge the semantic gaps between data captured by OLTP systems and the information provided by OLAP systems. The central focus of this design approach is on enabling business intelligence using not just data, but data with context.