Title :
Using LINQ transformation patterns to evaluate SQL queries
Author :
Dollinger, Robert ; Thomas, Kent
Author_Institution :
Comput. & New Media Technol., Univ. of Wisconsin Stevens Point, Stevens Point, WI, USA
Abstract :
The SQL Lightweight Tutoring Module (SQL-LTM) is a software tool designed to evaluate the correctness of SQL queries in order to provide useful feedback to the students and guidance in their effort to learn SQL. The XML representations of the queries are processed and analyzed in several steps in order to achieve this. One important step in this process is to transform the query into a logically equivalent one, having a different structure, which is easier to further analyze. This paper focuses on the query transformation patterns and their key role in the semantic evaluation of SQL queries of an arbitrary complexity.
Keywords :
SQL; XML; computational complexity; computer aided instruction; software tools; LINQ transformation patterns; SQL lightweight tutoring module; SQL queries; SQL-LTM; XML representations; arbitrary complexity; query transformation patterns; software tool; Complexity theory; Computers; XML; LINQ to XML; SQL queries; XML; intelligent tutoring systems; semantic evaluation;
Conference_Titel :
Applications of Digital Information and Web Technologies (ICADIWT), 2011 Fourth International Conference on the
Conference_Location :
Stevens Point, WI
Print_ISBN :
978-1-4244-9824-6
DOI :
10.1109/ICADIWT.2011.6041397
