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

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 ce...

• Type: Conference
• Year: 2004
• Where: WIDM
• Authors: Sihem Amer-Yahia, Fang Du, Juliana Freire
• Keywords: Mapping Strategies, Query Translation, WIDM 2004, XML Data