SQL Logic Error Detection by Using Start End Mid Algorithm

• Main Authors: Jevri Tri Ardiansah, Aji Prasetya Wibawa, Triyanna Widyaningtyas, Okazaki Yasuhisa
• Format: Article
• Language: English
• Published: Universitas Negeri Malang 2017-12-01
• Series: Knowledge Engineering and Data Science
• Online Access: http://journal2.um.ac.id/index.php/keds/article/view/1376

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.