{"id":"https://openalex.org/W4365600826","doi":"https://doi.org/10.1145/3584372.3588675","title":"Space-Time Tradeoffs for Conjunctive Queries with Access Patterns","display_name":"Space-Time Tradeoffs for Conjunctive Queries with Access Patterns","publication_year":2023,"publication_date":"2023-06-02","ids":{"openalex":"https://openalex.org/W4365600826","doi":"https://doi.org/10.1145/3584372.3588675"},"language":"en","primary_location":{"id":"doi:10.1145/3584372.3588675","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3584372.3588675","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2304.06221","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5000969697","display_name":"Hangdong Zhao","orcid":"https://orcid.org/0009-0009-7636-0831"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Hangdong Zhao","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, WI, USA"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036934715","display_name":"Shaleen Deep","orcid":"https://orcid.org/0000-0003-2342-4060"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shaleen Deep","raw_affiliation_strings":["Microsoft Gray Systems Lab, Madison, WI, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Gray Systems Lab, Madison, WI, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5040506752","display_name":"Paraschos Koutris","orcid":"https://orcid.org/0000-0001-6309-1702"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Paraschos Koutris","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, WI, USA"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5000969697"],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":0.807,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.72283025,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"59","last_page":"68"},"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.9998000264167786,"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.9998000264167786,"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.9997000098228455,"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/T11269","display_name":"Algorithms and Data Compression","score":0.996399998664856,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8090229630470276},{"id":"https://openalex.org/keywords/reachability","display_name":"Reachability","score":0.5940725207328796},{"id":"https://openalex.org/keywords/preprocessor","display_name":"Preprocessor","score":0.581038236618042},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.5784095525741577},{"id":"https://openalex.org/keywords/path","display_name":"Path (computing)","score":0.4934498369693756},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.49325722455978394},{"id":"https://openalex.org/keywords/decomposition","display_name":"Decomposition","score":0.4878571033477783},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.46651995182037354},{"id":"https://openalex.org/keywords/space","display_name":"Space (punctuation)","score":0.4493348300457001},{"id":"https://openalex.org/keywords/state","display_name":"State (computer science)","score":0.44247370958328247},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.4412154257297516},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.43303295969963074},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3880261480808258},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.15109017491340637},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.14006057381629944},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.10207042098045349},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.09432435035705566}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8090229630470276},{"id":"https://openalex.org/C136643341","wikidata":"https://www.wikidata.org/wiki/Q1361526","display_name":"Reachability","level":2,"score":0.5940725207328796},{"id":"https://openalex.org/C34736171","wikidata":"https://www.wikidata.org/wiki/Q918333","display_name":"Preprocessor","level":2,"score":0.581038236618042},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.5784095525741577},{"id":"https://openalex.org/C2777735758","wikidata":"https://www.wikidata.org/wiki/Q817765","display_name":"Path (computing)","level":2,"score":0.4934498369693756},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.49325722455978394},{"id":"https://openalex.org/C124681953","wikidata":"https://www.wikidata.org/wiki/Q339062","display_name":"Decomposition","level":2,"score":0.4878571033477783},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.46651995182037354},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.4493348300457001},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.44247370958328247},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4412154257297516},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.43303295969963074},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3880261480808258},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.15109017491340637},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.14006057381629944},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10207042098045349},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.09432435035705566},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"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/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3584372.3588675","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3584372.3588675","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2304.06221","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2304.06221","pdf_url":"https://arxiv.org/pdf/2304.06221","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2304.06221","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2304.06221","pdf_url":"https://arxiv.org/pdf/2304.06221","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[{"score":0.5,"display_name":"Partnerships for the goals","id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4365600826.pdf"},"referenced_works_count":34,"referenced_works":["https://openalex.org/W55870569","https://openalex.org/W161072239","https://openalex.org/W1579803282","https://openalex.org/W1982358125","https://openalex.org/W2031683606","https://openalex.org/W2035744833","https://openalex.org/W2045201280","https://openalex.org/W2050100848","https://openalex.org/W2093149131","https://openalex.org/W2108166877","https://openalex.org/W2143238590","https://openalex.org/W2147045484","https://openalex.org/W2150004999","https://openalex.org/W2161956202","https://openalex.org/W2336190256","https://openalex.org/W2536131596","https://openalex.org/W2580647187","https://openalex.org/W2585424461","https://openalex.org/W2592257482","https://openalex.org/W2612777267","https://openalex.org/W2680551515","https://openalex.org/W2795570227","https://openalex.org/W2963448011","https://openalex.org/W2963560792","https://openalex.org/W3028618047","https://openalex.org/W3030422499","https://openalex.org/W3105352315","https://openalex.org/W3106319426","https://openalex.org/W3121092302","https://openalex.org/W4252462081","https://openalex.org/W4283329535","https://openalex.org/W4315588959","https://openalex.org/W6685326043","https://openalex.org/W6721489668"],"related_works":["https://openalex.org/W2127267268","https://openalex.org/W2136512912","https://openalex.org/W2067910792","https://openalex.org/W2156446763","https://openalex.org/W2150194458","https://openalex.org/W2143461633","https://openalex.org/W4321471459","https://openalex.org/W2889071233","https://openalex.org/W2380814829","https://openalex.org/W2387511021"],"abstract_inverted_index":{"In":[0],"this":[1],"paper,":[2],"we":[3,120],"investigate":[4],"space-time":[5,87],"tradeoffs":[6,88,111,127],"for":[7,32,51,54,85,89,116,133],"answering":[8,33,52],"conjunctive":[9],"queries":[10,35,55],"with":[11],"access":[12],"patterns":[13],"(CQAPs).":[14],"The":[15],"goal":[16],"is":[17,80],"to":[18],"create":[19],"a":[20,70,81],"space-efficient":[21],"data":[22,44],"structure":[23],"in":[24,36,129],"an":[25,37],"initial":[26],"preprocessing":[27],"phase":[28],"and":[29,63,73,99],"use":[30],"it":[31],"(multiple)":[34],"online":[38],"phase.":[39],"Previous":[40],"work":[41],"has":[42],"developed":[43],"structures":[45],"that":[46,105,112],"trades":[47],"off":[48],"space":[49],"usage":[50],"time":[53],"of":[56],"practical":[57],"interest,":[58],"such":[59],"as":[60],"the":[61,96,125,130],"path":[62],"triangle":[64],"query.":[65],"However,":[66],"these":[67],"approaches":[68],"lack":[69],"comprehensive":[71],"framework":[72,84,93,107],"are":[74],"not":[75],"generalizable.":[76],"Our":[77,92],"main":[78],"contribution":[79],"general":[82],"algorithmic":[83],"obtaining":[86],"any":[90],"CQAP.":[91],"builds":[94],"upon":[95],"PANDA":[97],"algorithm":[98],"tree":[100],"decomposition":[101],"techniques.":[102],"We":[103],"demonstrate":[104],"our":[106],"captures":[108],"all":[109],"state-of-the-art":[110,126],"were":[113],"independently":[114],"produced":[115],"various":[117],"queries.":[118,135],"Further,":[119],"show":[121],"surprising":[122],"improvements":[123],"over":[124],"known":[128],"existing":[131],"literature":[132],"reachability":[134]},"counts_by_year":[{"year":2025,"cited_by_count":4}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}