Search Results - "SQL Query"
-
1
Similarity Metrics for SQL Query Clustering
ISSN: 1041-4347, 1558-2191Published: New York IEEE 01.12.2018Published in IEEE transactions on knowledge and data engineering (01.12.2018)“…, which is challenging to compute for SQL queries, especially when the underlying data and database schema is unavailable…”
Get full text
Journal Article -
2
Random Forest Bagging and X-Means Clustered Antipattern Detection from SQL Query Log for Accessing Secure Mobile Data
ISSN: 1530-8669, 1530-8677Published: Oxford Hindawi 2021Published in Wireless communications and mobile computing (2021)“… To address the above-said issues and further enhance the antipattern detection accuracy with minimum time and false positive rate, in this work, Random Forest Bagging X-means SQL Query Clustering (RFBXSQLQC…”
Get full text
Journal Article -
3
Decoupling SQL query hardness parsing for text-to-SQL
ISSN: 0925-2312Published: Elsevier B.V 07.03.2025Published in Neurocomputing (Amsterdam) (07.03.2025)“…The fundamental goal of the Text-to-SQL task is to translate natural language question into SQL query…”
Get full text
Journal Article -
4
The effects of database complexity on SQL query formulation
ISSN: 0164-1212, 1873-1228Published: Elsevier Inc 01.07.2020Published in The Journal of systems and software (01.07.2020)“…•Increase in database complexity results in lower success rates in query formulation.•Increase in database complexity results in more unnecessary…”
Get full text
Journal Article -
5
SQL query extensions for imprecise questions
ISSN: 0169-023X, 1872-6933Published: Elsevier B.V 01.01.2022Published in Data & knowledge engineering (01.01.2022)“… If SQL is easy-to-use and has proved its robustness over the years, it is not always easy to formulate SQL queries as it is more and more frequent to have databases with hundreds of tables and/or attributes…”
Get full text
Journal Article -
6
Scalable and data-aware SQL query recommendations
ISSN: 0306-4379, 1873-6076Published: Oxford Elsevier Ltd 01.02.2021Published in Information systems (Oxford) (01.02.2021)“…SQL query recommendation suggests an SQL statement to a user, based on his submitted requests and on queries of other users stored in a log…”
Get full text
Journal Article -
7
Cleaning Antipatterns in an SQL Query Log
ISSN: 1041-4347, 1558-2191Published: New York IEEE 01.03.2018Published in IEEE transactions on knowledge and data engineering (01.03.2018)“… We propose a framework designed to discover patterns and antipatterns in arbitrary SQL query logs and to clean antipatterns…”
Get full text
Journal Article -
8
Speech-to-SQL: toward speech-driven SQL query generation from natural language question
ISSN: 1066-8888, 0949-877XPublished: Berlin/Heidelberg Springer Berlin Heidelberg 01.07.2024Published in The VLDB journal (01.07.2024)“…Speech-based inputs have been gaining significant momentum with the popularity of smartphones and tablets in our daily lives, since voice is the most popular…”
Get full text
Journal Article -
9
Integrity Authentication for SQL Query Evaluation on Outsourced Databases: A Survey
ISSN: 1041-4347, 1558-2191Published: New York IEEE 01.04.2021Published in IEEE transactions on knowledge and data engineering (01.04.2021)“…, the same as the results of query execution locally)? This survey focuses on categorizing and reviewing the progress on the current approaches for result integrity of SQL query evaluation in the DaaS model…”
Get full text
Journal Article -
10
Efficiently Translating Complex SQL Query to MapReduce Jobflow on Cloud
ISSN: 2168-7161, 2372-0018Published: Piscataway IEEE Computer Society 01.04.2020Published in IEEE transactions on cloud computing (01.04.2020)“…MapReduce is a widely-used programming model in cloud environment for parallel processing large-scale data sets. The combination of the high-level language…”
Get full text
Journal Article -
11
Design and Implementation of Enabling SQL–Query Processing for Ethereum-Based Blockchain Systems
ISSN: 2079-9292, 2079-9292Published: Basel MDPI AG 01.10.2023Published in Electronics (Basel) (01.10.2023)“…A blockchain is designed to establish consistent and reliable agreements in an untrusted and decentralized environment. In addition, the blockchain enables…”
Get full text
Journal Article -
12
Explaining Causes Behind SQL Query Formulation Errors
ISSN: 2377-634XPublished: IEEE 21.10.2020Published in Proceedings - Frontiers in Education Conference (21.10.2020)“…This Full Research Paper presents the most prominent query formulation errors in Structured Query Language (SQL), and maps these errors to their cognitive…”
Get full text
Conference Proceeding -
13
A Text-to-SQL Query Parser with Integrating Instances
ISSN: 1819-656X, 1819-9224Published: Hong Kong International Association of Engineers 01.06.2025Published in IAENG international journal of computer science (01.06.2025)“… This paper presents a Text-to-SQL query parser that integrates database instances to address these limitations…”
Get full text
Journal Article -
14
A sign language to SQL query translation system for enhancing database accessibility
ISSN: 0928-8910, 1573-7535Published: New York Springer US 01.06.2026Published in Automated software engineering (01.06.2026)“… In this paper, we present SIGN2SQL , an innovative end-to-end framework that generates SQL queries from signed input…”
Get full text
Journal Article -
15
On the Usefulness of SQL-Query-Similarity Measures to Find User Interests
ISSN: 1041-4347, 1558-2191Published: New York IEEE 01.10.2020Published in IEEE transactions on knowledge and data engineering (01.10.2020)“… Such a clustering requires a notion of query similarity. This, in turn, raises the question of what features of SQL queries are meaningful…”
Get full text
Journal Article -
16
A novel method for SQL injection attack detection based on removing SQL query attribute values
ISSN: 0895-7177, 1872-9479Published: Elsevier Ltd 2012Published in Mathematical and computer modelling (2012)“… The method removes the value of an SQL query attribute of web pages when parameters are submitted and then compares it with a predetermined one…”
Get full text
Journal Article -
17
Bridging the Semantic Gap with SQL Query Logs in Natural Language Interfaces to Databases
ISSN: 2375-026XPublished: IEEE 01.04.2019Published in Data engineering (01.04.2019)“… Join path inference is the process of selecting the relations and join conditions in the FROM clause of the final SQL query, and is difficult…”
Get full text
Conference Proceeding -
18
Unified SQL Query Middleware for Heterogeneous Databases
ISSN: 1742-6588, 1742-6596Published: Bristol IOP Publishing 01.04.2021Published in Journal of physics. Conference series (01.04.2021)“…With the development of modern computer technology, the data which needs to be stored and processed by modern application systems becomes more and more varied…”
Get full text
Journal Article -
19
Query grouping–based multi‐query optimization framework for interactive SQL query engines on Hadoop
ISSN: 1532-0626, 1532-0634Published: Hoboken Wiley Subscription Services, Inc 10.10.2018Published in Concurrency and computation (10.10.2018)“…Summary In the past few years, executing high‐concurrency queries with interactive SQL query engines on Hadoop has become an important activity for many organizations…”
Get full text
Journal Article -
20
Transforming Medical Data Access: The Role and Challenges of Recent Language Models in SQL Query Automation
ISSN: 1999-4893, 1999-4893Published: Basel MDPI AG 01.03.2025Published in Algorithms (01.03.2025)“…Generating accurate SQL queries from natural language is critical for enabling non-experts to interact with complex databases, particularly in high-stakes domains like healthcare…”
Get full text
Journal Article