RelaXML: Bidirectional Transfer between Relational and XML Data

Publikation: Konferencebidrag uden forlag/tidsskriftPaper uden forlag/tidsskriftForskningpeer review

5 Citationer (Scopus)

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
Publikationsdato2005
Antal sider11
DOI
StatusUdgivet - 2005
BegivenhedInternational Database Engineering & Application Symposium - Montreal, Canada
Varighed: 25 jul. 200527 jul. 2005

Konference

KonferenceInternational Database Engineering & Application Symposium
LandCanada
ByMontreal
Periode25/07/200527/07/2005

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. Afhandling præsenteret på International Database Engineering & Application Symposium, Montreal, Canada. https://doi.org/10.1109/IDEAS.2005.48
Knudsen, Steffen Ulsø ; Pedersen, Torben Bach ; Thomsen, Christian ; Torp, Kristian. / RelaXML : Bidirectional Transfer between Relational and XML Data. Afhandling præsenteret på International Database Engineering & Application Symposium, Montreal, Canada.11 s.
@conference{5607a360336b11db8b1e000ea68e967b,
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",
doi = "10.1109/IDEAS.2005.48",
language = "English",
note = "null ; Conference date: 25-07-2005 Through 27-07-2005",

}

Knudsen, SU, Pedersen, TB, Thomsen, C & Torp, K 2005, 'RelaXML: Bidirectional Transfer between Relational and XML Data' Paper fremlagt ved International Database Engineering & Application Symposium, Montreal, Canada, 25/07/2005 - 27/07/2005, . https://doi.org/10.1109/IDEAS.2005.48

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

2005. Afhandling præsenteret på International Database Engineering & Application Symposium, Montreal, Canada.

Publikation: Konferencebidrag uden forlag/tidsskriftPaper uden forlag/tidsskriftForskningpeer review

TY - CONF

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.

U2 - 10.1109/IDEAS.2005.48

DO - 10.1109/IDEAS.2005.48

M3 - Paper without publisher/journal

ER -

Knudsen SU, Pedersen TB, Thomsen C, Torp K. RelaXML: Bidirectional Transfer between Relational and XML Data. 2005. Afhandling præsenteret på International Database Engineering & Application Symposium, Montreal, Canada. https://doi.org/10.1109/IDEAS.2005.48