Login or register for free to remove ads.

SQL Lightweight Tutoring Module – Semantic Analysis of SQL Queries based on XML Representation and LINQ PROCEEDINGS

, UNIVERSITY OF WISCONSIN-STEVENS POINT, United States

World Conference on Educational Multimedia, Hypermedia and Telecommunications, in Toronto, Canada ISBN 978-1-880094-81-5 Publisher: Association for the Advancement of Computing in Education (AACE), Chesapeake, VA

Abstract

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.

Citation

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 Multimedia, Hypermedia and Telecommunications 2010 (pp. 3323-3328). Chesapeake, VA: AACE.

OpenURL

Keywords


Feedback and Suggestions please email info@editlib.org or use our online feedback form.