A Generic Framework for Extracting XML Data from Legacy Databases

Philippe Thiran, Fabrice Estievenart, Jean-Luc Hainaut, Geert-Jan Houben

Research output: Contribution to journalArticle

Abstract

This paper describes a generic framework in which semantics-based XML data can be derived from legacy databases. It consists of first recovering the conceptual schema of the database through reverse engineering techniques, and then of converting this schema, or part of it, into XML-compliant data structures. Both steps heavily rely on generic schema transformation techniques, while all the schemas involved in the whole process are expressed in a unique model, named GER. Transformations between schemas are expressed as sequences of reversible transformation primitives. The reversed sequence can be used to automatically translate query, data or updates posed on XML.
Original languageEnglish
Pages (from-to)205-223
Number of pages19
JournalJournal of Web Engineering
Volume4
Issue number3
Publication statusUnpublished - 2005

Fingerprint

XML
Reverse engineering
Data structures
Semantics

Keywords

  • Legacy Database
  • Data Reverse Engineering
  • Schema Transformation
  • XML

Cite this

Thiran, Philippe ; Estievenart, Fabrice ; Hainaut, Jean-Luc ; Houben, Geert-Jan. / A Generic Framework for Extracting XML Data from Legacy Databases. In: Journal of Web Engineering. 2005 ; Vol. 4, No. 3. pp. 205-223.
@article{f06837c43ae34cd48c7b96bfc7cca06d,
title = "A Generic Framework for Extracting XML Data from Legacy Databases",
abstract = "This paper describes a generic framework in which semantics-based XML data can be derived from legacy databases. It consists of first recovering the conceptual schema of the database through reverse engineering techniques, and then of converting this schema, or part of it, into XML-compliant data structures. Both steps heavily rely on generic schema transformation techniques, while all the schemas involved in the whole process are expressed in a unique model, named GER. Transformations between schemas are expressed as sequences of reversible transformation primitives. The reversed sequence can be used to automatically translate query, data or updates posed on XML.",
keywords = "Legacy Database, Data Reverse Engineering, Schema Transformation, XML",
author = "Philippe Thiran and Fabrice Estievenart and Jean-Luc Hainaut and Geert-Jan Houben",
year = "2005",
language = "English",
volume = "4",
pages = "205--223",
journal = "Journal of Web Engineering",
issn = "1540-9589",
publisher = "Rinton Press Inc.",
number = "3",

}

A Generic Framework for Extracting XML Data from Legacy Databases. / Thiran, Philippe; Estievenart, Fabrice; Hainaut, Jean-Luc; Houben, Geert-Jan.

In: Journal of Web Engineering, Vol. 4, No. 3, 2005, p. 205-223.

Research output: Contribution to journalArticle

TY - JOUR

T1 - A Generic Framework for Extracting XML Data from Legacy Databases

AU - Thiran, Philippe

AU - Estievenart, Fabrice

AU - Hainaut, Jean-Luc

AU - Houben, Geert-Jan

PY - 2005

Y1 - 2005

N2 - This paper describes a generic framework in which semantics-based XML data can be derived from legacy databases. It consists of first recovering the conceptual schema of the database through reverse engineering techniques, and then of converting this schema, or part of it, into XML-compliant data structures. Both steps heavily rely on generic schema transformation techniques, while all the schemas involved in the whole process are expressed in a unique model, named GER. Transformations between schemas are expressed as sequences of reversible transformation primitives. The reversed sequence can be used to automatically translate query, data or updates posed on XML.

AB - This paper describes a generic framework in which semantics-based XML data can be derived from legacy databases. It consists of first recovering the conceptual schema of the database through reverse engineering techniques, and then of converting this schema, or part of it, into XML-compliant data structures. Both steps heavily rely on generic schema transformation techniques, while all the schemas involved in the whole process are expressed in a unique model, named GER. Transformations between schemas are expressed as sequences of reversible transformation primitives. The reversed sequence can be used to automatically translate query, data or updates posed on XML.

KW - Legacy Database

KW - Data Reverse Engineering

KW - Schema Transformation

KW - XML

M3 - Article

VL - 4

SP - 205

EP - 223

JO - Journal of Web Engineering

JF - Journal of Web Engineering

SN - 1540-9589

IS - 3

ER -