• Home
  • Search
  • RELATIONAL DATABASE REVERSE ENGINEERING: A METHOD BASED ON QUERY ANALYSIS
  • Cite Icon20
  • https://doi.org/10.1142/s0218843095000123Copy DOI Icon

RELATIONAL DATABASE REVERSE ENGINEERING: A METHOD BASED ON QUERY ANALYSIS

Show More
  • Abstract
  • Literature Map
  • Citations
  • Similar Papers
Abstract

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.

Similar Papers
  • Conference Article
  • Citations65

Towards the reverse engineering of renormalized relational databases

  • Mar 25, 2019
  • J.-M Petit +3
  • Research Article
  • Citations22

Between Self and Others: Relational Schemas as an Integrating Construct in Psychotherapy

  • Jan 01, 2009
  • Transactional Analysis Journal
  • Gregor Žvelc
  • Book Chapter
  • Citations15

From a Conceptual Model to a Knowledge Graph for Genomic Datasets

  • Jan 01, 2019
  • Anna Bernasconi +2
  • Book Chapter

Objects through Relations

  • Jan 01, 1997
  • Michal Kopecky +1
  • Book Chapter
  • Citations10

Applying Instance Visualisation and Conceptual Schema Mapping for Geodata Harmonisation

  • Jan 01, 2009
  • Thorsten Reitz +1
  • Conference Article
  • Citations102

A method for transforming relational schemas into conceptual schemas

  • Feb 14, 1994
  • P Johannesson
  • Book Chapter
  • Citations4

Data manipulation languages for the universal relation view DURST

  • Jan 01, 1988
  • Joachim Biskup +1
  • Research Article
  • Citations19

Integrating user knowledge with information from parallelisation tools to facilitate the automatic generation of efficient parallel FORTRAN code

  • Feb 01, 1996
  • Parallel Computing
  • P.F Leggett +3
  • Research Article
  • Citations138

Why is the snowflake schema a good data warehouse design?

  • Jan 17, 2003
  • Information Systems
  • Mark Levene +1
  • Conference Article
  • Citations7

An approach to proving the correctness of data base operations

  • Jan 01, 1972
  • I T Hawryszkiewycz +1
  • PDF
  • Research Article
  • Citations25

Design and validation of a new Healthcare Systems Usability Scale (HSUS) for clinical decision support systems: a mixed-methods approach

  • Jan 01, 2023
  • BMJ Open
  • Abir Ghorayeb +3
  • Book Chapter
  • Citations2

Integrating Hypermedia Functionality into Database Applications

  • Jan 01, 2001
  • Anirban Bhaumik +6
  • Book Chapter

Enterprise Business Intelligence Data Preparation Using RDF Data Sources

  • Jan 01, 2007
  • Wajee Teswanich +1
  • Conference Article

New Join Operator Definitions and Implementation Methods for Sensor Networks

  • Oct 01, 2007
  • Seungjae Lee +2
  • Research Article
  • Citations16

A Comparative Study for Telerobotic Surgery Using Free Hand Gestures

  • Sep 10, 2016
  • Journal of Human-Robot Interaction
  • Tian Zhou +4
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.