{"id":"https://openalex.org/W3165842875","doi":"https://doi.org/10.14778/3503585.3503600","title":"Database workload characterization with query plan encoders","display_name":"Database workload characterization with query plan encoders","publication_year":2021,"publication_date":"2021-12-01","ids":{"openalex":"https://openalex.org/W3165842875","doi":"https://doi.org/10.14778/3503585.3503600","mag":"3165842875"},"language":"en","primary_location":{"id":"doi:10.14778/3503585.3503600","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3503585.3503600","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/A5075310174","display_name":"Debjyoti Paul","orcid":"https://orcid.org/0000-0001-8057-399X"},"institutions":[{"id":"https://openalex.org/I223532165","display_name":"University of Utah","ror":"https://ror.org/03r0ha626","country_code":"US","type":"education","lineage":["https://openalex.org/I223532165"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Debjyoti Paul","raw_affiliation_strings":["University of Utah"],"affiliations":[{"raw_affiliation_string":"University of Utah","institution_ids":["https://openalex.org/I223532165"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101752372","display_name":"Jie Cao","orcid":"https://orcid.org/0000-0001-8268-954X"},"institutions":[{"id":"https://openalex.org/I223532165","display_name":"University of Utah","ror":"https://ror.org/03r0ha626","country_code":"US","type":"education","lineage":["https://openalex.org/I223532165"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jie Cao","raw_affiliation_strings":["University of Utah"],"affiliations":[{"raw_affiliation_string":"University of Utah","institution_ids":["https://openalex.org/I223532165"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100450462","display_name":"Li Fei-Fei","orcid":"https://orcid.org/0000-0002-7481-0810"},"institutions":[{"id":"https://openalex.org/I223532165","display_name":"University of Utah","ror":"https://ror.org/03r0ha626","country_code":"US","type":"education","lineage":["https://openalex.org/I223532165"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Feifei Li","raw_affiliation_strings":["University of Utah"],"affiliations":[{"raw_affiliation_string":"University of Utah","institution_ids":["https://openalex.org/I223532165"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5013135203","display_name":"Vivek Srikumar","orcid":"https://orcid.org/0000-0003-0419-6568"},"institutions":[{"id":"https://openalex.org/I223532165","display_name":"University of Utah","ror":"https://ror.org/03r0ha626","country_code":"US","type":"education","lineage":["https://openalex.org/I223532165"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vivek Srikumar","raw_affiliation_strings":["University of Utah"],"affiliations":[{"raw_affiliation_string":"University of Utah","institution_ids":["https://openalex.org/I223532165"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5075310174"],"corresponding_institution_ids":["https://openalex.org/I223532165"],"apc_list":null,"apc_paid":null,"fwci":1.5398,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.85821699,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"15","issue":"4","first_page":"923","last_page":"935"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T11719","display_name":"Data Quality and Management","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9940999746322632,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8370270729064941},{"id":"https://openalex.org/keywords/encoder","display_name":"Encoder","score":0.7515991926193237},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6790743470191956},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4990098476409912},{"id":"https://openalex.org/keywords/adaptability","display_name":"Adaptability","score":0.4683759808540344},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.43715721368789673},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4309021234512329},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.42140209674835205},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.4033476710319519},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.35682016611099243},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.35404932498931885},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2322579324245453},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.1867801547050476},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.18246403336524963},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.12802088260650635},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09722691774368286}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8370270729064941},{"id":"https://openalex.org/C118505674","wikidata":"https://www.wikidata.org/wiki/Q42586063","display_name":"Encoder","level":2,"score":0.7515991926193237},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6790743470191956},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4990098476409912},{"id":"https://openalex.org/C177606310","wikidata":"https://www.wikidata.org/wiki/Q5674297","display_name":"Adaptability","level":2,"score":0.4683759808540344},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.43715721368789673},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4309021234512329},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.42140209674835205},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4033476710319519},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.35682016611099243},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35404932498931885},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2322579324245453},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.1867801547050476},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.18246403336524963},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.12802088260650635},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09722691774368286},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3503585.3503600","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3503585.3503600","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":34,"referenced_works":["https://openalex.org/W192088517","https://openalex.org/W1972309850","https://openalex.org/W2014294093","https://openalex.org/W2025768430","https://openalex.org/W2038669746","https://openalex.org/W2081728040","https://openalex.org/W2100495367","https://openalex.org/W2100773341","https://openalex.org/W2109907545","https://openalex.org/W2112474496","https://openalex.org/W2115687261","https://openalex.org/W2122111042","https://openalex.org/W2145020294","https://openalex.org/W2153579005","https://openalex.org/W2162064942","https://openalex.org/W2167978511","https://openalex.org/W2250375035","https://openalex.org/W2396309311","https://openalex.org/W2613206411","https://openalex.org/W2759181158","https://openalex.org/W2760770811","https://openalex.org/W2883510886","https://openalex.org/W2913631065","https://openalex.org/W2944240329","https://openalex.org/W2963196945","https://openalex.org/W2963341956","https://openalex.org/W2963403868","https://openalex.org/W2966185412","https://openalex.org/W2970597249","https://openalex.org/W2970851599","https://openalex.org/W2971270287","https://openalex.org/W2979271470","https://openalex.org/W3098844916","https://openalex.org/W3105457604"],"related_works":["https://openalex.org/W2357124094","https://openalex.org/W2387399993","https://openalex.org/W2389739210","https://openalex.org/W2348924972","https://openalex.org/W2365736347","https://openalex.org/W2047454415","https://openalex.org/W2070040999","https://openalex.org/W2387293848","https://openalex.org/W3121791438","https://openalex.org/W2250140200"],"abstract_inverted_index":{"Smart":[0],"databases":[1,17],"are":[2,110],"adopting":[3],"artificial":[4],"intelligence":[5],"(AI)":[6],"technologies":[7],"to":[8,43,51,112,173],"achieve":[9,44],"instance":[10],"optimality":[11],",":[12],"and":[13,41,85,97,127,152,180],"in":[14,55],"the":[15,49,56,95,98,116,135,159,175],"future,":[16],"will":[18],"come":[19],"with":[20,59,130],"prepackaged":[21],"AI":[22],"models":[23],"within":[24],"their":[25,60,86],"core":[26],"components.":[27],"The":[28],"reason":[29],"is":[30],"that":[31,81,106,114],"every":[32],"database":[33],"runs":[34],"on":[35,170],"different":[36],"workloads,":[37],"demands":[38],"specific":[39],"resources,":[40],"settings":[42],"optimal":[45],"performance.":[46],"It":[47],"prompts":[48],"necessity":[50],"understand":[52],"workloads":[53,113],"running":[54],"system":[57],"along":[58],"features":[61,84],"comprehensively,":[62],"which":[63],"we":[64,75,143],"dub":[65],"as":[66],"workload":[67,72,163],"characterization.":[68,164],"To":[69],"address":[70],"this":[71],"characterization":[73],"problem,":[74],"propose":[76],"our":[77,107,139],"query":[78,89,140,149,154],"plan":[79,141],"encoders":[80,93,109,129,172],"learn":[82],"essential":[83],"correlations":[87],"from":[88],"plans.":[90],"Our":[91],"pretrained":[92,108],"captures":[94],"structural":[96,125],"computational":[99],"performance":[100,128],"of":[101,124,138,161,177],"queries":[102],"independently.":[103],"We":[104,120,165],"show":[105,158],"adaptable":[111],"expedites":[115],"transfer":[117],"learning":[118],"process.":[119],"performed":[121,167],"independent":[122],"assessments":[123],"encoder":[126],"multiple":[131],"downstream":[132,146],"tasks.":[133],"For":[134],"overall":[136],"evaluation":[137],"encoders,":[142],"architect":[144],"two":[145],"tasks":[147,157],"(i)":[148],"latency":[150],"prediction":[151],"(ii)":[153],"classification.":[155],"These":[156],"importance":[160],"feature-based":[162],"also":[166],"extensive":[168],"experiments":[169],"individual":[171],"verify":[174],"effectiveness":[176],"representation":[178],"learning,":[179],"domain":[181],"adaptability.":[182]},"counts_by_year":[{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":5}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}