RelaXML: Bidirectional Transfer Between Relational and XML Data

Publikation: Bog/antologi/afhandling/rapportRapportForskning

Resumé

In modern enterprises, almost all data is stored in relational databases. Additionally, most enterprises increasingly collaborate with other enterprises in long-running read-write workflows, primarily through XML-based data exchange technologies such as web services. However, bidirectional XML data exchange is cumbersome and must often be hand-coded, at considerable expense. This paper remedies the situation by proposing RELAXML, an automatic and effective approach to bidirectional XML-based exchange of relational data. RELAXML supports re-use through multiple inheritance, and handles both export of relational data to XML documents and (re-)import of XML documents with a large degree of flexibility in terms of the SQL statements and XML document structures supported. Import and export are formally defined so as to avoid semantic problems, and algorithms to implement both are given. A performance study shows that the approach has a reasonable overhead compared to hand-coded programs.
OriginalsprogEngelsk
ForlagAalborg Universitet
Antal sider30
StatusUdgivet - 2005
NavnTechnical Report
NummerTR-11

Fingerprint

XML
Electronic data interchange
Industry
Web services
Semantics

Citer dette

Knudsen, S. U., Pedersen, T. B., Thomsen, C., & Torp, K. (2005). RelaXML: Bidirectional Transfer Between Relational and XML Data. Aalborg Universitet. Technical Report, Nr. TR-11
Knudsen, Steffen Ulsø ; Pedersen, Torben Bach ; Thomsen, Christian ; Torp, Kristian. / RelaXML : Bidirectional Transfer Between Relational and XML Data. Aalborg Universitet, 2005. 30 s. (Technical Report; Nr. TR-11).
@book{27b9ac80c49211dab67b000ea68e967b,
title = "RelaXML: Bidirectional Transfer Between Relational and XML Data",
abstract = "In modern enterprises, almost all data is stored in relational databases. Additionally, most enterprises increasingly collaborate with other enterprises in long-running read-write workflows, primarily through XML-based data exchange technologies such as web services. However, bidirectional XML data exchange is cumbersome and must often be hand-coded, at considerable expense. This paper remedies the situation by proposing RELAXML, an automatic and effective approach to bidirectional XML-based exchange of relational data. RELAXML supports re-use through multiple inheritance, and handles both export of relational data to XML documents and (re-)import of XML documents with a large degree of flexibility in terms of the SQL statements and XML document structures supported. Import and export are formally defined so as to avoid semantic problems, and algorithms to implement both are given. A performance study shows that the approach has a reasonable overhead compared to hand-coded programs.",
author = "Knudsen, {Steffen Uls{\o}} and Pedersen, {Torben Bach} and Christian Thomsen and Kristian Torp",
year = "2005",
language = "English",
series = "Technical Report",
number = "TR-11",
publisher = "Aalborg Universitet",

}

Knudsen, SU, Pedersen, TB, Thomsen, C & Torp, K 2005, RelaXML: Bidirectional Transfer Between Relational and XML Data. Technical Report, nr. TR-11, Aalborg Universitet.

RelaXML : Bidirectional Transfer Between Relational and XML Data. / Knudsen, Steffen Ulsø; Pedersen, Torben Bach; Thomsen, Christian; Torp, Kristian.

Aalborg Universitet, 2005. 30 s. (Technical Report; Nr. TR-11).

Publikation: Bog/antologi/afhandling/rapportRapportForskning

TY - RPRT

T1 - RelaXML

T2 - Bidirectional Transfer Between Relational and XML Data

AU - Knudsen, Steffen Ulsø

AU - Pedersen, Torben Bach

AU - Thomsen, Christian

AU - Torp, Kristian

PY - 2005

Y1 - 2005

N2 - In modern enterprises, almost all data is stored in relational databases. Additionally, most enterprises increasingly collaborate with other enterprises in long-running read-write workflows, primarily through XML-based data exchange technologies such as web services. However, bidirectional XML data exchange is cumbersome and must often be hand-coded, at considerable expense. This paper remedies the situation by proposing RELAXML, an automatic and effective approach to bidirectional XML-based exchange of relational data. RELAXML supports re-use through multiple inheritance, and handles both export of relational data to XML documents and (re-)import of XML documents with a large degree of flexibility in terms of the SQL statements and XML document structures supported. Import and export are formally defined so as to avoid semantic problems, and algorithms to implement both are given. A performance study shows that the approach has a reasonable overhead compared to hand-coded programs.

AB - In modern enterprises, almost all data is stored in relational databases. Additionally, most enterprises increasingly collaborate with other enterprises in long-running read-write workflows, primarily through XML-based data exchange technologies such as web services. However, bidirectional XML data exchange is cumbersome and must often be hand-coded, at considerable expense. This paper remedies the situation by proposing RELAXML, an automatic and effective approach to bidirectional XML-based exchange of relational data. RELAXML supports re-use through multiple inheritance, and handles both export of relational data to XML documents and (re-)import of XML documents with a large degree of flexibility in terms of the SQL statements and XML document structures supported. Import and export are formally defined so as to avoid semantic problems, and algorithms to implement both are given. A performance study shows that the approach has a reasonable overhead compared to hand-coded programs.

M3 - Report

T3 - Technical Report

BT - RelaXML

PB - Aalborg Universitet

ER -

Knudsen SU, Pedersen TB, Thomsen C, Torp K. RelaXML: Bidirectional Transfer Between Relational and XML Data. Aalborg Universitet, 2005. 30 s. (Technical Report; Nr. TR-11).