Investigation of SQL Clone on MVC-based Application

Fawwaz Ali Akbar, Siti Rochimah, Rizky Januar Akbar

Abstract


Model-View-Controller (MVC) design pattern is design pattern that is suitable for interactive systems. MVC is adapted in desktop and web-based applications. Moreover, many frameworks are adapting MVC pattern. Each layer of MVC has a different function. The main function of the model layer is query to the database system that represented by SQL language. In software development, code duplication or code clone is a serious problem because it will impact on the maintenance process. Associated with model layer and code clone, clone detection approach that exists today is not effective to detect clones in the model layer represented by SQL language, because the definition of code clone is not suitable for SQL clone.  SQL is declarative language that is different from the common programming language like C and Java. So, the definition of code clone must be adjusted with characteristic of SQL. In this research, we investigate the existence of SQL clone on MVC-based application and define the types of SQL clone. We define four types of SQL clone and they are confirmed exist in MVC-based application datasets that used in this research

Keywords


Clone Detection; Model Layer; Model-View-Controller; SQL Clone

Full Text:

PDF

References


A. Leff and J. T. Rayfield, “Web-application development using the Model/View/Controller design pattern,” in Proceedings Fifth IEEE International Enterprise Distributed Object Computing Conference, pp. 118–127.

F. Buschmann, K. Henney, and D. C. Schmidt, Pattern-oriented software architecture. v. 4, A pattern language for distributed computing. West Sussex: John Wiley & Sons, 2007.

D. Rattan, R. Bhatia, and M. Singh, “Software clone detection: A systematic review,” Inf. Softw. Technol., vol. 55, no. 7, pp. 1165–1199, Jul. 2013.

D. C. Rajapakse and S. Jarzabek, “An investigation of cloning in web applications,” in Special interest tracks and posters of the 14th international conference on World Wide Web - WWW ’05, 2005, p. 924.

A. Leff and J. T. Rayfield, “Web-Application Development Using the Model/View/Controller Design Pattern,” in Enterprise Distributed Object Computing Conference, 2001, pp. 118–127.

F. Buschmann, K. Henney, and D. C. Schmidt, PATTERN-ORIENTED SOFTWARE ARCHITECTURE, 4th ed. West Sussex: John Wiley & Sons, Ltd, 2007.

R. Morales-Chaparro, M. Linaje, J. C. Preciado, and F. Sánchez-Figueroa, “MVC web design patterns and rich internet applications,” in Proceedings of the Jornadas de Ingenierıa del Software y Bases de Datos, 2007, pp. 39–46.

D. Rattan, R. Bhatia, and M. Singh, Software clone detection: A systematic review, vol. 55, no. 7. Elsevier B.V., 2013.

D. Chatterji, J. C. Carver, and N. A. Kraft, “Claims and beliefs about code clones: Do we agree as a community? A survey,” in 2012 6th International Workshop on Software Clones (IWSC), 2012, pp. 15–21.

A. Beaulieu, Learning SQL, 2nd Edition. O’Reilly Media, 2009.

H. Störrle, “Towards clone detection in UML domain models,” Softw. Syst. Model., vol. 12, no. 2, pp. 307–329, May 2013.

J. Tuya, M. J. Suárez-cabal, and C. De Riva, “SQLMutation : A tool

to generate mutants of SQL database queries,” 2006.

M. Eirinaki, S. Abraham, N. Polyzotis, and N. Shaikh, “QueRIE: Collaborative Database Exploration,” IEEE Trans. Knowl. Data Eng., vol. 26, no. 7, pp. 1778–1790, Jul. 2014.

M. Stephan, “Model Clone Detector Evaluation Using Mutation Analysis,” in 2014 IEEE International Conference on Software Maintenance and Evolution, 2014, pp. 633–638.

J. Tuya, M. J. Suarez-Cabal, and C. de la Riva, “SQLMutation: A tool to generate mutants of SQL database queries,” in Second Workshop on Mutation Analysis (Mutation 2006 - ISSRE Workshops 2006), 2006, pp. 1–1.




DOI: http://dx.doi.org/10.12962/j23546026.y2018i1.3511

Refbacks

  • There are currently no refbacks.


View my Stat: Click Here

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.