|
|
|
                                          
|
Return to Session 4: XML Query Processing
We consider the scenario where existing relational data is exported as XML. In this context, we look at the problem of translating XML queries into SQL. XML query languages have two different notions of duplicates: node-identity based and value-based. Path expression queries have an implicit node-identity based duplicate elimination built into them. On the other hand, SQL only supports value-based duplicate elimination. In this paper, using a simple path expression query we illustrate the problems that arise when we attempt to simulate the node-identity based duplicate elimination using value-based duplicate elimination in the SQL queries. We show how a general solution for this problem covering the class of views considered in published literature requires a fairly complex mechanism.
@inproceedings {DBLP:conf/webdb/KrishnamurthyKN04, author = {Rajasekar Krishnamurthy and Raghav Kaushik and Jeffrey F. Naughton}, title = {Unraveling the Duplicate-Elimination Problem in XML-to-SQL Query Translation}, pages = {49-54}, ee = {http://webdb2004.cs.columbia.edu/papers/4-2.pdf}, booktitle = {Seventh International Workshop on the Web and Databases}, month = Jun, year = 2004, crossref = {conf/webdb/2004} }  ©2005 Association for Computing Machinery |
