Selection of Reverse Engineering Methods for Relational Databases

Authors:
Maria de Lurdes Pedro-de-Jesus;Pedro Manuel Antunes Sousa
Affiliations:
-;-
Venue:
CSMR '99 Proceedings of the Third European Conference on Software Maintenance and Reengineering
Year:
1999

Citing 0
Cited 4

An MDA-based approach for database re-engineering

Journal of Software Maintenance and Evolution: Research and Practice
Extracting entity-relationship diagram from a table-based legacy database

Journal of Systems and Software
Database reverse engineering tools

SEPADS'08 Proceedings of the 7th WSEAS International Conference on Software Engineering, Parallel and Distributed Systems
A Formal Semantics-Preserving Translation from Fuzzy Relational Database Schema to Fuzzy OWL DL Ontology

ASWC '08 Proceedings of the 3rd Asian Semantic Web Conference on The Semantic Web

Quantified Score

Hi-index	0.00

Visualization

Abstract

The problem of choosing a method for the reverse engineering of relational database systems is not trivial. Methods have different input requirements and each legacy system has its particular characteristics that restrict information availability. In this paper, we propose a classification framework based on the method's input requirements, namely: attribute semantics, attribute name consistency, data instances, applications source code, candidate keys, 3NF, inclusion dependencies, and human input. We present a short description of seven reverse engineering methods and analyse the applicability of each method to existing database systems, as well as the possibility of applying different methods to different parts of the system.