SQL is a standardised and well entrenched database technology, which allows for the development of robust, customised applications for information management and has been used as the back-end to many successful web client accessible applications.
The Natural Language to SQL Query Generator is an intelligent system designed to allow users to retrieve information from databases by asking questions in simple natural language. Traditionally, users need knowledge of SQL syntax to interact with relational databases. This creates difficulties for non-technical users w...
B. Divya, V. Vaishnavi, E. H. Charan et al.· International Journal of Eng...· 0 citations
Controlling database systems using traditional interfaces requires a strong understanding of Structured Query Language (SQL) and the database administration tools employed. This study introduces a new AI-based system that automates create, read, update, and delete database actions through natural language processing, s...
O. Jayawardana· Journal of Multidisciplinary...· 0 citations
Results demonstrate that implementing the LLM's recommended query, indexing, and schema-level changes yielded performance improvements ranging from 43% to 94% across test cases, whereby temporal aggregations yield 89% average improvement while multi-dimensional grouping nets 86% improvement on the whole system.
N. Salih, Min-Ming Lee· Journal of Informatics and W...· 0 citations
Relational database queries depend on SQL and prior knowledge of the schema. This work proposes SABRE, a plain-text search architecture for relational databases based on the vectorization of tuples and queries and on retrieval by semantic similarity. The evaluation used a pilot study for selecting the embedding model a...
Mikael Sales, M. Duarte, Wellington Franco et al.· Brazilian Symposium on Datab...· 0 citations
iPDB is demonstrated, a system that supports in-database LLM inference using an extended declarative SQL syntax and new optimizations that result in efficient query processing of LLM-enabled SQL queries that outperform state-of-the-art systems.
Udesh Kumarasinghe, Tyler Liu, Ahmed R. Mahmood et al.· Proceedings of the VLDB Endo...· 0 citations
World Wide Web (Web) applications have become an important interface for network services. However, the direct connection among user input, business logic, and database operations has also increased security risks. SQL injection vulnerabilities remain an important issue affecting Web application security. To address th...
Shun-Yan Hong· Applied and Computational En...· 0 citations
We use cookies to run the site and, with your consent, for analytics and to show ads.
See our Cookie Policy.