{"id":"https://openalex.org/W4405623369","doi":"https://doi.org/10.1145/3698828","title":"Towards a Converged Relational-Graph Optimization Framework","display_name":"Towards a Converged Relational-Graph Optimization Framework","publication_year":2024,"publication_date":"2024-12-18","ids":{"openalex":"https://openalex.org/W4405623369","doi":"https://doi.org/10.1145/3698828"},"language":"en","primary_location":{"id":"doi:10.1145/3698828","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3698828","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","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/A5009873965","display_name":"Yunkai Lou","orcid":"https://orcid.org/0000-0002-9427-3012"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yunkai Lou","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"raw_orcid":"https://orcid.org/0000-0002-9427-3012","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103178004","display_name":"Longbin Lai","orcid":"https://orcid.org/0009-0009-4735-3835"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Longbin Lai","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0009-4735-3835","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058153334","display_name":"Bingqing Lyu","orcid":"https://orcid.org/0000-0002-6795-9262"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bingqing Lyu","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"raw_orcid":"https://orcid.org/0000-0002-6795-9262","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5115604022","display_name":"Y Yang","orcid":"https://orcid.org/0009-0006-9397-9458"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yufan Yang","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0006-9397-9458","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051517472","display_name":"Xiaoli Zhou","orcid":"https://orcid.org/0009-0001-1687-4621"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"XiaoLi Zhou","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0001-1687-4621","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018856303","display_name":"Wenyuan Yu","orcid":"https://orcid.org/0009-0006-5641-2452"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wenyuan Yu","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0006-5641-2452","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100386104","display_name":"Ying Zhang","orcid":"https://orcid.org/0000-0002-2674-1638"},"institutions":[{"id":"https://openalex.org/I75059550","display_name":"Zhejiang Gongshang University","ror":"https://ror.org/0569mkk41","country_code":"CN","type":"education","lineage":["https://openalex.org/I75059550"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ying Zhang","raw_affiliation_strings":["Zhejiang Gongshang University, Hangzhou, China"],"raw_orcid":"https://orcid.org/0000-0002-2674-1638","affiliations":[{"raw_affiliation_string":"Zhejiang Gongshang University, Hangzhou, China","institution_ids":["https://openalex.org/I75059550"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057864403","display_name":"Jingren Zhou","orcid":"https://orcid.org/0000-0002-4220-2634"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jingren Zhou","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"raw_orcid":"https://orcid.org/0000-0002-4220-2634","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.8175,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.74489577,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"2","issue":"6","first_page":"1","last_page":"27"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":1.0,"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"}},"topics":[{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":1.0,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.998199999332428,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.996999979019165,"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.8473426103591919},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.746271014213562},{"id":"https://openalex.org/keywords/graph-database","display_name":"Graph database","score":0.6502811908721924},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.608075737953186},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.5336862802505493},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5096426010131836},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.48542532324790955},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.442441463470459},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.4370790719985962},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3441622853279114},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.24659445881843567},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.1612197458744049}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8473426103591919},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.746271014213562},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.6502811908721924},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.608075737953186},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.5336862802505493},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5096426010131836},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.48542532324790955},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.442441463470459},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4370790719985962},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3441622853279114},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.24659445881843567},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.1612197458744049}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3698828","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3698828","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","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":34,"referenced_works":["https://openalex.org/W1837083","https://openalex.org/W135863099","https://openalex.org/W1991271936","https://openalex.org/W2028705450","https://openalex.org/W2035173902","https://openalex.org/W2066623874","https://openalex.org/W2079806729","https://openalex.org/W2100387739","https://openalex.org/W2126359798","https://openalex.org/W2140840007","https://openalex.org/W2232813226","https://openalex.org/W2396309311","https://openalex.org/W2421547754","https://openalex.org/W2423652555","https://openalex.org/W2579169324","https://openalex.org/W2734941459","https://openalex.org/W2916456461","https://openalex.org/W2963066364","https://openalex.org/W2965179470","https://openalex.org/W2970204999","https://openalex.org/W3002980296","https://openalex.org/W3013082216","https://openalex.org/W3030639942","https://openalex.org/W3094660140","https://openalex.org/W3116457585","https://openalex.org/W3137504194","https://openalex.org/W3171879699","https://openalex.org/W3193493045","https://openalex.org/W4290878206","https://openalex.org/W4380433183","https://openalex.org/W4381327058","https://openalex.org/W4386768611","https://openalex.org/W4405623369","https://openalex.org/W6605485969"],"related_works":["https://openalex.org/W1982455124","https://openalex.org/W2505630977","https://openalex.org/W1497653608","https://openalex.org/W2383709723","https://openalex.org/W2015932315","https://openalex.org/W2573939812","https://openalex.org/W45850614","https://openalex.org/W2120098008","https://openalex.org/W1575529579","https://openalex.org/W3022423983"],"abstract_inverted_index":{"The":[0],"recent":[1],"ISO":[2],"SQL:2023":[3],"standard":[4],"adopts":[5],"SQL/PGQ":[6,28],"(Property":[7],"Graph":[8],"Queries),":[9],"facilitating":[10],"graph-like":[11],"querying":[12],"within":[13,30],"relational":[14,31,74,118,128],"databases.":[15],"This":[16],"advancement,":[17],"however,":[18],"underscores":[19],"a":[20,82,102],"significant":[21],"gap":[22],"in":[23,59,93],"how":[24],"to":[25,45,67,86,156],"effectively":[26],"optimize":[27],"queries":[29,44,63,69],"database":[32],"systems.":[33],"To":[34,96],"address":[35,97],"this":[36,98],"gap,":[37],"we":[38,100],"extend":[39],"the":[40,94,126,160],"foundational":[41],"SPJ":[42,68],"(Select-Project-Join)":[43],"SPJM":[46,62,111,142],"queries,":[47,112],"which":[48],"include":[49],"an":[50,150],"additional":[51],"matching":[52,58],"operator":[53],"for":[54,109,141],"representing":[55],"graph":[56,120],"pattern":[57],"SQL/PGQ.":[60],"Although":[61],"can":[64,136],"be":[65],"converted":[66],"and":[70,119],"optimized":[71],"using":[72],"existing":[73],"query":[75,121],"optimizers,":[76],"our":[77,131],"analysis":[78],"shows":[79],"that":[80,134],"such":[81],"graph-agnostic":[83,161],"method":[84],"fails":[85],"benefit":[87],"from":[88,116],"graph-specific":[89],"optimization":[90,105],"techniques":[91],"found":[92],"literature.":[95],"issue,":[99],"develop":[101],"converged":[103],"relational-graph":[104],"framework":[106],"called":[107],"RelGo":[108,135],"optimizing":[110],"leveraging":[113],"joint":[114],"efforts":[115],"both":[117],"optimizations.":[122],"Using":[123],"DuckDB":[124],"as":[125],"underlying":[127],"execution":[129,139],"engine,":[130],"experiments":[132],"show":[133],"generate":[137],"efficient":[138],"plans":[140,148],"queries.":[143],"On":[144],"well-established":[145],"benchmarks,":[146],"these":[147],"exhibit":[149],"average":[151],"speedup":[152],"of":[153],"21.90x":[154],"compared":[155],"those":[157],"produced":[158],"by":[159],"optimizer.":[162]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}