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 条

[41] Query Optimization for Complex Path Queries on Data
Wang, Hongzhi
Li, Jianzhong
Liu, Xianmin
Luo, Jizhou
DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, PROCEEDINGS, 2009, 5463 : 389 - 404
[42] SEMANTIC QUERY OPTIMIZATION FOR TREE AND CHAIN QUERIES
SUN, W
YU, CT
IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1994, 6 (01) : 136 - 151
[43] An algorithm for skyline queries based on window query
Yu, J
Liu, X
Liu, GH
Proceedings of the 11th Joint International Computer Conference, 2005, : 267 - 270
[44] Query Rewriting for Voice Shopping Null Queries
Gamzu, Iftah
Haikin, Marina
Halabi, Nissim
PROCEEDINGS OF THE 43RD INTERNATIONAL ACM SIGIR CONFERENCE ON RESEARCH AND DEVELOPMENT IN INFORMATION RETRIEVAL (SIGIR '20), 2020, : 1369 - 1378
[45] Information Needs, Queries, and Query Performance Prediction
Zendel, Oleg
Shtok, Anna
Rabier, Fiana
Kurland, Oren
Culpepper, J. Shane
PROCEEDINGS OF THE 42ND INTERNATIONAL ACM SIGIR CONFERENCE ON RESEARCH AND DEVELOPMENT IN INFORMATION RETRIEVAL (SIGIR '19), 2019, : 395 - 404
[46] Typed query languages for databases containing queries
Neven, F
Van den Bussche, J
Van Gucht, D
Vossen, G
INFORMATION SYSTEMS, 1999, 24 (07) : 569 - 595
[47] Determinacy and query rewriting for conjunctive queries and views
Afrati, Foto N.
THEORETICAL COMPUTER SCIENCE, 2011, 412 (11) : 1005 - 1021
[48] PIR with compressed queries and amortized query processing
Angel, Sebastian
Chen, Hao
Laine, Kim
Setty, Srinath
2018 IEEE SYMPOSIUM ON SECURITY AND PRIVACY (SP), 2018, : 962 - 979
[49] RebaCQ: Query Refinement Based on Consecutive Queries
Hung, Chia-Hsin
Tsai, Shuo-En
Chen, Yi-Shin
PROCEEDINGS OF THE 2009 IEEE INTERNATIONAL CONFERENCE ON INFORMATION REUSE AND INTEGRATION, 2008, : 366 - +
[50] QUERY-PROCESSING THAT PERMITS INCOMPLETENESS OF QUERIES SPECIFYING A SEQUENCE OF DATA IN A MOTION-PICTURE DATABASE AND THE MESOD MODEL
TABUCHI, M
MURAOKA, Y
SYSTEMS AND COMPUTERS IN JAPAN, 1994, 25 (07) : 1 - 18

← 1 2 3 4 5 →