XML and NET Based GUI for Heterogeneous Database Backup System

Abstract

Abstract-In order to ensure that data stored on a medium such as a disk is not lost or damaged, a copy of that data is stored on another medium. Should the original data be lost or damaged, then the copy may be accessed to reproduce the original data. This paper explains a novel technique to backup and restore DBMS and all types of files and directory through XML and NET. With proposed Solution, user data will be safely protected from accidental delete, overwrite and viruses. Moreover, proposed methodology is compatible with both oracle and SQL Servers. In this approach, we use XML and Ionic zip file manager to deploy the application. Database structure and metadata of the documents are stored within XML format i.e. all the files and folders are stored using Extensible Mark-up language (XML) instead of data base. With XML, intended data will be created, stored and even transport by defining set of rules with encoding document and proposed algorithm. The main advantage with proposed work is database administrator can use simple XML encoded files to create and backup data from heterogeneous databases (oracle, SQL etc.) at any place instead of using complex tools and interfaces. Index Terms-Database management system (DBMS), extensible mark-up language (XML), graphical user inter face (GUI). I. INTRODUCTIONBackup is defined as a copy of data that can reconstruct from database or data-warehouse [1]. Data backup and recovery consists of set of procedures to protect database against data loss and reconstruct the database after any kind of data loss. A relatively simple backup and restore program helps to interface effectively with computer's operating system to backup data including files and directories stored on a hard disk to the tape drive and to restore such data from the tape drive onto the hard disk [2]. Backup can be stored at a specific folder where the file may be either in coded form or in normal form i.e. the application has two kinds of actions namely automatic and manual approach. In first approach, backup will be created automatically on widow's start up i.e. user cannot see interface [3]. At first start up, user needs to define automatic backup option. Subsequently, application will save the settings and data will be automatically gets backup from subsequent backups. In later Manuscript