SQL Logic Error Detection using Start End Mid Algorithm

Authors

Jevri Tri Ardiansyah, State University of Malang, IndonesiaFollow
Aji Prasetya Wibawa, State University of Malang, IndonesiaFollow
Triyanna Widiyaningtyas, State University of Malang, IndonesiaFollow
Okazaki Yasuhisa, Saga University, JapanFollow

Abstract

Database is an important part of a system and it stores data to be manipulated. SQL (Structured Query Language) is used for manipulating those data to extract information and make decision. There are two types of error which make SQL is challenging to learn, namely syntax error and logic error. Compiler can detect syntax error, but it does not show error warning while logical error occurred. It makes logic error more difficult to understand than syntax error. A web based SQL compiler with errors detection ability by using Start End Mid algorithm is then developed, To help database's user to learn SQL in practical implementation.

DOI

10.17977/um018v1i12017p33-38

Recommended Citation

Ardiansyah, Jevri Tri; Wibawa, Aji Prasetya; Widiyaningtyas, Triyanna; and Yasuhisa, Okazaki (2018) "SQL Logic Error Detection using Start End Mid Algorithm," Knowledge Engineering and Data Science: Vol. 1: No. 1, Article 5.
DOI: 10.17977/um018v1i12017p33-38
Available at: https://citeus.um.ac.id/keds/vol1/iss1/5