A Hybrid OLAP & OLTP Architecture Using Non-Relational Data Components

Faculty/Professorship: Lehrstuhl für Wirtschaftsinformatik, insbes. Systementwicklung und Datenbankanwendung 
Author(s): Benker, Thomas
Editors: Jung, Reinhard; Reichert, Manfred
Title of the compilation: Enterprise Modelling and Information Systems Architectures (EMISA 2013) : Fifth International Workshop on Enterprise Modelling and Information Systems Architectures, September 5 - 6, 2013 St.Gallen, Switzerland
Corporate Body: Gesellschaft für Informatik
Publisher Information: Bonn : Köllen
Year of publication: 2013
Pages: 41-54 ; Illustrationen
ISBN: 978-3-88579-616-9
Series ; Volume: Lecture Notes in Informatics (LNI) / GI-Edition : Proceedings
Language(s): English
URL: http://emisa2013.iwi.unisg.ch/index.php?eID=tx_...
Relational database systems are still the first choice for the realization of business application systems. They are used as operational databases to persist business process data or as the basis for data warehouse systems. In recent years, the NoSQL-movement proposed a number of new non-relational data stores because of changing requirements of Web 2.0 applications and related limitations of relational systems. We argue that these new systems can also be used in OLTP- and right-time OLAP-scenarios. We demonstrate how enterprise application systems can be realized based on concepts of the NoSQL-movement. We propose an architecture that enables the deployment of an appropriate data model to a certain business domain and the integration of OLTP- and OLAP-functionality. Components of the architecture are suited to enhance business data with analysis-relevant information and to perform analysis tasks. To demonstrate the application of the architecture and its analytic features, we introduce a short case study.
Type: Conferenceobject
URI: https://fis.uni-bamberg.de/handle/uniba/2446
Year of publication: 20. November 2013