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

New Search

Print Abstract

E-mail Abstract

Full Text

Save to My Collections

Export 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.
Retrieved from http://www.editlib.org/p/35118.

• Share:
• 
• 
• 
• 
• 
• 
• 

Conference Information

World Conference on Educational Multimedia, Hypermedia and Telecommunications (EDMEDIA) 2010
Toronto, Canada
June 29, 2010
ISBN 1-880094-81-9
AACE

More Information on EDMEDIA
Table of Contents

Author

Robert Dollinger, UNIVERSITY OF WISCONSIN-STEVENS POINT, United States

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.

Also Read

• Supporting E-Learning with Technologies for Electronic Documents
• Instructional Design Considerations for Science E-Learning
• Using Multimedia as an Educational Instrument to Enhance Teaching and Learning Strategies: A Malaysian Perspective
• The International Handbook Summit Call to Action for Learning with Technology in the 21st Century
• Implementing Embedded Assessment to Provide Feedback to Student and Instructor.
• Toward a Taxonomy of Distributed Learning Delivery Modes
• Examining the Field of Educational Technology:A Bourdieuian Perspective
• Usable But Not Entertaining e-Learning Material
• SITE's Digital Fabrication Initative
• The “Corporate University” as Technological and Scientific Support of the Virtual Education in Latin America

Tags