Journal of AI-Driven Communication Engineering

Articles

Vol. 1 (2025)

A Detailed Analysis of Backup and Recovery Techniques in Database Management Systems (DBMS)

Submitted
December 31, 2025
Published
2025-12-31

Abstract

In this exponential growth age and frequent disruption, data has to be really secure, integral, and accessible. DBMS plays a keynote in all these aspects. This report reviews the backup and recovery techniques of four DBMSs: Cassandra, MongoDB, Neo4j, and Oracle. It discusses their efficacy in restoring data loss and maintaining schema integrity. This study throws light on the challenge of complete data and schema recovery considering operational nuances and system-specific requirements. The recovery processes were recreated in the controlled environments by using hands-on experimentation. Recovery percentages for each DBMS were computed from recovered data. The results of the study indicate that 100% success rate for all systems, which means these systems do not fail in case of a disaster. These results give critical insight into the reliability and application-specific advantages of each DBMS in guiding database administrators in the design of resilient systems.

References

  1. Singh and J. Battra, "Strategies for Data Backup and Recovery in the Cloud," International Journal of Performability Engineering, vol. 19, no. 11, pp. 728-735, 2023. https://doi.org/10.23940/ijpe.23.11.p3.728735
  2. G. Ramesh, J.Logeshwaran and V.Aravindarajan, "A Secured Database Monitoring Method to Improve Data Backup and Recovery," BOHR International Journal of Operations in Cloud Computing, vol. 2, no. 1, pp. 1-7, January 2023. https://doi.org/10.54646/bijcs.019
  3. V. Javaraiah, "Backup for cloud and disaster recovery for consumers and SMBs," 2011. https://ieeexplore.ieee.org/document/6163671 (accessed Mar. 06, 2020).
  4. K. Bohora, A. Bothe and D. S. a. R. Chopade, "Backup and Recovery Mechanisms of Cassandra Database: A Review," The Journal of Digital Forensics, Security and Law, 2021. https://doi.org/10.15394/jdfsl.2021.1613
  5. I. Kuyumdzhiev, "Backup and recovery of MongoDB database: features, state, problems," Journal of The Union of Scientists - Varna, Economic Sciences Series, no. 1, pp. 125-133, January 2015.
  6. M. F. P.F and R. K. a. S. M. Varghese, "Outcome Analysis Using Neo4j Graph Database," International Journal on Cybernetics & Informatics, vol. 5, no. 2, pp. 229-236, April 2016. https://doi.org/10.5121/ijci.2016.5225
  7. J.-H. Choi and D. W. J. a. S. Lee, "The method of recovery for deleted record in Oracle Database," Journal of the Korea Institute of Information Security and Cryptology, vol. 23, no. 5, pp. 947-955, October 2013. https://doi.org/10.13089/JKIISC.2013.23.5.947
  8. F. Y. H. Ahmed and R. S. a. M. Abdullah, "Enhancement of E-Commerce Database System During the COVID-19 Pandemic," 2021 IEEE 11th IEEEE Symposium on Computer Applications & Industrial Electronics (ISCAIE), 2021. https://doi.org/10.1109/ISCAIE51753.2021.9431804
  9. P. Lu, L. Zhang, X. Liu and J. Y. a. Z. Zhu, "Highly efficient data migration and backup for big data applications in elastic optical inter-data-center networks," IEEE Network, 2015. https://doi.org/10.1109/MNET.2015.7293303
  10. R. PLAKA, "Backup & Data Recovery in Cloud Computing: A Systematic Mapping Study," Ingenious, vol. 2, no. 1, pp. 94-113, January 2022. https://doi.org/10.58944/pwhk4843
  11. M. Z. Hasan, N. Sarwar, I. Alam, M. Z. Hussain and A. A. S. a. A. Irshad, "Data Recovery and Backup Management: A Cloud Computing Impact," 2023 IEEE International Conference on Emerging Trends in Engineering, Sciences and Technology (ICES&T), 2023. https://doi.org/10.1109/ICEST56843.2023.10138852
  12. A. K. a. P. Sehgal, "{BARNS}: Towards Building Backup and Recovery for NoSQL Databases," January 2017.
  13. H. A. Mumtahana, "Optimization of Transaction Database Design with MySQL and MongoDB," SinkrOn, vol. 7, no. 3, pp. 883-890, July 2022. https://doi.org/10.33395/sinkron.v7i3.11528
  14. NoSQL Database: Cassandra is a Better Option to Handle Big Data," International Journal of Science and Research (IJSR), vol. 5, no. 1, pp. 24-26, January 2016. https://doi.org/10.21275/v5i1.NOV152557
  15. V. Tiwari, "Oracle Database Backup Testing," International Journal of Trend in Scientific Research and Development, vol. 2, no. 3, pp. 2043-2044, April 2018. https://doi.org/10.31142/ijtsrd11572
  16. A. Boicea and F. R. a. L. I. Agapin, "MongoDB vs Oracle -- Database Comparison," 2012 Third International Conference on Emerging Intelligent Data and Web Technologies, September 2012. https://doi.org/10.1109/EIDWT.2012.32
  17. H. Kim and H. Y. Y. a. Y. Son, "An Efficient Database Backup and Recovery Scheme using Write-Ahead Logging," IEEE Xplore, 2020. https://ieeexplore.ieee.org/document/9284224 (accessed May 11, 2022).
  18. C. Sauer and G. G. a. T. Härder, "Instant restore after a media failure," arXiv (Cornell University), January 2017. https://doi.org/10.1007/978-3-319-66917-5_21
  19. A. Magalhaes and J. M. M. a. A. Brayner, "Main Memory Database Recovery: A Survey," ACM Computing Surveys, vol. 54, no. 2, pp. 1-36, March 2021. https://doi.org/10.1145/3442197
  20. L. K. a. M. Krstić, "Testing the performance of NoSQL databases via teh database benchmark tool," Vojnotehnicki glasnik, vol. 66, no. 3, pp. 614-639, 2018. https://doi.org/10.5937/vojtehg66-15928