Please use this identifier to cite or link to this item: https://hdl.handle.net/1822/73404

TitleBeyond relational databases: preserving the data
Author(s)Ramalho, José Carlos
Ferreira, Bruno
Faria, Luís
Ferreira, Miguel
KeywordsDigital Archiving
eArchiving
Database preservation
E-ARK
SIARD
Databases
Relational databases
RDMS
Database preservation toolkit
Issue date2020
PublisherRoutledge
JournalNew Review of Information Networking
CitationJosé Carlos Ramalho, Bruno Ferreira, Luis Faria & Miguel Ferreira (2020) Beyond Relational Databases: Preserving the Data, New Review of Information Networking, 25:2, 107-118, DOI: 10.1080/13614576.2021.1919398
Abstract(s)Relational databases are one of the main technologies supporting information assets in today’s organizations. They are designed to store, organize and retrieve digital information, and are such a fundamental part of information systems that most would not be able to function without them. Very often, the information contained in databases is irreplaceable or prohibitively expensive to reacquire; therefore, steps must be taken to ensure that the information within databases is preserved. This paper describes a methodology for long-term preservation of relational databases based on information extraction and format migration to a preservation format. It also presents a tool that was developed to support this methodology: Database Preservation Toolkit (DBPTK), as well as the processes and formats needed to preserve databases. The DBPTK connects to live relational databases and extracts information into formats more adequate for long-term preservation. Supported preservation formats include the SIARD 2, created by a cooperation between the Swiss Federal Archives and the E-ARK project that is becoming a standard in the area. DBPTK has a flexible plugin-based architecture enabling its use for other purposes like database upgrade and database migration between different systems. Presented real case scenarios demonstrate the usefulness, correctness and performance of the tool.
TypeArticle
URIhttps://hdl.handle.net/1822/73404
DOI10.1080/13614576.2021.1919398
ISSN1361-4576
e-ISSN1740-7869
Publisher versionhttps://www.tandfonline.com/doi/abs/10.1080/13614576.2021.1919398
Peer-Reviewedyes
AccessOpen access
Appears in Collections:KEEPS - Artigos (Papers)

Files in This Item:
File Description SizeFormat 
Beyond Relational Databases Preserving the Data.pdf1,14 MBAdobe PDFView/Open

This item is licensed under a Creative Commons License Creative Commons

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu ORCID