Assimilating sense into disaster recovery databases and judgement framing proceedings for the fastest recovery

Title

Assimilating sense into disaster recovery databases and judgement framing proceedings for the fastest recovery

Creator

Shaik V.; Kalyanasundaram N.

Description

The replication between the primary and secondary (standby) databases can be configured in either synchronous or asynchronous mode. It is referred to as out-of-sync in either mode if there is any lag between the primary and standby databases. In the previous research, the advantages of the asynchronous method were demonstrated over the synchronous method on highly transactional databases. The asynchronous method requires human intervention and a great deal of manual effort to configure disaster recovery database setups. Moreover, in existing setups there was no accurate calculation process for estimating the lag between the primary and standby databases in terms of sequences and time factors with intelligence. To address these research gaps, the current work has implemented a self-image looping database link process and provided decision-making capabilities at standby databases. Those decisions from standby are always in favor of selecting the most efficient data retrieval method and being in sync with the primary database. The purpose of this paper is to add intelligence and automation to the standby database to begin taking decisions based on the rate of concurrency in transactions at primary and out-of-sync status at standby. 2023 Institute of Advanced Engineering and Science. All rights reserved.

Source

International Journal of Electrical and Computer Engineering, Vol-13, No. 4, pp. 4234-4245.

Date

2023-01-01

Publisher

Institute of Advanced Engineering and Science

Subject

Cloud and on-premises; Cloud database recovery; Database disaster recovery; database integrations; Intelligence to standby; Oracle on-premises database; recovery

Coverage

Shaik V., Department of Computer Science and Engineering, School of Engineering and Technology, CHRIST (Deemed to be University), Bangalore, India; Kalyanasundaram N., Department of Computer Science and Engineering, School of Engineering and Technology, CHRIST (Deemed to be University), Bangalore, India

Rights

All Open Access; Gold Open Access; Green Open Access

Relation

ISSN: 20888708

Format

Online

Language

English

Type

Article

Identifier

https://doi.org/10.11591/ijece.v13i4.pp4234-4245

https://www.scopus.com/inward/record.uri?eid=2-s2.0-85152097103&doi=10.11591%2fijece.v13i4.pp4234-4245&partnerID=40&md5=432c8d68b94d7d0b1de0865f24f0f0d8