{"id":"https://openalex.org/W2948233700","doi":"https://doi.org/10.1145/3299869.3319860","title":"FITing-Tree","display_name":"FITing-Tree","publication_year":2019,"publication_date":"2019-06-18","ids":{"openalex":"https://openalex.org/W2948233700","doi":"https://doi.org/10.1145/3299869.3319860","mag":"2948233700"},"language":"en","primary_location":{"id":"doi:10.1145/3299869.3319860","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3299869.3319860","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1801.10207","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Alex Galakatos","orcid":null},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Alex Galakatos","raw_affiliation_strings":["Brown University, Providence, RI, USA"],"affiliations":[{"raw_affiliation_string":"Brown University, Providence, RI, USA","institution_ids":["https://openalex.org/I27804330"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Michael Markovitch","orcid":null},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael Markovitch","raw_affiliation_strings":["Brown University, Providence, RI, USA"],"affiliations":[{"raw_affiliation_string":"Brown University, Providence, RI, USA","institution_ids":["https://openalex.org/I27804330"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Carsten Binnig","orcid":null},"institutions":[{"id":"https://openalex.org/I31512782","display_name":"Technical University of Darmstadt","ror":"https://ror.org/05n911h24","country_code":"DE","type":"education","lineage":["https://openalex.org/I31512782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Carsten Binnig","raw_affiliation_strings":["TU Darmstadt, Darmstadt, Germany"],"affiliations":[{"raw_affiliation_string":"TU Darmstadt, Darmstadt, Germany","institution_ids":["https://openalex.org/I31512782"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Rodrigo Fonseca","orcid":null},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rodrigo Fonseca","raw_affiliation_strings":["Brown University, Providence, RI, USA"],"affiliations":[{"raw_affiliation_string":"Brown University, Providence, RI, USA","institution_ids":["https://openalex.org/I27804330"]}]},{"author_position":"last","author":{"id":null,"display_name":"Tim Kraska","orcid":null},"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,"raw_author_name":"Tim Kraska","raw_affiliation_strings":["Massachusetts Institute of Technology, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, Cambridge, MA, USA","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I27804330"],"apc_list":null,"apc_paid":null,"fwci":13.1842,"has_fulltext":false,"cited_by_count":180,"citation_normalized_percentile":{"value":0.98999381,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"1189","last_page":"1206"},"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.9991999864578247,"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.9991999864578247,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9991999864578247,"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/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/leverage","display_name":"Leverage (statistics)","score":0.5455999970436096},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4848000109195709},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.4620000123977661},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.4408999979496002},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.38670000433921814},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.37299999594688416},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.3700000047683716},{"id":"https://openalex.org/keywords/error-detection-and-correction","display_name":"Error detection and correction","score":0.36559998989105225},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.3630000054836273}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.694599986076355},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.5455999970436096},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4848000109195709},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.4620000123977661},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.450300008058548},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.4408999979496002},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.38670000433921814},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.37299999594688416},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.3700000047683716},{"id":"https://openalex.org/C103088060","wikidata":"https://www.wikidata.org/wiki/Q1062839","display_name":"Error detection and correction","level":2,"score":0.36559998989105225},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.3630000054836273},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.3529999852180481},{"id":"https://openalex.org/C70388272","wikidata":"https://www.wikidata.org/wiki/Q5968558","display_name":"IBM","level":2,"score":0.33899998664855957},{"id":"https://openalex.org/C74912251","wikidata":"https://www.wikidata.org/wiki/Q6815727","display_name":"Memory footprint","level":2,"score":0.33629998564720154},{"id":"https://openalex.org/C190190378","wikidata":"https://www.wikidata.org/wiki/Q1192625","display_name":"Process capability index","level":3,"score":0.31529998779296875},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.302700012922287},{"id":"https://openalex.org/C34388435","wikidata":"https://www.wikidata.org/wiki/Q2267362","display_name":"Bounded function","level":2,"score":0.29409998655319214},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.2831999957561493},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.2709999978542328},{"id":"https://openalex.org/C102634674","wikidata":"https://www.wikidata.org/wiki/Q868473","display_name":"Smoothness","level":2,"score":0.26589998602867126},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.258899986743927},{"id":"https://openalex.org/C134835016","wikidata":"https://www.wikidata.org/wiki/Q690265","display_name":"Lookup table","level":2,"score":0.25780001282691956},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.25429999828338623}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3299869.3319860","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3299869.3319860","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1801.10207","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1801.10207","pdf_url":"https://arxiv.org/pdf/1801.10207","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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"pmh:oai:tubiblio.ulb.tu-darmstadt.de:119078","is_oa":false,"landing_page_url":"http://tubiblio.ulb.tu-darmstadt.de/119078/","pdf_url":null,"source":{"id":"https://openalex.org/S4377196390","display_name":"TUbilio (Technical University of Darmstadt)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I31512782","host_organization_name":"Technische Universit\u00e4t Darmstadt","host_organization_lineage":["https://openalex.org/I31512782"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Konferenzver\u00f6ffentlichung"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1801.10207","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1801.10207","pdf_url":"https://arxiv.org/pdf/1801.10207","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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G2659989168","display_name":null,"funder_award_id":"IIS-1453171","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2683461770","display_name":null,"funder_award_id":"1514491","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5013058220","display_name":null,"funder_award_id":"1452712","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G562918000","display_name":null,"funder_award_id":"IIS-1514491","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6671297155","display_name":null,"funder_award_id":"CAREER","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8446249152","display_name":"CAREER: Query Compilation Techniques for Complex Analytics on Enterprise Clusters","funder_award_id":"1453171","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W1992891851","https://openalex.org/W1995259821","https://openalex.org/W2003421875","https://openalex.org/W2008627910","https://openalex.org/W2025475723","https://openalex.org/W2033201837","https://openalex.org/W2043735243","https://openalex.org/W2061997675","https://openalex.org/W2082633203","https://openalex.org/W2084481683","https://openalex.org/W2089247435","https://openalex.org/W2097054885","https://openalex.org/W2109289209","https://openalex.org/W2111451400","https://openalex.org/W2111687586","https://openalex.org/W2115440939","https://openalex.org/W2140453381","https://openalex.org/W2142285455","https://openalex.org/W2151224499","https://openalex.org/W2159754133","https://openalex.org/W2344304035","https://openalex.org/W2345132233","https://openalex.org/W2429518132","https://openalex.org/W2435355301","https://openalex.org/W2443229613","https://openalex.org/W2567161013","https://openalex.org/W2605800201","https://openalex.org/W2962771342","https://openalex.org/W4237407586","https://openalex.org/W4252446498"],"related_works":[],"abstract_inverted_index":{"Index":[0],"structures":[1,198],"are":[2],"one":[3],"of":[4,16,48,56,77,97,179,206],"the":[5,14,49,57,75,201],"most":[6],"important":[7],"tools":[8],"that":[9,43,121,153,184,192],"DBAs":[10],"leverage":[11],"to":[12,80,125,129,137,189,195],"improve":[13],"performance":[15,140,191],"analytics":[17],"and":[18,32,69,73,132,141],"transactional":[19],"workloads.":[20],"However,":[21],"building":[22],"several":[23],"indexes":[24,44],"over":[25],"large":[26],"datasets":[27],"can":[28,52],"often":[29],"become":[30],"prohibitive":[31],"consume":[33],"valuable":[34,68],"system":[35],"resources.":[36],"In":[37,88],"fact,":[38],"a":[39,62,94,98,107,118,123,130,150,163,171,177],"recent":[40],"study":[41],"showed":[42],"created":[45],"as":[46],"part":[47],"TPC-C":[50],"benchmark":[51],"account":[53],"for":[54],"55%":[55],"total":[58],"memory":[59],"available":[60,79],"in":[61],"modern":[63],"DBMS.":[64],"This":[65,114],"overhead":[66],"consumes":[67],"expensive":[70],"main":[71],"memory,":[72],"limits":[74],"amount":[76],"space":[78,142],"store":[81],"new":[82],"data":[83],"or":[84,169],"process":[85],"existing":[86],"data.":[87],"this":[89,146],"paper,":[90],"we":[91,148,182],"present":[92],"FITing-Tree,":[93],"novel":[95],"form":[96],"learned":[99],"index":[100,128,186,197],"which":[101],"uses":[102],"piece-wise":[103],"linear":[104],"functions":[105],"with":[106],"bounded":[108],"error":[109,115,158],"specified":[110],"at":[111],"construction":[112],"time.":[113],"knob":[116],"provides":[117],"tunable":[119],"parameter":[120,159],"allows":[122],"DBA":[124],"FIT":[126],"an":[127,156],"dataset":[131],"workload":[133],"by":[134,204],"being":[135],"able":[136,188],"balance":[138],"lookup":[139,164],"consumption.":[143],"To":[144],"navigate":[145],"tradeoff,":[147],"provide":[149,190],"cost":[151],"model":[152],"helps":[154],"determine":[155],"appropriate":[157],"given":[160],"either":[161],"(1)":[162],"latency":[165],"requirement":[166],"(e.g.,":[167,174],"500ns)":[168],"(2)":[170],"storage":[172,202],"budget":[173],"100MB).":[175],"Using":[176],"variety":[178],"real-world":[180],"datasets,":[181],"show":[183],"our":[185],"is":[187,193],"comparable":[194],"full":[196],"while":[199],"reducing":[200],"footprint":[203],"orders":[205],"magnitude.":[207]},"counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":30},{"year":2024,"cited_by_count":42},{"year":2023,"cited_by_count":32},{"year":2022,"cited_by_count":30},{"year":2021,"cited_by_count":21},{"year":2020,"cited_by_count":20},{"year":2016,"cited_by_count":1}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2019-06-14T00:00:00"}