Volume 2 Number 4 (Jul. 2013)
Home > Archive > 2013 > Volume 2 Number 4 (Jul. 2013) >
IJCCE 2013 Vol.2(4): 535-538 ISSN: 2010-3743
DOI: 10.7763/IJCCE.2013.V2.243

Replication of Data in Database Systems for Backup and Failover – An Overview

Tarandeep Singh, Parvinder S. Sandhu, and Harbax Singh Bhatti
Abstract—The production database are transactions intensive transactions can be insert, update on the tables, failover is the replica of the production server, if there is any change we have to implement on the production and it will be automatically implemented on failover or standby database. Now a days the data on the production server is increasing and we need extra storage space on production server to keep data and this is same required on the failover. To generate reports from that data will increase load on the production server and can affect the performance of the server. There are also some threats which can cause loss of data from which we have to protect our database like Hardware failure, loss of machine. Replication is one of the methods for Backup of the running database and its immediate failover during failure. This paper represents some parts for the replication techniques, failover, and transaction states.

Index Terms—Asynchronous, synchronous, active, commit, rollback, RAIDb.

Tarandeep Singh is with the Punjab Technical University, India (e-mail: tarandeepskhs@gmail.com).
Parvinder S. Sandhu is with the Rayat and Bahra Institute of Engineering and Bio-Technology, Mohali, Punjab, India (e-mail: parvinder.sandhu@gmail.com). Harbax Singh Bhatti is with the Department of Applied Sciences, Baba Banda Singh Bahadur, Engineering College, Fatehgarh Sahib (India).

Cite:Tarandeep Singh, Parvinder S. Sandhu, and Harbax Singh Bhatti, "Replication of Data in Database Systems for Backup and Failover – An Overview," International Journal of Computer and Communication Engineering vol. 2, no. 4, pp. 535-538, 2013.

General Information

ISSN: 2010-3743 (Online)
Abbreviated Title: Int. J. Comput. Commun. Eng.
Frequency: Quarterly
Editor-in-Chief: Dr. Maode Ma
Abstracting/ Indexing: INSPEC, CNKI, Google Scholar, Crossref, EBSCO, ProQuest, and Electronic Journals Library
E-mail: ijcce@iap.org
  • Dec 29, 2021 News!

    IJCCE Vol. 10, No. 1 - Vol. 10, No. 2 have been indexed by Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • Mar 17, 2022 News!

    IJCCE Vol.11, No.2 is published with online version!   [Click]

  • Dec 29, 2021 News!

    The dois of published papers in Vol. 9, No. 3 - Vol. 10, No. 4 have been validated by Crossref.

  • Dec 29, 2021 News!

    IJCCE Vol.11, No.1 is published with online version!   [Click]

  • Sep 16, 2021 News!

    IJCCE Vol.10, No.4 is published with online version!   [Click]

  • Read more>>