Search Results - Automated SQL Query Generation

Automated SQL Query Generation for an Intelligent Sewer Management System Using Large Language Models by Chitte, Dharmendra Reddy, Liang, Fei, Sheng, Weihua, Shan, Yongwei, Khaleghian, Hossein

“… This paper investigates automated SQL query generation from natural language, a critical step in developing an intelligent sewer management system…”
Get full text

A new method of automatic generation of SQL queries for automated text analizing by Kulynsky, O., Polishchuk, U., Yurchak, I.

“…In this article is discussed the basis for a new concept of automatic generation of SQL queries to different databases, adapted for the problems of automated text information analysis…”
Get full text

Information Integration in Social Science Research: Advances with LLMs in the NAIP Project by Pu, Calton, Agarwal, Anmol, Chen, Tianyu, Faulk, Lewis

“…s. This paper describes recent advances and experiences using Large Language Models (LLMs) to facilitate data cleaning, modeling, and automated SQL query generation on NAIP datasets…”
Get full text

Search-based test data generation for SQL queries by Castelein, Jeroen, Aniche, Maurício, Soltani, Mozhan, Panichella, Annibale, van Deursen, Arie

“…Database-centric systems strongly rely on SQL queries to manage and manipulate their data…”
Get full text

On automated prepared statement generation to remove SQL injection vulnerabilities by Thomas, Stephen, Williams, Laurie, Xie, Tao

“… We created a prepared statement replacement algorithm and a corresponding tool for automated fix generation…”
Get full text

Student Outcome Assessment on Structured Query Language using Rubrics and Automated Feedback Generation by Nayak, Sidhidatri, Agarwal, Reshu, Khatri, Sunil Kumar, Mohammadian, Masoud

“…Automated assessment of student assignment based on SQL(Structured Query Language…”
Get full text

Reverse SQL Question Generation Algorithm in the DBLearn Adaptive E-Learning System by Atchariyachanvanich, Kanokwan, Nalintippayawong, Srinual, Julavanich, Thanakrit

“…Using a traditional e-learning system, when teaching structured query language (SQL) queries in classical classrooms help instructors, to improve the students' SQL skills and learning effectiveness…”
Get full text

Context-Aware SQL Error Correction Using Few-Shot Learning -- A Novel Approach Based on NLQ, Error, and SQL Similarity by Jain, Divyansh, Yang, Eric

“…In recent years, the demand for automated SQL generation has increased significantly, driven by the need for efficient data querying in various applications…”
Get full text

Auto-Assess: Automated Evaluation Platform for Enhanced SQL learning by Motiwala, Mohommed Arman, Joshi, Ananya, Chapaneri, Radhika

“…This work describes the designing and development of an AI-driven SQL learning and teaching platform that could be used for automating SQL query generation, evaluation, and feedback…”
Get full text

Automated Dashboards for the Identification of Pathogenic Circulating Tumor DNA Mutations in Longitudinal Blood Draws of Cancer Patients by Udalov, Aleksandr, Kumar, Lexman, Gaudette, Anna N., Zhang, Ran, Salomao, Joao, Saigal, Sanjay, Nosrati, Mehdi, McAllister, Sean D., Desprez, Pierre-Yves

“…, the manual work for research personnel is drastically reduced. Automated dashboards provide longitudinal views of patient data for research studies to investigate tumor…”
Get full text

Automatic Whitelist Generation for SQL Queries Using Web Application Tests by Nomura, Komei, Rikitake, Kenji, Matsumoto, Ryosuke

“… For large-scale web applications, automated generation of the whitelist is conducted because manually defining numerous query patterns is impractical for developers…”
Get full text

AutoQUEST: A Chain-of-Thought Pipeline for Automated Question Generation and Validation in MAUDE Research by Hua, Lei, Gong, Yang

“… In five distinct test cases, AutoQUEST yielded an accuracy rate of 100% in generating valid research questions and attained query execution success rates ranging from 75% to 100…”
Get more information

SQLify Me: An Automated Text-To-SQL Query Generator by Mohamed, Ahmed Yasser, Zain-elabdeen, Mohamed Hisham, Sayed, Salwa Ahmed, Abdelwahab, Samaa Sabry, Mohamed, Ziad Ezzat, Ali, Zyad Mahmoud, Kawashti, Yomna A., Hindy, Hanan

“… This paper aims to bridge this gap by developing a Text-to-SQL generation system, facilitating natural language queries to database operations…”
Get full text

Enhancing clinical data retrieval with Smart Watchers: a NiFi-based ETL pipeline for Elasticsearch queries by Al-Agil, Mohammad, Obee, Stephen J., Dinu, Vlad, Teo, James, Brawand, David, Patten, Piers E. M., Alhaq, Anwar

“…Background The aim is to develop and deploy an automated clinical alert system to enhance patient care and streamline healthcare operations…”
Get full text

Implementation of Large Language Models in the Educational Process by Krempasky, Alex, Kajati, Erik, Nagy, Tomas, Vascak, Jan, Papcun, Peter

“… In the experimental part, the LLaMA 3.2 1B and Qwen 2.5 7B models were tested in the LM Studio environment on eight types of tasks, ranging from SQL query generation and code explanation to automated assessment of student solutions…”
Get full text

Enhancing Automated Exam Creation with Retrieval-Augmented Generation for Scalable Educational Assessment by Hamidi, Charaf, Badiy, Mohamed, Gaou, Salma, Amounas, Fatima, Azrour, Mourade, Tribak, Hicham, Alnajim, Abdullah M., Alabdulatif, Abdulatif

Get full text

Is ChatGPT a Good Geospatial Data Analyst? Exploring the Integration of Natural Language into Structured Query Language within a Spatial Database by Jiang, Yongyao, Yang, Chaowei

“…) generate geospatial SQL queries based on a natural language question, (3) send the SQL query to the backend database, (4…”
Get full text

Developing a SQL Injection Exploitation Tool with Natural Language Generation by Boekweg, Kate Isabelle

“… However, they are also rife with vulnerabilities, including SQL injection (SQLI) vulnerabilities. SQLI attacks can lead to significant damage to the data stored within web applications and their database…”
Get full text

What Factors Make SQL Test Cases Understandable for Testers? A Human Study of Automated Test Data Generation Techniques by Alsharif, Abdullah, Kapfhammer, Gregory M., McMinn, Phil

“… for database-related functionality. Yet, there has been no research to analyze how well testers - who must often serve as an "oracle" - both understand tests involving SQL and decide if they reveal flaws…”
Get full text

RSQLG: The Reverse SQL Question Generation Algorithm by Julavanich, Thanakrit, Nalintippayawong, Srinual, Atchariyachanvanich, Kanokwan

“… The reverse SQL question generation algorithm (RSQLG) is developed to solve this problem. The RSQLG has ability to automatically generate SQL exercise for students…”
Get full text