{"id":"https://openalex.org/W4386768691","doi":"https://doi.org/10.14778/3611540.3611607","title":"AQUA: Automatic Collaborative Query Processing in Analytical Database","display_name":"AQUA: Automatic Collaborative Query Processing in Analytical Database","publication_year":2023,"publication_date":"2023-08-01","ids":{"openalex":"https://openalex.org/W4386768691","doi":"https://doi.org/10.14778/3611540.3611607"},"language":"en","primary_location":{"id":"doi:10.14778/3611540.3611607","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611540.3611607","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5017539350","display_name":"Yuchen Peng","orcid":null},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yuchen Peng","raw_affiliation_strings":["Zhejiang University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100451984","display_name":"Ke Chen","orcid":"https://orcid.org/0000-0001-9457-9364"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ke Chen","raw_affiliation_strings":["Zhejiang University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103017455","display_name":"Lidan Shou","orcid":"https://orcid.org/0000-0001-8062-8356"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lidan Shou","raw_affiliation_strings":["Zhejiang University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5077156448","display_name":"Dawei Jiang","orcid":"https://orcid.org/0000-0002-1890-4046"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Dawei Jiang","raw_affiliation_strings":["Zhejiang University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100389286","display_name":"Gang Chen","orcid":"https://orcid.org/0000-0002-7483-0045"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Gang Chen","raw_affiliation_strings":["Zhejiang University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5017539350"],"corresponding_institution_ids":["https://openalex.org/I76130692"],"apc_list":null,"apc_paid":null,"fwci":0.3842,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.61600305,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":"16","issue":"12","first_page":"4006","last_page":"4009"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.9970999956130981,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8651458024978638},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7498795390129089},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5905115008354187},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.5830955505371094},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5758039355278015},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5514741539955139},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5305388569831848},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5245028734207153},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.503694474697113},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.46826794743537903},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4560104012489319},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.43750500679016113},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4170396327972412},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.41329193115234375},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.41055572032928467},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.35419440269470215},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1492449939250946},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.09148380160331726},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.08388537168502808}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8651458024978638},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7498795390129089},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5905115008354187},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.5830955505371094},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5758039355278015},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5514741539955139},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5305388569831848},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5245028734207153},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.503694474697113},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.46826794743537903},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4560104012489319},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.43750500679016113},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4170396327972412},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.41329193115234375},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.41055572032928467},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.35419440269470215},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1492449939250946},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09148380160331726},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.08388537168502808}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3611540.3611607","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611540.3611607","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W2044849727","https://openalex.org/W3029900615","https://openalex.org/W3030051638","https://openalex.org/W3174529902","https://openalex.org/W4289866515"],"related_works":["https://openalex.org/W2006459955","https://openalex.org/W1003283331","https://openalex.org/W1461606193","https://openalex.org/W2128834514","https://openalex.org/W906795786","https://openalex.org/W4379390531","https://openalex.org/W2406556739","https://openalex.org/W1590029787","https://openalex.org/W2491796624","https://openalex.org/W2903968032"],"abstract_inverted_index":{"Data":[0],"analysts":[1,127],"nowadays":[2],"are":[3],"keen":[4],"to":[5,19,26,41,49,63,112,128,217],"have":[6],"analytical":[7,145],"capabilities":[8],"involving":[9],"deep":[10],"learning":[11],"(DL).":[12],"Collaborative":[13],"queries,":[14],"which":[15],"employ":[16],"relational":[17,46,109],"operations":[18],"process":[20,27,64],"structured":[21],"data":[22,126,132,178,193,200],"and":[23,104,133,180,195],"DL":[24,51,99],"models":[25,52],"unstructured":[28,65],"data,":[29],"provide":[30],"a":[31,58,107,173,210],"powerful":[32],"facility":[33],"for":[34,148,176,184],"DL-based":[35],"in-database":[36],"analysis.":[37],"The":[38],"classical":[39,108],"approach":[40,68,121],"support":[42],"collaborative":[43,93,116,150,160,185,219],"queries":[44,161,220],"in":[45,57],"databases":[47],"is":[48],"integrate":[50],"with":[53],"user-defined":[54],"functions":[55],"(UDFs)":[56],"general-purpose":[59],"language":[60],"(e.g.,":[61],"C++)":[62],"data.":[66],"This":[67],"suffers":[69],"from":[70,159,198],"suboptimal":[71],"performance":[72,196],"as":[73],"the":[74,78,90,114,119,189,199,204,215,222],"opaque":[75],"UDFs":[76],"preclude":[77],"generation":[79],"of":[80,92,191,207],"an":[81,144],"optimal":[82],"query":[83,94,110,135,151,186],"plan.":[84],"A":[85],"recent":[86],"work,":[87],"DL2SQL,":[88,155],"addresses":[89],"problem":[91],"optimization":[95],"by":[96,124],"first":[97],"converting":[98],"computations":[100],"into":[101,162],"SQL":[102,163],"subqueries":[103],"then":[105],"using":[106],"optimizer":[111],"optimize":[113],"entire":[115],"query.":[117],"However,":[118],"DL2SQL":[120],"compromises":[122],"usability":[123],"requiring":[125],"manually":[129],"manage":[130],"DL-related":[131,177],"tune":[134],"performance.":[136],"To":[137,165],"this":[138,140],"end,":[139],"paper":[141],"introduces":[142,169],"AQUA,":[143],"database":[146],"designed":[147],"efficient":[149],"processing.":[152],"Built":[153],"on":[154,221],"AQUA":[156,168,208],"automates":[157],"translations":[158],"queries.":[164],"enhance":[166],"usability,":[167],"two":[170],"techniques:":[171],"1)":[172],"declarative":[174],"scheme":[175],"management,":[179],"2)":[181],"DL-specific":[182],"optimizations":[183],"processing,":[187],"eliminating":[188],"burden":[190],"manual":[192],"management":[194],"tuning":[197],"analysts.":[201],"We":[202],"demonstrate":[203],"key":[205],"contributions":[206],"via":[209],"web":[211],"APP":[212],"that":[213],"allows":[214],"audience":[216],"perform":[218],"CIFAR-10":[223],"dataset.":[224]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}