We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 December 2024
Reseach Article

Adaptive SQL Analysis & Refactoring System Model

by Soumya Reddy, Srikanth Jatla
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

@article{ 10.5120/5657-7547,
author = { Soumya Reddy, Srikanth Jatla },
title = { Adaptive SQL Analysis & Refactoring System Model },
journal = { International Journal of Computer Applications },
issue_date = { March 2012 },
volume = { 42 },
number = { 1 },
month = { March },
year = { 2012 },
issn = { 0975-8887 },
pages = { 23-26 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume42/number1/5657-7547/ },
doi = { 10.5120/5657-7547 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:30:22.930285+05:30
%A Soumya Reddy
%A Srikanth Jatla
%T Adaptive SQL Analysis & Refactoring System Model
%J International Journal of Computer Applications
%@ 0975-8887
%V 42
%N 1
%P 23-26
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
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
  1. A. V. Aho, M. S. Lam, R. Sethi, and J. D. Ullman, Compilers: Principles, Techniques, and Tools, second ed. Addison-Wesley, 2007.
  2. A. V. Aho, J. D. Ullman, and J. E. Hopcroft, Data Structures and Algorithms, series in Computer Science and Information Processing. Addison-Wesley, 1983.
  3. 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.
  4. T. Boyle, Design for Multimedia Learning. Prentice Hall, 1997.
  5. 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.
  6. 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.
  7. 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.
  8. C. Kenny, "Automated Tutoring for a Database Skills Training Environment," MSc thesis, School of Computing, Dublin City Univ. , 2006.
  9. C. Kenny and C. Pahl, "Automated Tutoring for a Database Skills Training Environment," Proc. ACM SIGCSE '05, pp. 58-62, 2005.
  10. 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.
  11. 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.
  12. 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.
  13. 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.
  14. R. Ramakrishnan and J. Gehrke, Database Management Systems. McGraw-Hill, 2003.
  15. 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.
  16. 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

Computer Science
Information Sciences

Keywords

Syntax Grammar Comparison Techniques Artificial Intelligence Education Query Language