{"id":"https://openalex.org/W4392453910","doi":"https://doi.org/10.14778/3636218.3636235","title":"A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies","display_name":"A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies","publication_year":2023,"publication_date":"2023-12-01","ids":{"openalex":"https://openalex.org/W4392453910","doi":"https://doi.org/10.14778/3636218.3636235"},"language":"en","primary_location":{"id":"doi:10.14778/3636218.3636235","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3636218.3636235","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/A5101769297","display_name":"Yue Zhao","orcid":"https://orcid.org/0009-0000-7161-1421"},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"education","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Yue Zhao","raw_affiliation_strings":["Nanyang Technological University"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University","institution_ids":["https://openalex.org/I172675005"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102569669","display_name":"Zhaodonghui Li","orcid":"https://orcid.org/0009-0005-9078-843X"},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"education","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Zhaodonghui Li","raw_affiliation_strings":["Nanyang Technological University"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University","institution_ids":["https://openalex.org/I172675005"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5045198704","display_name":"Gao Cong","orcid":"https://orcid.org/0000-0002-4430-6373"},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"education","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Gao Cong","raw_affiliation_strings":["Nanyang Technological University"],"affiliations":[{"raw_affiliation_string":"Nanyang Technological University","institution_ids":["https://openalex.org/I172675005"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5101769297"],"corresponding_institution_ids":["https://openalex.org/I172675005"],"apc_list":null,"apc_paid":null,"fwci":2.0175,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.87882537,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"17","issue":"4","first_page":"823","last_page":"835"},"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.9990000128746033,"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.9990000128746033,"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.9983000159263611,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9959999918937683,"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/component","display_name":"Component (thermodynamics)","score":0.6452414989471436},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6417988538742065},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.5647242665290833},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4648166298866272},{"id":"https://openalex.org/keywords/political-science","display_name":"Political science","score":0.04918298125267029},{"id":"https://openalex.org/keywords/physics","display_name":"Physics","score":0.042311638593673706}],"concepts":[{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.6452414989471436},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6417988538742065},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.5647242665290833},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4648166298866272},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.04918298125267029},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.042311638593673706},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","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/C97355855","wikidata":"https://www.wikidata.org/wiki/Q11473","display_name":"Thermodynamics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3636218.3636235","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3636218.3636235","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":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W1991271936","https://openalex.org/W2071009745","https://openalex.org/W2122816893","https://openalex.org/W2132525863","https://openalex.org/W2133741724","https://openalex.org/W2154888102","https://openalex.org/W2158237121","https://openalex.org/W2396309311","https://openalex.org/W2911464154","https://openalex.org/W2944240329","https://openalex.org/W2970148517","https://openalex.org/W2998249308","https://openalex.org/W3011998105","https://openalex.org/W3025775630","https://openalex.org/W3095166039","https://openalex.org/W3099273181","https://openalex.org/W3105457604","https://openalex.org/W3111141572","https://openalex.org/W3129744650","https://openalex.org/W3165842875","https://openalex.org/W4206830372","https://openalex.org/W4226086155","https://openalex.org/W4283326127"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2478288626","https://openalex.org/W4391913857","https://openalex.org/W2350741829","https://openalex.org/W2530322880"],"abstract_inverted_index":{"Query":[0],"plan":[1,16,66,123],"is":[2],"widely":[3],"used":[4],"as":[5,18],"input":[6],"in":[7,69,143],"machine":[8],"learning":[9],"for":[10,51,141,152,161],"databases":[11],"(ML4DB)":[12],"research,":[13],"with":[14,40,46],"query":[15,37,65,96,122],"representation":[17,48,67,84,107,124],"a":[19,32,41,52,57,64,70,79,188],"critical":[20,58],"step.":[21],"However,":[22],"existing":[23],"studies":[24],"typically":[25],"focus":[26],"on":[27,82,86,203],"one":[28,172],"task,":[29],"and":[30,95,131,134,197],"propose":[31],"novel":[33],"design":[34,139],"to":[35,191],"represent":[36],"plans":[38],"along":[39],"ML4DB":[42,71,89],"framework,":[43],"without":[44],"comparing":[45],"other":[47],"methods":[49,85,108],"designed":[50],"different":[53,110,144,158],"task.":[54],"This":[55],"raises":[56],"question:":[59],"How":[60],"do":[61,178],"we":[62,77,119],"select":[63],"method":[68],"system?":[72],"To":[73],"address":[74],"this":[75],"question,":[76],"perform":[78],"comparative":[80],"study":[81],"ten":[83],"three":[87],"distinct":[88],"tasks:":[90],"cost":[91,182],"estimation,":[92],"index":[93],"selection":[94],"optimization.":[97],"Our":[98,146],"extensive":[99],"experiments":[100],"not":[101,179],"only":[102,186],"verify":[103],"the":[104,121,136,150,204,207],"interchangeability":[105],"of":[106,138,206],"across":[109],"tasks,":[111],"but":[112,185],"also":[113],"identify":[114],"consistently":[115],"high-performing":[116],"models.":[117],"Further,":[118],"dissect":[120],"into":[125],"two":[126],"core":[127],"components:":[128],"feature":[129],"encoding":[130],"tree":[132,176],"model,":[133],"evaluate":[135],"impact":[137,181],"choices":[140],"each":[142],"scenarios.":[145],"results":[147],"show":[148],"that":[149,175],"findings":[151,160,167,205],"tasks":[153,162],"optimizing":[154,163],"absolute":[155],"errors":[156],"are":[157,200],"from":[159],"relative":[164,193],"errors.":[165],"Some":[166],"challenge":[168],"widely-held":[169],"assumptions,":[170],"i.e.,":[171],"finding":[173],"shows":[174],"models":[177],"significantly":[180],"estimation":[183],"results,":[184],"play":[187],"significant":[189],"role":[190],"optimize":[192],"performance.":[194],"Practical":[195],"guidelines":[196],"future":[198],"directions":[199],"provided":[201],"based":[202],"study.":[208]},"counts_by_year":[{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":4}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}