DEVELOPMENT OF CENTRALIZED DATA FETCHING SERVICE WITH MULTI DBMS IN MICROSERVICES APPLICATION

• Main Author: Alfayat, Yudi
• Format: Final Project
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/78313
• Institution: Institut Teknologi Bandung

Microservices provide benefits in creating applications such as ease of upgrade, technological heterogeneity, independent services, and ease of development and deployment. To achieve these beneficial objectives, microservices application development usually uses a decentralized data management paradigm where the database is split and management is carried out in each service. However, this creates challenges in developing microservices applications in retrieving data that is spread across each database. In this final project, a service is implemented that is useful for centrally fetching data from various databases to overcome problems caused by a decentralized data management approach. Data retrieval services use SQL as an interface to other services that can communicate to various types of DBMS. In addition, every operation performed will be controlled using attribute-based access control or ABAC. Based on the tests carried out the service can perform CRUD operations with the defined database schema. This service can provide access to separate databases with SQL as the interface. In addition, the service also successfully validates the ABAC authorization rules that have been defined in the database schema before executing operations sent by the user.