使用Query AutoAwesome更新数据库查询

2019 IEEE 20th International Conference on Information Reuse and Integration for Data Science (IRI) Pub Date : 2019-07-01 DOI:10.1109/IRI.2019.00048

Chetna Suryavanshi, C. Dyreson, Jonathan Adams

{"title":"使用Query AutoAwesome更新数据库查询","authors":"Chetna Suryavanshi, C. Dyreson, Jonathan Adams","doi":"10.1109/IRI.2019.00048","DOIUrl":null,"url":null,"abstract":"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 re-placing 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.","PeriodicalId":295028,"journal":{"name":"2019 IEEE 20th International Conference on Information Reuse and Integration for Data Science (IRI)","volume":"19 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2019-07-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Renovating Database Queries with Query AutoAwesome\",\"authors\":\"Chetna Suryavanshi, C. Dyreson, Jonathan Adams\",\"doi\":\"10.1109/IRI.2019.00048\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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 re-placing 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.\",\"PeriodicalId\":295028,\"journal\":{\"name\":\"2019 IEEE 20th International Conference on Information Reuse and Integration for Data Science (IRI)\",\"volume\":\"19 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2019-07-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2019 IEEE 20th International Conference on Information Reuse and Integration for Data Science (IRI)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/IRI.2019.00048\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2019 IEEE 20th International Conference on Information Reuse and Integration for Data Science (IRI)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/IRI.2019.00048","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

摘要

查询是一项重要的数据库活动，通常比更新发生得更频繁。程序员投入时间和精力开发一组查询。我们建议使用Query AutoAwesome (QAA)来重用这些查询。QAA是一个自动增强查询的系统。QAA的灵感来自谷歌的Auto Awesome工具，该工具可以自动增强照片。QAA摄取查询、数据库模式和数据以增强查询。QAA可以通过几种方式重用查询，例如用替代选项替换文字。从潜在的增强池中选择top-k生成的查询是很重要的。为此，我们引入目标函数来衡量增强并对潜在查询进行排序。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Renovating Database Queries with Query AutoAwesome

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 re-placing 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.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

2019 IEEE 20th International Conference on Information Reuse and Integration for Data Science (IRI)

自引率

0.00%

发文量