Query optimization for selections using bitmaps

Authors:
Ming-Chuan Wu
Affiliations:
Database Research Group, Computer Science Department, Technische Universität Darmstadt, Germany
Venue:
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Year:
1999

Citing 12
Cited 24

Join processing in database systems with large main memories

ACM Transactions on Database Systems (TODS)
Graph-Based Algorithms for Boolean Function Manipulation

IEEE Transactions on Computers
An analysis of B-trees and their variants

Information Systems
Symbolic Boolean manipulation with ordered binary-decision diagrams

ACM Computing Surveys (CSUR)
Query evaluation techniques for large databases

ACM Computing Surveys (CSUR)
Multi-table joins through bitmapped join indices

ACM SIGMOD Record
Improved query performance with variant indexes

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Bitmap index design and evaluation

SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Ubiquitous B-Tree

ACM Computing Surveys (CSUR)
Implementation techniques for main memory database systems

SIGMOD '84 Proceedings of the 1984 ACM SIGMOD international conference on Management of data
Encoded Bitmap Indexing for Data Warehouses

ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
Model 204 Architecture and Performance

Proceedings of the 2nd International Workshop on High Performance Transaction Systems

Space efficient bitmap indexing

Proceedings of the ninth international conference on Information and knowledge management
Bit-sliced index arithmetic

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Querying Compressed Data in Data Warehouses

Information Technology and Management
BitCube: A Three-Dimensional Bitmap Indexing for XML Documents

Journal of Intelligent Information Systems
Optimizing Queries on Compressed Bitmaps

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Bitmap-Based Indexing for Multi-dimensional Multimedia XML Documents

ICADL '02 Proceedings of the 5th International Conference on Asian Digital Libraries: Digital Libraries: People, Knowledge, and Technology
Calculating Aggregates with Range-Encoded Bit-Sliced Index

IDEAL '02 Proceedings of the Third International Conference on Intelligent Data Engineering and Automated Learning
Supporting Group-By and Pipelining in Bitmap-Enabled Query Processors

SOFSEM '99 Proceedings of the 26th Conference on Current Trends in Theory and Practice of Informatics on Theory and Practice of Informatics
Improving the Performance of High-Energy Physics Analysis through Bitmap Indices

DEXA '00 Proceedings of the 11th International Conference on Database and Expert Systems Applications
Bitmap Indices for Speeding Up High-Dimensional Data Analysis

DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
NetCube: A Scalable Tool for Fast Data Mining and Compression

Proceedings of the 27th International Conference on Very Large Data Bases
A bitmap-based access control for restricted views of XML documents

Proceedings of the 2003 ACM workshop on XML security
Presto Authorization: A Bitmap Indexing Scheme for High-Speed Access Control to XML Documents

IEEE Transactions on Knowledge and Data Engineering
Approximate encoding for direct access and query processing over compressed bitmaps

VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Multi-resolution bitmap indexes for scientific data

ACM Transactions on Database Systems (TODS)
Processing star queries on hierarchically-clustered fact tables

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Answering preference queries with bit-sliced index arithmetic

Proceedings of the 2008 C3S2E conference
Finding Regions of Interest in Large Scientific Datasets

SSDBM 2009 Proceedings of the 21st International Conference on Scientific and Statistical Database Management
Data mining-based materialized view and index selection in data warehouses

Journal of Intelligent Information Systems
Analyses of multi-level and multi-component compressed bitmap indexes

ACM Transactions on Database Systems (TODS)
An improved OLAP join and aggregate algorithm based on dimension hierarchy

FSKD'09 Proceedings of the 6th international conference on Fuzzy systems and knowledge discovery - Volume 5
Indexing incomplete databases

EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
Automatic selection of bitmap join indexes in data warehouses

DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
Space-efficient structures for detecting port scans

DEXA'07 Proceedings of the 18th international conference on Database and Expert Systems Applications

Quantified Score

Hi-index	0.00

Visualization

Abstract

Bitmaps are popular indexes for data warehouse (DW) applications and most database management systems offer them today. This paper proposes query optimization strategies for selections using bitmaps. Both continuous and discrete selection criteria are considered. Query optimization strategies are categorized into static and dynamic. Static optimization strategies discussed are the optimal design of bitmaps, and algorithms based on tree and logical reduction. The dynamic optimization discussed is the approach of inclusion and exclusion for both bit-sliced indexes and encoded bitmap indexes.