Sciweavers

Share
WEBDB
2004
Springer

Unraveling the Duplicate-Elimination Problem in XML-to-SQL Query Translation

11 years 6 months ago
Unraveling the Duplicate-Elimination Problem in XML-to-SQL Query Translation
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.
Rajasekar Krishnamurthy, Raghav Kaushik, Jeffrey F
Added 02 Jul 2010
Updated 02 Jul 2010
Type Conference
Year 2004
Where WEBDB
Authors Rajasekar Krishnamurthy, Raghav Kaushik, Jeffrey F. Naughton
Comments (0)
books