Date of Award
6-12-2006
Degree Type
Thesis
Degree Name
Master of Science (MS)
Department
Computer Science
First Advisor
Rajshekhar Sunderraman - Chair
Second Advisor
Dr.Sushil Prasad
Third Advisor
Alex Zelikovsky
Abstract
In this thesis we present an automated system that allows users to execute XPATH queries against an XML data source. The system exploits the shared-inlining mapping from XML to Relational data. At the core of the system is an XPATH to SQL transformation algorithm that produces corresponding SQL queries for a subset of XPATH. This approach allows one to utilize standard relational databases to store XML data. Given a DTD, the system creates appropriate relational tables based on the shared-inlining method. The system is capable of transforming an XML data source that conforms to the DTD into relational data. The main component of the system is the XPATH interpreter that parses an XPATH expression for the XML data source and transforms it into an equivalent SQL query. The SQL query is then executed against the relational database and results are packaged into XML and returned as the answer to the XPATH query. The use of the relational database to store and query the XML data is transparent to the user as they interact only with the XPATH interpreter. This methodology provides a novel technique to provide an XML database system implementation. Index Words: XML SQL transformation, XPATH to SQL queries, XSU, Data mapping.
DOI
https://doi.org/10.57709/1059366
Recommended Citation
Jandhyala, Sandeep, "An Automated XPATH to SQL Transformation Methodology for XML Data." Thesis, Georgia State University, 2006.
doi: https://doi.org/10.57709/1059366