An Approach to Heterogeneous Data Translation based on XML Conversion

In this paper, we illustrate a preliminary approach to the translation of Web data between heterogeneous formats. This work fits into a larger project whose aim is the development of a tool for the management of data described according to a large variety of formats used on the Web and the (semi)automatic translation of schemes and instances from one model to another. Data translations operate over XML representations of instances and rely on a uniform representation of models that we call metamodel. The metamodel shows structural diversities and dictates the needed transformations. Complex translation can be derived by combining a number of predefined basic functions performing XML transformations expressed in XQuery. Practical examples are provided to show the effectiveness of the approach.

[1]  SalesTaxRate Orders Did Quantity UnitPrice,et al.  Rondo : A Programming Platform for Generic Model Management , 2003 .

[2]  Paolo Atzeni,et al.  A unified framework for data translation over the Web , 2001, Proceedings of the Second International Conference on Web Information Systems Engineering.

[3]  Paolo Atzeni,et al.  Management of Multiple Models in an Extensible Database Design Tool , 1996, EDBT.

[4]  Vishu Krishnamurthy,et al.  Performance Challenges in Object-Relational DBMSs , 1999, IEEE Data Eng. Bull..

[5]  Stefano Ceri,et al.  Designing Data-Intensive Web Applications , 2002 .

[6]  Philip A. Bernstein,et al.  A vision for management of complex models , 2000, SGMD.

[7]  Philip A. Bernstein,et al.  Applying Model Management to Classical Meta Data Problems , 2003, CIDR.

[8]  Erhard Rahm,et al.  A survey of approaches to automatic schema matching , 2001, The VLDB Journal.

[9]  Paolo Merialdo,et al.  Design and development of data-intensive web sites: The Araneus approach , 2003, TOIT.

[10]  Masatoshi Yoshikawa,et al.  ILOG: Declarative Creation and Manipulation of Object Identifiers , 1990, VLDB.

[11]  Dan Suciu,et al.  Data on the Web: From Relations to Semistructured Data and XML , 1999 .

[12]  Ronald Fagin,et al.  Translating Web Data , 2002, VLDB.

[13]  Ronald Fagin,et al.  Data exchange: semantics and query answering , 2003, Theor. Comput. Sci..

[14]  Philip A. Bernstein,et al.  Merging Models Based on Given Correspondences , 2003, VLDB.

[15]  Daniela Florescu,et al.  Storing and Querying XML Data using an RDMBS , 1999, IEEE Data Eng. Bull..

[16]  Paolo Atzeni,et al.  Chameleon: an Extensible and Customizable Tool for Web Data Translation , 2003, VLDB.

[17]  Erhard Rahm,et al.  Rondo: a programming platform for generic model management , 2003, SIGMOD '03.

[18]  Paolo Atzeni,et al.  Schema Translation between Heterogeneous Data Models in a Lattice Framework , 1995, DS-6.

[19]  Dongwon Lee,et al.  Comparative analysis of six XML schema languages , 2000, SGMD.