SQL Lightweight Tutoring Module – Semantic Analysis of SQL Queries based on XML Representation and LINQ PROCEEDINGS
Robert Dollinger, UNIVERSITY OF WISCONSIN-STEVENS POINT, United States
World Conference on Educational Media and Technology, in Toronto, Canada ISBN 978-1-880094-81-5 Publisher: Association for the Advancement of Computing in Education (AACE)
The SQL Lightweight Tutoring Module (SQL-LTM) is capable to provide semantic feedback on otherwise syntactically correct SQL statements pointing out their logic flaws. The target SQL statement provided by the learning student is converted to an intermediate XML representation, which is analyzed and compared to a representation of a test SQL statement by using LINQ to XML. Leveraging the power of LINQ allows a simple and flexible implementation of the analyzer, though powerful and functionally robust. Two main strategies are used in the analyses process: (1) apply transformation patterns to bring the target queries to equivalent representations that can then be compared to the test query representation (2) use the LINQ to XML query capabilities to extract and compare specific query metrics/invariants (list of tables, list of join connections, etc) from the target and test SQL statements. Most conceptual errors SQL learners typically make can be detected in this way.
Dollinger, R. (2010). SQL Lightweight Tutoring Module – Semantic Analysis of SQL Queries based on XML Representation and LINQ. In Proceedings of World Conference on Educational Media and Technology 2010 (pp. 3323-3328). Association for the Advancement of Computing in Education (AACE).
© 2010 AACE