Join Queries Translation from SQL to XML

Abstract

SQL (Structured Query Language) was one of the standardized query languages 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 overcome by converting the user’s SQL
queries into XML. In this paper, we have developed a converter tool to convert SQL join (Left, Right, and Full) queries into XML. As a result users
can access XML database through SQL queries only.

Index Terms— SQL; XML; XPath; RDBMS; Query Converter