Analyses of multi-level and multi-component compressed bitmap indexes

ACM Transactions on Database Systems

Volumn 35, Issue 1, 2010, Pages

  Wu, Kesheng ^a   Shoshani, Arie ^a   Stockinger, Kurt ^a  

^a LAWRENCE BERKELEY NATIONAL LABORATORY   (United States)

Author keywords

Compression; Multi component bitmap index; Multi level bitmap index; Performance analysis

Indexed keywords

ANSWERING QUERIES; BITMAP INDEXES; CLOSED FORM; COMMERCIAL PRODUCTS; INDEXING METHODS; MULTI-LEVEL; MULTICOMPONENTS; OPTIMAL COMPUTATIONAL COMPLEXITY; PERFORMANCE ANALYSIS; RANGE QUERY; WORST CASE;

COMPUTATIONAL COMPLEXITY;

INDEXING (OF INFORMATION);

EID: 77249148544     PISSN: 03625915     EISSN: 15574644     Source Type: Journal    
DOI: 10.1145/1670243.1670245     Document Type: Article

References (44)

1. ANTOSHENKOV, G. 1995. Byte-Aligned bitmap compression. In Proceedings of the Data Compression Conference (DCC'95). U.S. Patent number 5,363,098.
2. ANTOSHENKOV, G. AND ZIAUDDIN, M. 1996. Query processing and optimization in ORACLE RDB. VLDB J. 5, 229-237.
3. BLOCH, G., GREINER, S., DE MEER, H., AND TRIVEDI, K. S. 1998. Queueing Networks and Markov Chains. John Wiley and Sons, New York.
4. BOOKSTEIN, A. AND KLEIN, S. T. 1990. Using bitmaps for medium sized information retrieval systems. Inform. Process. Manag. 26, 525-533.
5. BOOKSTEIN, A., KLEIN, S. T., AND RAITA, T. 2000. Simple Bayesian model for bitmap compression. Inform. Retriev. 1, 4, 315-328.
6. CHAN, C.-Y. AND IOANNIDIS, Y. E. 1998. Bitmap index design and evaluation. In Proceedings of the ACM SIGMOD International Conference on Management of Data. ACM Press, New York, 355-366.
7. CHAN, C. Y. AND IOANNIDIS, Y. E. 1999. An efficient bitmap encoding scheme for selection queries. In Proceedings of the ACM SIGMOD International Conference on Management of Data. ACM Press, New York, 215-226.
8. CHAUDHURI, S., DAYAL, U., AND GANTI, V. 2001. Database technology for decision support systems. Comput. 34, 12, 48-55.
9. COMER, D. 1979. The ubiquitous B-tree. Comput. Surv. 11, 2, 121-137.
10. DELIS, A., FALOUTSOS, C., ANDGHANDEHARIZADEH, S., EDS. 1999. In Proceedings of the ACMSIGMOD International Conference on Management of Data. ACM Press, New York.
11. FALOUTSOS, C. AND CHRISTODOULAKIS, S. 1984. Signature files: An access method for documents and its analytical performance evaluation. ACM Trans. Inform. Syst. 2, 4, 267-288.
12. FALOUTSOS, C., MATIAS, Y., AND SILBERSCHATZ, A. 1996. Modeling skewed distribution using multifractals and the '80-20' law. In Proceedings of the International Conference on Very Large DataBases (VLDB '96). Morgan Kaufmann, San Francisco, CA, 307-317.
13. HU, Y., SUNDARA, S., CHORMA, T., AND SRINIVASAN, J. 2005. Supporting RFID-based item tracking applications in oracle DBMS using a bitmap datatype. In Proceedings of the International Conference on Very Large DataBases (VLDB).
14. K. Böhm, C. S. Jensen, L. M. Haas, M. L. Kersten, P.-°A. Larson, and B. C. Ooi Eds., ACM Press, New York, 1140-1151.
15. JOHNSON, T. 1999. Performance measurements of compressed bitmap indices. In Proceedings of the 25th International Conference on Very Large Data Bases (VLDB'99). M. P. Atkinson, M. E. Orlowska, P. Valduriez, S. B. Zdonik, and M. L. Brodie Eds. Morgan Kaufmann, San Francisco, CA, 278-289.
16. KNUTH, D. E. 1998. The Art of Computer Programming 2nd Ed. Vol.3. Addison Wesley.
17. KOUDAS, N. 2000. Space efficient bitmap indexing. In Proceedings of the 9th International Conference on Information Knowledge Management (CIKM'00). ACM Press, New York, 194-201.
18. LIEBENDöRFER, M., RAMPP, M., JANKA, H.-T., ANDMEZZACAPPA, A. 2005. Supernova simulations with boltzmann neutrino transport: A comparison of methods. Astrophys. J. 620, 840-860.
19. LIN, X., LI, Y., AND TSANG, C. P. 1999. Applying on-line bitmap indexing to reduce counting costs in mining association rules. Inform. Sci. 120, 1-4, 197-208.
20. MACNICOL, R. AND FRENCH, B. 2004. Sybase IQ multiplex-Designed for analytics. In Proceedings of the 30th International Conference on Very Large DataBases (VLDB'04). 1227-1230.
21. MOFFAT, A. AND ZOBEL, J. 1992. Parameterised compression for sparse bitmaps. In Proceedings of the ACM-SIGIR International Conference on Research and Development in Information Retrieval. N. Belkin, P. Ingwersen, and A. M. Pejtersen Eds., ACM Press, New York, 274-285.
22. NASCIMENTO, M. A., öZSU, M. T., KOSSMANN, D., MILLER, R. J., BLAKELEY, J. A., AND SCHIEFER, K. B., EDS. 2004. In Proceedings of the 30th International Conference on Very Large Data Bases (VLDB'04). Morgan Kaufmann.
23. O'NEIL, E., O'NEIL, P., AND WU, K. 2007. Bitmap index design choices and their performance implications. In Proceedings of IDEAS'07. 72-84.
24. O'NEIL, P. 1987. Model 204 architecture and performance. In Proceedings of the 2nd International Workshop in High Performance Transaction Systems. Lecture Notes in Computer Science, vol.359. Springer, 40-59.
25. O'NEIL, P. 1997. Informix indexing support for data warehouses. Datab. Program. Des. 10, 2, 38-43.
26. O'NEIL, P. AND QUASS, D. 1997. Improved query performance with variant indices. In Proceedings of the ACM SIGMOD International Conference on Management of Data. J. Peckham Ed., ACM Press, New York, 38-49.
27. O'NEIL, P. E. AND GRAEFE, G. 1995. Multi-Table joins through bitmapped join indices. SIGMOD Rec. 24, 3, 8-11.
28. PEDERSEN, T. B. AND JENSEN, C. S. 1998. Research issues in clinical data warehousing. In Proceedings of the 10th International Conference on Scientific and Statistical Database Management. M. Rafanelli and M. Jarke Eds., IEEE Computer Society, 43-52.
29. ROTEM, D., STOCKINGER, K., ANDWU, K. 2005. Optimizing candidate check costs for bitmap indices. In Proceedings of the ACMInternational Conference on Information and Knowledge Management (CIKM'05).
30. SINHA, R. R. AND WINSLETT, M. 2007. Multi-Resolution bitmap indexes for scientific data. ACM Trans. Datab. Syst. 32, 3, 16.
31. STOCKINGER, K., SHALF, J., BETHEL, W., ANDWU, K. 2005. DEX: Increasing the capability of scientific data analysis pipelines by using efficient bitmap indices to accelerate scientific visualization. In Proceedings of the International Conference on Statistical and Scientific Database Management (SSDBM'05). 35-44. LBNL rep. LBNL-57023.
32. STOCKINGER, K. ANDWU, K. 2006. Bitmap Indices for Data Warehouses. Idea Group, Inc., Chapter VII, 179-202. LBNL-59952.
33. STOCKINGER, K., WU, K., AND SHOSHANI, A. 2002. Strategies for processing ad hoc queries on large data warehouses. In Proceedings of the InternationalWorkshop on DataWarehouseing and OLAP (DOLAP'02). 72-79.
34. STOCKINGER, K., WU, K., AND SHOSHANI, A. 2004. Evaluation strategies for bitmap indices with binning. In Proceedings of the International Conference on Database and Expert Systems Applications (DEXA'04). Springer.
35. WONG, H. K. T., LIU, H.-F., OLKEN, F., ROTEM, D., AND WONG, L. 1985. Bit transposed files. In Proceedings of the International Conference on Very Large DataBases (VLDB'85). 448-457.
36. WU, K. 2005. FastBit: An efficient indexing technology for accelerating data-intensive science. J. Phys.: Conf. Ser. 16, 556-560.
37. WU, K., OTOO, E., AND SHOSHANI, A. 2001a. Compressed bitmap indices for efficient query processing. Tech. rep. LBNL-47807, Lawrence Berkeley National Laboratory, Berkeley, CA.
38. WU, K., OTOO, E., AND SHOSHANI, A. 2001b. A performance comparison of bitmap indexes. In Proceedings of the ACM International Conference on Information and Knowledge Management (CIKM). 559-561.
39. WU, K.,OTOO, E., AND SHOSHANI,A. 2004. Onthe performance of bitmap indices for high cardinality attributes. In Proceedings of the International Conference on Very Large Databases (VLDB'04). 24-35. LBNL-54673.
40. WU, K., OTOO, E., AND SHOSHANI, A. 2006. Optimizing bitmap indices with efficient compression. ACM Trans. Datab. Syst. 31, 1-38.
41. WU, K.-L. AND YU, P. 1996. Range-Based bitmap indexing for high cardinality attributes with skew. Tech. rep. RC 20449, IBM Watson Research Division, Yorktown Heights, NY.
42. WU, M.-C. 1999. Query optimization for selections using bitmaps. In Proceedings of the ACM SIGMOD International Conference on Management of Data. ACM Press, New York.
43. WU, M.-C. AND BUCHMANN, A. P. 1998. Encoded bitmap indexing for data warehouses. In Proceedings of the 14th International Conference on Data Engineering. IEEE Computer Society, 220-230.
44. ZOBEL, J., MOFFAT, A., AND RAMAMOHANARAO, K. 1998. Inverted files versus signature files for text indexing. ACM Trans. Datab. Syst. 23, 4, 453-490.