Bitmap index
A bitmap index is a special kind of database index that uses bitmaps. Bitmap indexes have traditionally been considered to work well for low-cardinality columns, which have a modest number of distinct values, either absolutely, or relative to the number of records that contain the data. The extreme case of low cardinality is Boolean data (e.g., does a resident in a city have internet access?), which has two values, True and False. Bitmap indexes use bit arrays (commonly called bitmaps) and answer queries by performing bitwise logical operations on these bitmaps. Bitmap indexes have a significant space and performance advantage over other structures for query of such data. Their drawback is they are less efficient than the traditional B-tree indexes for columns whose data is frequently upda
Wikipage disambiguates
Wikipage redirect
Binary IndexBinary indexBit IndexBit arrayBit indexBitmapBitmap (disambiguation)Bitmap IndexColumn-oriented DBMSComparison of relational database management systemsDimensional modelingDrizzle (database server)Free space bitmapInverted indexJoin (SQL)LucidDBModel 204Patrick O'NeilPostgreSQLRelational databaseReverse indexRun-length encodingSpace–time tradeoff
Link from a Wikipage to another Wikipage
primaryTopic
Bitmap index
A bitmap index is a special kind of database index that uses bitmaps. Bitmap indexes have traditionally been considered to work well for low-cardinality columns, which have a modest number of distinct values, either absolutely, or relative to the number of records that contain the data. The extreme case of low cardinality is Boolean data (e.g., does a resident in a city have internet access?), which has two values, True and False. Bitmap indexes use bit arrays (commonly called bitmaps) and answer queries by performing bitwise logical operations on these bitmaps. Bitmap indexes have a significant space and performance advantage over other structures for query of such data. Their drawback is they are less efficient than the traditional B-tree indexes for columns whose data is frequently upda
has abstract
A bitmap index is a special ki ...... ose arranged in a star schema.
@en
Bitmapové indexování je speciá ...... y v prostředí datových skladů.
@cs
Link from a Wikipage to an external page
Wikipage page ID
page length (characters) of wiki page
Wikipage revision ID
1,022,279,226
Link from a Wikipage to another Wikipage
wikiPageUsesTemplate
hypernym
comment
A bitmap index is a special ki ...... whose data is frequently upda
@en
Bitmapové indexování je speciá ...... y v prostředí datových skladů.
@cs
label
Bitmap index
@en
Bitmap-Index
@de
Bitmapové indexování
@cs