Cited By
View all- Taipalus TGrahn H(2023)Framework for SQL Error Message Design: A Data-Driven ApproachACM Transactions on Software Engineering and Methodology10.1145/360718033:1(1-50)Online publication date: 23-Nov-2023
Automatic Correction of Syntax Errors in SuperSQL Queries
Pages 28 - 33
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.
References
[1]
[n.d.]. log4j. https://logging.apache.org/log4j/
[2]
[n.d.]. SuperSQL. http://ssql.db.ics.keio.ac.jp
[3]
[n.d.]. TensorFlow. https://www.tensorflow.org/
[4]
Umair Z. Ahmed, Pawan Kumar, Amey Karkare, Purushottam Kar, and Sumit Gulwani. 2018. Compilation error repair: for the student programs, from the student programs. In Proceedings of the 40th International Conference on Software Engineering: Software Engineering Education and Training, ICSE (SEET) 2018, Gothenburg, Sweden, May 27 - June 03, 2018, Patricia Lago and Michal Young (Eds.). ACM, 78--87. https://doi.org/10.1145/3183377.3183383
[5]
Dzmitry Bahdanau, Kyunghyun Cho, and Yoshua Bengio. 2014. Neural Machine Translation by Jointly Learning to Align and Translate. arXiv:cs.CL/1409.0473
[6]
Tatsuki Fujimoto, Kento Goto, and Motomichi Toyama. 2018. 3D Visualization of data using SuperSQL and Unity. In Proceedings of the 22nd International Database Engineering & Applications Symposium, IDEAS 2018, Villa San Giovanni, Italy, June 18-20, 2018, Bipin C. Desai, Sergio Flesca, Ester Zumpano, Elio Masciari, and Luciano Caroprese (Eds.). ACM, 141--147.
[7]
Xavier Glorot and Yoshua Bengio. 2010. Understanding the difficulty of training deep feedforward neural networks. In Proceedings of the Thirteenth International Conference on Artificial Intelligence and Statistics, AISTATS 2010, Chia Laguna Resort, Sardinia, Italy, May 13-15, 2010 (JMLR Proceedings), Yee Whye Teh and D. Mike Titterington (Eds.), Vol. 9. JMLR.org, 249--256.
[8]
Rahul Gupta, Soham Pal, Aditya Kanade, and Shirish K. Shevade. 2017. DeepFix: Fixing Common C Language Errors by Deep Learning. In Proceedings of the Thirty-First AAAI Conference on Artificial Intelligence, February 4-9, 2017, San Francisco, California, USA, Satinder P. Singh and Shaul Markovitch (Eds.). AAAI Press, 1345--1351. http://aaai.org/ocs/index.php/AAAI/AAAI17/paper/view/14603
[9]
Diederik P. Kingma and Jimmy Ba. 2015. Adam: A Method for Stochastic Optimization. In 3rd International Conference on Learning Representations, ICLR 2015, San Diego, CA, USA, May 7-9, 2015, Conference Track Proceedings, Yoshua Bengio and Yann LeCun (Eds.).
[10]
Thang Luong, Hieu Pham, and Christopher D. Manning. 2015. Effective Approaches to Attention-based Neural Machine Translation. In Proceedings of the 2015 Conference on Empirical Methods in Natural Language Processing. Association for Computational Linguistics, Lisbon, Portugal, 1412--1421. https://doi.org/10.18653/v1/D15-1166
[11]
Shunsuke Otawa, Kento Goto, and Motomichi Toyama. 2019. Two-Dimensional Visualization of Structured Data with SuperSQL. In DEIM' 19 The 11th Forum on Data Engineering and Information Management.
[12]
Ilya Sutskever, Oriol Vinyals, and Quoc V Le. 2014. Sequence to Sequence Learning with Neural Networks. In Advances in Neural Information Processing Systems 27, Z. Ghahramani, M. Welling, C. Cortes, N. D. Lawrence, and K. Q. Weinberger (Eds.). Curran Associates, Inc., 3104--3112.
[13]
Motomichi Toyama. 1998. SuperSQL: An Extended SQL for Database Publishing and Presentation. In SIGMOD 1998, Proceedings ACM SIGMOD International Conference on Management of Data, June 2-4, 1998, Seattle, Washington, USA, Laura M. Haas and Ashutosh Tiwary (Eds.). ACM Press, 584--586.
Index Terms
- Automatic Correction of Syntax Errors in SuperSQL Queries
Recommendations
Generating 3D virtual museum using superSQL
iiWAS '17: Proceedings of the 19th International Conference on Information Integration and Web-based Applications & ServicesVirtual Reality is gaining traction as a medium. But generating virtual reality scenes is still a challenge as manipulating and arranging 3D objects is a complex task requiring the mastery of specialized tools. SuperSQL is an extension of the SQL query ...
Supporting Tools for Creating SuperSQL Queries
IDEAS '15: Proceedings of the 19th International Database Engineering & Applications SymposiumThis paper introduces a pair of query editors for SuperSQL: SSedit and SSvisual. SSedit is a structured editor specialized for SuperSQL, which is mainly used to create a query statement from scratch. SSvisual is a WYSIWYG editor, which is mainly used to ...
Comments
Information & Contributors
Information
Published In
November 2020
492 pages
ISBN:9781450389228
DOI:10.1145/3428757
Copyright © 2020 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]
In-Cooperation
- Johannes Kepler University, Linz, Austria
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 27 January 2021
Check for updates
Author Tags
Qualifiers
- Short-paper
- Research
- Refereed limited
Conference
iiWAS '20
iiWAS '20: The 22nd International Conference on Information Integration and Web-based Applications & Services
November 30 - December 2, 2020
Chiang Mai, Thailand
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- View Citations1Total Citations
- 44Total Downloads
- Downloads (Last 12 months)5
- Downloads (Last 6 weeks)0
Reflects downloads up to 27 Jul 2024
Other Metrics
Citations
Cited By
View all- Taipalus TGrahn H(2023)Framework for SQL Error Message Design: A Data-Driven ApproachACM Transactions on Software Engineering and Methodology10.1145/360718033:1(1-50)Online publication date: 23-Nov-2023
View Options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in