{"id":"https://openalex.org/W4248408214","doi":"https://doi.org/10.1109/ideas.2007.4318091","title":"Bitmap Index Design Choices and Their Performance Implications","display_name":"Bitmap Index Design Choices and Their Performance Implications","publication_year":2007,"publication_date":"2007-09-01","ids":{"openalex":"https://openalex.org/W4248408214","doi":"https://doi.org/10.1109/ideas.2007.4318091"},"language":"en","primary_location":{"id":"doi:10.1109/ideas.2007.4318091","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ideas.2007.4318091","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"11th International Database Engineering and Applications Symposium (IDEAS 2007)","raw_type":"proceedings-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/A5111369063","display_name":"Elizabeth O\u2019Neil","orcid":null},"institutions":[{"id":"https://openalex.org/I33434090","display_name":"University of Massachusetts Boston","ror":"https://ror.org/04ydmy275","country_code":"US","type":"education","lineage":["https://openalex.org/I33434090"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Elizabeth O'Neil","raw_affiliation_strings":["University of Massachusetts, Boston, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Massachusetts, Boston, USA","institution_ids":["https://openalex.org/I33434090"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113511047","display_name":"Patrick O\u2019Neil","orcid":null},"institutions":[{"id":"https://openalex.org/I33434090","display_name":"University of Massachusetts Boston","ror":"https://ror.org/04ydmy275","country_code":"US","type":"education","lineage":["https://openalex.org/I33434090"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Patrick O'Neil","raw_affiliation_strings":["University of Massachusetts, Boston, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Massachusetts, Boston, USA","institution_ids":["https://openalex.org/I33434090"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5043129695","display_name":"Kesheng Wu","orcid":"https://orcid.org/0000-0002-6907-3393"},"institutions":[{"id":"https://openalex.org/I148283060","display_name":"Lawrence Berkeley National Laboratory","ror":"https://ror.org/02jbv0t02","country_code":"US","type":"facility","lineage":["https://openalex.org/I1330989302","https://openalex.org/I148283060","https://openalex.org/I39565521"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kesheng Wu","raw_affiliation_strings":["Lawrence Berkeley National Laboratory, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Lawrence Berkeley National Laboratory, USA","institution_ids":["https://openalex.org/I148283060"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.0317,"has_fulltext":false,"cited_by_count":30,"citation_normalized_percentile":{"value":0.92340393,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"72","last_page":"84"},"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.9995999932289124,"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.9995999932289124,"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.9991999864578247,"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"}},{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9811000227928162,"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/bitmap","display_name":"Bitmap","score":0.9672757983207703},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.818453848361969},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.6891634464263916},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.6038948893547058},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.6033928990364075},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5531651377677917},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5465781688690186},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5303220152854919},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.5122808814048767},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.4611091911792755},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.4590983986854553},{"id":"https://openalex.org/keywords/row","display_name":"Row","score":0.457472562789917},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3705318570137024},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1552795171737671},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.10975968837738037},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1093457043170929}],"concepts":[{"id":"https://openalex.org/C3115412","wikidata":"https://www.wikidata.org/wiki/Q1194708","display_name":"Bitmap","level":2,"score":0.9672757983207703},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.818453848361969},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.6891634464263916},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6038948893547058},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.6033928990364075},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5531651377677917},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5465781688690186},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5303220152854919},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.5122808814048767},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.4611091911792755},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.4590983986854553},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.457472562789917},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3705318570137024},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1552795171737671},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.10975968837738037},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1093457043170929},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/ideas.2007.4318091","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ideas.2007.4318091","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"11th International Database Engineering and Applications Symposium (IDEAS 2007)","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.77.6028","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.77.6028","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.umb.edu/~poneil/BitmDesIdeas07.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W1496669888","https://openalex.org/W1501548698","https://openalex.org/W1565098692","https://openalex.org/W1967983783","https://openalex.org/W2003421875","https://openalex.org/W2101566835","https://openalex.org/W2111967617","https://openalex.org/W2127069799","https://openalex.org/W3138367763","https://openalex.org/W3140081847","https://openalex.org/W4234246607","https://openalex.org/W4234825580","https://openalex.org/W6629843584","https://openalex.org/W6633493289","https://openalex.org/W6638231387","https://openalex.org/W6675349867","https://openalex.org/W6679136211"],"related_works":["https://openalex.org/W2394126128","https://openalex.org/W185307983","https://openalex.org/W13798402","https://openalex.org/W2155928473","https://openalex.org/W4248408214","https://openalex.org/W2199640993","https://openalex.org/W2495090380","https://openalex.org/W1505866794","https://openalex.org/W2117716920","https://openalex.org/W2527247821"],"abstract_inverted_index":{"Historically,":[0],"bitmap":[1,57,83,85,133,162,187],"indexing":[2,223],"has":[3],"provided":[4],"an":[5,51,110],"important":[6],"database":[7,16,37,229],"capability":[8],"to":[9,143,196,220],"accelerate":[10],"queries.":[11],"However,":[12],"only":[13],"a":[14,36,72,126,149,161,185,190,216],"few":[15],"systems":[17],"have":[18,48],"implemented":[19],"these":[20],"indexes":[21],"because":[22],"of":[23,26,35,43,46,100,120,128,132,173,193,209,218],"the":[24,31,41,121,139,155,174,194,205,221,228],"difficulties":[25],"modifying":[27],"fundamental":[28],"assumptions":[29],"in":[30,40,50,88,227],"low-":[32],"level":[33],"design":[34,81,112,211],"system":[38],"and":[39,63,93,98,125,147,160,207],"expectations":[42],"customers,":[44],"both":[45],"which":[47],"developed":[49],"environment":[52],"that":[53,61,65,76,151],"does":[54],"not":[55],"support":[56],"indexes.":[58,134],"Another":[59],"problem":[60],"arises,":[62],"one":[64],"may":[66],"more":[67],"easily":[68],"be":[69],"addressed":[70],"by":[71],"research":[73,130],"article,":[74],"is":[75,78,168],"there":[77],"no":[79],"definitive":[80],"for":[82,104],"indexes;":[84],"index":[86],"designs":[87],"Oracle,":[89],"Sybase":[90],"IQ,":[91],"Vertica":[92],"MODEL":[94],"204":[95],"are":[96,180],"idiosyncratic,":[97],"some":[99],"them":[101],"were":[102],"designed":[103],"older":[105],"machine":[106],"architectures.":[107],"To":[108],"investigate":[109],"efficient":[111],"on":[113,170],"modern":[114],"processors,":[115],"this":[116,201],"paper":[117],"provides":[118],"details":[119],"Set":[122],"Query":[123],"benchmark":[124],"comparison":[127],"two":[129],"implementations":[131],"One,":[135],"called":[136,166],"RIDBit,":[137],"uses":[138],"N-ary":[140],"storage":[141],"model":[142],"organize":[144],"table":[145,175],"rows,":[146],"implements":[148,184],"strategy":[150],"gracefully":[152],"switches":[153],"between":[154],"well-known":[156],"B-tree":[157],"RID-list":[158],"structure":[159],"structure.":[163],"The":[164],"other,":[165],"FastBit":[167],"based":[169],"vertical":[171],"organization":[172,192],"data,":[176],"where":[177],"all":[178],"columns":[179],"individually":[181],"stored.":[182],"It":[183],"compressed":[186],"index,":[188],"with":[189],"linear":[191],"bitmaps":[195],"optimize":[197],"disk":[198],"accesses.":[199],"Through":[200],"comparison,":[202],"we":[203],"evaluate":[204],"pros":[206],"cons":[208],"various":[210],"choices.":[212],"Our":[213],"analysis":[214],"adds":[215],"number":[217],"subtleties":[219],"conventional":[222],"wisdom":[224],"commonly":[225],"quoted":[226],"community.":[230]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}