Online analytical processing (OLAP) Question:

Explain about the role of bitmap indexes to solve aggregation problems?

OLAP Interview Question
OLAP Interview Question

Answer:

Bitmaps are very useful in start schema to join large databases to small databases. Answer queries and bit arrays are used to perform logical operations on the databases. Bit map indexes are very efficient in handling Gender differentiation; also repetitive tasks are performed with much larger efficiency.


Previous QuestionNext Question
Explain about the view selection problem?Explain about Encoding technique used in bitmaps indexes?