Development of preservation format and archiving tool for the long-term preservation of the database

Abstract

A digital archiving of the database is a series of actions that preserve and utilize valuable database contents in the future. If a specific database is not supported from the vendor anymore, its backup tools and dump files are also unusable. Furthermore just backing up database is not a digital archiving because it doesn't guarantee long-term preserving and utilizing database contents. Therefore valuable information that stored in the databases are disappeared due to lack of archiving methods. The purpose of this paper is to design the preservation format and to implement archiving tools for a database digital archiving. For this, we first analyze OAIS reference architecture, standard of a digital archiving and SIARD format. The preservation format for database archiving is defined next based on the related works. For developing archiving tool, the JDBC Driver and the SQL:1999 are used for the accessing and managing various kinds of databases. The experimental tests are performed with the major databases; Oracle, MySQL, MSSQL. The define preservation format and archiving tool can be used for basis studies of long-term preserving of all kind of electronic documents using a database.