SQL Logic Error Detection by Using Start End Mid Algorithm

Jevri Tri Ardiansah; Aji Prasetya Wibawa; Triyanna Widyaningtyas; Okazaki Yasuhisa

doi:10.17977/um018v1i12018p33-38

SQL Logic Error Detection by Using Start End Mid Algorithm

Jevri Tri Ardiansah, Aji Prasetya Wibawa, Triyanna Widyaningtyas, Okazaki Yasuhisa

Abstract

Data base is an important part of a system and it stores data to be manipulated. A language called SQL (Structured Query Language) is used for manipulating those data to make needed information. There are two types of error which make SQL more difficult in practical implementation. They are syntax error and logic error. The difference between them is that syntax error can be detected by compiler so it is easy to learn by its warning. But compiler does not show error warning if logical error was occurred. It makes logic error is more difficult to understand than syntax error. To help data base's user to learn SQL in practical implementation, web based SQL compiler that be able to detect syntax and logic error is developed by using Start End Mid algorithm.

Full Text:

PDF

References

R. Dollinger, “SQL Lightweight Tutoring Module–Semantic Analysis of SQL Queries based on XML Representation and LINQ,” in EdMedia: World Conference on Educational Media and Technology, 2010. online

S. Brass and C. Goldberg, “Semantic errors in SQL queries: A quite complete list,” J. Syst. Softw., vol. 79, no. 5, pp. 630–634, 2006. crossref

A. Ahadi, V. Behbood, A. Vihavainen, J. Prior, and R. Lister, “Students’ Syntactic Mistakes in Writing Seven Different Types of SQL Queries and its Application to Predicting Students’ Success,” Proc. 47th ACM Tech. Symp. Comput. Sci. Educ. - SIGCSE ’16, pp. 401–406, 2016. crossref

A. Fanani, “Pengembangan Sumber Belajar SQL Berbasis Web untuk Matakuliah Basis Data Prodi S1 Pendidikan Teknik Informatika Universitas Negeri Malang,” Universitas Negeri Malang, 2014. crossref

E. P. Costa, A. C. Lorena, A. C. P. L. F. Carvalho, and A. A. Freitas, “A Review of Performance Evaluation Measures for Hierarchical Classifiers,” in AAAI-2007 Workshop, AAAI Technical Report WS-07-05, 2007. online

C. Goldberg, “Do You Know Sql? About Semantic Errors in Database Queries,” in 7th Workshop on Teaching, Learning and Assessment in Databases, 2009. online

J. Ardiansah, O. Yasuhisa, and T. Wibawa, Aji Prasetya Widyaningtyas, “Development and Trial Use of a Web-based Database Learning System,” in JAiSE (Japanese Society for Information and System in Education), 2017.

T. Lecroq, “Experimental results on string matching algorithms,” Softw. Pract. Exp., vol. 25, no. 7, pp. 727–765, 1995. crossref

O. Masanori, T. Ryo, and S. Tadamasa, “An Evaluation of String Search Algorithms at User Standing,” in Proceedings of the 3rd WSES International Conference on Mathematics and Computers in Mechanical Engineering (MCME), 2001, pp. 4231–4236. online

T. H. Cormen, C. E. Leiserson, R. L. Rivest, and S. Clifford, Introduction to Algorithms 3rd edition. MIT Press, 2009. crossref

R. A. Abdeen, “An Algorithm for String Searching Based on Brute-force Algorithm,” IJCSNS Int. J. Comput. Sci. Netw. Secur., vol. 11, no. 7, pp. 24–27, 2011. online

B. W. Watson and R. E. Watson, “A Boyer–Moore-style algorithm for regular expression pattern matching,” Sci. Comput. Program., vol. 48, no. 2–3, pp. 99–117. crossref

M. T. Goodrich and R. Tamassia, Algorithm design. Wiley, 2002.

L. I. Zhulin, “A Method for Data Structure Course Design Based on CDIO Teaching Idea 2 The Course Design Based on CDIO Model,” pp. 418–421.

J. Ardiansah, O. Yasuhisa, and T. Wibawa, Aji Prasetya Widyaningtyas, “Developing of a Web-based Database Learning Support System for Practical Implementation of SQL,” IEICE (Institute Electron. Inf. Commun. Eng. Tech. Rep., vol. 116, no. 266, pp. 57–62, 2016.

T. Saito and M. Rehmsmeier, “The precision-recall plot is more informative than the ROC plot when evaluating binary classifiers on imbalanced datasets,” PLoS One, vol. 10, no. 3, 2015. crossref

T. Fawcett, “An introduction to ROC analysis,” Pattern Recognit. Lett., vol. 27, no. 8, pp. 861–874, 2006. crossref

DOI: http://dx.doi.org/10.17977/um018v1i12018p33-38