Xml-to-sql query translation
Rajasekar Krishnamurthy, Jeffrey F. Naughton · 2004
Developing techniques for managing and querying the growing body of XML data is becomingly increasingly important. A popular approach to evaluating XML queries is to translate them to relational queries and then to use a relational database system to evaluate the result. The XML and relational data models are significantly different, and as a result, the corresponding query languages (XQuery and SQL respectively) also differ significantly. This mismatch raises some interesting questions: (i) From a functionality perspective, is it possible to handle all XML data sets using this approach or are there any fundamental limitations in SQL that create problems? (ii) From a performance perspective, are there any implications on the quality of the SQL queries produced due to this mismatch between the two data models? In this thesis, we address the above two questions in two different scenarios: XML storage and XML publishing. In the former, the goal is to use relational databases to store and query existing XML data, while in the latter, existing relational data is exported as XML.