SQL Logic Error Detection by Using Start End Mid Algorithm

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 e...

Full description

Bibliographic Details
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
Description
Summary: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.
ISSN:2597-4602
2597-4637