[Week 1]
The project's title is XPath to SQL Converter and its aim is to provide the following features:
- Ability to read XML Schema (.xsd) files
- Build a tree based on schema file selected
- Allow user to select nodes from the tree to build an XPath expression
- Allow user to add a predicate to certain nodes where appropriate
- Build XPath expression based on user selection
- Convert XPath expression to SQL and query PostgresSQL DB
- Display results in user friendly manner
The main motivation for this project lies in the fact that querying over native XML databases can be inefficient. It has been shown that building relational indexes of XML data and querying with SQL can be more efficient.