Join queries translation from SQL to XPath

Abstract

SQL (Structured Query Language) was one of the standarized query language for requesting information from a database. Over the past few years organizations are using SQL for storing and managing the organization specific information. At the same time there is an emerging trend towards XML (Extensible Markup Language), and it has become a standard for information exchange over the internet. Users/Developers are supposed to use two different kinds of languages for data reception and manipulation. This problem is overcomed by converting the user's SQL queries into XML. In this paper, we propose a framework to convert SQL join (Left, Right, and Full) queries into XPath expressions. As a result user's can access XML database through SQL queries only. We also present algorithms for translating SQL join queries to XPath expressions.