Managing Database Replication Using Binary Vote Assignment on Grid Quorum with Association Rule

Ahmad, Nesar; Fauzi, Ainul Azila Che; Ubaidillah, Sharifah Hafizah Sy Ahmad; Abdullah, Zailani; Sidek, Roslina Mohd; Fakhreldin, Mohammed Adam Ibrahim

doi:10.1166/asl.2018.13027

Cited by 2 publications

(7 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The concept of Binary Vote Assignment on Grid (BVAG) is replicating the data from the primary replica to the neighbours" replica which is located at the adjacent sites of the primary replica [11]. Full replication can result in a huge waste of storage space and consume a lot of bandwidth [12].…”

Section: A Binary Vote Assignment On Grid (Bvag)mentioning

confidence: 99%

“…Each site has a premier data file. Data will be replicated to the neighbours sites from the primary site [11]. For simplicity, the primary site of any data file and its neighbours are assigned with vote one (1) or vote zero (0) otherwise.…”

Section: A Binary Vote Assignment On Grid (Bvag)mentioning

confidence: 99%

“…Meanwhile, primary data "f" from site F are replicated to site C, E and I. The number of quorums used are based on the total number of replicated data and the primary data, d, which can be three, four or five [11,14].…”

Section: A Binary Vote Assignment On Grid (Bvag)mentioning

confidence: 99%

“…The status of each site is statistically independent of others. When a site is available, the copy at the site is available too; otherwise, it is unavailable [11,14]. [11,14].…”

Section: The Transaction Procedures In Bvag Is Called As Binary Vote Assignment On Grid Transaction Manager (Bvagtm)mentioning

confidence: 99%

“…When a site is available, the copy at the site is available too; otherwise, it is unavailable [11,14]. [11,14]. IL phase involves locking the primary site if the primary site is in available (0) status.…”

Section: The Transaction Procedures In Bvag Is Called As Binary Vote Assignment On Grid Transaction Manager (Bvagtm)mentioning

confidence: 99%

See 4 more Smart Citations

An Efficient Data Replication Technique with Fault Tolerance Approach using BVAG with Checkpoint and Rollback-Recovery

Ubaidillah¹,

Adzhar²,

Alkazemi³

2021

IJACSA

Self Cite

View full text Add to dashboard Cite

Data replication has been one of the pathways for distributed database management as well as computational intelligence scheme as it continues to improve data access and reliability. The performance of data replication technique can be crucial when it involves failure interruption. In order to develop a more efficient data replication technique which can cope with failure, a fault tolerance approach needs to be applied in the data replication transaction. Fault tolerance approach is a core issue for a transaction management as it preserves an operation mode transaction prone to failure. In this study, a data replication technique known as Binary Vote Assignment on Grid (BVAG) has been combined with a fault tolerance approach named as Checkpoint and Rollback-Recovery (CR) to evaluate the effectiveness of applying fault tolerance approach in a data replication transaction. Binary Vote Assignment on Grid with Checkpoint and Rollback-Recovery Transaction Manager (BVAGCRTM) is used to run the BVAGCR proposed method. The performance of the proposed BVAGCR is compared to standard BVAG in terms of total execution time for a single data replication transaction. The experimental results reveal that BVAGCR improves the BVAG total execution time in failure environment of about 31.65% by using CR fault tolerance approach. Besides improving the total execution time of BVAG, BVAGCR also reduces the time taken to execute the most critical phase in BVAGCRTM which is Update (U) phase by 98.82%. Therefore, based on the benefits gained, BVAGCR is recommended as a new and efficient technique to obtain a reliable performance of data replication with failure condition in distributed databases.

show abstract

Section: A Binary Vote Assignment On Grid (Bvag)mentioning

confidence: 99%

Section: A Binary Vote Assignment On Grid (Bvag)mentioning

confidence: 99%

Section: A Binary Vote Assignment On Grid (Bvag)mentioning

confidence: 99%

“…The status of each site is statistically independent of others. When a site is available, the copy at the site is available too; otherwise, it is unavailable [11,14]. [11,14].…”

Section: The Transaction Procedures In Bvag Is Called As Binary Vote Assignment On Grid Transaction Manager (Bvagtm)mentioning

confidence: 99%

Section: The Transaction Procedures In Bvag Is Called As Binary Vote Assignment On Grid Transaction Manager (Bvagtm)mentioning

confidence: 99%

See 3 more Smart Citations

An Efficient Data Replication Technique with Fault Tolerance Approach using BVAG with Checkpoint and Rollback-Recovery

Ubaidillah¹,

Adzhar²,

Alkazemi³

2021

IJACSA

Self Cite

View full text Add to dashboard Cite

show abstract

An automate failure recovery for synchronous distributed database system

Noor

Fauzi

et al. 2022

IJEECS

View full text Add to dashboard Cite

Periodically, researchers have been sharing their constant attempts to improve the existing methods for data replication in distributed database system. The main goal is to work for an efficient distributed environment. An efficient environment may handle huge amount of data and preserve data availability. The occasionally failures in distributed systems will affect the end results, such as data loss, income loss etc. Thus, to prevent the data loss and guarantee the continuity of the business, many organizations have applied disaster recovery solutions in their system. One of the widely used is database replication, because it guarantees data safety and availability. However, disaster still can occur in database replication. Hence, an automatic failure recovery technique called distributed database replication with fault tolerance (DDR-FT) has been proposed in this research. DDR-FT uses heartbeat message for node monitoring. Subsequently, a foundation of binary vote assignment for fragmented database (BVAFD) replication technique has been used. In DDR-FT, the data nodes are continuously monitored while auto reconfiguring for automatic failure recovery. From the conducted experiments, it is proved that DDR-FT can preserve system availability. It shows that DDR-FT technique provides a convenient approach to system availability for distributed database replication in real time environment.

show abstract

Managing Database Replication Using Binary Vote Assignment on Grid Quorum with Association Rule

Cited by 2 publications

References 0 publications

An Efficient Data Replication Technique with Fault Tolerance Approach using BVAG with Checkpoint and Rollback-Recovery

An Efficient Data Replication Technique with Fault Tolerance Approach using BVAG with Checkpoint and Rollback-Recovery

An automate failure recovery for synchronous distributed database system

Contact Info

Product

Resources

About