SQL Lightweight Tutoring Module – Semantic Analysis of SQL Queries based on XML Representation and LINQ
Save to My Collections
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 Multimedia, Hypermedia and Telecommunications 2010 (pp. 3323-3328). Chesapeake, VA: AACE. Retrieved December 10, 2013 from http://www.editlib.org/p/35118.
- The intractability of information: non-governmental development organizations and the uses of knowledge
- A Comparison of Learners' Achievement between Blended Learning and Distance Learning
- The International Handbook Summit Call to Action for Learning with Technology in the 21st Century
- The Effects of Computer-Assisted Concept Mapping on EFL Students’English Reading
- Social Networking and Education: Using Facebook as an Edusocial Space
- The Ecology in Architecture Design Project: Pedagogical, Graphic and Technological Strategic Choices
- Education and Information Technology 2012: A Selection of AACE Award Papers
- Becoming an Educational Technology Leader Though Online Education
- Research Highlights in Technology and Teacher Education 2011
- Instructional Design Considerations for Science E-Learning
Comments & Discussion
Comment on the paper above. You must be registered to participate. Registration is free.