Type of Document Master's Thesis Author Jandhyala, Sandeep Author's Email Address jan_sandeep@yahoo.com URN etd-04012006-121218 Title An Automated XPATH to SQL Transformation Methodology for XML Data Degree Master of Science Department Computer Science Advisory Committee
Advisor Name Title Rajshekhar Sunderraman Committee Chair Alex Zelikovsky Committee Member Dr.Sushil Prasad Committee Member Keywords
- XSU
- XPATH to SQL queries
- XML SQL transformation
- Data Mapiing
Date of Defense 2005-12-02 Availability unrestricted 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.
Files
Filename Size Approximate Download Time (Hours:Minutes:Seconds)
28.8 Modem 56K Modem ISDN (64 Kb) ISDN (128 Kb) Higher-speed Access jandahayla_sandeep_200601_ms.pdf 267.44 Kb 00:01:14 00:00:38 00:00:33 00:00:16 00:00:01