{"id":"https://openalex.org/W2003421875","doi":"https://doi.org/10.1145/1132863.1132864","title":"Optimizing bitmap indices with efficient compression","display_name":"Optimizing bitmap indices with efficient compression","publication_year":2006,"publication_date":"2006-03-01","ids":{"openalex":"https://openalex.org/W2003421875","doi":"https://doi.org/10.1145/1132863.1132864","mag":"2003421875"},"language":"en","primary_location":{"id":"doi:10.1145/1132863.1132864","doi":"https://doi.org/10.1145/1132863.1132864","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1132863.1132864","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2003421875"],"child_works_count":0,"type":"article","is_traditional":true,"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/A5043129695","display_name":"Kesheng John Wu","orcid":"https://orcid.org/0000-0002-6907-3393","observed_orcids":["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, Berkeley, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Lawrence Berkeley National Laboratory, Berkeley, CA","institution_ids":["https://openalex.org/I148283060"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050430493","display_name":"Ekow J. Otoo","orcid":null,"observed_orcids":[]},"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":"Ekow J. Otoo","raw_affiliation_strings":["Lawrence Berkeley National Laboratory, Berkeley, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Lawrence Berkeley National Laboratory, Berkeley, CA","institution_ids":["https://openalex.org/I148283060"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109133252","display_name":"Arie Shoshani","orcid":null,"observed_orcids":[]},"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":"Arie Shoshani","raw_affiliation_strings":["Lawrence Berkeley National Laboratory, Berkeley, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Lawrence Berkeley National Laboratory, Berkeley, CA","institution_ids":["https://openalex.org/I148283060"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I148283060"],"apc_list":null,"apc_paid":null,"fwci":37.9721,"has_fulltext":false,"cited_by_count":333,"citation_normalized_percentile":{"value":0.99814066,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":100},"biblio":{"volume":"31","issue":"1","first_page":"1","last_page":"38"},"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.6782000064849854,"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.6782000064849854,"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.3086000084877014,"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.0071000000461936,"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/bitmap-indices","display_name":"bitmap indices","score":0.8849999904632568},{"id":"https://openalex.org/keywords/range-queries","display_name":"range queries","score":0.8270000219345093},{"id":"https://openalex.org/keywords/multidimensional-range-queries","display_name":"multidimensional range queries","score":0.9480000138282776},{"id":"https://openalex.org/keywords/query-time","display_name":"query response time","score":0.7139999866485596}],"concepts":[{"id":"https://openalex.org/C3115412","wikidata":"https://www.wikidata.org/wiki/Q1194708","display_name":"Bitmap","level":2,"score":0.96732497215271},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7956578135490417},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.7925636768341064},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.6524079442024231},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.5937992930412292},{"id":"https://openalex.org/C136736807","wikidata":"https://www.wikidata.org/wiki/Q818943","display_name":"Range query (database)","level":5,"score":0.5928846001625061},{"id":"https://openalex.org/C180016635","wikidata":"https://www.wikidata.org/wiki/Q2712821","display_name":"Compression (physics)","level":2,"score":0.47525617480278015},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.473450630903244},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.43577373027801514},{"id":"https://openalex.org/C25797200","wikidata":"https://www.wikidata.org/wiki/Q828137","display_name":"Compression ratio","level":3,"score":0.42648884654045105},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3887220323085785},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.19830557703971863},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.19293996691703796},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.19049257040023804},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.14476335048675537},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.06591784954071045},{"id":"https://openalex.org/C171146098","wikidata":"https://www.wikidata.org/wiki/Q124192","display_name":"Automotive engineering","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/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.0},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C511840579","wikidata":"https://www.wikidata.org/wiki/Q12757","display_name":"Internal combustion engine","level":2,"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/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1132863.1132864","doi":"https://doi.org/10.1145/1132863.1132864","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1132863.1132864","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.160.1639","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.160.1639","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.ssrc.ucsc.edu/PaperArchive/wu-tods06.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W32845244","https://openalex.org/W67853643","https://openalex.org/W68632584","https://openalex.org/W126684907","https://openalex.org/W129807151","https://openalex.org/W1501548698","https://openalex.org/W1527137792","https://openalex.org/W1539647991","https://openalex.org/W1561200998","https://openalex.org/W1575923355","https://openalex.org/W1576757369","https://openalex.org/W1704989917","https://openalex.org/W1723787988","https://openalex.org/W1982945449","https://openalex.org/W2006148350","https://openalex.org/W2022077460","https://openalex.org/W2038926861","https://openalex.org/W2053562648","https://openalex.org/W2059417738","https://openalex.org/W2072764742","https://openalex.org/W2101566835","https://openalex.org/W2107745473","https://openalex.org/W2111967617","https://openalex.org/W2117156932","https://openalex.org/W2117716920","https://openalex.org/W2135619017","https://openalex.org/W2140646908","https://openalex.org/W2146365100","https://openalex.org/W2154462487","https://openalex.org/W2161694911","https://openalex.org/W2168410847","https://openalex.org/W2171669671","https://openalex.org/W2427788461","https://openalex.org/W2752061190","https://openalex.org/W2752853835","https://openalex.org/W4206835082","https://openalex.org/W6637500425"],"related_works":["https://openalex.org/W2018596944","https://openalex.org/W107934845","https://openalex.org/W2768256658","https://openalex.org/W1181753599","https://openalex.org/W7099290967","https://openalex.org/W2081858681","https://openalex.org/W2120706107","https://openalex.org/W2101566835","https://openalex.org/W2477076408","https://openalex.org/W4234246607"],"abstract_inverted_index":{"Bitmap":[0],"indices":[1,28,86,102,140,148],"are":[2,87],"efficient":[3,29,88],"for":[4,31,53,89],"answering":[5],"queries":[6,92,98,117,142],"on":[7,115],"low-cardinality":[8],"attributes.":[9,33],"In":[10],"this":[11],"article,":[12],"we":[13],"present":[14],"a":[15,64,69],"new":[16,39],"compression":[17],"scheme":[18],"called":[19],"Word-Aligned":[20],"Hybrid":[21],"(WAH)":[22],"code":[23],"that":[24,37,83,137],"makes":[25],"compressed":[26,40,84,139,156],"bitmap":[27,41,85,101,157],"even":[30],"high-cardinality":[32],"We":[34],"further":[35],"prove":[36],"the":[38,44,48,59,73,80,121,125,130,145],"index,":[42,50],"like":[43],"best":[45],"variants":[46],"of":[47,72,75,95,132],"B-tree":[49,152],"is":[51,68],"optimal":[52],"one-dimensional":[54,65,96],"range":[55,66,91,97,110,116],"queries.":[56,111],"More":[57],"specifically,":[58],"time":[60,128],"required":[61],"to":[62,107],"answer":[63,108,141],"query":[67,126],"linear":[70,122],"function":[71],"number":[74,131],"hits.":[76],"This":[77],"strongly":[78],"supports":[79],"well-known":[81],"observation":[82],"multidimensional":[90,109],"because":[93],"results":[94],"computed":[99],"with":[100],"can":[103],"be":[104],"easily":[105],"combined":[106],"Our":[112],"timing":[113],"measurements":[114],"not":[118],"only":[119],"confirm":[120],"relationship":[123],"between":[124],"response":[127],"and":[129,154],"hits,":[133],"but":[134],"also":[135],"demonstrate":[136],"WAH":[138],"faster":[143],"than":[144],"commonly":[146],"used":[147],"including":[149],"projection":[150],"indices,":[151,153],"other":[155],"indices.":[158]},"counts_by_year":[{"year":2026,"cited_by_count":5},{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":12},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":15},{"year":2019,"cited_by_count":14},{"year":2018,"cited_by_count":19},{"year":2017,"cited_by_count":14},{"year":2016,"cited_by_count":21},{"year":2015,"cited_by_count":30},{"year":2014,"cited_by_count":23},{"year":2013,"cited_by_count":22},{"year":2012,"cited_by_count":24}],"updated_date":"2026-11-12T12:28:57.059296","created_date":"2016-06-24T00:00:00"}
