EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

An SQL Query Description Problem with AI Assistance for an SQL Programming Learning Assistant System

Ni Wayan Wardani, Nobuo Funabiki, Htoo Htoo Sandi Kyaw, Zihao Zhu, I Nyoman Darma Kotama, Putu Sugiartawan, I Nyoman Agus Suarya Putra

Information · 09.01.2026 · 17 (1) · 65

DOI: 10.3390/info17010065 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Information, online erschienen am 09.01.2026. Verfasst von Ni Wayan Wardani und 6 weiteren Autor:innen. Die Arbeit wurde bisher 2-mal zitiert (Crossref) und nennt 44 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Today, relational databases are widely used in information systems. SQL (structured query language) is taught extensively in universities and professional schools across the globe as a programming language for its data management and accesses. Previously, we have studied a web-based programming learning assistant system (PLAS) to help novice students learn popular programming languages by themselves through solving various types of exercises. For SQL programming, we have implemented the grammar-concept understanding problem (GUP) and the comment insertion problem (CIP) for its initial studies. In this paper, we propose an SQL Query Description Problem (SDP) as a new exercise type for describing the SQL query to a specified request in a MySQL database system. To reduce teachers’ preparation workloads, we integrate a generative AI-assisted SQL query generator to automatically generate a new SDP instance with a given dataset. An SDP instance consists of a table, a set of questions and corresponding queries. Answer correctness is determined by enhanced string matching against an answer module that includes multiple semantically equivalent canonical queries. For evaluation, we generated 11 SDP instances on basic topics using the generator, where we found that Gemini 3.0 Pro exhibited higher pedagogical consistency compared to ChatGPT-5.0, achieving perfect scores in Sensibleness, Topicality, and Readiness metrics. Then, we assigned the generated instances to 32 undergraduate students at the Indonesian Institute of Business and Technology (INSTIKI). The results showed an average correct answer rate of 95.2% and a mean SUS score of 78, which demonstrates strong initial student performance and system acceptance.

Zitieren

APA

Wardani, N. W., Funabiki, N., Kyaw, H. H. S., Zhu, Z., Kotama, I. N. D., Sugiartawan, P., & Putra, I. N. A. S. (2026). An SQL Query Description Problem with AI Assistance for an SQL Programming Learning Assistant System. Information, 17(1), 65. https://doi.org/10.3390/info17010065

Vancouver

Wardani NW, Funabiki N, Kyaw HHS, Zhu Z, Kotama IND, Sugiartawan P, et al. An SQL Query Description Problem with AI Assistance for an SQL Programming Learning Assistant System. Information. 2026;17(1):65. doi:10.3390/info17010065

BibTeX
@article{Wardani2026,
  author = {Wardani, Ni Wayan and Funabiki, Nobuo and Kyaw, Htoo Htoo Sandi and Zhu, Zihao and Kotama, I Nyoman Darma and Sugiartawan, Putu and Putra, I Nyoman Agus Suarya},
  title = {An SQL Query Description Problem with AI Assistance for an SQL Programming Learning Assistant System},
  journal = {Information},
  year = {2026},
  volume = {17},
  number = {1},
  pages = {65},
  doi = {10.3390/info17010065}
}
Kostenlos starten →