Beyond relational databases: preserving the data

Ver registo simples
dc.creatorRamalho, José Carlos
dc.creatorFerreira, Bruno
dc.creatorFaria, Luís
dc.creatorFerreira, Miguel
dc.date.accessioned2023-11-24T15:13:46Z
dc.date.available2023-11-24T15:13:46Z
dc.date.issued2020
dc.description.abstractRelational 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.
dc.identifierJosé 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
dc.identifier1361-4576
dc.identifierhttp://hdl.handle.net/1822/73404
dc.identifier1740-7869
dc.identifier10.1080/13614576.2021.1919398
dc.identifier.urihttps://demo.dspace.keep.pt/handle/123456789/14
dc.languageeng
dc.publisherRoutledge
dc.relationhttps://www.tandfonline.com/doi/abs/10.1080/13614576.2021.1919398
dc.relation620998
dc.rights
dc.rightsopen access
dc.rights.licensehttp://creativecommons.org/licenses/by-nc-nd/4.0/
dc.subjectDigital Archiving
dc.subjecteArchiving
dc.subjectDatabase preservation
dc.subjectE-ARK
dc.subjectSIARD
dc.subjectDatabases
dc.subjectRelational databases
dc.subjectRDMS
dc.subjectDatabase preservation toolkit
dc.titleBeyond relational databases: preserving the data
dc.typejournal article
dspace.entity.typePublicationen
Ficheiros
Coleções
Comunidade KEEP SOLUTIONS do RepositóriUM