CogITo Smart Journal
Vol. 9 No. 1 (2023): Cogito Smart Journal

Teknik Optimasi Database dengan Logic Execution Optimization pada Microservices Architecture

Isnen Hadi Al Ghozali (Universitas Budi Luhur)
Mohammad Shiddiq Antarressa (Universitas Budi Luhur)
Samidi Samidi (Unknown)



Article Info

Publish Date
30 Jun 2023

Abstract

Microservices architecture, a distributed framework architecture that allows changes to one module without interfering with other modules. The implementation of this architecture has its own challenges. The get-list-attachment API running on this architecture takes an average of 12.5 seconds to serve data. This needs to be considered because business processes require shorter access times to support decision making. The research objective is to obtain query response time efficiency for accounting applications. To achieve this, the research uses database optimization techniques with logic execution optimization microservices architecture. This study obtained the source of information from the Accounting Harmony Accounting Module, which has an API (get-list-attachment) with data sourced from Service Accounting (581253 records) and Service Users (2182 records). Based on a series of tests carried out, several services need to be added with APIs to improve the microservices architecture to accept bulk parameters that generate a list of objects so that data presentation is more optimal. After doing a series of engineering on microservices architecture and indexing application, query response time performance increased by 49.22% for Service Accounting module.

Copyrights © 2023






Journal Info

Abbrev

cogito

Publisher

Subject

Computer Science & IT Decision Sciences, Operations Research & Management Education Electrical & Electronics Engineering

Description

CogITo Smart Journal adalah jurnal ilmiah di bidang Ilmu Komputer yang diterbitkan oleh Fakultas Ilmu Komputer Universitas Klabat anggota CORIS (Cooperation Research Inter University) dan IndoCEISS (Indonesian Computer Electronics and Instrumentation Support Society). CogITo Smart Journal dua kali ...