TY - GEN
T1 - Automatic Correction of Syntax Errors in SuperSQL Queries
AU - Otawa, Shunsuke
AU - Goto, Kento
AU - Toyama, Motomichi
N1 - Publisher Copyright:
© 2020 ACM.
PY - 2020/11/30
Y1 - 2020/11/30
N2 - SuperSQL is an extended language of SQL. By structuring the output of relational databases, SuperSQL enables the user to generate various types of structured documents with various layouts which are not represented in SQL. There is a problem that the larger and more complicated the SuperSQL query is, the more difficult it is to detect errors and the more time is spent on debugging. In this study, we propose a system that automatically detects and corrects syntax errors in user queries. When a query parsing fails, the system reanalyzes the query and predicts a correction by using deep learning. To modify the query, we use recurrent neural network and attention mechanism. By presenting the predicted modifications to users, the burden of debugging can be reduced and the efficiency of user's work can be improved.
AB - SuperSQL is an extended language of SQL. By structuring the output of relational databases, SuperSQL enables the user to generate various types of structured documents with various layouts which are not represented in SQL. There is a problem that the larger and more complicated the SuperSQL query is, the more difficult it is to detect errors and the more time is spent on debugging. In this study, we propose a system that automatically detects and corrects syntax errors in user queries. When a query parsing fails, the system reanalyzes the query and predicts a correction by using deep learning. To modify the query, we use recurrent neural network and attention mechanism. By presenting the predicted modifications to users, the burden of debugging can be reduced and the efficiency of user's work can be improved.
KW - Automatic Error Correction
KW - Deep Learning
KW - SuperSQL
UR - http://www.scopus.com/inward/record.url?scp=85100343267&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=85100343267&partnerID=8YFLogxK
U2 - 10.1145/3428757.3429131
DO - 10.1145/3428757.3429131
M3 - Conference contribution
AN - SCOPUS:85100343267
T3 - ACM International Conference Proceeding Series
SP - 28
EP - 33
BT - 22nd International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2020 - Proceedings
A2 - Indrawan-Santiago, Maria
A2 - Pardede, Eric
A2 - Salvadori, Ivan Luiz
A2 - Steinbauer, Matthias
A2 - Khalil, Ismail
A2 - Kotsis, Gabriele
PB - Association for Computing Machinery
T2 - 22nd International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2020
Y2 - 30 November 2020 through 2 December 2020
ER -