Beyond relational databases: preserving the data
| Autor: | Luís Faria, Bruno Ferreira, Miguel Ferreira, José Carlos Ramalho |
|---|---|
| Přispěvatelé: | Universidade do Minho |
| Jazyk: | angličtina |
| Rok vydání: | 2020 |
| Předmět: |
Paz
justiça e instituições eficazes Computer Networks and Communications Relational database Computer science E-ARK Engenharia e Tecnologia::Outras Engenharias e Tecnologias 02 engineering and technology Database preservation Education Human-Computer Interaction World Wide Web Digital Archiving Databases 020204 information systems SIARD 0202 electrical engineering electronic engineering information engineering Outras Engenharias e Tecnologias [Engenharia e Tecnologia] eArchiving RDMS Database preservation toolkit Relational databases Information Systems |
| Zdroj: | Repositório Científico de Acesso Aberto de Portugal Repositório Científico de Acesso Aberto de Portugal (RCAAP) instacron:RCAAP |
| Popis: | 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. The initial E-ARK project was in part supported by the European Commission within the Competitiveness and Innovation Programme 2007–2013, Grant Agreement no. 620998 under the Policy Support Programme. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|