Knowledge Engineering and Data Science
Vol 1, No 1 (2018)

SQL Logic Error Detection by Using Start End Mid Algorithm

Jevri Tri Ardiansah (Universitas Negeri Malang)
Aji Prasetya Wibawa (Universitas Negeri Malang)
Triyanna Widyaningtyas (Universitas Negeri Malang)
Okazaki Yasuhisa (Unknown)



Article Info

Publish Date
31 Dec 2017

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.

Copyrights © 2018






Journal Info

Abbrev

keds

Publisher

Subject

Computer Science & IT Engineering

Description

Knowledge Engineering and Data Science (2597-4637), KEDS, brings together researchers, industry practitioners, and potential users, to promote collaborations, exchange ideas and practices, discuss new opportunities, and investigate analytics frameworks on data-driven and knowledge base systems. ...