files/journal/2022-09-02_12-54-44-000000_354.png

Journal of Engineering and Applied Sciences

ISSN: Online 1818-7803
ISSN: Print 1816-949x
105
Views
0
Downloads

Enhancement of Business Continuity Through Effective Database Integration and Database Gateway Implementation

Young-Ho Shin and Jae-Cheol Ryou
Page: 3358-3363 | Received 21 Sep 2022, Published online: 21 Sep 2022

Full Text Reference XML File PDF File

Abstract

This study seeks to develop optimal measures that enable organizations or institutions to quickly resume web services after performing database integration and migration following the new establishment or modification of systems. Database integration was performed for multiple databases and instances by avoiding schema collision for each character set and the database connection information of various Java-based web services was analyzed. Using the information of new databases integrated with existing databases, connection information mapping tables were derived for each user account. The mapping tables were used to design and implement a conversion gateway for connection to new databases and web service migration was carried out. When multiple web services require migration due to a change in the target database, the corresponding database connection information of application programs for each service must be analyzed and services can undergo migration after connection information is modified. This involves significant time and costs. This study performed service migration by implementing a driver-level conversion gateway corresponding to the connection process of databases without having to separately modify application programs for each service. This method of migration allows organizations to resume web services in a shorter period of time. This quick restoration of services contributes to service stability and business continuity, thereby greatly enhancing business competitiveness. By implementing driver-level common functions for database connection resulting from a change in the database server, fast and stable standard measures were presented for database connection during migration.


How to cite this article:

Young-Ho Shin and Jae-Cheol Ryou. Enhancement of Business Continuity Through Effective Database Integration and Database Gateway Implementation.
DOI: https://doi.org/10.36478/jeasci.2018.3358.3363
URL: https://www.makhillpublications.co/view-article/1816-949x/jeasci.2018.3358.3363