research-article

Meet cyrus: the query by voice mobile assistant for the tutoring and formative assessment of SQL learners

Authors:

Josue Espinosa Godinez,

Hasan M. JamilAuthors Info & Claims

SAC '19: Proceedings of the 34th ACM/SIGAPP Symposium on Applied Computing

Pages 2461 - 2468

https://doi.org/10.1145/3297280.3297523

Published: 08 April 2019 Publication History

Abstract

Being declarative, SQL stands a better chance at being the programming language for conceptual computing next to natural language programming. We examine the possibility of using SQL as a back-end for natural language database programming. Distinctly from keyword based SQL querying, keyword dependence and SQL's table structure constraints are significantly less pronounced in our approach. We present a mobile device voice query interface, called Cyrus, to arbitrary relational databases. Cyrus supports a large type of query classes, sufficient for an entry level database class. Cyrus is also application independent, allows test database adaptation, and not limited to specific sets of keywords or natural language sentence structures. It's cooperative error reporting is more intuitive, and iOS based mobile platform is also more accessible compared to most contemporary mobile and voice enabled systems.

References

[1]

2016. English Stop Words List - Github. https://tinyurl.com/y86xbn9e. Accessed: January 18, 2018.

[2]

Alireza Ahadi, Julia Coleman Prior, Vahid Behbood, and Raymond Lister. 2015. A Quantitative Study of the Relative Difficulty for Novices of Writing Seven Different Types of SQL Queries. In Proceedings of the ACM Conference on Innovation and Technology in Computer Science Education, Vilnius, Lithuania, July 4-8, 2015. 201--206.

Digital Library

[3]

Peter Brusilovsky, Sergey A. Sosnovsky, Michael Yudelson, Danielle H. Lee, Vladimir Zadorozhny, and Xin Zhou. 2010. Learning SQL Programming with Interactive Tools: From Integration to Personalization. TOCE 9, 4 (2010), 1--9:119:15.

Digital Library

[4]

Chih-Ming Chen and Ming-Chuan Chen. 2009. Mobile formative assessment tool based on data mining techniques for supporting web-based learning. Computers & Education 52, 1 (2009), 256--273.

Digital Library

[5]

Begum Genc, Mohamed Siala, Barry O'Sullivan, and Gilles Simonin. 2017. Finding Robust Solutions to Stable Marriage. In Proceedings of the Twenty-Sixth International Joint Conference on Artificial Intelligence, IJCAI 2017, Melbourne, Australia, August 19-25, 2017. 631--637.

Digital Library

[6]

Carsten Kleiner, Christopher Tebbe, and Felix Heine. 2013. Automated grading and tutoring of SQL statements to improve student learning. In 13th Koli Calling International Conference on Computing Education Research, Koli, Finland, November 14-17, 2013. 161--168.

Digital Library

[7]

Sachin Kumar, Ashish Kumar, Pinaki Mitra, and Girish Sundaram. 2013. System and Methods for Converting Speech to SQL. CoRR abs/1308.3106 (2013). arXiv:1308.3106 http://arxiv.org/abs/1308.3106

[8]

Dejan Lavbic, Tadej Matek, and Aljaz Zrnec. 2017. Recommender system for learning SQL using hints. Interactive Learning Environments 25, 8 (2017), 1048--1064.

[9]

Fei Li and H. V. Jagadish. 2016. Understanding Natural Language Queries over Relational Databases. SIGMOD Record 45, 1 (2016), 6--13.

Digital Library

[10]

Gabriel Lyons, Vinh Tran, Carsten Binnig, Ugur Çetintemel, and Tim Kraska. 2016. Making the Case for Query-by-Voice with EchoQuery. In Proceedings of the 2016 International Conference on Management of Data, SIGMOD Conference 2016, San Francisco, CA, USA, June 26 - July 01, 2016. 2129--2132.

Digital Library

[11]

Antonija Mitrovic and Stellan Ohlsson. 2016. Implementing CBM: SQL-Tutor After Fifteen Years. I. J. Artificial Intelligence in Education 26, 1 (2016), 150--159.

[12]

Julia R. Prior. 2014. AsseSQL: an online, browser-based SQL skills assessment tool. In Innovation and Technology in Computer Science Education Conference Uppsala, Sweden, June 23-25, 2014. 327.

Digital Library

[13]

Arsénio Reis, Dennis Paulino, Hugo Paredes, and João Barroso. 2017. Using Intelligent Personal Assistants to Strengthen the Elderlies' Social Bonds - A Preliminary Evaluation of Amazon Alexa, Google Assistant, Microsoft Cortana, and Apple Siri. In Universal Access in Human-Computer Interaction. Human and Technological Environments - 11th International Conference, Held as Part of HCI International 2017, Vancouver, BC, Canada, July 9-14, 2017, Proceedings, Part III. 593--602.

[14]

Tia Shelley, Chandan Dasgupta, Alexandra Silva, Leilah Lyons, and Tom Moher. 2015. PhotoMAT: A Mobile Tool for Aiding in Student Construction of Research Questions and Data Analysis. Technology, Knowledge and Learning 20, 1 (2015), 85--92.

[15]

Zhong Zeng, Mong-Li Lee, and Tok Wang Ling. 2016. Answering Keyword Queries involving Aggregates and GROUPBY on Relational Databases. In Proceedings of the 19th International Conference on Extending Database Technology, EDBT 2016, Bordeaux, France, March 15-16, 2016, Bordeaux, France, March 15-16, 2016. 161--172.

Cited By

Jamil HNaha K(2022)Mapping Declarative Queries to Heterogeneous Biological Databases using Schema Graphs for Intelligent Responses2022 IEEE Intl Conf on Parallel & Distributed Processing with Applications, Big Data & Cloud Computing, Sustainable Computing & Communications, Social Computing & Networking (ISPA/BDCloud/SocialCom/SustainCom)10.1109/ISPA-BDCloud-SocialCom-SustainCom57177.2022.00026(147-154)Online publication date: Dec-2022
https://doi.org/10.1109/ISPA-BDCloud-SocialCom-SustainCom57177.2022.00026
Karimzadeh MJamil H(2022)ViSQL: An Intelligent Online SQL Tutoring System2022 International Conference on Advanced Learning Technologies (ICALT)10.1109/ICALT55010.2022.00069(212-213)Online publication date: Jul-2022
https://doi.org/10.1109/ICALT55010.2022.00069
Kulik ATrofymova IChukhray AStoliarenko TYevdokymov O(2022)Relevant Objectives of Developing SQL Adaptive Learning Technology2022 12th International Conference on Dependable Systems, Services and Technologies (DESSERT)10.1109/DESSERT58054.2022.10018757(1-7)Online publication date: 9-Dec-2022
https://doi.org/10.1109/DESSERT58054.2022.10018757
Show More Cited By

Index Terms

Meet cyrus: the query by voice mobile assistant for the tutoring and formative assessment of SQL learners

Recommendations

Superviews: Virtual Integration of Multiple Databases

An important advantage of a database system is that it provides each application with a custom view of the data. The issue addressed in this paper is how to provide such custom views to applications that access multiple databases. The paper describes a ...
Augmenting the Use of Mobile Devices in Language Classrooms

Do students use varied types of technological devices for enhancing learning? If not, how can educators motivate students to use them within or outside the classroom? How can teachers facilitate mobile learning in a traditional classroom? With the ...
Minimal data sets vs. synchronized data copies in a schema and data versioning system
PIKM '11: Proceedings of the 4th workshop on Workshop for Ph.D. students in information & knowledge management

In this paper, we describe a key component of our proposed data-base schema and data versioning system, ScaDaVer. The versioning system is based on common practices used to manage source code changes in software development. It allows users of a data-...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SAC '19: Proceedings of the 34th ACM/SIGAPP Symposium on Applied Computing

April 2019

2682 pages

ISBN:9781450359337

DOI:10.1145/3297280

Conference Chairs:
Chih-Cheng Hung
Kennesaw State University, Marietta, Georgia
,
George A. Papadopoulos
University of Cyprus, Nicosia, Cyprus

Copyright © 2019 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 the author(s) 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].

Sponsors

SIGAPP: ACM Special Interest Group on Applied Computing

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 08 April 2019

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

SAC '19

Sponsor:

SIGAPP

SAC '19: The 34th ACM/SIGAPP Symposium on Applied Computing

April 8 - 12, 2019

Limassol, Cyprus

Upcoming Conference

SAC '25

Sponsor:
sigapp

The 40th ACM/SIGAPP Symposium on Applied Computing

March 31 - April 4, 2025

Catania , Italy

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

6
Total Citations
View Citations
99
Total Downloads

Downloads (Last 12 months)7
Downloads (Last 6 weeks)0

Reflects downloads up to 05 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Jamil HNaha K(2022)Mapping Declarative Queries to Heterogeneous Biological Databases using Schema Graphs for Intelligent Responses2022 IEEE Intl Conf on Parallel & Distributed Processing with Applications, Big Data & Cloud Computing, Sustainable Computing & Communications, Social Computing & Networking (ISPA/BDCloud/SocialCom/SustainCom)10.1109/ISPA-BDCloud-SocialCom-SustainCom57177.2022.00026(147-154)Online publication date: Dec-2022
https://doi.org/10.1109/ISPA-BDCloud-SocialCom-SustainCom57177.2022.00026
Karimzadeh MJamil H(2022)ViSQL: An Intelligent Online SQL Tutoring System2022 International Conference on Advanced Learning Technologies (ICALT)10.1109/ICALT55010.2022.00069(212-213)Online publication date: Jul-2022
https://doi.org/10.1109/ICALT55010.2022.00069
Kulik ATrofymova IChukhray AStoliarenko TYevdokymov O(2022)Relevant Objectives of Developing SQL Adaptive Learning Technology2022 12th International Conference on Dependable Systems, Services and Technologies (DESSERT)10.1109/DESSERT58054.2022.10018757(1-7)Online publication date: 9-Dec-2022
https://doi.org/10.1109/DESSERT58054.2022.10018757
Franciscatto MDel Fabro MTrois CDe Bona LCabot JGoncalves L(2022)Talk to Your Data: a Chatbot System for Multidimensional Datasets2022 IEEE 46th Annual Computers, Software, and Applications Conference (COMPSAC)10.1109/COMPSAC54236.2022.00092(486-495)Online publication date: Jun-2022
https://doi.org/10.1109/COMPSAC54236.2022.00092
Bogdan RTatu ACrisan-Vida MPopa MStoicu-Tivadar L(2021)A Practical Experience on the Amazon Alexa Integration in Smart OfficesSensors10.3390/s2103073421:3(734)Online publication date: 22-Jan-2021
https://doi.org/10.3390/s21030734
Jamil H(2021)Architecture of an Intelligent Personal Health Library for Improved Health Outcomes2021 IEEE International Conference on Digital Health (ICDH)10.1109/ICDH52753.2021.00012(1-10)Online publication date: Sep-2021
https://doi.org/10.1109/ICDH52753.2021.00012

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten