The week's pick
Reseach Article
Adaptive SQL Analysis & Refactoring System Model
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 42 - Number 1 |
| Year of Publication: 2012 |
| Authors: Soumya Reddy, Srikanth Jatla |
10.5120/5657-7547
|
Soumya Reddy, Srikanth Jatla . Adaptive SQL Analysis & Refactoring System Model. International Journal of Computer Applications. 42, 1 ( March 2012), 23-26. DOI=10.5120/5657-7547
Abstract
In any form of education continuous learning and training plays an important role while knowledge and skills are equally important. In a given domain, an automated system for training skills and active learning is an effective form of learning. This paper presents a system that helps in active learning and training of skills with respect to database programming. While learning database programming with SQL commands, this system guides the user by giving feedback. The recommendations and the automated feedback help end user to improve his skills and focus on week areas. Classification and correction component proposed in this paper is the core of the system which is based on syntax and grammars and provides necessary feedback. The approaches used are comparison techniques and syntax tree based abstractions which were proved effective.
References
- A. V. Aho, M. S. Lam, R. Sethi, and J. D. Ullman, Compilers: Principles, Techniques, and Tools, second ed. Addison-Wesley, 2007.
- A. V. Aho, J. D. Ullman, and J. E. Hopcroft, Data Structures and Algorithms, series in Computer Science and Information Processing. Addison-Wesley, 1983.
- S. Bhagat, L. Bhagat, J. Kavalan, and M. Sasikumar. Acharya, "An Intelligent Tutoring Environment for Learning SQL," Proc. Int'l Conf. Online Learning (Vidyakash), 2002.
- T. Boyle, Design for Multimedia Learning. Prentice Hall, 1997.
- P. Brusilovsky, "Adaptive Hypermedia: From Intelligent Tutoring Systems to Web-Based Education," Proc. Fifth Int'l Conf. Intelligent Tutoring Systems (ITS '00), pp. 1-7, 2000.
- P. De Bra, D. Smits, and N. Stash, "Creating and Delivering Adaptive Courses with AHA!," Proc. First European Conf. Technology Enhanced Learning (EC-TEL '06), 2006.
- D. Heaney and C. Daly, "Mass Production of Individual Feedback," Proc. Ninth Ann. ACM SIGCSE Int'l Conf. Innovation and Technology in Computer Science Education (ITiCSE '04), pp. 117-121, 2004.
- C. Kenny, "Automated Tutoring for a Database Skills Training Environment," MSc thesis, School of Computing, Dublin City Univ. , 2006.
- C. Kenny and C. Pahl, "Automated Tutoring for a Database Skills Training Environment," Proc. ACM SIGCSE '05, pp. 58-62, 2005.
- M. Mathews and A. Mitrovic, "Investigating the Effectiveness of Problem Templates on Learning in Intelligent Tutoring Systems," Proc. 13th Int'l Conf. Artificial Intelligence in Education (AIED '07), pp. 611-613, 2007.
- A. Mitrovic, B. Martin, and P. Suraweera, "Intelligent Tutors for All: The Constraint-Based Approach," IEEE Intelligent Systems, vol. 22, no. 4, pp. 38-45, July/Aug. 2007.
- T. Murray, "Authoring Intelligent Tutoring Systems: An Analysis of the State of the Art," Int'l J. Artificial Intelligence in Education, vol. 10, pp. 98-129, 1999.
- C. Pahl, R. Barrett, and C. Kenny, "Supporting Active Database Learning and Training through Interactive Multimedia," Proc. Ninth Ann. Conf. Innovation and Technology in Computer Science Education (ITiCSE), 2004.
- R. Ramakrishnan and J. Gehrke, Database Management Systems. McGraw-Hill, 2003.
- S. Sadiq, M. Orlowska,W. Sadiq, and J. Lin, "SQLator An Online SQL Learning Workbench," Proc. Ninth Ann. ACM SIGCSE Int'l Conf. Innovation and Technology in Computer Science Education (ITiCSE '04), pp. 223-227, June 2004.
- R. H. Stottler and M. Vinkavich, "Tactical Action Officer Intelligent Tutoring System (TAO ITS)," Proc. Interservice/ Industry Training, Simulation and Education Conf. (I/ITSEC), 2000.
Index Terms
Keywords