Building ontologies from relational databases using reverse engineering methods

2007 ◽  
Author(s):  
Justas Trinkunas ◽  
Olegas Vasilecas
Keyword(s):  
Reverse Engineering ◽  
Relational Databases

Reverse engineering of relational databases: Extraction of an EER model from a relational database

1994 ◽  
Vol 12 (2) ◽  
pp. 107-142 ◽  
Author(s):  
Roger H.L. Chiang ◽  
Terence M. Barron ◽  
Veda C. Storey
Keyword(s):  
Reverse Engineering ◽  
Relational Database ◽  
Relational Databases

RELATIONAL DATABASE REVERSE ENGINEERING: A METHOD BASED ON QUERY ANALYSIS

1995 ◽  
Vol 04 (02n03) ◽  
pp. 287-316 ◽  
Author(s):  
JEAN-MARC PETIT ◽  
FAROUK TOUMANI ◽  
JACQUES KOULOUMDJIAN
Keyword(s):  
Reverse Engineering ◽  
Program Analysis ◽  
Relational Databases ◽  
A Priori ◽  
User Interaction ◽  
Description Language ◽  
Relational Schema ◽  
Conceptual Schema ◽  
Expert User ◽  
Application Programs

This paper introduces a method of reverse engineering for operational relational databases. The conceptual schemas are derived using information extracted from data dictionaries, database extensions and application programs. Its main strength relies on the assumptions made on the a priori knowledge available about the database (only [Formula: see text] and/or [Formula: see text] constraints on attribute(s)) as well as the user competence. We argue that most of the knowledge needed to build a conceptual schema, if not described in the Data Description Language, is embedded in application programs under various forms. The method is therefore based on four main steps: firstly, application program analysis is performed and a set [Formula: see text] of equi-joins is obtained; secondly, a conceptual schema is derived from [Formula: see text], from the database extension and from the relational schema; thirdly, this conceptual schema is validated through an interactive dialogue with the expert user who is helped in this task by indications given by the method. Finally, a schema reorganization under user control is achieved to match the user requirements better. We introduce also how other kinds of queries can help the task of semantics discovery. Additionally, we precisely identify the phases when user interaction is needed. This method has been successfully validated on an operational database.

An approach for reverse engineering of relational databases

1994 ◽  
Vol 37 (5) ◽  
pp. 42 ◽  
Author(s):  
William J. Premerlani ◽  
Michael R. Blaha
Keyword(s):  
Reverse Engineering ◽  
Relational Databases

Extracting generalization hierarchies from relational databases: A reverse engineering approach

2007 ◽  
Vol 63 (2) ◽  
pp. 568-589 ◽  
Author(s):  
Nadira Lammari ◽  
Isabelle Comyn-Wattiau ◽  
Jacky Akoka
Keyword(s):  
Reverse Engineering ◽  
Relational Databases ◽  
Engineering Approach
Sign in / Sign up

Export Citation Format

Share Document