Generalized Micro Service Architecture for Web Based Database Management Systems
In web based database management systems, execution of multiple select queries or the queries requesting a large amount of data records from a single database management service via http requests is heavily affected by the performance of the database management service, rather than database engine. Although almost every popular Relational Database Management System (RDBMS) is designed with an architecture to provide higher efficiency, ultimately a single database management service will read the database and serve the results through http in the common scenario. So, a drastic performance reduction is visible while serving the http requests with the fetched data from the databases.This research examines the efficiency difference between micro service architecture and mono service architecture for web based database management systems by analyzing the time taken to get the response with data for READ operations with different record sizes. This research proposes a simple and generic web service architecture in managing HTTP requests which require fetching data from the underlying SQL adhering the micro service concepts.
2020 20th International Conference on Advances in ICT for Emerging Regions (ICTer)