Renovating Database Queries with Query AutoAwesome

被引:0
|
作者
Suryavanshi, Chetna [1 ]
Dyreson, Curtis [2 ]
Adams, Jonathan [2 ]
机构
[1] Micron, Boise, ID 83707 USA
[2] Dept Comp Sci, Logan, UT USA
来源
2019 IEEE 20TH INTERNATIONAL CONFERENCE ON INFORMATION REUSE AND INTEGRATION FOR DATA SCIENCE (IRI 2019) | 2019年
关键词
D O I
10.1109/IRI.2019.00048
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Querying is an important database activity, typically occurring more frequently than update. Programmers invest time and effort into developing a set of queries. We propose reusing these queries with Query AutoAwesome (QAA). QAA is a system to automatically enhance queries. QAA was inspired by Google's Auto Awesome tool, which provides automatic enhancements of photos. QAA ingests a query, the database schema, and the data to enhance a query. QAA can reuse a query in several ways, such as replacing a literal with a choice of alternatives. From among the pool of potential enhancements it is important to choose the top-k generated queries. To do so we introduce objective functions to measure the enhancement and rank potential queries.
引用
收藏
页码:253 / 260
页数:8
相关论文
共 50 条
  • [21] On the structure of queries in constraint query languages
    Benedikt, M
    Libkin, L
    11TH ANNUAL IEEE SYMPOSIUM ON LOGIC IN COMPUTER SCIENCE, PROCEEDINGS, 1996, : 25 - 34
  • [22] Learning routing queries in a query zone
    Singhal, A
    Mitra, M
    Buckley, C
    PROCEEDINGS OF THE 20TH ANNUAL INTERNATIONAL ACM SIGIR CONFERENCE ON RESEARCH AND DEVELOPMENT IN INFORMATION RETRIEVAL, 1997, : 25 - 32
  • [23] Query Relaxation for Star Queries on RDF
    Huang, Hai
    Liu, Chengfei
    WEB INFORMATION SYSTEM ENGINEERING-WISE 2010, 2010, 6488 : 376 - 389
  • [24] Parameterised Queries and Lifted Query Answering
    Braun, Tanya
    Moeller, Ralf
    PROCEEDINGS OF THE TWENTY-SEVENTH INTERNATIONAL JOINT CONFERENCE ON ARTIFICIAL INTELLIGENCE, 2018, : 4980 - 4986
  • [25] Adaptive Query Suggestion for Difficult Queries
    Liu, Yang
    Song, Ruihua
    Chen, Yu
    Nie, Jian-Yun
    Wen, Ji-Rong
    SIGIR 2012: PROCEEDINGS OF THE 35TH INTERNATIONAL ACM SIGIR CONFERENCE ON RESEARCH AND DEVELOPMENT IN INFORMATION RETRIEVAL, 2012, : 15 - 24
  • [26] Ranked Enumeration for Database Queries
    Tziavelis, Nikolaos
    Gatterbauer, Wolfgang
    Riedewald, Mirek
    SIGMOD Record, 2024, 53 (03) : 6 - 19
  • [27] Dynamic Prioritization of Database Queries
    Narayanan, Sivaramakrishnan
    Waas, Florian
    IEEE 27TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2011), 2011, : 1232 - 1241
  • [28] POSTCONDITIONAL SEMANTICS OF DATABASE QUERIES
    RISHE, N
    LECTURE NOTES IN COMPUTER SCIENCE, 1986, 239 : 275 - 295
  • [29] Database Queries that Explain their Work
    Cheney, James
    Ahmed, Amal
    Acar, Umut A.
    PPDP'14: PROCEEDINGS OF THE 16TH INTERNATIONAL SYMPOSIUM ON PRINCIPLES AND PRACTICE OF DECLARATIVE PROGRAMMING, 2014, : 271 - 282
  • [30] Learning Database Queries with Prolog
    Orehova, Ekaterina
    Govyazin, Sergey
    Stroganov, Yurii
    NEW TECHNOLOGIES AND REDESIGNING LEARNING SPACES, VOL II, 2019, : 265 - 272