{"id":"https://openalex.org/W114679201","doi":null,"title":"Efficient In-Memory Indexing with Generalized Prefix Trees.","display_name":"Efficient In-Memory Indexing with Generalized Prefix Trees.","publication_year":2011,"publication_date":"2011-01-01","ids":{"openalex":"https://openalex.org/W114679201","mag":"114679201"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.650.7113","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.650.7113","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://subs.emis.de/LNI/Proceedings/Proceedings180/227.pdf","raw_type":"text"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"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/A5026574045","display_name":"Matthias B\u00f6hm","orcid":"https://orcid.org/0000-0002-8918-3725","observed_orcids":["https://orcid.org/0000-0002-8918-3725"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Matthias B\u00f6hm","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-8918-3725","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028127326","display_name":"Benjamin Schlegel","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Benjamin Schlegel","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072488588","display_name":"Peter Benjamin Volk","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Peter Benjamin Volk","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103676866","display_name":"Ulrike Fischer","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ulrike Fischer","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057703543","display_name":"Dirk Habich","orcid":"https://orcid.org/0000-0002-8671-5466","observed_orcids":["https://orcid.org/0000-0002-8671-5466"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dirk Habich","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-8671-5466","affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5063512642","display_name":"Wolfgang Lehner","orcid":"https://orcid.org/0000-0001-8107-2775","observed_orcids":["https://orcid.org/0000-0001-8107-2775"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wolfgang Lehner","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0001-8107-2775","affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":5.5308,"has_fulltext":false,"cited_by_count":39,"citation_normalized_percentile":{"value":0.95368979,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"227","last_page":"246"},"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.6464999914169312,"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.6464999914169312,"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.3483999967575073,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.003000000026077032,"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/in-memory-indexing","display_name":"in-memory indexing","score":0.9539999961853027},{"id":"https://openalex.org/keywords/prefix-tree","display_name":"prefix tree","score":0.9610000252723694},{"id":"https://openalex.org/keywords/memory-usage","display_name":"memory usage","score":0.5920000076293945},{"id":"https://openalex.org/keywords/skewed-data","display_name":"skewed data","score":0.7089999914169312},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"online transaction processing","score":0.5450000166893005}],"concepts":[{"id":"https://openalex.org/C190290938","wikidata":"https://www.wikidata.org/wiki/Q387015","display_name":"Trie","level":3,"score":0.9412018060684204},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6834985017776489},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.6229549646377563},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.5464904308319092},{"id":"https://openalex.org/C141603448","wikidata":"https://www.wikidata.org/wiki/Q134830","display_name":"Prefix","level":2,"score":0.5395530462265015},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.4806205630302429},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.47749704122543335},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.47465139627456665},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.37143674492836},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.36680281162261963},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.29127824306488037},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.08900469541549683},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","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/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.650.7113","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.650.7113","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://subs.emis.de/LNI/Proceedings/Proceedings180/227.pdf","raw_type":"text"},{"id":"mag:114679201","doi":null,"is_oa":false,"landing_page_url":"http://wwwdb.inf.tu-dresden.de/misc/team/boehm/pubs/btw2011.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306504987","display_name":"BTW","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"BTW","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W1539221976","https://openalex.org/W1577196593","https://openalex.org/W1598618182","https://openalex.org/W1598765706","https://openalex.org/W1985490341","https://openalex.org/W1993449345","https://openalex.org/W1994085050","https://openalex.org/W2000484009","https://openalex.org/W2008627910","https://openalex.org/W2014515453","https://openalex.org/W2021615496","https://openalex.org/W2039379906","https://openalex.org/W2040062099","https://openalex.org/W2073216502","https://openalex.org/W2076747312","https://openalex.org/W2087966340","https://openalex.org/W2096229429","https://openalex.org/W2099117306","https://openalex.org/W2104003087","https://openalex.org/W2106503116","https://openalex.org/W2137077706","https://openalex.org/W2145148249","https://openalex.org/W2147076738","https://openalex.org/W2147107544","https://openalex.org/W2148554095","https://openalex.org/W2151224499","https://openalex.org/W2155512447","https://openalex.org/W2157174514","https://openalex.org/W2160404300","https://openalex.org/W2337480916"],"related_works":["https://openalex.org/W6912939059","https://openalex.org/W3137565180","https://openalex.org/W4226174211","https://openalex.org/W1985998685","https://openalex.org/W4404133945","https://openalex.org/W2799221749","https://openalex.org/W2030062409","https://openalex.org/W1979211754","https://openalex.org/W2947756274","https://openalex.org/W168127711"],"abstract_inverted_index":{"Abstract:":[0],"Efficient":[1],"data":[2,42,148,244],"structures":[3,46,63,67,103,129],"for":[4,40,91,122,145,174,193,220],"in-memory":[5,41,127,216,232],"indexing":[6,146],"gain":[7],"in":[8,55,74,104,235],"importance":[9],"due":[10],"to":[11,214],"(1)":[12],"the":[13,20,26,82,89,98,133,160,163,176,208,225],"exponentially":[14],"increasing":[15],"amount":[16],"of":[17,101,106,150,162,178],"data,":[18],"(2)":[19],"growing":[21],"main-memory":[22,29],"capac-ity,":[23],"and":[24,30,79,93,111,130,166,180,188,195,242],"(3)":[25],"gap":[27],"between":[28],"CPU":[31],"speed.":[32],"In":[33,96,117,223],"consequence,":[34],"there":[35],"are":[36,47,64,72,85],"high":[37,107],"performance":[38],"demands":[39],"structures.":[43],"Such":[44],"index":[45,128,217,233],"used\u2014with":[48],"minor":[49],"changes\u2014as":[50],"primary":[51],"or":[52,61,152,204,239],"secondary":[53],"indices":[54],"almost":[56],"every":[57],"DBMS.":[58],"Typically,":[59],"tree-based":[60,78],"hash-based":[62,80],"used,":[65],"while":[66],"based":[68],"on":[69],"prefix-trees":[70],"(tries)":[71],"neglected":[73],"this":[75,118],"context.":[76],"For":[77],"struc-tures,":[81],"major":[83,99],"disadvantages":[84],"inherently":[86],"caused":[87],"by":[88],"need":[90],"reorganization":[92,203],"key":[94,205],"comparisons.":[95,206],"contrast,":[97],"disadvantage":[100],"trie-based":[102],"terms":[105],"memory":[108,168],"consumption":[109],"(created":[110],"accessed":[112,181],"nodes)":[113],"could":[114],"be":[115],"improved.":[116],"paper,":[119],"we":[120,131,171],"argue":[121],"reconsidering":[123],"prefix":[124,139,143,157],"trees":[125],"as":[126,230],"present":[132],"generalized":[134,209,226],"trie,":[135],"which":[136],"is":[137,186,228],"a":[138],"tree":[140],"with":[141],"variable":[142,153,156],"length":[144,158],"arbitrary":[147],"types":[149],"fixed":[151],"length.":[154],"The":[155],"enables":[159],"adjustment":[161],"trie":[164,182,185,191,210,227],"height":[165],"its":[167],"consumption.":[169],"Further,":[170],"introduce":[172],"concepts":[173],"reducing":[175],"number":[177],"created":[179],"levels.":[183],"This":[184],"order-preserving":[187],"has":[189],"deterministic":[190],"paths":[192],"keys,":[194],"hence,":[196],"it":[197],"does":[198],"not":[199],"require":[200,248],"any":[201],"dynamic":[202],"Finally,":[207],"yields":[211],"improvements":[212],"compared":[213],"existing":[215],"structures,":[218],"especially":[219],"skewed":[221],"data.":[222],"conclusion,":[224],"applicable":[229],"general-purpose":[231],"structure":[234],"many":[236],"different":[237],"OLTP":[238],"hybrid":[240],"(OLTP":[241],"OLAP)":[243],"management":[245],"systems":[246],"that":[247],"balanced":[249],"read/write":[250],"performance.":[251],"1":[252]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":4}],"updated_date":"2026-11-08T12:12:28.789561","created_date":"2016-06-24T00:00:00"}