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.
Downloads
Keywords
This work is licensed under a Creative Commons Attribution 4.0 International License