The Community for Technology Leaders
Green Image
Issue No. 09 - Sept. (2012 vol. 24)
ISSN: 1041-4347
pp: 1570-1583
Bin He , IBM Almaden Research Center, San Jose
Hui-I Hsiao , IBM Almaden Research Center, San Jose
Ziyang Liu , NEC Laboratories America, Inc., Cupertino
Yu Huang , Arizona State University, Tempe
Yi Chen , Arizona State University, Tempe
Decision support and knowledge discovery systems often compute aggregate values of interesting attributes by processing a huge amount of data in very large databases and/or warehouses. In particular, iceberg query is a special type of aggregation query that computes aggregate values above a user-provided threshold. Usually, only a small number of results will satisfy the threshold constraint. Yet, the results often carry very important and valuable business insights. Because of the small result set, iceberg queries offer many opportunities for deep query optimization. However, most existing iceberg query processing algorithms do not take advantage of the small-result-set property and rely heavily on the tuple-scan-based approach. This incurs intensive disk accesses and computation, resulting in long processing time especially when data size is large. Bitmap index, which builds one bitmap vector for each attribute value, is gaining popularity in both column-oriented and row-oriented databases in recent years. It occupies less space than the raw data and gives opportunities for more efficient query processing. In this paper, we exploited the property of bitmap index and developed a very effective bitmap pruning strategy for processing iceberg queries. Our index-pruning-based approach eliminates the need of scanning and processing the entire data set (table) and thus speeds up the iceberg query processing significantly. Experiments show that our approach is much more efficient than existing algorithms commonly used in row-oriented and column-oriented databases.
Heuristic algorithms, Indexes, Aggregates, Query processing, Business, column-oriented database, Iceberg query, bitmap index
Bin He, Hui-I Hsiao, Ziyang Liu, Yu Huang, Yi Chen, "Efficient Iceberg Query Evaluation Using Compressed Bitmap Index", IEEE Transactions on Knowledge & Data Engineering, vol. 24, no. , pp. 1570-1583, Sept. 2012, doi:10.1109/TKDE.2011.73
94 ms
(Ver 3.3 (11022016))