Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jurnal Teknologi Informasi, Komputer, dan Aplikasinya (JTIKA )
Rabertra, Devis
Unknown Affiliation
Computer Science & IT Decision Sciences, Operations Research & Management Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
PYTHON WEB SYSTEM TO RESTORE SQL SERVER DATABASE TO DRC WITH ADVANCED INFORMATION RETRIEVAL Rabertra, Devis; Saputra, Irwansyah
JTIKA (Jurnal Teknik Informatika, Komputer dan Aplikasinya) Vol 8 No 1 (2026): Maret 2026
Publisher : Program Studi Teknik Informatika, Fakultas Teknik, Universitas Mataram

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.29303/jtika.v8i1.559

Abstract

Disaster Recovery Centers (DRC) play a crucial role in ensuring the availability and continuity of database operations in enterprise environments. The process of restoring databases from production servers to DRCs is often performed manually, which can lead to errors such as selecting incorrect backups, corrupted files, and lengthy search times. The complexity increases with the growing number of databases and the variety of daily backup types.This study develops an automated system based on a Python Web Interface integrated with Advanced Information Retrieval (IR) to improve the accuracy and speed of finding relevant backups before restoration. The system employs Natural Language Processing (NLP) and multi-criteria relevance scoring, evaluating backup suitability based on fuzzy matching of database names, recency, semantic similarity, backup type, and file size.Testing was conducted using 28 backup records from 5 different databases. Results show that Advanced IR can accelerate backup searches in under 2 seconds, with relevance ranking ranging from 38% to 67%. Additionally, the automated restore process via Python achieved an average execution time of 7.49 seconds with a 100% success rate.
Co-Authors Saputra, Irwansyah