PEMODELAN INTEGRASI NEARLY REAL TIME DATA WAREHOUSE DENGAN SERVICE ORIENTED ARCHITECTURE UNTUK MENUNJANG SISTEM INFORMASI RETAIL

• Main Authors: I Made Dwi Jendra Sulastra, Made Sudarma, I Nyoman Satya Kumara
• Format: Article
• Language: English
• Published: Universitas Udayana 2015-12-01
• Series: Majalah Ilmiah Teknologi Elektro
• Subjects: Nearly realtime data warehouse; service oriented architecture; change data capture; transaction log; web service
• Online Access: http://ojs.unud.ac.id/index.php/JTE/article/view/18566

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