EUVIMEDEUVIMED entdecken
Crossref

AI-Driven Fault-Tolerant Automated Database Backup and Recovery System

K. Loga Niranjan K. Loga Niranjan, V. Dharmar V. Dharmar, K. Mohamed Asraf K. Mohamed Asraf, Dr. B. Aysha Banu Dr. B. Aysha Banu, C.Jeyalakshmi C.Jeyalakshmi

International Journal of Creative and Open Research in Engineering and Management · 06.05.2026 · 02 (05) · 1-12

DOI: 10.55041/ijcope.v2i5.106 ↗

Kurz gefasst

Fachartikel in der Zeitschrift International Journal of Creative and Open Research in Engineering and Management, online erschienen am 06.05.2026. Verfasst von K. Loga Niranjan K. Loga Niranjan und 4 weiteren Autor:innen.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Database downtime represents one of the most financially devastating events in modern enterprise computing, with estimated losses ranging from $5,000 to $10,000 per minute depending on organizational scale and industry sector. Conventional backup strategies—whether manual or time-triggered—remain fundamentally reactive, failing to anticipate imminent database failures until data loss has already occurred. This paper presents an AI-Driven Fault-Tolerant Automated Database Backup and Recovery System (AIFDBAR) designed for PostgreSQL deployments in multi-user cloud environments. The proposed architecture integrates a real-time health monitoring subsystem that harvests PostgreSQL internal statistics views, an LSTM-based anomaly detection engine that assigns per-interval risk scores, and a hybrid backup orchestrator that combines schedule-driven incremental snapshots with prediction-triggered urgent backups. Recovery is coordinated by a Point-in-Time Recovery (PITR) orchestrator that targets Amazon S3-compatible object storage and exposes a RESTful management API secured via JSON Web Tokens. Experimental evaluation on an AWS t3.medium instance using the TPC-H benchmark dataset and 100 synthetic failure injections demonstrates a Recovery Time Objective (RTO) of 45 seconds compared to 5 minutes achieved by pgBackRest—an 85% reduction—while maintaining an anomaly detection AUC of 0.94 and a false-positive rate below 4.1%. The system achieves 99.8% modeled uptime availability, offering a compelling path toward fully autonomous database resilience. Keywords — PostgreSQL, fault tolerance, AI monitoring, automated recovery, anomaly detection

Zitieren

APA

Niranjan, K. L. N. K. L., Dharmar, V. D. V., Asraf, K. M. A. K. M., Banu, D. B. A. B. D. B. A., & C.Jeyalakshmi, C. (2026). AI-Driven Fault-Tolerant Automated Database Backup and Recovery System. International Journal of Creative and Open Research in Engineering and Management, 02(05), 1-12. https://doi.org/10.55041/ijcope.v2i5.106

Vancouver

Niranjan KLNKL, Dharmar VDV, Asraf KMAKM, Banu DBABDBA, C.Jeyalakshmi C. AI-Driven Fault-Tolerant Automated Database Backup and Recovery System. International Journal of Creative and Open Research in Engineering and Management. 2026;02(05):1-12. doi:10.55041/ijcope.v2i5.106

BibTeX
@article{Niranjan2026,
  author = {Niranjan, K. Loga Niranjan K. Loga and Dharmar, V. Dharmar V. and Asraf, K. Mohamed Asraf K. Mohamed and Banu, Dr. B. Aysha Banu Dr. B. Aysha and C.Jeyalakshmi, C.Jeyalakshmi},
  title = {AI-Driven Fault-Tolerant Automated Database Backup and Recovery System},
  journal = {International Journal of Creative and Open Research in Engineering and Management},
  year = {2026},
  volume = {02},
  number = {05},
  pages = {1--12},
  doi = {10.55041/ijcope.v2i5.106}
}
Kostenlos starten →