{"id":"https://openalex.org/W4415723230","doi":"https://doi.org/10.1145/3774325","title":"TreeTracker Join: Simple, Optimal, Fast","display_name":"TreeTracker Join: Simple, Optimal, Fast","publication_year":2025,"publication_date":"2025-10-31","ids":{"openalex":"https://openalex.org/W4415723230","doi":"https://doi.org/10.1145/3774325"},"language":"en","primary_location":{"id":"doi:10.1145/3774325","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3774325","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1145/3774325","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5057474488","display_name":"Zeyuan Hu","orcid":"https://orcid.org/0000-0003-3036-2777"},"institutions":[{"id":"https://openalex.org/I86519309","display_name":"The University of Texas at Austin","ror":"https://ror.org/00hj54h04","country_code":"US","type":"education","lineage":["https://openalex.org/I86519309"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zeyuan Hu","raw_affiliation_strings":["The University of Texas at Austin"],"raw_orcid":"https://orcid.org/0000-0003-3036-2777","affiliations":[{"raw_affiliation_string":"The University of Texas at Austin","institution_ids":["https://openalex.org/I86519309"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042994585","display_name":"Yisu Remy Wang","orcid":"https://orcid.org/0000-0002-6887-9395"},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yisu Remy Wang","raw_affiliation_strings":["Computer Science, University of California, Los Angeles"],"raw_orcid":"https://orcid.org/0000-0002-6887-9395","affiliations":[{"raw_affiliation_string":"Computer Science, University of California, Los Angeles","institution_ids":["https://openalex.org/I161318765"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5083499808","display_name":"Daniel P. Miranker","orcid":"https://orcid.org/0009-0003-8838-2890"},"institutions":[{"id":"https://openalex.org/I86519309","display_name":"The University of Texas at Austin","ror":"https://ror.org/00hj54h04","country_code":"US","type":"education","lineage":["https://openalex.org/I86519309"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Daniel P Miranker","raw_affiliation_strings":["The University of Texas at Austin"],"raw_orcid":"https://orcid.org/0009-0003-8838-2890","affiliations":[{"raw_affiliation_string":"The University of Texas at Austin","institution_ids":["https://openalex.org/I86519309"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.14941582,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"51","issue":"2","first_page":"1","last_page":"26"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.4577000141143799,"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"}},"topics":[{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.4577000141143799,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.11819999665021896,"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/T10627","display_name":"Advanced Image and Video Retrieval Techniques","score":0.11490000039339066,"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/hash-join","display_name":"Hash join","score":0.8341000080108643},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"Sort-merge join","score":0.6644999980926514},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.6337000131607056},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6053000092506409},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5561000108718872},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5044000148773193},{"id":"https://openalex.org/keywords/hash-table","display_name":"Hash table","score":0.44190001487731934},{"id":"https://openalex.org/keywords/hash-tree","display_name":"Hash tree","score":0.414000004529953},{"id":"https://openalex.org/keywords/binary-tree","display_name":"Binary tree","score":0.3937999904155731},{"id":"https://openalex.org/keywords/hypergraph","display_name":"Hypergraph","score":0.3718999922275543}],"concepts":[{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.8341000080108643},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.785099983215332},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.6644999980926514},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.6337000131607056},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6053000092506409},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5561000108718872},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5203999876976013},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5044000148773193},{"id":"https://openalex.org/C67388219","wikidata":"https://www.wikidata.org/wiki/Q207440","display_name":"Hash table","level":3,"score":0.44190001487731934},{"id":"https://openalex.org/C27353603","wikidata":"https://www.wikidata.org/wiki/Q16948622","display_name":"Hash tree","level":4,"score":0.414000004529953},{"id":"https://openalex.org/C197855036","wikidata":"https://www.wikidata.org/wiki/Q380172","display_name":"Binary tree","level":2,"score":0.3937999904155731},{"id":"https://openalex.org/C2781221856","wikidata":"https://www.wikidata.org/wiki/Q840247","display_name":"Hypergraph","level":2,"score":0.3718999922275543},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.35899999737739563},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.34790000319480896},{"id":"https://openalex.org/C48372109","wikidata":"https://www.wikidata.org/wiki/Q3913","display_name":"Binary number","level":2,"score":0.3465000092983246},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.3328000009059906},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.32350000739097595},{"id":"https://openalex.org/C140745168","wikidata":"https://www.wikidata.org/wiki/Q1210082","display_name":"Tree traversal","level":2,"score":0.3028999865055084},{"id":"https://openalex.org/C24755975","wikidata":"https://www.wikidata.org/wiki/Q4943354","display_name":"Boolean conjunctive query","level":5,"score":0.29330000281333923},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.29100000858306885},{"id":"https://openalex.org/C87431388","wikidata":"https://www.wikidata.org/wiki/Q2070573","display_name":"Perfect hash function","level":4,"score":0.28929999470710754},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.28679999709129333},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.28220000863075256},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.28060001134872437},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.2750999927520752},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.27219998836517334},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.26910001039505005},{"id":"https://openalex.org/C179799912","wikidata":"https://www.wikidata.org/wiki/Q205084","display_name":"Computational complexity theory","level":2,"score":0.265500009059906},{"id":"https://openalex.org/C163797641","wikidata":"https://www.wikidata.org/wiki/Q2067937","display_name":"Tree structure","level":3,"score":0.2644999921321869},{"id":"https://openalex.org/C2779190172","wikidata":"https://www.wikidata.org/wiki/Q4913888","display_name":"Binary data","level":3,"score":0.2621999979019165},{"id":"https://openalex.org/C74197172","wikidata":"https://www.wikidata.org/wiki/Q1195339","display_name":"Directed acyclic graph","level":2,"score":0.2547000050544739},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.2522999942302704},{"id":"https://openalex.org/C61114434","wikidata":"https://www.wikidata.org/wiki/Q7144649","display_name":"Path expression","level":3,"score":0.25209999084472656}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3774325","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3774325","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3774325","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3774325","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1979944023","https://openalex.org/W1991477862","https://openalex.org/W2106771621","https://openalex.org/W2151720296","https://openalex.org/W2396309311","https://openalex.org/W2613226836","https://openalex.org/W2963066364","https://openalex.org/W4254380579","https://openalex.org/W4280619330","https://openalex.org/W4312924702","https://openalex.org/W4323343708","https://openalex.org/W4386128208","https://openalex.org/W4402042382","https://openalex.org/W4404167827","https://openalex.org/W4404373436"],"related_works":[],"abstract_inverted_index":{"We":[0,112],"present":[1],"a":[2,25,29,125],"novel":[3],"linear-time":[4,58],"acyclic":[5,59,139],"join":[6,23,60,96],"algorithm,":[7,61,63],"TreeTracker":[8],"Join":[9,165],"(":[10],"TTJ":[11,33,64,89],").":[12],"The":[13,145],"algorithm":[14],"can":[15],"be":[16,156],"understood":[17],"as":[18],"the":[19,37,40,43,47,55,66,84,98,106,142,164,169],"pipelined":[20],"binary":[21,94],"hash":[22,30,87,95],"with":[24,151],"simple":[26],"twist:":[27],"upon":[28],"lookup":[31],"failure,":[32,44],"resets":[34],"execution":[35],"to":[36,54,115,120],"binding":[38],"of":[39,86,105,110,141,157],"tuple":[41,49],"causing":[42],"and":[45,108,137,154,168],"removes":[46],"offending":[48],"from":[50],"its":[51],"relation.":[52],"Compared":[53],"best":[56],"known":[57],"Yannakakis\u2019s":[62],"shares":[65],"same":[67,99],"asymptotic":[68],"complexity":[69],"while":[70],"imposing":[71],"lower":[72],"overhead.":[73],"Further,":[74],"we":[75],"prove":[76],"that":[77],"when":[78],"measuring":[79],"query":[80,143],"performance":[81],"by":[82,123],"counting":[83],"number":[85],"probes,":[88],"will":[90],"match":[91],"or":[92],"outperform":[93],"on":[97,162],"plan.":[100],"This":[101],"property":[102],"holds":[103],"independently":[104,109],"plan":[107],"acyclicity.":[111],"are":[113],"able":[114],"extend":[116],"our":[117],"theoretical":[118],"results":[119,161],"cyclic":[121],"queries":[122],"introducing":[124],"new":[126],"hypergraph":[127],"decomposition":[128,153],"method":[129,146],"called":[130],"tree":[131,152],"convolution.":[132],"Tree":[133],"convolution":[134],"iteratively":[135],"identifies":[136],"contracts":[138],"subgraphs":[140],"hypergraph.":[144],"avoids":[147],"redundant":[148],"calculations":[149],"associated":[150],"may":[155],"independent":[158],"interest.":[159],"Empirical":[160],"TPC-H,":[163],"Order":[166],"Benchmark,":[167],"Star":[170],"Schema":[171],"Benchmark":[172],"demonstrate":[173],"favorable":[174],"results.":[175]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-31T00:00:00"}