Analysis of Query System for SQL and XQuery

Abstract

SQL is a special-purpose programming language designed for managing data held in a relational database management system. XQuery is a standardized language for combining documents, databases and Web pages. Among many query languages for native XML databases, XQuery is the most versatile and widely used, thus to analyze and compare the use of SQL against XQuery is considered. This paper presents analysis of query system for SQL and XQuery. The query clauses used in this proposed systemare Select Clause, Where Clause, Join Clause and Order By Clause. This system convert from SQL database into XML documents using SQL to XML conversion algorithm and generate queries for SQL and XQuery using proposed query generation algorithm. The processing times for each query type of SQL and XQuery are analyzed in this system. From the experimental results, XQuery generally has faster processing time than SQL. However, XQuery cannot process and execute all features that are available in SQL. In the case of join statements, SQL turned out to be faster than XQuery, because of predefined indexing.