Schema Transformation Techniques for Database Reverse Engineering

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

Schema Transformation Techniques for Database Reverse Engineering

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

Faculte d'informatique

Résultats de recherche: Contribution dans un livre/un catalogue/un rapport/dans les actes d'une conférence › Article dans les actes d'une conférence/un colloque

Résumé

The paper 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 restructuring techniques, or schema transformations. The paper illustrates the methodology by applying it to various DBRE processes : removing optimization structures, untranslating Relational, COBOL, CODASYL, TOTAL/IMAGE and IMS database as well as file structures, and finally conceptual normalization. A shorter version appears in the final proceedings of the conference.

langue originale	Anglais
titre	Proc. of the 12th Int. Conf. on ER Approach
Lieu de publication	Arlington-Dallas
Editeur	Springer Verlag
Pages	353-372
Nombre de pages	20
Etat de la publication	Publié - 1993

Accès au document

http://www.info.fundp.ac.be/cgi-bin/pub-spec-paper?RP-93-004

Contient cette citation

@inproceedings{36d8a58f0d6b41efb6b5980f0f6c8a82,

title = "Schema Transformation Techniques for Database Reverse Engineering",

abstract = "The paper 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 restructuring techniques, or schema transformations. The paper illustrates the methodology by applying it to various DBRE processes : removing optimization structures, untranslating Relational, COBOL, CODASYL, TOTAL/IMAGE and IMS database as well as file structures, and finally conceptual normalization. A shorter version appears in the final proceedings of the conference.",

keywords = " schema equivalence, schema transformation, dabase reverse engineering, database design",

author = "Jean-Luc Hainaut and Catherine Tonneau and Michel Joris and Muriel Chandelon",

year = "1993",

language = "English",

pages = "353--372",

booktitle = "Proc. of the 12th Int. Conf. on ER Approach",

publisher = "Springer Verlag",

address = "Germany",

}

Schema Transformation Techniques for Database Reverse Engineering. / Hainaut, Jean-Luc; Tonneau, Catherine; Joris, Michel et al.
Proc. of the 12th Int. Conf. on ER Approach. Arlington-Dallas: Springer Verlag, 1993. p. 353-372.

Résultats de recherche: Contribution dans un livre/un catalogue/un rapport/dans les actes d'une conférence › Article dans les actes d'une conférence/un colloque

TY - GEN

T1 - Schema Transformation Techniques for Database Reverse Engineering

AU - Hainaut, Jean-Luc

AU - Tonneau, Catherine

AU - Joris, Michel

AU - Chandelon, Muriel

PY - 1993

Y1 - 1993

N2 - The paper 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 restructuring techniques, or schema transformations. The paper illustrates the methodology by applying it to various DBRE processes : removing optimization structures, untranslating Relational, COBOL, CODASYL, TOTAL/IMAGE and IMS database as well as file structures, and finally conceptual normalization. A shorter version appears in the final proceedings of the conference.

AB - The paper 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 restructuring techniques, or schema transformations. The paper illustrates the methodology by applying it to various DBRE processes : removing optimization structures, untranslating Relational, COBOL, CODASYL, TOTAL/IMAGE and IMS database as well as file structures, and finally conceptual normalization. A shorter version appears in the final proceedings of the conference.

KW - schema equivalence

KW - schema transformation

KW - dabase reverse engineering

KW - database design

M3 - Conference contribution

SP - 353

EP - 372

BT - Proc. of the 12th Int. Conf. on ER Approach

PB - Springer Verlag

CY - Arlington-Dallas

ER -

Schema Transformation Techniques for Database Reverse Engineering

Résumé

Accès au document

Empreinte digitale

Contient cette citation