OLTP and OLAP Data Integration: A Review of Feasible Implementation Methods and Architectures for Real Time Data Analysis

Abstract

This paper elaborates on the justification and need for integration of OLTP (online transaction processing) and OLAP (online analytical processing) data environments for the purpose of real time data analysis, and reviews potential implementation methods and architectures for integration of these disparate environments. A body of relevant literature is reviewed to answer a central question on the efficacy of OLTP and OLAP integrated environments, and the central question is made tractable by its decomposition to the essential questions that must be answered regarding the feasibility of various methods and architectures for integrating data architectures. Additional coverage is given to proposed architectures and methods for real time data warehouses in the context of OLTP and OLAP data integration. This qualitative study uses an interpretivist epistemology to reach conclusions about the literature's treatment of the topic and the justification and need for data integration to accomplish real time data analysis in the business enterprise.