<?xml version="1.0" encoding="UTF-8"?><?xml-stylesheet type="text/xsl" href="static/style.xsl"?><OAI-PMH xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/ http://www.openarchives.org/OAI/2.0/OAI-PMH.xsd"><responseDate>2026-11-22T00:04:25Z</responseDate><request verb="GetRecord" identifier="oai:uwspace.uwaterloo.ca:10012/1201" metadataPrefix="dim">https://dspacemainprd01.lib.uwaterloo.ca/server/oai/request</request><GetRecord><record><header><identifier>oai:uwspace.uwaterloo.ca:10012/1201</identifier><datestamp>2017-03-21T15:00:17Z</datestamp><setSpec>com_10012_9924</setSpec><setSpec>com_10012_1</setSpec><setSpec>col_10012_9930</setSpec><setSpec>col_10012_6</setSpec></header><metadata><dim:dim xmlns:dim="http://www.dspace.org/xmlns/dspace/dim" xmlns:doc="http://www.lyncode.com/xoai" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.dspace.org/xmlns/dspace/dim http://www.dspace.org/schema/dim.xsd">
   <dim:field mdschema="dc" element="contributor" qualifier="author" lang="en" authority="5816e7e4-e61c-4767-ac5b-15c6c58cbc4a" confidence="600">Chen, Yingwen</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="accessioned">2006-08-22T14:24:41Z</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="available">2006-08-22T14:24:41Z</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="issued" lang="en">2004</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="submitted" lang="en">2004</dim:field>
   <dim:field mdschema="dc" element="identifier" qualifier="uri">http://hdl.handle.net/10012/1201</dim:field>
   <dim:field mdschema="dc" element="description" qualifier="abstract" lang="en">With the rapid growth of XML documents to serve as a popular and major media for storage and interchange of the data on the Web, there is an increasing interest in using existing traditional relational database techniques to store and/or query XML data.   Since XQuery is becoming a standard XML query language, significant effort has been made in developing an efficient and comprehensive XQuery-to-SQL query processor.       
In this thesis, we design and implement an &amp;lt;em&amp;gt;XQuery-to-SQL Query Processor&amp;lt;/em&amp;gt; based on the &amp;lt;em&amp;gt;Dynamic Intervals&amp;lt;/em&amp;gt; approach.   We also provide a comprehensive translation for XQuery basic operations and FLWR expressions.    The query processor is able to translate a complex XQuery query, which might include arbitrarily composed and nested FLWR expressions, basic functions, and element constructors, into a single SQL query for RDBMS and a physical plan for the &amp;lt;em&amp;gt;XQuery-enhanced Relational Engine&amp;lt;/em&amp;gt;.        
In order to produce efficient and concise SQL queries, succinct XQuery to SQL translation templates and the optimization algorithms for the SQL query generation are proposed and implemented.   The preferable &amp;lt;em&amp;gt;merge-join&amp;lt;/em&amp;gt; approach is also proposed to avoid the inefficient &amp;lt;em&amp;gt;nested-loop&amp;lt;/em&amp;gt; evaluation for FLWR expressions.   &amp;lt;em&amp;gt;Merge-join&amp;lt;/em&amp;gt; patterns and query rewriting rules are designed to identify XQuery fragments that can utilize the efficient &amp;lt;em&amp;gt;merge-join&amp;lt;/em&amp;gt; evaluation.   Proofs of correctness of the approach are provided in the thesis.   Experimental results justify the correctness of our work.</dim:field>
   <dim:field mdschema="dc" element="format" lang="en">application/pdf</dim:field>
   <dim:field mdschema="dc" element="format" qualifier="extent">785324 bytes</dim:field>
   <dim:field mdschema="dc" element="format" qualifier="mimetype">application/pdf</dim:field>
   <dim:field mdschema="dc" element="language" qualifier="iso" lang="en">en</dim:field>
   <dim:field mdschema="dc" element="publisher" lang="en">University of Waterloo</dim:field>
   <dim:field mdschema="dc" element="rights" lang="en">Copyright: 2004, 
  Chen, Yingwen. All rights reserved.</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">Computer Science</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">XQuery</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">SQL translation</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">XML</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">Query processor</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">Dynamic Interval Encoding</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">Merge-join</dim:field>
   <dim:field mdschema="dc" element="title" lang="en">XQuery Query Processing in Relational Systems</dim:field>
   <dim:field mdschema="dc" element="type" lang="en">Master Thesis</dim:field>
   <dim:field mdschema="dc" element="pending" lang="en">false</dim:field>
   <dim:field mdschema="uws-etd" element="degree" qualifier="department" lang="en">School of Computer Science</dim:field>
   <dim:field mdschema="uws-etd" element="degree" lang="en">Master of Mathematics</dim:field>
   <dim:field mdschema="uws" element="typeOfResource" lang="en">Text</dim:field>
   <dim:field mdschema="uws" element="peerReviewStatus" lang="en">Unreviewed</dim:field>
   <dim:field mdschema="uws" element="scholarLevel" lang="en">Graduate</dim:field>
   <dim:field mdschema="others" element="access-status">open.access</dim:field>
</dim:dim>
</metadata></record></GetRecord></OAI-PMH>