A comprehensive solution to the XML-to-relational mapping problem

Sihem Amer-Yahia, Fang Du, Juliana Freire

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

The use of relational database management systems (RDBMSs) to store and query XML data has attracted considerable interest with a view to leveraging their powerful and reliable data management services. Due to the mismatch between the relational and XML data models, it is necessary to first shred and load the XML data into relational tables, and then translate XML queries over the original data into equivalent SQL queries over the mapped tables. Although there is a rich literature on XML-relational storage, none of the existing solutions addresses all the storage problems in a single framework. Works on mapping strategies often have little or no details about query translation, and proposals for query translation often target a specific mapping strategy. XML-storage solutions provided by RDBMS also have limitations. Notably, they are tied to a specific backend and use proprietary mapping languages, which not only may require a steep learning curve, but often are unable to express certain desirable mappings. In order to address these limitations, we developed ShreX, a XML-to-relational mapping framework and system that provides the first comprehensive and end-to-end solution to the relational storage of XML data. Mappings in ShreX are defined through annotations to an XML Schema. The use of XML Schema simplifies the mapping process, since it does not require users to master a new specialized mapping language. The use of annotations allows mapping choices to be combined in many different ways. As a result, ShreX not only supports all the mapping strategies proposed in the literature, but also new useful strategies that had not been considered previously. ShreX provides generic (and automatic) document shredding and query translation capabilities; and it is portable - its mapping specifications are independent of the database backend.

Original languageEnglish (US)
Title of host publicationWIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management
EditorsA.H.F. Laender, D. Lee, M. Ronthaler
Pages31-38
Number of pages8
StatePublished - 2004
EventWIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management - Washington, DC, United States
Duration: Nov 12 2004Nov 13 2004

Other

OtherWIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management
CountryUnited States
CityWashington, DC
Period11/12/0411/13/04

Fingerprint

XML
Information management
Data structures
Specifications

Keywords

  • Mapping techniques
  • Relational Databases
  • XML Shredding
  • XML Storage

ASJC Scopus subject areas

  • Computer Networks and Communications
  • Information Systems

Cite this

Amer-Yahia, S., Du, F., & Freire, J. (2004). A comprehensive solution to the XML-to-relational mapping problem. In A. H. F. Laender, D. Lee, & M. Ronthaler (Eds.), WIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management (pp. 31-38)

A comprehensive solution to the XML-to-relational mapping problem. / Amer-Yahia, Sihem; Du, Fang; Freire, Juliana.

WIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management. ed. / A.H.F. Laender; D. Lee; M. Ronthaler. 2004. p. 31-38.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Amer-Yahia, S, Du, F & Freire, J 2004, A comprehensive solution to the XML-to-relational mapping problem. in AHF Laender, D Lee & M Ronthaler (eds), WIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management. pp. 31-38, WIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management, Washington, DC, United States, 11/12/04.
Amer-Yahia S, Du F, Freire J. A comprehensive solution to the XML-to-relational mapping problem. In Laender AHF, Lee D, Ronthaler M, editors, WIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management. 2004. p. 31-38
Amer-Yahia, Sihem ; Du, Fang ; Freire, Juliana. / A comprehensive solution to the XML-to-relational mapping problem. WIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management. editor / A.H.F. Laender ; D. Lee ; M. Ronthaler. 2004. pp. 31-38
@inproceedings{7864fa6c791e4406a73d285d1daedb4b,
title = "A comprehensive solution to the XML-to-relational mapping problem",
abstract = "The use of relational database management systems (RDBMSs) to store and query XML data has attracted considerable interest with a view to leveraging their powerful and reliable data management services. Due to the mismatch between the relational and XML data models, it is necessary to first shred and load the XML data into relational tables, and then translate XML queries over the original data into equivalent SQL queries over the mapped tables. Although there is a rich literature on XML-relational storage, none of the existing solutions addresses all the storage problems in a single framework. Works on mapping strategies often have little or no details about query translation, and proposals for query translation often target a specific mapping strategy. XML-storage solutions provided by RDBMS also have limitations. Notably, they are tied to a specific backend and use proprietary mapping languages, which not only may require a steep learning curve, but often are unable to express certain desirable mappings. In order to address these limitations, we developed ShreX, a XML-to-relational mapping framework and system that provides the first comprehensive and end-to-end solution to the relational storage of XML data. Mappings in ShreX are defined through annotations to an XML Schema. The use of XML Schema simplifies the mapping process, since it does not require users to master a new specialized mapping language. The use of annotations allows mapping choices to be combined in many different ways. As a result, ShreX not only supports all the mapping strategies proposed in the literature, but also new useful strategies that had not been considered previously. ShreX provides generic (and automatic) document shredding and query translation capabilities; and it is portable - its mapping specifications are independent of the database backend.",
keywords = "Mapping techniques, Relational Databases, XML Shredding, XML Storage",
author = "Sihem Amer-Yahia and Fang Du and Juliana Freire",
year = "2004",
language = "English (US)",
pages = "31--38",
editor = "A.H.F. Laender and D. Lee and M. Ronthaler",
booktitle = "WIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management",

}

TY - GEN

T1 - A comprehensive solution to the XML-to-relational mapping problem

AU - Amer-Yahia, Sihem

AU - Du, Fang

AU - Freire, Juliana

PY - 2004

Y1 - 2004

N2 - The use of relational database management systems (RDBMSs) to store and query XML data has attracted considerable interest with a view to leveraging their powerful and reliable data management services. Due to the mismatch between the relational and XML data models, it is necessary to first shred and load the XML data into relational tables, and then translate XML queries over the original data into equivalent SQL queries over the mapped tables. Although there is a rich literature on XML-relational storage, none of the existing solutions addresses all the storage problems in a single framework. Works on mapping strategies often have little or no details about query translation, and proposals for query translation often target a specific mapping strategy. XML-storage solutions provided by RDBMS also have limitations. Notably, they are tied to a specific backend and use proprietary mapping languages, which not only may require a steep learning curve, but often are unable to express certain desirable mappings. In order to address these limitations, we developed ShreX, a XML-to-relational mapping framework and system that provides the first comprehensive and end-to-end solution to the relational storage of XML data. Mappings in ShreX are defined through annotations to an XML Schema. The use of XML Schema simplifies the mapping process, since it does not require users to master a new specialized mapping language. The use of annotations allows mapping choices to be combined in many different ways. As a result, ShreX not only supports all the mapping strategies proposed in the literature, but also new useful strategies that had not been considered previously. ShreX provides generic (and automatic) document shredding and query translation capabilities; and it is portable - its mapping specifications are independent of the database backend.

AB - The use of relational database management systems (RDBMSs) to store and query XML data has attracted considerable interest with a view to leveraging their powerful and reliable data management services. Due to the mismatch between the relational and XML data models, it is necessary to first shred and load the XML data into relational tables, and then translate XML queries over the original data into equivalent SQL queries over the mapped tables. Although there is a rich literature on XML-relational storage, none of the existing solutions addresses all the storage problems in a single framework. Works on mapping strategies often have little or no details about query translation, and proposals for query translation often target a specific mapping strategy. XML-storage solutions provided by RDBMS also have limitations. Notably, they are tied to a specific backend and use proprietary mapping languages, which not only may require a steep learning curve, but often are unable to express certain desirable mappings. In order to address these limitations, we developed ShreX, a XML-to-relational mapping framework and system that provides the first comprehensive and end-to-end solution to the relational storage of XML data. Mappings in ShreX are defined through annotations to an XML Schema. The use of XML Schema simplifies the mapping process, since it does not require users to master a new specialized mapping language. The use of annotations allows mapping choices to be combined in many different ways. As a result, ShreX not only supports all the mapping strategies proposed in the literature, but also new useful strategies that had not been considered previously. ShreX provides generic (and automatic) document shredding and query translation capabilities; and it is portable - its mapping specifications are independent of the database backend.

KW - Mapping techniques

KW - Relational Databases

KW - XML Shredding

KW - XML Storage

UR - http://www.scopus.com/inward/record.url?scp=18744377500&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=18744377500&partnerID=8YFLogxK

M3 - Conference contribution

SP - 31

EP - 38

BT - WIDM 2004: Proceedings of the Sixth ACM International Workshop on Web Information and Data Management

A2 - Laender, A.H.F.

A2 - Lee, D.

A2 - Ronthaler, M.

ER -