{"id":"https://openalex.org/W4391853837","doi":"https://doi.org/10.1109/tkde.2024.3361989","title":"Learned Optimizer for Online Approximate Query Processing in Data Exploration","display_name":"Learned Optimizer for Online Approximate Query Processing in Data Exploration","publication_year":2024,"publication_date":"2024-02-15","ids":{"openalex":"https://openalex.org/W4391853837","doi":"https://doi.org/10.1109/tkde.2024.3361989"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2024.3361989","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/tkde.2024.3361989","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","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/A5102927482","display_name":"L.L. Liu","orcid":null},"institutions":[{"id":"https://openalex.org/I24943067","display_name":"Fudan University","ror":"https://ror.org/013q1eq08","country_code":"CN","type":"education","lineage":["https://openalex.org/I24943067"]},{"id":"https://openalex.org/I4210092257","display_name":"China Guangzhou Analysis and Testing Center","ror":"https://ror.org/00d6bjs95","country_code":"CN","type":"other","lineage":["https://openalex.org/I4210092257"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Liyuan Liu","raw_affiliation_strings":["School of Computer Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China","institution_ids":["https://openalex.org/I4210092257"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114859774","display_name":"Hanbing Zhang","orcid":"https://orcid.org/0000-0003-4987-932X"},"institutions":[{"id":"https://openalex.org/I24943067","display_name":"Fudan University","ror":"https://ror.org/013q1eq08","country_code":"CN","type":"education","lineage":["https://openalex.org/I24943067"]},{"id":"https://openalex.org/I4210092257","display_name":"China Guangzhou Analysis and Testing Center","ror":"https://ror.org/00d6bjs95","country_code":"CN","type":"other","lineage":["https://openalex.org/I4210092257"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hanbing Zhang","raw_affiliation_strings":["School of Computer Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China","Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China","institution_ids":["https://openalex.org/I4210092257"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087411191","display_name":"Yinan Jing","orcid":"https://orcid.org/0000-0002-1169-8032"},"institutions":[{"id":"https://openalex.org/I24943067","display_name":"Fudan University","ror":"https://ror.org/013q1eq08","country_code":"CN","type":"education","lineage":["https://openalex.org/I24943067"]},{"id":"https://openalex.org/I4210092257","display_name":"China Guangzhou Analysis and Testing Center","ror":"https://ror.org/00d6bjs95","country_code":"CN","type":"other","lineage":["https://openalex.org/I4210092257"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yinan Jing","raw_affiliation_strings":["School of Computer Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China","Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China","institution_ids":["https://openalex.org/I4210092257"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059000467","display_name":"Zhenying He","orcid":"https://orcid.org/0000-0002-2926-4814"},"institutions":[{"id":"https://openalex.org/I24943067","display_name":"Fudan University","ror":"https://ror.org/013q1eq08","country_code":"CN","type":"education","lineage":["https://openalex.org/I24943067"]},{"id":"https://openalex.org/I4210092257","display_name":"China Guangzhou Analysis and Testing Center","ror":"https://ror.org/00d6bjs95","country_code":"CN","type":"other","lineage":["https://openalex.org/I4210092257"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhenying He","raw_affiliation_strings":["School of Computer Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China","institution_ids":["https://openalex.org/I4210092257"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100323896","display_name":"Kai Zhang","orcid":"https://orcid.org/0000-0001-7518-5466"},"institutions":[{"id":"https://openalex.org/I24943067","display_name":"Fudan University","ror":"https://ror.org/013q1eq08","country_code":"CN","type":"education","lineage":["https://openalex.org/I24943067"]},{"id":"https://openalex.org/I4210092257","display_name":"China Guangzhou Analysis and Testing Center","ror":"https://ror.org/00d6bjs95","country_code":"CN","type":"other","lineage":["https://openalex.org/I4210092257"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Kai Zhang","raw_affiliation_strings":["School of Computer Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China","institution_ids":["https://openalex.org/I4210092257"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5072790845","display_name":"X. Sean Wang","orcid":"https://orcid.org/0000-0002-9059-3713"},"institutions":[{"id":"https://openalex.org/I24943067","display_name":"Fudan University","ror":"https://ror.org/013q1eq08","country_code":"CN","type":"education","lineage":["https://openalex.org/I24943067"]},{"id":"https://openalex.org/I4210092257","display_name":"China Guangzhou Analysis and Testing Center","ror":"https://ror.org/00d6bjs95","country_code":"CN","type":"other","lineage":["https://openalex.org/I4210092257"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"X. Sean Wang","raw_affiliation_strings":["School of Computer Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Data Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Shanghai Key Laboratory of Computer Software Evaluating and Testing, Shanghai, China","institution_ids":["https://openalex.org/I4210092257"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5102927482"],"corresponding_institution_ids":["https://openalex.org/I24943067","https://openalex.org/I4210092257"],"apc_list":null,"apc_paid":null,"fwci":0.7794,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.72621536,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":"36","issue":"8","first_page":"3977","last_page":"3991"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9144999980926514,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9144999980926514,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.8510143756866455},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7016014456748962},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.5460382699966431},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5116158127784729},{"id":"https://openalex.org/keywords/data-exploration","display_name":"Data exploration","score":0.4994189739227295},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.49070894718170166},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.49042174220085144},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4217711389064789},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3614845275878906},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1766352653503418},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.15729022026062012}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8510143756866455},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7016014456748962},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.5460382699966431},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5116158127784729},{"id":"https://openalex.org/C2780977526","wikidata":"https://www.wikidata.org/wiki/Q42417149","display_name":"Data exploration","level":3,"score":0.4994189739227295},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.49070894718170166},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.49042174220085144},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4217711389064789},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3614845275878906},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1766352653503418},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.15729022026062012}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2024.3361989","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/tkde.2024.3361989","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G7894252150","display_name":null,"funder_award_id":"62072113","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W2572349046","https://openalex.org/W3125756434","https://openalex.org/W2392799717","https://openalex.org/W2026738364","https://openalex.org/W1981131819","https://openalex.org/W2146885082","https://openalex.org/W2124814993","https://openalex.org/W2017989738","https://openalex.org/W2113390685"],"abstract_inverted_index":{"In":[0,75],"the":[1,18,25,34,38,50,56,63,70,91,104,108,118,132,144,150,167,177,185],"interactive":[2],"data":[3,61,171],"exploration,":[4],"approximate":[5],"query":[6,15,35,39,72,82,109,120,133,158,194],"processing":[7],"(AQP)":[8],"can":[9,27,183],"be":[10,28],"used":[11,47],"to":[12,48,55,102,112,116,129,148],"quickly":[13],"return":[14],"results":[16],"at":[17],"cost":[19],"of":[20,60,99,143,153],"accuracy.":[21,195],"For":[22],"online":[23,86,187],"AQP,":[24,42],"sampler":[26,51,105,155],"treated":[29],"as":[30],"an":[31,164],"operator":[32],"in":[33,180,193],"plan.":[36,134],"During":[37],"optimization":[40,66,83],"for":[41,85],"heuristic":[43,64],"rules":[44,101],"are":[45],"usually":[46],"guide":[49,103],"push-down.":[52],"However,":[53],"due":[54],"complexity":[57],"and":[58,95,169],"changes":[59],"distribution,":[62],"rule-based":[65],"methods":[67],"cannot":[68],"meet":[69,117],"users\u2019":[71,119],"accuracy":[73,121],"requirements.":[74],"this":[76,137,181],"article,":[77],"we":[78,123,146],"propose":[79,96,124],"a":[80,97,125],"learning-based":[81],"method":[84,178,190],"AQP.":[87],"We":[88],"first":[89],"introduce":[90],"weak":[92],"equivalence":[93],"concept":[94],"series":[98],"push-down":[100,106,141,156],"during":[107,139],"optimization.":[110],"Then,":[111],"enable":[113],"more":[114],"queries":[115],"requirements,":[122],"deep":[126],"learning":[127],"model":[128,138],"further":[130],"optimize":[131],"By":[135],"using":[136],"each":[140],"process":[142],"sampler,":[145],"try":[147],"avoid":[149],"negative":[151],"effect":[152],"inappropriate":[154],"on":[157],"accuracy,":[159],"especially":[160],"when":[161],"there":[162],"is":[163],"inconsistency":[165],"between":[166],"underlying":[168],"intermediate":[170],"distribution.":[172],"Extensive":[173],"experiments":[174],"show":[175],"that":[176],"proposed":[179],"paper":[182],"outperform":[184],"state-of-the-art":[186],"sampling-based":[188],"AQP":[189],"by":[191],"1.2\u00d7\u22127.9\u00d7":[192]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}