{"id":"https://openalex.org/W2139715833","doi":"https://doi.org/10.1145/1353343.1353407","title":"The SBC-tree","display_name":"The SBC-tree","publication_year":2008,"publication_date":"2008-03-25","ids":{"openalex":"https://openalex.org/W2139715833","doi":"https://doi.org/10.1145/1353343.1353407","mag":"2139715833"},"language":"en","primary_location":{"id":"doi:10.1145/1353343.1353407","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353407","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353407","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353407","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5074322354","display_name":"Mohamed Y. Eltabakh","orcid":"https://orcid.org/0000-0002-6344-8246"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mohamed Y. Eltabakh","raw_affiliation_strings":["Purdue University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Purdue University","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5013112058","display_name":"Wing-Kai Hon","orcid":"https://orcid.org/0000-0002-0570-2904"},"institutions":[{"id":"https://openalex.org/I25846049","display_name":"National Tsing Hua University","ror":"https://ror.org/00zdnkx70","country_code":"TW","type":"education","lineage":["https://openalex.org/I25846049"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Wing-Kai Hon","raw_affiliation_strings":["National Tsing Hua University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"National Tsing Hua University","institution_ids":["https://openalex.org/I25846049"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105778361","display_name":"Rahul Shah","orcid":"https://orcid.org/0000-0002-0605-5681"},"institutions":[{"id":"https://openalex.org/I121820613","display_name":"Louisiana State University","ror":"https://ror.org/05ect4e57","country_code":"US","type":"education","lineage":["https://openalex.org/I121820613"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rahul Shah","raw_affiliation_strings":["Louisiana State University","Louisiana State University**"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Louisiana State University","institution_ids":["https://openalex.org/I121820613"]},{"raw_affiliation_string":"Louisiana State University**","institution_ids":["https://openalex.org/I121820613"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000123743","display_name":"Walid G. Aref","orcid":"https://orcid.org/0000-0001-8169-7775"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Walid G. Aref","raw_affiliation_strings":["Purdue University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Purdue University","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003340402","display_name":"Jeffrey Scott Vitter","orcid":"https://orcid.org/0000-0001-7970-6118"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jeffrey S. Vitter","raw_affiliation_strings":["Purdue University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Purdue University","institution_ids":["https://openalex.org/I219193219"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.5115,"has_fulltext":true,"cited_by_count":14,"citation_normalized_percentile":{"value":0.83209458,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"523","last_page":"534"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":1.0,"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":1.0,"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/T12326","display_name":"Network Packet Processing and Optimization","score":0.9925000071525574,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T11247","display_name":"Plant nutrient uptake and metabolism","score":0.9519000053405762,"subfield":{"id":"https://openalex.org/subfields/1110","display_name":"Plant Science"},"field":{"id":"https://openalex.org/fields/11","display_name":"Agricultural and Biological Sciences"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/substring","display_name":"Substring","score":0.8642287254333496},{"id":"https://openalex.org/keywords/trie","display_name":"Trie","score":0.739210307598114},{"id":"https://openalex.org/keywords/search-tree","display_name":"Search tree","score":0.660293459892273},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6239156126976013},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.6078702807426453},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.6037333607673645},{"id":"https://openalex.org/keywords/segment-tree","display_name":"Segment tree","score":0.5902566313743591},{"id":"https://openalex.org/keywords/amortized-analysis","display_name":"Amortized analysis","score":0.589165210723877},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.5103113055229187},{"id":"https://openalex.org/keywords/matching","display_name":"Matching (statistics)","score":0.48461684584617615},{"id":"https://openalex.org/keywords/range-tree","display_name":"Range tree","score":0.48415666818618774},{"id":"https://openalex.org/keywords/interval-tree","display_name":"Interval tree","score":0.4795070290565491},{"id":"https://openalex.org/keywords/b-tree","display_name":"B-tree","score":0.4284391403198242},{"id":"https://openalex.org/keywords/pattern-matching","display_name":"Pattern matching","score":0.41772258281707764},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.41482290625572205},{"id":"https://openalex.org/keywords/string","display_name":"String (physics)","score":0.41099822521209717},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.37119048833847046},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.3177493214607239},{"id":"https://openalex.org/keywords/search-algorithm","display_name":"Search algorithm","score":0.27468451857566833},{"id":"https://openalex.org/keywords/binary-tree","display_name":"Binary tree","score":0.20472177863121033},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.10508263111114502}],"concepts":[{"id":"https://openalex.org/C182407805","wikidata":"https://www.wikidata.org/wiki/Q2626534","display_name":"Substring","level":3,"score":0.8642287254333496},{"id":"https://openalex.org/C190290938","wikidata":"https://www.wikidata.org/wiki/Q387015","display_name":"Trie","level":3,"score":0.739210307598114},{"id":"https://openalex.org/C207024777","wikidata":"https://www.wikidata.org/wiki/Q621673","display_name":"Search tree","level":3,"score":0.660293459892273},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6239156126976013},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.6078702807426453},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.6037333607673645},{"id":"https://openalex.org/C94557470","wikidata":"https://www.wikidata.org/wiki/Q2377385","display_name":"Segment tree","level":5,"score":0.5902566313743591},{"id":"https://openalex.org/C142417499","wikidata":"https://www.wikidata.org/wiki/Q331716","display_name":"Amortized analysis","level":3,"score":0.589165210723877},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.5103113055229187},{"id":"https://openalex.org/C165064840","wikidata":"https://www.wikidata.org/wiki/Q1321061","display_name":"Matching (statistics)","level":2,"score":0.48461684584617615},{"id":"https://openalex.org/C68775195","wikidata":"https://www.wikidata.org/wiki/Q818944","display_name":"Range tree","level":5,"score":0.48415666818618774},{"id":"https://openalex.org/C84927040","wikidata":"https://www.wikidata.org/wiki/Q6057306","display_name":"Interval tree","level":4,"score":0.4795070290565491},{"id":"https://openalex.org/C78669399","wikidata":"https://www.wikidata.org/wiki/Q677051","display_name":"B-tree","level":3,"score":0.4284391403198242},{"id":"https://openalex.org/C68859911","wikidata":"https://www.wikidata.org/wiki/Q1503724","display_name":"Pattern matching","level":2,"score":0.41772258281707764},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.41482290625572205},{"id":"https://openalex.org/C157486923","wikidata":"https://www.wikidata.org/wiki/Q1376436","display_name":"String (physics)","level":2,"score":0.41099822521209717},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.37119048833847046},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.3177493214607239},{"id":"https://openalex.org/C125583679","wikidata":"https://www.wikidata.org/wiki/Q755673","display_name":"Search algorithm","level":2,"score":0.27468451857566833},{"id":"https://openalex.org/C197855036","wikidata":"https://www.wikidata.org/wiki/Q380172","display_name":"Binary tree","level":2,"score":0.20472177863121033},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10508263111114502},{"id":"https://openalex.org/C37914503","wikidata":"https://www.wikidata.org/wiki/Q156495","display_name":"Mathematical physics","level":1,"score":0.0},{"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/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/1353343.1353407","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353407","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353407","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},{"id":"pmh:oai:docs.lib.purdue.edu:ccpubs-1012","is_oa":false,"landing_page_url":"https://docs.lib.purdue.edu/ccpubs/7","pdf_url":null,"source":{"id":"https://openalex.org/S4377196310","display_name":"Purdue e-Pubs (Purdue University System)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801333002","host_organization_name":"Purdue University System","host_organization_lineage":["https://openalex.org/I2801333002"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Cyber Center Publications","raw_type":"text"},{"id":"pmh:oai:docs.lib.purdue.edu:ccpubs-1247","is_oa":false,"landing_page_url":"https://docs.lib.purdue.edu/ccpubs/254","pdf_url":null,"source":{"id":"https://openalex.org/S4377196310","display_name":"Purdue e-Pubs (Purdue University System)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801333002","host_organization_name":"Purdue University System","host_organization_lineage":["https://openalex.org/I2801333002"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Cyber Center Publications","raw_type":"text"},{"id":"pmh:oai:repository.lsu.edu:eecs_pubs-3691","is_oa":false,"landing_page_url":"https://repository.lsu.edu/eecs_pubs/2689","pdf_url":null,"source":{"id":"https://openalex.org/S4210169993","display_name":"Civil War Book Review","issn_l":"1528-6592","issn":["1528-6592"],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310315936","host_organization_name":"Louisiana State University","host_organization_lineage":["https://openalex.org/P4310315936"],"host_organization_lineage_names":["Louisiana State University"],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Faculty Publications","raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/1353343.1353407","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353407","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353407","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1928311749","display_name":"CAREER:  Research and Development of Database Technologies for Modern Applications","funder_award_id":"0093116","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2721342868","display_name":null,"funder_award_id":"IIS-0093116","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"},{"id":"https://openalex.org/G4011362023","display_name":null,"funder_award_id":"CCF-0621457","funder_id":"https://openalex.org/F4320337387","funder_display_name":"Division of Computing and Communication Foundations"},{"id":"https://openalex.org/G4428693574","display_name":"Performance Models and Systems Optimization for Disk-Bound Applications","funder_award_id":"0621457","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"},{"id":"https://openalex.org/F4320337387","display_name":"Division of Computing and Communication Foundations","ror":"https://ror.org/01mng8331"},{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2139715833.pdf","grobid_xml":"https://content.openalex.org/works/W2139715833.grobid-xml"},"referenced_works_count":58,"referenced_works":["https://openalex.org/W788498898","https://openalex.org/W1505005586","https://openalex.org/W1520688336","https://openalex.org/W1539221976","https://openalex.org/W1540616176","https://openalex.org/W1804684259","https://openalex.org/W1885799453","https://openalex.org/W1964238867","https://openalex.org/W1968328322","https://openalex.org/W1978388540","https://openalex.org/W1984789718","https://openalex.org/W1990061958","https://openalex.org/W1992876024","https://openalex.org/W1996861774","https://openalex.org/W1997841190","https://openalex.org/W2008627910","https://openalex.org/W2024795930","https://openalex.org/W2026511056","https://openalex.org/W2026893402","https://openalex.org/W2033625795","https://openalex.org/W2043148321","https://openalex.org/W2043731712","https://openalex.org/W2046441184","https://openalex.org/W2054439442","https://openalex.org/W2055385473","https://openalex.org/W2080637107","https://openalex.org/W2087721273","https://openalex.org/W2090352468","https://openalex.org/W2096552453","https://openalex.org/W2107745473","https://openalex.org/W2108706843","https://openalex.org/W2115613939","https://openalex.org/W2115898638","https://openalex.org/W2118269922","https://openalex.org/W2121252285","https://openalex.org/W2122962290","https://openalex.org/W2124070418","https://openalex.org/W2127057359","https://openalex.org/W2127515417","https://openalex.org/W2128061541","https://openalex.org/W2134696992","https://openalex.org/W2135771747","https://openalex.org/W2137023570","https://openalex.org/W2142753649","https://openalex.org/W2152301310","https://openalex.org/W2155512447","https://openalex.org/W2158322625","https://openalex.org/W2158874082","https://openalex.org/W2160748429","https://openalex.org/W2161488606","https://openalex.org/W2161694911","https://openalex.org/W2337480916","https://openalex.org/W2533248932","https://openalex.org/W2901608006","https://openalex.org/W3138367763","https://openalex.org/W6632287593","https://openalex.org/W6646381120","https://openalex.org/W6679642144"],"related_works":["https://openalex.org/W22108090","https://openalex.org/W2125650843","https://openalex.org/W2351720606","https://openalex.org/W2359807192","https://openalex.org/W2383581812","https://openalex.org/W3109340025","https://openalex.org/W2108643052","https://openalex.org/W2196142605","https://openalex.org/W4233481513","https://openalex.org/W2139715833"],"abstract_inverted_index":{"Run-Length-Encoding":[0],"(RLE)":[1],"is":[2,8,26,66,116,126,150,160,167,202],"a":[3,67,78,185],"data":[4,37],"compression":[5],"technique":[6],"that":[7,209],"used":[9],"in":[10,139,225],"various":[11],"applications,":[12],"e.g.,":[13],"time":[14],"series,":[15],"biological":[16],"sequences,":[17,51,123],"and":[18,34,57,77,96,124,135,158,170,173,179],"multimedia":[19],"databases.":[20],"One":[21],"of":[22,61,111,120,153,181,184,188,222],"the":[23,46,53,73,117,121,127,151,154,161,211,229,235,239],"main":[24],"challenges":[25],"how":[27],"to":[28,213,219],"operate":[29],"on":[30,72],"(e.g.,":[31],"index,":[32],"search,":[33],"retrieve)":[35],"compressed":[36,122,155,186],"without":[38],"decompressing":[39],"it.":[40],"In":[41],"this":[42],"paper,":[43],"we":[44],"introduce":[45],"<u>S</u>tring":[47],"<u>B</u>-tree":[48],"for":[49,55],"<u>C</u>ompressed":[50],"termed":[52],"SBC-tree,":[54],"indexing":[56],"searching":[58],"RLE-compressed":[59,101,215],"sequences":[60,216],"arbitrary":[62],"length.":[63],"The":[64,84,103,165,177,199],"SBC-tree":[65,85,104,166,200,212],"two-level":[68],"index":[69,201,214],"structure":[70,82],"based":[71],"well-known":[74],"String":[75,236],"B-tree":[76,237],"3-sided":[79],"range":[80,97,136],"query":[81,156,162],"[7].":[83],"supports":[86,171],"pattern":[87,157],"matching":[88],"queries":[89],"such":[90],"as":[91],"substring":[92],"matching,":[93,95,132,134],"prefix":[94,133],"search":[98,137,231],"operations":[99,175],"over":[100,238],"sequences.":[102,241],"has":[105],"an":[106,140,220],"optimal":[107,141,230],"external-memory":[108],"space":[109],"complexity":[110],"O(N/B)":[112],"pages,":[113],"where":[114,148],"N":[115,143],"total":[118],"length":[119,152,189],"B":[125],"disk":[128],"page":[129],"size.":[130,164],"Substring":[131],"execute":[138],"O(logB":[142],"+":[144,194],"|p|+T/B)":[145],"I/O":[146,197],"operations,":[147],"|p|":[149],"T":[159],"output":[163],"also":[168],"dynamic":[169],"insert":[172],"delete":[174],"efficiently.":[176],"insertion":[178],"deletion":[180],"all":[182],"suffixes":[183],"sequence":[187],"m":[190],"take":[191],"O(m":[192],"logB(N":[193],"m))":[195],"amortized":[196],"operations.":[198],"realized":[203],"inside":[204],"PostgreSQL.":[205],"Performance":[206],"results":[207],"illustrate":[208],"using":[210],"achieves":[217],"up":[218],"order":[221],"magnitude":[223],"reduction":[224],"storage,":[226],"while":[227],"retains":[228],"performance":[232],"achieved":[233],"by":[234],"uncompressed":[240]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-08-01T09:00:35.917206","created_date":"2016-06-24T00:00:00"}