SQL Generator Based On MVC Pattern

Authors: Chanchai Supaartagorn

Abstract:

Structured Query Language (SQL) is the standard de facto language to access and manipulate data in a relational database. Although SQL is a language that is simple and powerful, most novice users will have trouble with SQL syntax. Thus, we are presenting SQL generator tool which is capable of translating actions and displaying SQL commands and data sets simultaneously. The tool was developed based on Model-View-Controller (MVC) pattern. The MVC pattern is a widely used software design pattern that enforces the separation between the input, processing, and output of an application. Developers take full advantage of it to reduce the complexity in architectural design and to increase flexibility and reuse of code. In addition, we use White-Box testing for the code verification in the Model module.

Keywords: MVC, relational database, SQL, White-Box testing.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1337759

References:

[1] Aversano L, Canfora G, De Lucia A, and Stefanucci S, “Understanding SQL through Iconic Interfaces, ” in Computer Software and Applications Conference, Oxford, England, 2002, pp. 703–708.
[2] J. Li, G. Ma, G.Feng, and Y. Ma, “Research on Web Application of Struts Framework based on MVC pattern,” in International Workshop on Web-Based Internet Computing for Science and Engineering, 2006, pp. 1029–1032.
[3] Armando Padilla, “Beginning Zend Framework,” New York, 2009, pp. 55.
[4] Karam M, Keirouz W, and Hage R, “An abstract Model for Testing MVC and Workflow Based Web Applications,” in International Conference on Telecommunications and International Conference on Internet and Web Applications, Guadeloupe, 2006, pp. 206–212.
[5] W. Cui, L. Huang, L. Liang, and J. Li, “The Research of PHP Development Framework Based on MVC Pattern,” in Fourth International Conference on Computer Sciences and Convergence Information Technology, Seoul, Korea, 2009, pp. 947–949.
[6] A. Mitrovic, “A Knowledge-Based Teaching System for SQL,” in World Conference on Educational Multimedia Hypermedia and Telecommunications, 1998, pp. 1027–1032.
[7] S. Sadiq, M. Orlowska, W Sadiq, and J. Lin, “SQLator – An Online SQL Learning Workbench,” in Proceedings of the 9th annual SIGCSE Conference on Innovation and Technology in Computer Science Education, 2004, Leeds, UK, pp. 223–227.
[8] G. Russel, and A. Cumming, “Improving the student learning experience for SQL using automatic marking,” in IADIS International Conference Cognition and Exploratory Learning in Digital Age, 2004, Lisbon, Portugal, pp. 281–288.
[9] PhpMyAdmin, On-line. Available from Internet, http://www.phpmyadmin.net, accessed 2 June 2014.
[10] SQLyog, On-line. Available from Internet, http://www.webyog.com, accessed 2 June 2014.
[11] Navicat, On-line. Available from Internet, http://www.navicat.com, accessed 2 June 2014.
[12] N. Rishel, K.Naboulsi, O. Wolfson, and B. Ehlmann, “An Efficient Web-based Semantic SQL Query Generator,” in Proceedings 19th IEEE International Conference on Distributed Computing Systems, 1999, Texas, U.S.A., pp. 23–30.
[13] Z. Yanqiu, and C. Chuan, “Designing JSP/Servlet+EJB Web Applications Based on MVC Design Mode,” in Computer Engineering, 2001, pp. 71–73.
[14] Timothy C, and Robert L, “Object-Oriented Software Engineering,” McGraw-Hill, 2005.