Transformation-based Database Reverse Engineering

Jean-Luc Hainaut, Catherine Tonneau, Michel Joris, Muriel Chandelon

Research output: Contribution in Book/Catalog/Report/Conference proceedingConference contribution


This is an abstract of a revision of the original paper (ER'93 pre-proceedings) that presents a DBMS-independent database reverse engineering (DBRE) methodology based on a generic process model and on transformation techniques. DBRE is proposed as a two-phase process consisting in recovering the DBMS-dependent data structures (data structure extraction) then in recovering their semantics (data structure conceptualization). The second phase, that is strongly linked with the logical design phase of current database design methodologies, can be performed by application of a selected set of standard schema transformations. The paper illustrates the methodology by applying it to various DBRE processes : removing optimization structures, untranslating database/file structures, and finally conceptual normalization.
Original languageEnglish
Title of host publicationEntity-Relationship Approach — ER '93
Subtitle of host publication12th International Conference on the Entity-Relationship Approach Arlington, Texas, USA, December 15–17, 1993 Proceedings
EditorsRamez A. Elmasri, Vram Kouramajian, Bernhard Thalheim
Place of PublicationArlington-Dallas
PublisherSpringer Verlag
Number of pages12
ISBN (Electronic)978-3-540-48575-9
ISBN (Print)978-3-540-58217-5
Publication statusPublished - 1994

Publication series

NameLecture Notes in Computer Science
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349


  • schema equivalence
  • schema transformation
  • dabase reverse engineering
  • database design


Dive into the research topics of 'Transformation-based Database Reverse Engineering'. Together they form a unique fingerprint.

Cite this