{"id":"https://openalex.org/W2077401654","doi":"https://doi.org/10.1145/73721.73745","title":"Utilization of B-trees with inserts, deletes and modifies","display_name":"Utilization of B-trees with inserts, deletes and modifies","publication_year":1989,"publication_date":"1989-03-29","ids":{"openalex":"https://openalex.org/W2077401654","doi":"https://doi.org/10.1145/73721.73745","mag":"2077401654"},"language":"en","primary_location":{"id":"doi:10.1145/73721.73745","is_oa":false,"landing_page_url":"https://doi.org/10.1145/73721.73745","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the eighth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"},"type":"conference-paper","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/A5103172342","display_name":"T. Johnson","orcid":"https://orcid.org/0000-0002-1605-1713"},"institutions":[{"id":"https://openalex.org/I36672615","display_name":"Courant Institute of Mathematical Sciences","ror":"https://ror.org/037tm7f56","country_code":"US","type":"education","lineage":["https://openalex.org/I36672615","https://openalex.org/I57206974"]},{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"T. Johnson","raw_affiliation_strings":["Courant Institute of Mathematical Sciences, New York University","Courant Institute of Mathematical Sciences, New York University#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Courant Institute of Mathematical Sciences, New York University","institution_ids":["https://openalex.org/I36672615","https://openalex.org/I57206974"]},{"raw_affiliation_string":"Courant Institute of Mathematical Sciences, New York University#TAB#","institution_ids":["https://openalex.org/I36672615"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5055576104","display_name":"Dennis Shasha","orcid":"https://orcid.org/0000-0002-7036-3312"},"institutions":[{"id":"https://openalex.org/I36672615","display_name":"Courant Institute of Mathematical Sciences","ror":"https://ror.org/037tm7f56","country_code":"US","type":"education","lineage":["https://openalex.org/I36672615","https://openalex.org/I57206974"]},{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"D. Shasha","raw_affiliation_strings":["Courant Institute of Mathematical Sciences, New York University","Courant Institute of Mathematical Sciences, New York University#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Courant Institute of Mathematical Sciences, New York University","institution_ids":["https://openalex.org/I36672615","https://openalex.org/I57206974"]},{"raw_affiliation_string":"Courant Institute of Mathematical Sciences, New York University#TAB#","institution_ids":["https://openalex.org/I36672615"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":49,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"235","last_page":"246"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9940000176429749,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9940000176429749,"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/T11719","display_name":"Data Quality and Management","score":0.9894000291824341,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9857000112533569,"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/computer-science","display_name":"Computer science","score":0.421357661485672}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.421357661485672}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/73721.73745","is_oa":false,"landing_page_url":"https://doi.org/10.1145/73721.73745","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the eighth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W1978071187","https://openalex.org/W2078100813","https://openalex.org/W2085903699","https://openalex.org/W6857528661"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2350741829","https://openalex.org/W2130043461","https://openalex.org/W2530322880","https://openalex.org/W1596801655"],"abstract_inverted_index":{"The":[0],"utilization":[1,29,43,60,107,138],"of":[2,8,26,44,61,122,147,161,174],"B-tree":[3,12,45,62],"nodes":[4,46,63,88],"determines":[5],"the":[6,11,19,24,32,42,59,106,128,137,145,159,171],"number":[7],"levels":[9],"in":[10,98,182],"and":[13,36,55,124,149,179],"hence":[14],"its":[15],"performance.":[16],"Until":[17],"now,":[18],"only":[20,89],"analytical":[21],"aid":[22],"to":[23,118],"determination":[25],"a":[27,80,119,153,183],"B-tree's":[28],"has":[30],"been":[31],"analysis":[33],"by":[34,57,69,83],"Yao":[35,39],"related":[37],"work.":[38],"showed":[40],"that":[41,87,105,156],"under":[47],"pure":[48],"inserts":[49,67,123],"was":[50],"69%.":[51],"We":[52,114,142,151,163],"derive":[53,152],"analytically":[54],"verify":[56],"simulation":[58],"constructed":[64],"from":[65],"N":[66],"followed":[68,82],"M":[70,73,111],"modifies":[71,129],"(where":[72],">":[74],"N),":[75],"where":[76],"each":[77],"modify":[78],"is":[79,108,139],"delete":[81],"an":[84],"insert.":[85],"Assuming":[86],"merge":[90],"when":[91],"they":[92],"are":[93,130],"empty":[94],"(the":[95],"technique":[96],"used":[97],"most":[99],"database":[100],"management":[101],"systems),":[102],"we":[103,186],"show":[104],"39%":[109],"as":[110],"becomes":[112],"large.":[113],"extend":[115],"this":[116,169],"model":[117],"parameterized":[120],"mixture":[121],"modifies.":[125],"Surprisingly,":[126],"if":[127],"mixed":[131],"with":[132],"just":[133],"10%":[134],"inserts,":[135],"then":[136,180],"over":[140],"62%.":[141],"also":[143],"calculated":[144],"probability":[146,160],"splitting":[148],"merging.":[150],"simple":[154],"rule-of-thumb":[155],"accurately":[157],"calculates":[158],"splitting.":[162],"present":[164],"two":[165],"models":[166],"for":[167],"computing":[168],"utilization,":[170],"more":[172],"accurate":[173],"which":[175],"remembers":[176],"items":[177,189],"inserted":[178],"deleted":[181],"node":[184],"-":[185],"call":[187],"such":[188],"ghosts.":[190]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}