Towards the Design of a Unified Recording and Querying Model for OLTP and OLAP Systems

Stephen Opoku-Anokye () and Yinshan Tang ()
Additional contact information
Stephen Opoku-Anokye: University of Reading
Yinshan Tang: University of Reading

A chapter in LISS 2013, 2015, pp 1105-1110 from Springer

Abstract: 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.

Keywords: Information Recording Modeling; OLAP and OLTP Information Sources; Facts with business operational context; Data with business rules (search for similar items in EconPapers)
Date: 2015
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sprchp:978-3-642-40660-7_166

Ordering information: This item can be ordered from
http://www.springer.com/9783642406607

DOI: 10.1007/978-3-642-40660-7_166

Access Statistics for this chapter

More chapters in Springer Books from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().