Conference Paper

Query translation from SQL to XPath

DOI: 10.1109/NABIC.2009.5393628 Conference: Nature & Biologically Inspired Computing, 2009. NaBIC 2009. World Congress on
Source: IEEE Xplore


Today XML is the de facto standard of data exchange format for the information on the Web. At the same time, database systems are well known for consistent storage, retrieval and manipulation of data. XML querying language (XPath) is used to access XML documents whereas Structured Query Language (SQL) for retrieving and manipulating data in relational database. It may not be possible for users and developers to be familiar with both the query languages easily and quickly. Here, we examine how XML data can be queried using SQL. In this paper, we propose a new concept and framework where SQL statements can be easily transformed to XPath expressions. We use SQL, as it has long been the standard language. Users can access XML database and relational database through the query language SQL using our framework. We present algorithms for translating queries expressed in SQL (SELECT, DELETE, RENAME) to XPath. The procedure provides relational interface to XML database and the experimental results validate the proposed approach.

181 Reads
  • [Show abstract] [Hide abstract]
    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.
    No preview · Conference Paper · Mar 2013