Anzeige
Erschienen in:
2015 | OriginalPaper | Buchkapitel
Towards the Design of a Unified Recording and Querying Model for OLTP and OLAP Systems
verfasst von : Stephen Opoku-Anokye, Yinshan Tang
Erschienen in: LISS 2013
Verlag: Springer Berlin Heidelberg
Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.
Wählen Sie Textabschnitte aus um mit Künstlicher Intelligenz passenden Patente zu finden. powered by
Markieren Sie Textabschnitte, um KI-gestützt weitere passende Inhalte zu finden. powered by
Abstract
To improve efficiency of processing transactions, data duplications in information stored need to be minimised. A variety of data modeling techniques are adopted to help achieve these objectives during OLTP systems design. Making the use of OLAP systems to recall information stored in OLTP systems inefficient or in some cases unsuitable. These gives rise to the need to extract, cleanse, transform and load data from OLTP systems’ databases into databases design for OLAP purposes. This paper reviews the modeling of information stored in OLTP systems as facts with operational context. A unified model for designing information recording and querying is proposed. The design model enables OLTP systems to record and store data with execution of business rules; to allow for use of OLTP and OLAP systems to query data with business rules used to capture data. Ensuring information recalled via OLAP systems preserves the context of original information captured.