Overview of Presentation

Table of Contents

PPT Slide

Overview of Presentation

Integrated vs. Specialized Products for Warehousing

Integrated vs. Specialized Products for Warehousing

Why Update Capability Is Useful

What Is a Bitmap Index?

Basic Observations

Bitmap Indexes in Oracle

Oracle’s Bitmap Access Methods

Equality Predicates

AND Predicates

OR Predicates

NOT EQUAL Predicates

Range Predicates

GROUP BY Queries

Distinct Queries

Combining Predicates

Bitmap Indexes On Disk

Bitmap Index Creation

Updates and Mapping Rows to Bitmaps

Updates to Bitmap Indexes

Compression

Index Size

Star Join Queries

Star Join Queries (cont’d)Basic Idea

Star Join Queries (cont’d)

Star Join Queries (cont’d)

Star Join Queries (cont’d)

Star Join Queries (cont’d)

Star Join Queries (cont’d)

Star Join Queries (cont’d)

Conclusion