Database Preservation: The DBPreserve Approach

dc.contributor.author Ur,A en
dc.contributor.author Muzammal,M en
dc.contributor.author Gabriel David en
dc.contributor.author Cristina Ribeiro en
dc.date.accessioned 2017-11-16T21:47:45Z
dc.date.available 2017-11-16T21:47:45Z
dc.date.issued 2015 en
dc.description.abstract In many institutions relational databases are used as a tool for managing information related to day to day activities. Institutions may be required to keep the information stored in relational databases accessible because of many reasons including legal requirements and institutional policies. However, the evolution in technology and change in users with the passage of time put the information stored in relational databases in danger. In the long term the information may become inaccessible when the operating system, database management system or the application software is not available any more or the contextual information not stored in the database may be lost thus affecting the authenticity and understandability of the information. This paper presents an approach for preserving relational databases for the long-term. The proposal involves migrating a relational database to a dimensional model which is simple to understand and easy to write queries against. Practical transformation rules are developed by carrying out multiple case studies. One of the case studies is presented as a running example in the paper. Systematic implementation of the rules ensures no loss of information in the process except for the unwanted details. The database preserved using the approach is converted to an open format but may be reloaded to a database management system in the long-term.
dc.identifier.uri http://repositorio.inesctec.pt/handle/123456789/3022
dc.identifier.uri http://dx.doi.org/10.14569/IJACSA.2015.061235
dc.language eng en
dc.relation 212 en
dc.relation 215 en
dc.rights info:eu-repo/semantics/openAccess en
dc.subject Database Preservation
dc.subject Transformation Rules
dc.title Database Preservation: The DBPreserve Approach en
dc.type article en
dc.type Publication en
Files