skip to main content
10.1145/1183512.1183529acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
Article

Heuristic design of property maps

Published: 10 November 2006 Publication History

Abstract

The Property Map is a specialized multidimensional indexing technique that precomputes attribute expressions for selected data items and stores the results as bit strings. Property Maps effectively index multi-attribute queries and high cardinality attributes. Designing properties for a Property Map, however, is not a trivial task. The solution space has exponential complexity; thus we develop heuristic algorithms to reduce the number of solutions to consider while still producing a Property Map index with good performance. In this paper, the algorithms comprising the design framework for Property Maps are discussed and illustrated.

References

[1]
Chan, C.Y., and Y. Ioannidis, "Bitmap Index Design and Evaluation." Proceedings of the ACM SIGMOD International Conference, Seattle, Washington, June 1998, pp. 355--366.
[2]
Davis, K.C., and A. Gupta, "Indexing in Data Warehouses: Bitmaps and Beyond," Data Warehouses and OLAP: Concepts, Architectures and Solutions, Idea Group, Inc., 2006.
[3]
Dharmarajan, B., and K.C. Davis, "Property Maps: A New Secondary Access Mechanism," Proceedings of the Information Resources Management Association Conference, Hershey, PA, May 1999.
[4]
Gray, J., The Benchmark Handbook for Database and Transaction Processing Systems, Morgan Kaufmann Publishers, Inc., 1993.
[5]
Grommon-Litton, J., "Heuristic Design Algorithms and Evaluation Methods for Property Maps," Masters Thesis, ECECS Dept., University of Cincinnati, Cincinnati, OH, November 2000.
[6]
Gupta, A., Davis, K.C., and J. Grommon-Litton, "A Performance Comparison of Property Map and Bitmap Indexing," Proceedings of ACM Workshop on Data Warehousing and On-Line Analytical Processing, McLean, VA, November 2002, pp. 65--71.
[7]
Piatetsky-Shapiro, G., and C. Connell, "Accurate Estimation of the Number of Tuples Satisfying a Condition," Proceedings of the ACM SIGMOD International Conference on the Management of Data, Boston, MA, June 1984, pp. 256--275.

Cited By

View all
  • (2019)Sorting improves word-aligned bitmap indexesData & Knowledge Engineering10.1016/j.datak.2009.08.00669:1(3-28)Online publication date: 1-Jan-2019
  • (2008)Histogram-aware sorting for enhanced word-aligned compression in bitmap indexesProceedings of the ACM 11th international workshop on Data warehousing and OLAP10.1145/1458432.1458434(1-8)Online publication date: 30-Oct-2008

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
DOLAP '06: Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
November 2006
110 pages
ISBN:1595935304
DOI:10.1145/1183512
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 10 November 2006

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. data warehouse
  2. index design

Qualifiers

  • Article

Conference

CIKM06
CIKM06: Conference on Information and Knowledge Management
November 10, 2006
Virginia, Arlington, USA

Acceptance Rates

Overall Acceptance Rate 29 of 79 submissions, 37%

Upcoming Conference

CIKM '25

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)0
  • Downloads (Last 6 weeks)0
Reflects downloads up to 30 Jan 2025

Other Metrics

Citations

Cited By

View all
  • (2019)Sorting improves word-aligned bitmap indexesData & Knowledge Engineering10.1016/j.datak.2009.08.00669:1(3-28)Online publication date: 1-Jan-2019
  • (2008)Histogram-aware sorting for enhanced word-aligned compression in bitmap indexesProceedings of the ACM 11th international workshop on Data warehousing and OLAP10.1145/1458432.1458434(1-8)Online publication date: 30-Oct-2008

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media