{"id":"https://openalex.org/W1966484605","doi":"https://doi.org/10.1145/2339123.2339129","title":"Dynamic Indexability and the Optimality of B-Trees","display_name":"Dynamic Indexability and the Optimality of B-Trees","publication_year":2012,"publication_date":"2012-08-01","ids":{"openalex":"https://openalex.org/W1966484605","doi":"https://doi.org/10.1145/2339123.2339129","mag":"1966484605"},"language":"en","primary_location":{"id":"doi:10.1145/2339123.2339129","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2339123.2339129","pdf_url":null,"source":{"id":"https://openalex.org/S118992489","display_name":"Journal of the ACM","issn_l":"0004-5411","issn":["0004-5411","1557-735X"],"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the ACM","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5009196125","display_name":"Ke Yi","orcid":"https://orcid.org/0000-0002-2178-3716"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":true,"raw_author_name":"Ke Yi","raw_affiliation_strings":["Hong Kong University of Science and Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hong Kong University of Science and Technology","institution_ids":["https://openalex.org/I200769079"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5009196125"],"corresponding_institution_ids":["https://openalex.org/I200769079"],"apc_list":null,"apc_paid":null,"fwci":0.8699,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.7811897,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"59","issue":"4","first_page":"1","last_page":"19"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9995999932289124,"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.9995999932289124,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994999766349792,"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.9990000128746033,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/block-size","display_name":"Block size","score":0.7256816625595093},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.589069664478302},{"id":"https://openalex.org/keywords/binary-logarithm","display_name":"Binary logarithm","score":0.5764369368553162},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5684492588043213},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5464098453521729},{"id":"https://openalex.org/keywords/constant","display_name":"Constant (computer programming)","score":0.5459086894989014},{"id":"https://openalex.org/keywords/block","display_name":"Block (permutation group theory)","score":0.5361143946647644},{"id":"https://openalex.org/keywords/auxiliary-memory","display_name":"Auxiliary memory","score":0.4677814245223999},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.44668468832969666},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.43703755736351013},{"id":"https://openalex.org/keywords/amortized-analysis","display_name":"Amortized analysis","score":0.43636494874954224},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.4107089638710022},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.3967767059803009},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.39551329612731934},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.35233649611473083}],"concepts":[{"id":"https://openalex.org/C41431624","wikidata":"https://www.wikidata.org/wiki/Q1053357","display_name":"Block size","level":3,"score":0.7256816625595093},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.589069664478302},{"id":"https://openalex.org/C63553672","wikidata":"https://www.wikidata.org/wiki/Q581168","display_name":"Binary logarithm","level":2,"score":0.5764369368553162},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5684492588043213},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5464098453521729},{"id":"https://openalex.org/C2777027219","wikidata":"https://www.wikidata.org/wiki/Q1284190","display_name":"Constant (computer programming)","level":2,"score":0.5459086894989014},{"id":"https://openalex.org/C2777210771","wikidata":"https://www.wikidata.org/wiki/Q4927124","display_name":"Block (permutation group theory)","level":2,"score":0.5361143946647644},{"id":"https://openalex.org/C82687282","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Auxiliary memory","level":2,"score":0.4677814245223999},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.44668468832969666},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.43703755736351013},{"id":"https://openalex.org/C142417499","wikidata":"https://www.wikidata.org/wiki/Q331716","display_name":"Amortized analysis","level":3,"score":0.43636494874954224},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.4107089638710022},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3967767059803009},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.39551329612731934},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.35233649611473083},{"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/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2339123.2339129","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2339123.2339129","pdf_url":null,"source":{"id":"https://openalex.org/S118992489","display_name":"Journal of the ACM","issn_l":"0004-5411","issn":["0004-5411","1557-735X"],"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the ACM","raw_type":"journal-article"},{"id":"pmh:oai:repository.hkust.edu.hk:1783.1-57433","is_oa":false,"landing_page_url":"http://repository.hkust.edu.hk/ir/Record/1783.1-57433","pdf_url":null,"source":{"id":"https://openalex.org/S4306401796","display_name":"Rare & Special e-Zone (The Hong Kong University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I200769079","host_organization_name":"Hong Kong University of Science and Technology","host_organization_lineage":["https://openalex.org/I200769079"],"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":"Article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.44999998807907104,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W53813205","https://openalex.org/W1489843519","https://openalex.org/W1578513732","https://openalex.org/W1716716796","https://openalex.org/W1739920298","https://openalex.org/W1968301997","https://openalex.org/W1986633843","https://openalex.org/W1993022201","https://openalex.org/W2029814178","https://openalex.org/W2038142281","https://openalex.org/W2039785630","https://openalex.org/W2043148321","https://openalex.org/W2044188017","https://openalex.org/W2045195333","https://openalex.org/W2062618908","https://openalex.org/W2068739275","https://openalex.org/W2075968486","https://openalex.org/W2088116875","https://openalex.org/W2090103608","https://openalex.org/W2112821228","https://openalex.org/W2117098610","https://openalex.org/W2149592768","https://openalex.org/W2149710566","https://openalex.org/W2167184472","https://openalex.org/W2901608006","https://openalex.org/W2949708974","https://openalex.org/W3140526873"],"related_works":["https://openalex.org/W8290509","https://openalex.org/W2184537587","https://openalex.org/W2065411828","https://openalex.org/W3092127654","https://openalex.org/W1482484961","https://openalex.org/W4246145339","https://openalex.org/W2076407808","https://openalex.org/W2006811735","https://openalex.org/W2018777660","https://openalex.org/W2093612905"],"abstract_inverted_index":{"One-dimensional":[0],"range":[1,62],"queries,":[2],"as":[3],"one":[4,251],"of":[5,10,55,113,127,157,192,233,263,274,281],"the":[6,19,24,47,73,79,90,94,120,143,150,195,199,230,235,264,275],"most":[7,200],"basic":[8],"type":[9],"queries":[11],"in":[12,18,46,64,100,149,194,270],"databases,":[13,23],"have":[14,183],"been":[15,184],"studied":[16],"extensively":[17],"literature.":[20],"For":[21,124],"large":[22],"goal":[25],"is":[26,33,43,72,78,85,93,119,145,167,245,280,286],"to":[27,160,169,174,301],"build":[28],"an":[29,53],"external":[30],"index":[31,54],"that":[32,58,229,250],"optimized":[34],"for":[35,212,222,255,259,292],"disk":[36,80],"block":[37,81],"accesses":[38],"(or":[39],"I/Os).":[40],"The":[41],"problem":[42,144],"well":[44],"understood":[45],"static":[48],"case.":[49],"Theoretically,":[50],"there":[51],"exists":[52],"linear":[56],"size":[57,75,114],"can":[59,137,298],"answer":[60],"a":[61,98,110,140,246,271,287],"query":[63,99,196],"O(1":[65],"+":[66,105,218],"KB":[67,106,219],")":[68,107,210,220],"I/Os,":[69],"where":[70,117],"K":[71],"output":[74],"and":[76,131,155,214,297],"B":[77,103,132,135,207,243],"size,":[82],"but":[83,186],"it":[84,166],"highly":[86],"impractical.":[87],"In":[88,224],"practice,":[89],"standard":[91],"solution":[92],"B-tree,":[95],"which":[96,279],"answers":[97],"O":[101,205,215],"(log":[102,216],"NM":[104,136,209,217,244],"I/Os":[108,177,211,221],"on":[109],"data":[111],"set":[112],"N":[115],",":[116,130,133,278],"M":[118,129],"main":[121],"memory":[122],"size.":[123],"typical":[125],"values":[126,262],"N,":[128],"log":[134,208,242],"be":[138,161],"considered":[139],"constant.":[141,247],"However,":[142],"still":[146],"wide":[147],"open":[148],"dynamic":[151,181,237,272,294],"setting,":[152],"when":[153,241],"insertions":[154],"deletions":[156],"records":[158],"are":[159,239],"supported.":[162],"With":[163],"smart":[164],"buffering,":[165],"possible":[168],"speed":[170],"up":[171],"updates":[172,213],"significantly":[173],"o":[175],"(1)":[176],"amortized.":[178],"Indeed,":[179],"several":[180],"B-trees":[182,238],"proposed,":[185],"they":[187],"all":[188,234,260],"cause":[189],"certain":[190],"levels":[191],"degradation":[193],"performance,":[197],"with":[198],"interesting":[201,303],"tradeoff":[202],"point":[203],"at":[204],"(1":[206],"queries.":[223],"this":[225],"article,":[226],"we":[227],"prove":[228],"query-update":[231],"tradeoffs":[232],"known":[236],"optimal,":[240],"This":[248],"implies":[249],"should":[252],"not":[253],"hope":[254],"substantially":[256],"better":[257],"solutions":[258],"practical":[261],"parameters.":[265],"Our":[266],"lower":[267,304],"bounds":[268],"hold":[269],"version":[273],"indexability":[276,285],"model":[277,291],"independent":[282],"interests.":[283],"Dynamic":[284],"clean":[288],"yet":[289],"powerful":[290],"studying":[293],"indexing":[295],"problems,":[296],"potentially":[299],"lead":[300],"more":[302],"bound":[305],"results.":[306]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":2}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}