{"id":"https://openalex.org/W3107842002","doi":"https://doi.org/10.14778/3425879.3425880","title":"Tsunami: a learned multi-dimensional index for correlated data and skewed workloads","display_name":"Tsunami: a learned multi-dimensional index for correlated data and skewed workloads","alternate_titles":[],"publication_year":2020,"publication_date":"2020-10-01","ids":{"openalex":"https://openalex.org/W3107842002","doi":"https://doi.org/10.14778/3425879.3425880","mag":"3107842002"},"language":"en","primary_location":{"id":"doi:10.14778/3425879.3425880","doi":"https://doi.org/10.14778/3425879.3425880","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3425879.3425880","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-b","norway-2","poland-20","russia-white-list-1","vabb-shw"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W3107842002"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2006.13282","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103942334","display_name":"Jialin Ding","orcid":"https://orcid.org/0009-0002-1772-450X","observed_orcids":["https://orcid.org/0009-0002-1772-450X"]},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Jialin Ding","raw_affiliation_strings":["Massachusetts Insititute of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Massachusetts Insititute of Technology","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5077165909","display_name":"Vikram Nathan","orcid":"https://orcid.org/0000-0003-0189-0271","observed_orcids":["https://orcid.org/0000-0003-0189-0271"]},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Vikram Nathan","raw_affiliation_strings":["Massachusetts Insititute of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Massachusetts Insititute of Technology","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101669321","display_name":"Mohammad Alizadeh","orcid":"https://orcid.org/0000-0002-0014-6742","observed_orcids":["https://orcid.org/0000-0002-0014-6742"]},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Mohammad Alizadeh","raw_affiliation_strings":["Massachusetts Insititute of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Massachusetts Insititute of Technology","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034086130","display_name":"Tim Kraska","orcid":"https://orcid.org/0009-0003-2414-2759","observed_orcids":["https://orcid.org/0009-0003-2414-2759"]},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Tim Kraska","raw_affiliation_strings":["Massachusetts Insititute of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Massachusetts Insititute of Technology","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I63966007"],"apc_list":null,"apc_paid":null,"fwci":12.3628,"has_fulltext":true,"cited_by_count":216,"citation_normalized_percentile":{"value":0.98640281,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":"14","issue":"2","first_page":"74","last_page":"86"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.7300000190734863,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.7300000190734863,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.24779999256134033,"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"}},{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.002300000051036477,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/tsunami","display_name":"tsunami","score":0.6629999876022339},{"id":"https://openalex.org/keywords/correlated-data","display_name":"correlated data","score":0.7450000047683716},{"id":"https://openalex.org/keywords/index-optimization","display_name":"index optimization","score":0.6359999775886536},{"id":"https://openalex.org/keywords/index-size-reduction","display_name":"index size reduction","score":0.5839999914169312},{"id":"https://openalex.org/keywords/query-performance","display_name":"query performance","score":0.35600000619888306}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8547478914260864},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6598449945449829},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.6592708230018616},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.5146394968032837},{"id":"https://openalex.org/C106131492","wikidata":"https://www.wikidata.org/wiki/Q3072260","display_name":"Filter (signal processing)","level":2,"score":0.5106845498085022},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4965832829475403},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.21311751008033752},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.060825884342193604},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.14778/3425879.3425880","doi":"https://doi.org/10.14778/3425879.3425880","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3425879.3425880","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-b","norway-2","poland-20","russia-white-list-1","vabb-shw"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:arXiv.org:2006.13282","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2006.13282","pdf_url":"https://arxiv.org/pdf/2006.13282","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"pmh:oai:dspace.mit.edu:1721.1/132295","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/132295","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"VLDB Endowment","raw_type":"http://purl.org/eprint/type/ConferencePaper"},{"id":"doi:10.48550/arxiv.2006.13282","doi":"https://doi.org/10.48550/arxiv.2006.13282","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2006.13282","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2006.13282","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2006.13282","pdf_url":"https://arxiv.org/pdf/2006.13282","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G21459132","display_name":null,"funder_award_id":"16-43-D3M-FP-040","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G312414007","display_name":"III: Medium: Learning-based Synthesis of Data Processing Engines","funder_award_id":"1900933","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4713059963","display_name":null,"funder_award_id":"FA8750","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3107842002.pdf","grobid_xml":"https://content.openalex.org/works/W3107842002.grobid-xml"},"referenced_works_count":40,"referenced_works":["https://openalex.org/W1510305954","https://openalex.org/W1851390469","https://openalex.org/W1985229168","https://openalex.org/W1994655805","https://openalex.org/W2017052417","https://openalex.org/W2102489964","https://openalex.org/W2106642566","https://openalex.org/W2111687586","https://openalex.org/W2122990007","https://openalex.org/W2125901106","https://openalex.org/W2149173084","https://openalex.org/W2151135734","https://openalex.org/W2159886933","https://openalex.org/W2165558283","https://openalex.org/W2168503413","https://openalex.org/W2752313434","https://openalex.org/W2773466258","https://openalex.org/W2798658665","https://openalex.org/W2799015892","https://openalex.org/W2923407516","https://openalex.org/W2945486614","https://openalex.org/W2948233700","https://openalex.org/W2967734741","https://openalex.org/W2979531022","https://openalex.org/W2987948011","https://openalex.org/W2997027240","https://openalex.org/W2998553639","https://openalex.org/W2999149038","https://openalex.org/W3005310413","https://openalex.org/W3013691234","https://openalex.org/W3020084632","https://openalex.org/W3023346860","https://openalex.org/W3029532343","https://openalex.org/W3029564598","https://openalex.org/W3033065823","https://openalex.org/W3102117087","https://openalex.org/W3106489949","https://openalex.org/W3138367763","https://openalex.org/W7027112824","https://openalex.org/W7096976119"],"related_works":["https://openalex.org/W3029564598","https://openalex.org/W2484289073","https://openalex.org/W54126996","https://openalex.org/W4380551629","https://openalex.org/W7172163248","https://openalex.org/W3112177522","https://openalex.org/W3032112964","https://openalex.org/W4406628711","https://openalex.org/W4405314525","https://openalex.org/W7113576028"],"abstract_inverted_index":{"Filtering":[0],"data":[1,15,87],"based":[2],"on":[3,56],"predicates":[4],"is":[5,52],"one":[6],"of":[7,22,64,78,85,93],"the":[8,20,62,76,83],"most":[9],"fundamental":[10],"operations":[11],"for":[12,36,69],"any":[13],"modern":[14],"warehouse.":[16],"Techniques":[17],"to":[18,47,110,113,120,132,134],"accelerate":[19],"execution":[21],"filter":[23],"expressions":[24],"include":[25],"clustered":[26],"indexes,":[27,34,129],"specialized":[28],"sort":[29],"orders":[30],"(e.g.,":[31],"Z-order),":[32],"multi-dimensional":[33,58,128],"and,":[35],"high":[37],"selectivity":[38],"queries,":[39],"secondary":[40],"indexes.":[41,147],"However,":[42,75],"these":[43,108],"schemes":[44],"are":[45,95],"hard":[46],"tune":[48],"and":[49,73,88,118,139],"their":[50],"performance":[51,77,117,138],"inconsistent.":[53],"Recent":[54],"work":[55,80],"learned":[57,127],"indexes":[59],"has":[60],"introduced":[61],"idea":[63],"automatically":[65],"optimizing":[66],"an":[67],"index":[68,123,142],"a":[70],"particular":[71],"dataset":[72],"workload.":[74],"that":[79],"suffers":[81],"in":[82,97,130],"presence":[84],"correlated":[86],"skewed":[89],"query":[90,116,137],"workloads,":[91],"both":[92],"which":[94,106],"common":[96],"real":[98],"applications.":[99],"In":[100],"this":[101],"paper,":[102],"we":[103],"introduce":[104],"Tsunami,":[105],"addresses":[107],"limitations":[109],"achieve":[111],"up":[112,119,133],"6X":[114],"faster":[115,136],"8X":[121],"smaller":[122,141],"size":[124,143],"than":[125,144],"existing":[126],"addition":[131],"11X":[135],"170X":[140],"optimally-tuned":[145],"traditional":[146]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3107842002","counts_by_year":[{"year":2026,"cited_by_count":44},{"year":2025,"cited_by_count":42},{"year":2024,"cited_by_count":45},{"year":2023,"cited_by_count":39},{"year":2022,"cited_by_count":25},{"year":2021,"cited_by_count":17},{"year":2020,"cited_by_count":4}],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2020-12-07T00:00:00"}
