{"id":"https://openalex.org/W4392498349","doi":"https://doi.org/10.48550/arxiv.2403.01631","title":"TreeTracker Join: Simple, Optimal, Fast","display_name":"TreeTracker Join: Simple, Optimal, Fast","publication_year":2024,"publication_date":"2024-03-03","ids":{"openalex":"https://openalex.org/W4392498349","doi":"https://doi.org/10.48550/arxiv.2403.01631"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2403.01631","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2403.01631","pdf_url":"https://arxiv.org/pdf/2403.01631","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"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2403.01631","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5094078170","display_name":"Zeyuan Hu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hu, Zeyuan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Wang, Yisu Remy","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wang, Yisu Remy","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Miranker, Daniel P.","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Miranker, Daniel P.","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13999","display_name":"Digital Rights Management and Security","score":0.0737999975681305,"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"}},"topics":[{"id":"https://openalex.org/T13999","display_name":"Digital Rights Management and Security","score":0.0737999975681305,"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/join","display_name":"Join (topology)","score":0.9861453771591187},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6308528184890747},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"Sort-merge join","score":0.4723447561264038},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.39726871252059937},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.182341068983078},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.17232072353363037},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.14617419242858887},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.11003807187080383},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.07189813256263733}],"concepts":[{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.9861453771591187},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6308528184890747},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.4723447561264038},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.39726871252059937},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.182341068983078},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.17232072353363037},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.14617419242858887},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.11003807187080383},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.07189813256263733}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2403.01631","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2403.01631","pdf_url":"https://arxiv.org/pdf/2403.01631","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"},{"id":"doi:10.48550/arxiv.2403.01631","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2403.01631","pdf_url":null,"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":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2403.01631","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2403.01631","pdf_url":"https://arxiv.org/pdf/2403.01631","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":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4392498349.pdf"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2381211091","https://openalex.org/W4205996836","https://openalex.org/W1866159721","https://openalex.org/W2091359263","https://openalex.org/W4234452035","https://openalex.org/W2469706965","https://openalex.org/W1989231289","https://openalex.org/W3033055359","https://openalex.org/W2334867751","https://openalex.org/W4242221889"],"abstract_inverted_index":{"We":[0,110],"present":[1],"a":[2,23,27,123],"novel":[3],"linear-time":[4,56],"acyclic":[5,57,137],"join":[6,21,58,94],"algorithm,":[7,59,61],"TreeTracker":[8],"Join":[9,163],"(TTJ).":[10],"The":[11,143],"algorithm":[12],"can":[13],"be":[14,154],"understood":[15],"as":[16],"the":[17,35,38,41,45,53,64,82,96,104,140,162,167],"pipelined":[18],"binary":[19,92],"hash":[20,28,85,93],"with":[22,149],"simple":[24],"twist:":[25],"upon":[26],"lookup":[29],"failure,":[30,42],"TTJ":[31,62,87],"resets":[32],"execution":[33],"to":[34,52,113,118],"binding":[36],"of":[37,84,103,108,139,155],"tuple":[39,47],"causing":[40],"and":[43,106,135,152,166],"removes":[44],"offending":[46],"from":[48],"its":[49],"relation.":[50],"Compared":[51],"best":[54],"known":[55],"Yannakakis's":[60],"shares":[63],"same":[65,97],"asymptotic":[66],"complexity":[67],"while":[68],"imposing":[69],"lower":[70],"overhead.":[71],"Further,":[72],"we":[73],"prove":[74],"that":[75],"when":[76],"measuring":[77],"query":[78,141],"performance":[79],"by":[80,121],"counting":[81],"number":[83],"probes,":[86],"will":[88],"match":[89],"or":[90],"outperform":[91],"on":[95,160],"plan.":[98],"This":[99],"property":[100],"holds":[101],"independently":[102,107],"plan":[105],"acyclicity.":[109],"are":[111],"able":[112],"extend":[114],"our":[115],"theoretical":[116],"results":[117,159],"cyclic":[119],"queries":[120],"introducing":[122],"new":[124],"hypergraph":[125],"decomposition":[126,151],"method":[127,144],"called":[128],"tree":[129,150],"convolution.":[130],"Tree":[131],"convolution":[132],"iteratively":[133],"identifies":[134],"contracts":[136],"subgraphs":[138],"hypergraph.":[142],"avoids":[145],"redundant":[146],"calculations":[147],"associated":[148],"may":[153],"independent":[156],"interest.":[157],"Empirical":[158],"TPC-H,":[161],"Order":[164],"Benchmark,":[165],"Star":[168],"Schema":[169],"Benchmark":[170],"demonstrate":[171],"favorable":[172],"results.":[173]},"counts_by_year":[],"updated_date":"2026-07-03T08:13:44.112507","created_date":"2024-03-07T00:00:00"}