Database Preservation: The DBPreserve Approach
Journal Title: International Journal of Advanced Computer Science & Applications - Year 2015, Vol 6, Issue 12
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.
Authors and Affiliations
Arif Rahman, Muhammad Muzammal, Gabriel David, Cristina Ribeiro
Keywords
Related Articles
- EP ID EP106689
- DOI 10.14569/IJACSA.2015.061235
- Views 103
- Downloads 0
Cost Optimization of Cloud Computing Services in a Networked Environment
Cloud computing service providers' offer their customers' services maximizing their revenues, whereas customers wish to minimize their costs. In this paper we shall concentrate on consumers' point of view. Cloud computin...
Cyber Profiling Using Log Analysis And K-Means Clustering
The Activities of Internet users are increasing from year to year and has had an impact on the behavior of the users themselves. Assessment of user behavior is often only based on interaction across the Internet without...
A P System for K-Medoids-Based Clustering
The membrane computing model, also known as the P system, is a parallel and distributed computing system. K-medoids algorithm is one of the most famous algorithms in partition-based clustering algorithms, and has been wi...
Forensic Analysis of Docker Swarm Cluster using Grr Rapid Response Framework
An attack on Internet network does not only hap-pened in the web applications that are running natively by a web server under operating system, but also web applications that are running inside container. The currently p...
Quality EContent Design using Reusability approach
Technology is the one changing ever, and major technological innovations can make a paradigm shifts. The computer network known as the Internet is one such innovation. After affecting sweeping changes in the way people c...