{"id":"https://openalex.org/W4399175354","doi":"https://doi.org/10.1145/3654955","title":"Materialized View Selection & View-Based Query Planning for Regular Path Queries","display_name":"Materialized View Selection & View-Based Query Planning for Regular Path Queries","publication_year":2024,"publication_date":"2024-05-29","ids":{"openalex":"https://openalex.org/W4399175354","doi":"https://doi.org/10.1145/3654955"},"language":"en","primary_location":{"id":"doi:10.1145/3654955","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3654955","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/A5101993309","display_name":"Yue Pang","orcid":"https://orcid.org/0000-0003-3575-8236"},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yue Pang","raw_affiliation_strings":["Peking University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Peking University, Beijing, China","institution_ids":["https://openalex.org/I20231570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033785339","display_name":"Lei Zou","orcid":"https://orcid.org/0000-0002-8586-4400"},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lei Zou","raw_affiliation_strings":["Peking University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Peking University, Beijing, China","institution_ids":["https://openalex.org/I20231570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075642293","display_name":"Jeffrey Xu Yu","orcid":"https://orcid.org/0000-0002-9738-827X"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"HK","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Jeffrey Xu Yu","raw_affiliation_strings":["Chinese University of Hong Kong, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"Chinese University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I177725633"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102777177","display_name":"Linglin Yang","orcid":"https://orcid.org/0000-0001-9480-6088"},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Linglin Yang","raw_affiliation_strings":["Peking University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Peking University, Beijing, China","institution_ids":["https://openalex.org/I20231570"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5101993309"],"corresponding_institution_ids":["https://openalex.org/I20231570"],"apc_list":null,"apc_paid":null,"fwci":1.0267,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.74136287,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":97},"biblio":{"volume":"2","issue":"3","first_page":"1","last_page":"26"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994000196456909,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994000196456909,"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/T10720","display_name":"Complexity and Algorithms in Graphs","score":0.9961000084877014,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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.9948999881744385,"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/materialized-view","display_name":"Materialized view","score":0.9242866039276123},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8123824596405029},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6293773651123047},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.5517527461051941},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.5097853541374207},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.5014669895172119},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.47881585359573364},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.4745907485485077},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.4684978127479553},{"id":"https://openalex.org/keywords/path-expression","display_name":"Path expression","score":0.4414557218551636},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4378061294555664},{"id":"https://openalex.org/keywords/path","display_name":"Path (computing)","score":0.434232622385025},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.41882503032684326},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.41066351532936096},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.3901531398296356},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.3814195990562439},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.36775246262550354},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3657311797142029},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.3478407859802246},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3305298686027527},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.22572433948516846},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.16231414675712585},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.13385319709777832},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10433304309844971}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9242866039276123},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8123824596405029},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6293773651123047},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.5517527461051941},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.5097853541374207},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.5014669895172119},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.47881585359573364},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.4745907485485077},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.4684978127479553},{"id":"https://openalex.org/C61114434","wikidata":"https://www.wikidata.org/wiki/Q7144649","display_name":"Path expression","level":3,"score":0.4414557218551636},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4378061294555664},{"id":"https://openalex.org/C2777735758","wikidata":"https://www.wikidata.org/wiki/Q817765","display_name":"Path (computing)","level":2,"score":0.434232622385025},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.41882503032684326},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.41066351532936096},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3901531398296356},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.3814195990562439},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36775246262550354},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3657311797142029},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3478407859802246},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3305298686027527},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.22572433948516846},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.16231414675712585},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13385319709777832},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10433304309844971},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3654955","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3654955","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":[{"id":"https://openalex.org/G1501220941","display_name":null,"funder_award_id":"U20A20174, 61932001","funder_id":"https://openalex.org/F4320323817","funder_display_name":"Universitas Brawijaya"},{"id":"https://openalex.org/G1680206031","display_name":null,"funder_award_id":"2023YFB4502303","funder_id":"https://openalex.org/F4320323817","funder_display_name":"Universitas Brawijaya"}],"funders":[{"id":"https://openalex.org/F4320323817","display_name":"Universitas Brawijaya","ror":"https://ror.org/01wk3d929"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W41893858","https://openalex.org/W155417673","https://openalex.org/W1680189815","https://openalex.org/W2003652380","https://openalex.org/W2047809518","https://openalex.org/W2080133951","https://openalex.org/W2084151364","https://openalex.org/W2442049918","https://openalex.org/W2460786665","https://openalex.org/W2539350173","https://openalex.org/W2572635540","https://openalex.org/W2613189058","https://openalex.org/W2614759802","https://openalex.org/W2795067919","https://openalex.org/W2890592029","https://openalex.org/W2948412143","https://openalex.org/W2951321531","https://openalex.org/W2981117684","https://openalex.org/W3214396411","https://openalex.org/W4211142834","https://openalex.org/W4281666535","https://openalex.org/W4289646351","https://openalex.org/W4379280658"],"related_works":["https://openalex.org/W2382405670","https://openalex.org/W2403864397","https://openalex.org/W2992414350","https://openalex.org/W2955368753","https://openalex.org/W2549774162","https://openalex.org/W2249768123","https://openalex.org/W2294818385","https://openalex.org/W175663584","https://openalex.org/W2186907183","https://openalex.org/W1564408968"],"abstract_inverted_index":{"A":[0],"regular":[1,19],"path":[2,11],"query":[3,63,103,132,165],"(RPQ)":[4],"returns":[5],"node":[6],"pairs":[7],"connected":[8],"by":[9],"a":[10,22,66,136,159],"whose":[12],"edge":[13],"label":[14],"sequence":[15],"satisfies":[16],"the":[17,27,39,43,50,60,71,87,92,101,107,111,121,154,163,173],"given":[18],"expression.":[20],"Given":[21],"workload":[23,62],"of":[24],"RPQs,":[25,145],"selecting":[26],"shared":[28],"subqueries":[29],"as":[30,58,100],"materialized":[31,51],"views":[32,174],"to":[33,117,153,169],"precompute":[34],"offline":[35],"can":[36],"speed":[37],"up":[38],"online":[40],"processing.":[41],"Since":[42],"available":[44],"memory":[45,67],"is":[46],"limited,":[47],"we":[48,74,90,134],"define":[49],"view":[52,119,128],"selection":[53],"(MVS)":[54],"problem":[55],"for":[56,106,143],"RPQs":[57],"minimizing":[59],"total":[61,164],"cost":[64,138],"within":[65],"budget.":[68],"To":[69,83,130],"tackle":[70],"problem's":[72],"NP-hardness,":[73],"design":[75,135],"an":[76],"efficient":[77],"MVS":[78],"algorithm":[79],"based":[80],"on":[81],"heuristics.":[82],"prevent":[84],"redundancies":[85],"in":[86,162],"selected":[88],"views,":[89],"devise":[91],"AND-OR":[93],"directed":[94],"acyclic":[95],"graph":[96],"with":[97],"closure":[98],"(AODC)":[99],"multi-RPQ":[102],"plan":[104],"representation":[105],"workload,":[108],"which":[109],"encodes":[110],"relations":[112],"between":[113],"subqueries.":[114],"In":[115],"addition":[116],"detecting":[118],"redundancy,":[120],"AODC":[122],"also":[123],"incrementally":[124],"updates":[125],"itself":[126],"during":[127],"selection.":[129],"support":[131],"planning,":[133],"scalable":[137],"and":[139],"cardinality":[140],"estimation":[141],"scheme":[142],"full-fledged":[144],"including":[146],"Kleene":[147],"closures.":[148],"Our":[149],"method,":[150],"when":[151],"applied":[152],"Wikidata":[155],"Query":[156],"Logs,":[157],"shows":[158],"9.73\u00d7":[160],"speedup":[161],"processing":[166],"time":[167],"compared":[168],"ad-hoc":[170],"processing,":[171],"using":[172],"it":[175],"selects.":[176]},"counts_by_year":[{"year":2025,"cited_by_count":3}],"updated_date":"2026-04-09T08:11:56.329763","created_date":"2025-10-10T00:00:00"}