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

fYear

2011

Firstpage

1

Lastpage

6

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;

fLanguage

English

Publisher

ieee

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

Type

conf

DOI

10.1109/ICADIWT.2011.6041397

Filename

6041397