skip to main content
10.1145/2701126.2701192acmconferencesArticle/Chapter ViewAbstractPublication PagesicuimcConference Proceedingsconference-collections
short-paper

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

Published: 08 January 2015 Publication History

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.

References

[1]
Olson, J. E. (2010). Database archiving: how to keep lots of data for a very long time. Morgan Kaufmann
[2]
Heuscher, S., Järmann, S., Keller-Marxer, P., & Möhle, F. (2004). Providing authentic long-term archival access to complex relational data. arXiv preprint cs/0408054.
[3]
CCSDS. "Reference Model for an Open Archival Information System(OAIS)", http://public.ccsds.org/publications/archive/650x0m2.pdf, 2012, 7
[4]
Swiss Federal Archives, "SIARD Format Description", 2009, <http://www.bar.admin.ch/themen/00532/00536/00818/index.html?lang=en>
[5]
Melton, J., & Simon, A. R. (2001). SQL: 1999: understanding relational language components. Morgan Kaufmann.
[6]
Rahman, A. U., David, G., & Ribeiro, C. (2012). SIARD archive browser. In Theory and Practice of Digital Libraries (pp. 496--499). Springer Berlin Heidelberg.
[7]
Price, J., Illustrator-Mueller, M., & Illustrator-Wald, L. (2002). Oracle9i: JDBC Programming. Osborne/McGraw-Hill.
[8]
Signore, R., Stegman, M. O., & Creamer, J. (1995). The ODBC solution: Open database connectivity in distributed environments. McGraw-Hill, Inc.
[9]
Müller, H., Buneman, P., & Koltsidas, I. (2008, June). XArch: archiving scientific and reference data. In Proceedings of the 2008 ACM SIGMOD international conference on Management of data (pp. 1295--1298). ACM. DOI= http://doi.acm.org/10.1145/1376616.1376758

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
IMCOM '15: Proceedings of the 9th International Conference on Ubiquitous Information Management and Communication
January 2015
674 pages
ISBN:9781450333771
DOI:10.1145/2701126
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 08 January 2015

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. archiving tool
  2. database archiving
  3. long-term preservation
  4. preservation format

Qualifiers

  • Short-paper

Funding Sources

  • This research was supported by the Archives Preservation Technology R&D Program funded by the National Archives of Korea, the Ministry of Public Administration and Security.

Conference

IMCOM '15
Sponsor:

Acceptance Rates

Overall Acceptance Rate 213 of 621 submissions, 34%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • 0
    Total Citations
  • 153
    Total Downloads
  • Downloads (Last 12 months)8
  • Downloads (Last 6 weeks)0
Reflects downloads up to 18 Feb 2025

Other Metrics

Citations

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media