Search Results - "SQL Query"

Refine Results
  1. 1

    Similarity Metrics for SQL Query Clustering by Kul, Gokhan, Luong, Duc Thanh Anh, Xie, Ting, Chandola, Varun, Kennedy, Oliver, Upadhyaya, Shambhu

    ISSN: 1041-4347, 1558-2191
    Published: New York IEEE 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. 2

    Random Forest Bagging and X-Means Clustered Antipattern Detection from SQL Query Log for Accessing Secure Mobile Data by Dhanaraj, Rajesh Kumar, Ramakrishnan, Vinothsaravanan, Poongodi, M., Krishnasamy, Lalitha, Hamdi, Mounir, Kotecha, Ketan, Vijayakumar, V.

    ISSN: 1530-8669, 1530-8677
    Published: Oxford Hindawi 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. 3

    Decoupling SQL query hardness parsing for text-to-SQL by Yi, Jiawen, Chen, Guo, Zhou, Xiaojun

    ISSN: 0925-2312
    Published: Elsevier B.V 07.03.2025
    Published 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. 4

    The effects of database complexity on SQL query formulation by Taipalus, Toni

    ISSN: 0164-1212, 1873-1228
    Published: Elsevier Inc 01.07.2020
    Published 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. 5

    SQL query extensions for imprecise questions by Le Guilly, Marie, Petit, Jean-Marc, Scuturici, Vasile-Marian

    ISSN: 0169-023X, 1872-6933
    Published: Elsevier B.V 01.01.2022
    Published 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. 6

    Scalable and data-aware SQL query recommendations by Arzamasova, Natalia, Böhm, Klemens

    ISSN: 0306-4379, 1873-6076
    Published: Oxford Elsevier Ltd 01.02.2021
    Published 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. 7

    Cleaning Antipatterns in an SQL Query Log by Arzamasova, Natalia, Schaler, Martin, Bohm, Klemens

    ISSN: 1041-4347, 1558-2191
    Published: New York IEEE 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. 8

    Speech-to-SQL: toward speech-driven SQL query generation from natural language question by Song, Yuanfeng, Wong, Raymond Chi-Wing, Zhao, Xuefang

    ISSN: 1066-8888, 0949-877X
    Published: Berlin/Heidelberg Springer Berlin Heidelberg 01.07.2024
    Published 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. 9

    Integrity Authentication for SQL Query Evaluation on Outsourced Databases: A Survey by Zhang, Bo, Dong, Boxiang, Wang, Wendy Hui

    ISSN: 1041-4347, 1558-2191
    Published: New York IEEE 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. 10

    Efficiently Translating Complex SQL Query to MapReduce Jobflow on Cloud by Wu, Zhiang, Song, Aibo, Cao, Jie, Luo, Junzhou, Zhang, Lu

    ISSN: 2168-7161, 2372-0018
    Published: Piscataway IEEE Computer Society 01.04.2020
    Published 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. 11

    Design and Implementation of Enabling SQLQuery Processing for Ethereum-Based Blockchain Systems by Han, Jongbeen, Seo, Yunhyeong, Lee, Sangjin, Kim, Sunggon, Son, Yongseok

    ISSN: 2079-9292, 2079-9292
    Published: Basel MDPI AG 01.10.2023
    Published 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. 12

    Explaining Causes Behind SQL Query Formulation Errors by Taipalus, Toni

    ISSN: 2377-634X
    Published: IEEE 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. 13

    A Text-to-SQL Query Parser with Integrating Instances by Cui, Xuxu, Shen, Derong

    ISSN: 1819-656X, 1819-9224
    Published: Hong Kong International Association of Engineers 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. 14

    A sign language to SQL query translation system for enhancing database accessibility by Yang, Guocang, Yuan, Dawei, Zhang, Tao, Chen, Zhenghan

    ISSN: 0928-8910, 1573-7535
    Published: New York Springer US 01.06.2026
    Published 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. 15

    On the Usefulness of SQL-Query-Similarity Measures to Find User Interests by Arzamasova, Natalia, Bohm, Klemens, Goldman, Bertrand, Saaler, Christian, Schaler, Martin

    ISSN: 1041-4347, 1558-2191
    Published: New York IEEE 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. 16

    A novel method for SQL injection attack detection based on removing SQL query attribute values by Lee, Inyong, Jeong, Soonki, Yeo, Sangsoo, Moon, Jongsub

    ISSN: 0895-7177, 1872-9479
    Published: Elsevier Ltd 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. 17

    Bridging the Semantic Gap with SQL Query Logs in Natural Language Interfaces to Databases by Baik, Christopher, Jagadish, H. V., Li, Yunyao

    ISSN: 2375-026X
    Published: IEEE 01.04.2019
    Published 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. 18

    Unified SQL Query Middleware for Heterogeneous Databases by Zhang, Huiran, Zhang, Cheng, Hu, Rui, Liu, Xi, Dai, Dongbo

    ISSN: 1742-6588, 1742-6596
    Published: Bristol IOP Publishing 01.04.2021
    Published 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. 19

    Query grouping–based multi‐query optimization framework for interactive SQL query engines on Hadoop by Chen, Ling, Lin, Yan, Wang, Jingchang, Huang, Heqing, Chen, Donghui, Wu, Yong

    ISSN: 1532-0626, 1532-0634
    Published: Hoboken Wiley Subscription Services, Inc 10.10.2018
    Published 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. 20

    Transforming Medical Data Access: The Role and Challenges of Recent Language Models in SQL Query Automation by Tanković, Nikola, Šajina, Robert, Lorencin, Ivan

    ISSN: 1999-4893, 1999-4893
    Published: Basel MDPI AG 01.03.2025
    Published 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