Title (eng)

Transformation Rules for Model Migration in Relational Database Preservation: Paper - iPRES 2011 - Singapore

Author

Arif Ur Rahman

Cristina Ribeiro

Gabriel David

Description

Digital preservation is about memory and giving easy access to it. If the digital object is a relational database the requirements of normalization may make it hard to access and understand. In order to deal with this problem we have proposed the DBPreserve approach to transform a relational database to a dimensional model as part of the preservation process, making the preserved information more explicit and easier to access. The paper presents a set of transformation rules to deal with aspects of the migration process such as the identification of the fact tables corresponding to the main organizational processes and the choice of the set of relevant dimensions. The rules help to keep the traceability of the migration process and to preserve integrity and authenticity. The rules were implemented in a case study which involved a human resources information system.

Object languages

English

Rights

Creative Commons License
This work is licensed under a
CC BY-SA 3.0 AT - Creative Commons Attribution-ShareAlike 3.0 Austria License.

CC BY-SA 3.0 AT

http://creativecommons.org/licenses/by-sa/3.0/at/

Classification

iPRES, Singapore, database preservation, database transformation rules

Conferences, Conference 2011

Member of the Collection(s) (3)

o:424738 Openaire v3.0 collection
o:294299 iPRES 2011 - Proceedings of the 8th International Conference on Preservation of Digital Objects: iPRES 2011 - Singapore
o:168770 Open Access Collection