By Topic

Semantic evaluation of SQL queries

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

2 Author(s)
Dollinger, R. ; Comput. & New Media Technol., Univ. of Wisconsin Stevens Point, Stevens Point, WI, USA ; Melville, N.A.

The ability to evaluate the logical correctness of SQL queries is a vital feature of an intelligent tutoring system that provides meaningful feedback and guidance to students that learn SQL. This process relies on comparing the student's query with a reference query provided by the instructor. Converting the SQL source code into forms of XML representation of the query turns out to be an effective way to process and analyze the semantics of SQL queries. Queries of arbitrary complexity can be compared effectively through XML, using two forms of representation: structural representation and full content representation. Further, one can apply query transformation patterns that convert a query into a logically equivalent one, having a different structure, but still equivalent to the initial query. This paper focuses on the XML based technique to compare and to transform SQL queries in order to determine their logical compliance with a predetermined reference.

Published in:

Intelligent Computer Communication and Processing (ICCP), 2011 IEEE International Conference on

Date of Conference:

25-27 Aug. 2011