Skip to Content

189 Results Found

  • Article
  • Open Access
3 Citations
2,450 Views
20 Pages

Current mainstream SQL generation approaches remain insufficient in capturing the semantic information of structured data and handling complex query tasks. To address the challenges of hallucination and accuracy degradation in large language model (L...

(This article belongs to the Special Issue Artificial Intelligence and Big Data Processing: Transforming Industrial Applications)
  • Article
  • Open Access
7 Citations
7,195 Views
16 Pages

Relation-Aware Graph Transformer for SQL-to-Text Generation

  • Da Ma,
  • Xingyu Chen,
  • Ruisheng Cao,
  • Zhi Chen and ,
  • Lu Chen and
  • Kai Yu
  • + 1 author+ 0 author

31 December 2021

Generating natural language descriptions for structured representation (e.g., a graph) is an important yet challenging task. In this work, we focus on SQL-to-text, a task that maps a SQL query into the corresponding natural language question. Previou...

(This article belongs to the Special Issue Advances in Artificial Intelligence Methods for Natural Language Processing)
  • Article
  • Open Access
5 Citations
3,897 Views
32 Pages

6 January 2026

In today’s world, where the volume and variety of data are increasing at an extraordinary rate, extracting meaningful insights from data is of critical importance; however, the complexity of standard database query languages makes it difficult...

(This article belongs to the Special Issue AI-Based Data Science and Database Systems)
  • Article
  • Open Access
1 Citations
2,300 Views
33 Pages

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 and ,
  • I Nyoman Darma Kotama,
  • Putu Sugiartawan and
  • I Nyoman Agus Suarya Putra
  • + 2 authors+ 0 author

9 January 2026

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. Previo...

(This article belongs to the Section Artificial Intelligence)
  • Proceeding Paper
  • Open Access
1 Citations
1,124 Views
7 Pages

28 November 2023

There is a growing number of frail patients whose health conditions require constant monitoring by physicians. Unfortunately, the budget restrictions of hospitals and the concomitant decision that patients should stay home require that this monitorin...

(This article belongs to the Proceedings of The 4th International Electronic Conference on Applied Sciences)
  • Article
  • Open Access
1 Citations
1,066 Views
24 Pages

Enhancing Student Motivation and Competencies via the WWH Teaching Method: A Case Study on the NoSQL Database Course

  • Bin Yu,
  • Yihong Liu,
  • Yuhui Fan,
  • Shaohua Liu and ,
  • Xiaoyan Li and
  • Ruoyu Li
  • + 1 author+ 0 author

14 November 2025

NoSQL databases are vital for modern big data applications, yet traditional teaching methods struggle with lagging content, insufficient practice, and low student engagement. To address these issues, this paper proposes the WWH-integrated teaching me...

(This article belongs to the Topic Advances in Integrative AI, Machine Learning, and Big Data for Transformative Applications)
  • Article
  • Open Access
267 Views
29 Pages

RAG-Grounded Natural-Language-to-SQL for On-Premise Deployment in Regulated Batch Manufacturing

  • Luis Rabelo,
  • Juan Zamora-Aguas,
  • Fahad Alasim,
  • Jose Vazquez and ,
  • Milena Urbina,
  • Gustavo Manfredini,
  • Sean Doolittle and
  • Edgar Gutierrez-Franco
  • + 3 authors+ 0 author

5 November 2026

Natural-language access to structured manufacturing data could let plant personnel query batch records without structured query language (SQL) expertise, yet realistic multi-table industrial schemas remain hard for text-to-SQL systems, and regulated...

  • Article
  • Open Access
33 Citations
7,815 Views
26 Pages

31 December 2024

The widespread adoption of web services has heightened exposure to cybersecurity threats, particularly SQL injection (SQLi) attacks that target the database layers of web applications. Traditional Web Application Firewalls (WAFs) often fail to keep p...

(This article belongs to the Special Issue Generative Artificial Intelligence (AI) for Cybersecurity)
  • Article
  • Open Access
1,661 Views
33 Pages

The increasing digitization of healthcare records and growing reliance on interconnected systems have increased hospitals’ exposure to cyber threats, including ransomware, brute-force attacks, and Structured Query Language (SQL) injection. Trad...

(This article belongs to the Section Safety, Security, Privacy, and Cyber Resilience)
  • Article
  • Open Access
1 Citations
4,846 Views
16 Pages

A Web-Based Docker Image Assistant Generation Tool for User-PC Computing System

  • Lynn Htet Aung,
  • Nobuo Funabiki,
  • Soe Thandar Aung,
  • Xudong Zhou and ,
  • Xu Xiang and
  • Wen-Chung Kao
  • + 1 author+ 0 author

Currently, we are developing the user-PC computing (UPC) system based on the master-worker model as a scalable, low-cost, and high-performance computing platform. To run various application programs on personal computers (PCs) with different environm...

(This article belongs to the Special Issue Feature Papers in Information in 2023)
  • Article
  • Open Access
17 Citations
3,936 Views
20 Pages

5 August 2022

In accordance with the new recovery plan, Next Generation EU (NGEU), and the need to speed up the transition of cities towards a new sustainable model, this paper provides an overview of the outcomes of the PEDRERA project, which is focused on the de...

(This article belongs to the Special Issue Sustainable Spatial Planning and Territorial Governance)
  • Article
  • Open Access
640 Views
25 Pages

11 August 2026

The deployment of Large Language Model (LLM)-generated SQL in Artificial Intelligence of Things (AIoT) systems introduces critical security risks, as prompt injection attacks can manipulate LLMs into producing unauthorized queries that expose sensiti...

  • Article
  • Open Access
891 Views
18 Pages

23 July 2026

Large language model (LLM)-based question-answering (QA) systems are rapidly being deployed in institutional environments, where queries often require both unstructured document retrieval and structured database access. This paper proposes a secure m...

  • Article
  • Open Access
11 Citations
7,382 Views
20 Pages

Improving Text-to-SQL with a Hybrid Decoding Method

  • Geunyeong Jeong,
  • Mirae Han,
  • Seulgi Kim,
  • Yejin Lee and ,
  • Joosang Lee,
  • Seongsik Park and
  • Harksoo Kim
  • + 2 authors+ 0 author

16 March 2023

Text-to-SQL is a task that converts natural language questions into SQL queries. Recent text-to-SQL models employ two decoding methods: sketch-based and generation-based, but each has its own shortcomings. The sketch-based method has limitations in p...

(This article belongs to the Collection Feature Papers in Information Theory)
  • Article
  • Open Access
1 Citations
2,459 Views
21 Pages

DKASQL: Dynamic Knowledge Adaptation for Domain-Specific Text-to-SQL

  • Huaxing Bian,
  • Guanrong Li,
  • Yifan Wang,
  • Qinghan Fu and ,
  • Jian Shen,
  • Xixian Yao and
  • Zhen Wu
  • + 2 authors+ 0 author

16 October 2025

Text2SQL aims to translate natural language queries into structured query language (SQL). LLM-based Text2SQL methods have gradually become mainstream because of their strong capabilities in language understanding and transformation. However, in real-...

(This article belongs to the Special Issue Applications of Data Science and Artificial Intelligence)
  • Article
  • Open Access
5 Citations
2,986 Views
20 Pages

LR-SQL: A Supervised Fine-Tuning Method for Text2SQL Tasks Under Low-Resource Scenarios

  • Wuzhenghong Wen,
  • Yongpan Zhang,
  • Su Pan,
  • Yuwei Sun and ,
  • Pengwei Lu and
  • Cheng Ding
  • + 1 author+ 0 author

31 August 2025

In supervised fine-tuning (SFT) for Text2SQL tasks, particularly for databases with numerous tables, encoding schema features requires excessive tokens, escalating GPU resource requirements during fine-tuning. To bridge this gap, we propose LR-SQL, a...

(This article belongs to the Special Issue Advances in Data Security: Challenges, Technologies, and Applications)
  • Article
  • Open Access
63 Views
20 Pages

MERC-SQL: Heterogeneous Execution Consensus with a Fixed Number of SQL Candidates

  • Yuanjie Wang,
  • Jie Feng,
  • Cuilin Wang,
  • Kaiwen Tan and
  • Zhenhan Wang

15 November 2026

Large language models (LLMs) can improve text-to-structured query language (text-to-SQL) accuracy by generating several candidate queries and selecting an answer through agreement among their execution results. However, candidates from the same gener...

(This article belongs to the Section Computing and Artificial Intelligence)
  • Article
  • Open Access
200 Views
21 Pages

SCDS: Data Synthesis with Structural Priors via Large Language Models for Text-to-SQL

  • Haoyu Zhang,
  • Yingqi Zou,
  • Xiangyu Wang,
  • Shaohan Wang and
  • Zijian Zhang

1 November 2026

Text-to-SQL data synthesis must expand semantic coverage without losing the relational structure of observed queries. Existing SQL offers evidence of plausible join and nesting patterns, but reusing queries alone limits the range of training examples...

(This article belongs to the Special Issue Advancing Information Systems Through Artificial Intelligence: Innovative Approaches and Applications)
  • Article
  • Open Access
1 Citations
2,351 Views
20 Pages

4 March 2026

In Industry 4.0 environments, operators and production managers frequently query industrial databases for production monitoring, quality control, and equipment maintenance using natural language. Existing Chinese NL2SQL systems often process semantic...

(This article belongs to the Topic AI and Data-Driven Advancements in Industry 4.0, 2nd Edition)
  • Article
  • Open Access
2,350 Views
12 Pages

18 November 2025

Conversational text-to-SQL extends the traditional single-turn SQL generation paradigm to multi-turn, dialogue-based scenarios, enabling users to pose and refine database queries interactively, and requiring models to track dialogue context over mult...

(This article belongs to the Special Issue Artificial Intelligence (AI) and Natural Language Processing (NLP))
  • Article
  • Open Access
7 Citations
8,073 Views
24 Pages

FI-NL2PY2SQL: Financial Industry NL2SQL Innovation Model Based on Python and Large Language Model

  • Xiaozheng Du,
  • Shijing Hu,
  • Feng Zhou,
  • Cheng Wang and
  • Binh Minh Nguyen

2 January 2025

With the rapid development of prominent models, NL2SQL has made many breakthroughs, but customers still hope that the accuracy of NL2SQL can be continuously improved through optimization. The method based on large models has brought revolutionary cha...

(This article belongs to the Special Issue Edge-Cloud Computing and Federated-Split Learning in Internet of Things—Second Edition)
  • Article
  • Open Access
4 Citations
3,412 Views
18 Pages

26 June 2024

As a crucial task in natural language processing, table question answering has garnered significant attention from both the academic and industrial communities. It enables intelligent querying and question answering over structured data by translatin...

  • Article
  • Open Access
627 Views
39 Pages

Relational databases power high-stakes decisions in lending, healthcare, and justice, yet SQL lacks native constructs for causal and counterfactual reasoning. Prior SQL-based causal systems address parts of this gap but do not unify treatment-effect...

  • Article
  • Open Access
3 Citations
3,392 Views
18 Pages

Integrating Relational Structure to Heterogeneous Graph for Chinese NL2SQL Parsers

  • Changzhe Ma,
  • Wensheng Zhang,
  • Mengxing Huang,
  • Siling Feng and
  • Yuanyuan Wu

The existing models for NL2SQL tasks are mainly oriented toward English text and cannot solve the problems of column name reuse in Chinese text data, description in natural language query, and inconsistent representation of data stored in the databas...

(This article belongs to the Special Issue Natural Language Processing and Information Retrieval)
  • Article
  • Open Access
2 Citations
1,649 Views
18 Pages

Nabil: A Text-to-SQL Model Based on Brain-Inspired Computing Techniques and Large Language Modeling

  • Feng Zhou,
  • Shijing Hu,
  • Xiaozheng Du,
  • Nan Li and ,
  • Tongming Zhou,
  • Yanni Zhao,
  • Sitong Shang,
  • Xufeng Ling and
  • Huaizhong Zhu
  • + 4 authors+ 0 author

30 September 2025

Human-database interaction is inevitable in intelligent system applications, and accurately converting user-entered natural language into database query language is a critical step. To improve the accuracy, generalization, and robustness of text-to-S...

(This article belongs to the Topic Advanced Operation, Control, and Planning of Intelligent Energy Systems)
  • Article
  • Open Access
3 Citations
5,248 Views
40 Pages

Robust Clinical Querying with Local LLMs: Lexical Challenges in NL2SQL and Retrieval-Augmented QA on EHRs

  • Luka Blašković,
  • Nikola Tanković,
  • Ivan Lorencin and
  • Sandi Baressi Šegota

Electronic health records (EHRs) are typically stored in relational databases, making them difficult to query for nontechnical users, especially under privacy constraints. We evaluate two practical clinical NLP workflows, natural language to SQL (NL2...

(This article belongs to the Section Large Language Models and Embodied Intelligence)
  • Article
  • Open Access
29 Citations
9,990 Views
20 Pages

In the era of big data, Internet-based geospatial information services such as various LBS apps are deployed everywhere, followed by an increasing number of queries against the massive spatial data. As a result, the traditional relational spatial dat...

  • Article
  • Open Access
5 Citations
3,237 Views
24 Pages

FGCSQL: A Three-Stage Pipeline for Large Language Model-Driven Chinese Text-to-SQL

  • Guanyu Jiang,
  • Weibin Li,
  • Chenglong Yu,
  • Zixuan Zhu and
  • Wei Li

Recent advances in large language models have driven major breakthroughs in Text-to-SQL tasks. However, many challenges hinder the use of SQL parsers for cross-language tasks. In this article, we introduce FGCSQL, a novel three-stage pipeline framewo...

  • Article
  • Open Access
1 Citations
1,080 Views
16 Pages

EvoAgent-SQL: An Evolutionary Multi-Agent Text2SQL Framework Integrating User Feedback and Reflective Adaptation

  • Bin He,
  • Yanshu Du,
  • Hao Meng,
  • Shengbing Tang and ,
  • Ting Zhang and
  • Longfei Song
  • + 1 author+ 0 author

6 May 2026

Natural language to structured query language (Text2SQL) is a critical task in intelligent question answering and database interaction. A fundamental challenge lies in achieving semantic symmetry between natural language expressions and database sche...

(This article belongs to the Section A: Computer Science)
  • Article
  • Open Access
2 Citations
1,184 Views
36 Pages

GeoIR-Compiler: A Geospatial Intermediate Representation and Compilation Framework for Chinese Urban Spatial Question Answering

  • Chaolin Zhang,
  • Jiqiu Deng,
  • Hui Zhang,
  • Longbo Li and ,
  • Liji Sun and
  • Xiao Ma
  • + 1 author+ 0 author

Natural-language access to spatial databases requires relation interpretation, entity grounding, metric normalization, and database-specific execution semantics. Direct generation of Structured Query Language (SQL) by large language models (LLMs) can...

  • Article
  • Open Access
604 Views
28 Pages

CGD-QCSF: A Code Generation-Driven Query–Computation Separation Framework for Natural Language Geospatial Analysis

  • Zhiyuan Le,
  • Hao Li,
  • Yuanxun Mei,
  • Miaomiao Ren and ,
  • Haizhen Chen,
  • Yinying Zhou and
  • Lu Li
  • + 2 authors+ 0 author

Geospatial data provide an important basis for urban governance, resource management, disaster assessment, and public health analysis by linking spatial locations, attribute information, and dynamic processes. However, complex geospatial analysis sti...

(This article belongs to the Special Issue LLM4GIS: Large Language Models for GIS)
  • Article
  • Open Access
9 Citations
14,231 Views
18 Pages

18 December 2021

Structured Query Language (SQL) is commonly used in Relational Database Management Systems (RDBMS) and is currently one of the most popular data definition and manipulation languages. Its core functionality is implemented, with only some minor variat...

  • Article
  • Open Access
32 Citations
8,516 Views
18 Pages

30 March 2023

SQL injection is a highly detrimental web attack technique that can result in significant data leakage and compromise system integrity. To counteract the harm caused by such attacks, researchers have devoted much attention to the examination of SQL i...

(This article belongs to the Section Cybersecurity)
  • Article
  • Open Access
8 Citations
4,115 Views
20 Pages

sqlFuzz: Directed Fuzzing for SQL Injection Vulnerability

  • Ye Yuan,
  • Yuliang Lu,
  • Kailong Zhu,
  • Hui Huang and ,
  • Yuanchao Chen and
  • Yifan Zhang
  • + 1 author+ 0 author

Fuzz testing technology is an important approach to detecting SQL injection vulnerabilities. Among them, coverage-guided gray-box fuzz testing technology is the current research focus, and has been proved to be an effective method. However, for SQL i...

  • Article
  • Open Access
534 Views
32 Pages

Empirical Post-Generation Correctness Assessment for Natural-Language Access to Urban PostGIS Databases

  • Jiqiu Deng,
  • Chaolin Zhang,
  • Hui Zhang,
  • Longbo Li and ,
  • Liji Sun,
  • Xiao Ma and
  • Zhiyong Guo
  • + 2 authors+ 0 author

Natural-language interfaces make urban spatial databases accessible, but generated structured query language (SQL) can execute successfully while returning a semantically incorrect answer. We evaluate a post-generation correctness-ranking layer on 18...

(This article belongs to the Topic Geospatial AI: Systems, Model, Methods, and Applications)
  • Article
  • Open Access
42 Citations
13,399 Views
22 Pages

Over the years, injection vulnerabilities have been at the top of the Open Web Application Security Project Top 10 and are one of the most damaging and widely exploited types of vulnerabilities against web applications. Structured Query Language (SQL...

(This article belongs to the Special Issue AI in Cybersecurity)
  • Article
  • Open Access
1 Citations
4,420 Views
20 Pages

Ultimate Pit-Limit Optimization Algorithm Enhancement Using Structured Query Language

  • Gonzalo Ares,
  • César Castañón Fernández and
  • Isidro Diego Álvarez

20 July 2023

Three-dimensional block models are the most widely used tool for the study and evaluation of ore deposits, the calculation and design of economical pits, mine production planning, and physical and numerical simulations of ore deposits. The way these...

(This article belongs to the Section Mineral Deposits)
  • Article
  • Open Access
20 Citations
9,362 Views
25 Pages

Within a digital map service environment, the rapid growth of Spatial Big-Data is driving new requirements for effective mechanisms for massive online vector map tile processing. The emergence of Not Only SQL (NoSQL) databases has resulted in a new d...

(This article belongs to the Special Issue Web/Cloud Based Mapping and Geoinformation)
  • Article
  • Open Access
8 Citations
5,239 Views
33 Pages

DSP: Schema Design for Non-Relational Applications

  • Abdullahi Abubakar Imam,
  • Shuib Basri,
  • Rohiza Ahmad,
  • Amirudin A. Wahab and ,
  • María T. González-Aparicio,
  • Luiz Fernando Capretz,
  • Ammar K. Alazzawi and
  • Abdullateef O. Balogun
  • + 3 authors+ 0 author

30 October 2020

The way a database schema is designed has a high impact on its performance in relational databases, which are symmetric in nature. While the problem of schema optimization is even more significant for NoSQL (“Not only SQL”) databases, exi...

(This article belongs to the Section A: Computer Science)
  • Article
  • Open Access
1,096 Views
31 Pages

A Governed NL-to-SQL Architecture for Reliable Clinical Data Querying and Outpatient Schedule Monitoring

  • Isaac Daroch,
  • Matías Rojas Cabrera,
  • Rodrigo Muñoz Andrade,
  • Alejandra Fernández and
  • Juan Pablo Vásconez

The deployment of natural-language-to-SQL (NL-to-SQL) systems in primary healthcare requires more than accurate query generation: it also requires governed data access, robustness to local terminology, and reliable handling of ambiguous user requests...

  • Proceeding Paper
  • Open Access
1 Citations
727 Views
14 Pages

Research on Vulnerability Detection Methods in SQL and NoSQL Systems Using Machine Learning and Large Language Models

  • Yasfirbek Rozmetov,
  • Anel Aidos,
  • Murat Ozer,
  • Alibek Bissembayev and ,
  • Aigul Bissarinova and
  • Assel Mukasheva
  • + 1 author+ 0 author

16 September 2026

SQL and NoSQL databases are at risk from injection attacks, which is one of the most serious threats to the security of today’s data-centric systems. To address this issue, this research proposes an architecture for evaluating a new hybrid tech...

(This article belongs to the Proceedings of The International Conference on Electronics, Engineering Physics and Earth Science (EEPES2026))
  • Brief Report
  • Open Access
47 Citations
10,881 Views
10 Pages

With recent advancements, large language models (LLMs) such as ChatGPT and Bard have shown the potential to disrupt many industries, from customer service to healthcare. Traditionally, humans interact with geospatial data through software (e.g., ArcG...

(This article belongs to the Special Issue Unlocking the Power of Geospatial Data: Semantic Information Extraction, Ontology Engineering, and Deep Learning for Knowledge Discovery)
  • Article
  • Open Access
12 Citations
4,820 Views
19 Pages

28 April 2024

The emergence of security vulnerabilities and risks in software development assisted by self-generated tools, particularly with regard to the generation of code that lacks due consideration of security measures, could have significant consequences fo...

(This article belongs to the Special Issue Artificial Intelligence Applications in Industry)
  • Article
  • Open Access
2 Citations
3,100 Views
23 Pages

Beyond Standard Losses: Redefining Text-to-SQL with Task-Specific Optimization

  • Iker Azurmendi,
  • Ekaitz Zulueta,
  • Gustavo García,
  • Nekane Uriarte-Arrazola and
  • Jose Manuel Lopez-Guede

20 July 2025

In recent years, large language models (LLMs) have shown an impressive ability in translating text to SQL queries. However, in real-world applications, standard loss functions frequently fail to capture the complexity of queries adequately. Therefore...

  • Article
  • Open Access
12 Citations
5,615 Views
17 Pages

GPT-Based Text-to-SQL for Spatial Databases

  • Hui Wang,
  • Li Guo,
  • Yubin Liang,
  • Le Liu and
  • Jiajin Huang

Text-to-SQL for spatial databases enables the translation of natural language questions into corresponding SQL queries, allowing non-experts to easily access spatial data, which has gained increasing attention from researchers. Previous research has...

  • Article
  • Open Access
8 Citations
4,039 Views
23 Pages

15 February 2023

Database Management Systems (DBMSs) are the core of management information systems. Thus, detecting security bugs or vulnerabilities of DBMSs is an essential task. In recent years, grey-box fuzzing has been adopted to detect DBMS bugs for its high ef...

(This article belongs to the Special Issue Advances in Cybersecurity: Challenges and Solutions)
  • Article
  • Open Access
430 Views
23 Pages

8 September 2026

Adaptive learning environments and large language models (LLMs) are increasingly combined, yet most LLM-based tutoring work addresses feedback generation in isolation rather than its integration into a controlled, auditable learning loop. This paper...

(This article belongs to the Special Issue Intelligent Educational Technologies: Core Architectures, Algorithms, and Evidence-Based Systems)
  • Article
  • Open Access
6 Citations
6,106 Views
24 Pages

KVMod—A Novel Approach to Design Key-Value NoSQL Databases

  • Ahmed Dourhri,
  • Mohamed Hanine and
  • Hassan Ouahmane

12 October 2023

The growth of structured, semi-structured, and unstructured data produced by the new applications is a result of the development and expansion of social networks, the Internet of Things, web technology, mobile devices, and other technologies. However...

(This article belongs to the Special Issue Feature Papers in Information in 2023)
  • Article
  • Open Access
1 Citations
4,726 Views
23 Pages

This paper presents a comparative analysis of read performance for PostgreSQL and MongoDB in e-commerce scenarios, using identical datasets in a resource-constrained single-host environment. The results demonstrate that PostgreSQL executes complex an...

  • Article
  • Open Access
13 Citations
5,975 Views
13 Pages

Generating execution plans is a costly operation for the DataBase Management System (DBMS). An interesting alternative to this operation is to reuse the old execution plans, that were already generated by the optimizer for past queries, to execute ne...

of 4