sql查询语法错误的自动校正

Shunsuke Otawa, Kento Goto, Motomichi Toyama
{"title":"sql查询语法错误的自动校正","authors":"Shunsuke Otawa, Kento Goto, Motomichi Toyama","doi":"10.1145/3428757.3429131","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":212557,"journal":{"name":"Proceedings of the 22nd International Conference on Information Integration and Web-based Applications & Services","volume":"71 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2020-11-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Automatic Correction of Syntax Errors in SuperSQL Queries\",\"authors\":\"Shunsuke Otawa, Kento Goto, Motomichi Toyama\",\"doi\":\"10.1145/3428757.3429131\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":212557,\"journal\":{\"name\":\"Proceedings of the 22nd International Conference on Information Integration and Web-based Applications & Services\",\"volume\":\"71 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2020-11-30\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings of the 22nd International Conference on Information Integration and Web-based Applications & Services\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/3428757.3429131\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 22nd International Conference on Information Integration and Web-based Applications & Services","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3428757.3429131","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 1

摘要

SuperSQL是SQL的扩展语言。通过结构化关系数据库的输出,SuperSQL使用户能够生成具有SQL中没有表示的各种布局的各种类型的结构化文档。有一个问题是,SuperSQL查询越大、越复杂,检测错误就越困难,调试所需的时间也就越多。在这项研究中,我们提出了一个自动检测和纠正用户查询中的语法错误的系统。当查询解析失败时,系统重新分析查询并使用深度学习预测更正。为了修改查询,我们使用了递归神经网络和注意机制。通过将预测的修改结果呈现给用户,可以减少调试的负担,提高用户的工作效率。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
Automatic Correction of Syntax Errors in SuperSQL Queries
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.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
自引率
0.00%
发文量
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信