Pemodelan Integrasi Nearly Real Time Data Warehouse Dengan Service Oriented Architecture Untuk Menunjang Sistem Informasi Retail

Abstract

Updates the data in the data warehouse is not traditionally done every transaction. Retail information systems require the latest data and can be accessed from anywhere for business analysis needs. Therefore, in this study will be made data warehouse model that is able to produce the information near real time, and can be accessed from anywhere by end users application. Modeling design integration of nearly real time data warehouse (NRTDWH) with a service oriented architecture (SOA) to support the retail information system is done in two stages. In the first stage will be designed modeling NRTDWH using Change Data Capture (CDC) based Transaction Log. In the second stage will be designed modeling NRTDWH integration with SOA-based web service. Tests conducted by a simulation test applications. Test applications used retail information systems, web-based web service client, desktop, and mobile. Results of this study were (1) ETL-based CDC captures changes to the source table and then store it in the database NRTDWH with the help of a scheduler; (2) Middleware web service makes 6 service based on data contained in the database NRTDWH, and each of these services accessible and implemented by the web service client.

A Model and Implementation of Academic Data Integration in Near-Real Time Using Message-Oriented Middleware to Support Analysis of Student Performance in the Information Technology Department of Politeknik Caltex Riau

“…Another research by [3] designed near real-time data warehouse integration model for accommodating integration and access to a big amount of data in a retail business using Service Oriented Architecture that used Change Data Capture (CDC). The web service also used NuSOAP as the web service library.…”

“…Based on the reliability testing that has been conducted on 10 test cases, the reliability aspect can be obtained using formula based on ISO 9126 as shown in (3) and 4 As both of the reliability aspect scores are equal 0, both patterns can be said as reliable.…”

Implementation of Data Backup and Synchronization Based on Identity Column Real Time Data Warehouse

“…The current trend, an organization needs the latest information in decision making. The realtime data warehouse has different characteristics from the classic data warehouse [1][2] [5] [7] [11]. To achieve real-time data warehouse is very dependent on the process known as ETL (Extract, Transform, Loading) [1][2] [5] [7][10] [11] [12] [13] [14] [15][16] [17].…”

“…The realtime data warehouse has different characteristics from the classic data warehouse [1][2] [5] [7] [11]. To achieve real-time data warehouse is very dependent on the process known as ETL (Extract, Transform, Loading) [1][2] [5] [7][10] [11] [12] [13] [14] [15][16] [17]. There are several ETL approaches to realizing real-time data warehouse between processing data that only undergoes updating or known as the Change Data Capture (CDC) concept [1][2] [5][10] [11] [16] [18].…”

“…An identity column is a column (field) in a table whose value will be used as a benchmark when data will be pulled from the source system and then stored in a data warehouse [2]. Some research has been carried out of RTDW, such as research on RTDW modeling using the CDC [5][10] [11][16] [18]. There is also research on making RTDW using the CDC Event-Driven Programming method [11].…”