NDLI: An efficient bitmap encoding scheme for selection queries

Content Provider	ACM Digital Library
Author	Ioannidis, Yannis E. Chan, Chee-Yong
Abstract	Bitmap indexes are useful in processing complex queries in decision support systems, and they have been implemented in several commercial database systems. A key design parameter for bitmap indexes is the encoding scheme, which determines the bits that are set to 1 in each bitmap in an index. While the relative performance of the two existing bitmap encoding schemes for simple selection queries of the form “v1 ≤ A ≤ v2” is known (specifically, one of the encoding schemes is better for processing equality queries; i.e., v1 = v2, while the other is better for processing range queries; i.e., v1 < v2), it remains an open question whether these two encoding schemes are indeed optimal for their respective query classes in the sense that there is no other encoding scheme with better space-time tradeoff. In this paper, we establish a number of optimality results for the existing encoding schemes; in particular, we prove that neither of the two known schemes is optimal for the class of two-sided range queries. We also propose a new encoding scheme and prove that it is optimal for that class. Finally, we present an experimental study comparing the performance of the new encoding scheme with that of the existing ones as well as four hybrid encoding schemes for both simple selection queries and the more general class of membership queries of the form “A ∈ {v1, v2, .…, vk}”. These results demonstrate that the new encoding scheme has an overall better space-time performance than existing schemes.
Starting Page	215
Ending Page	226
Page Count	12
File Format	PDF
ISSN	01635808
DOI	10.1145/304181.304201
Journal	ACM SIGMOD Record (SGMD)
Volume Number	28
Issue Number	2
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	1999-06-01
Publisher Place	New York
Access Restriction	One Nation One Subscription (ONOS)
Content Type	Text
Resource Type	Article
Subject	Information Systems Software

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

An efficient bitmap encoding scheme for selection queries

An efficient scheme for providing high availability

Generating efficient plans for queries using views

Optimizing bitmap indices with efficient compression

Towards an efficient evaluation of general queries: quantifier and disjunction processing revisited

Efficient evaluation of XML middle-ware queries

An extensible notation for spatiotemporal index queries

PREFER:a system for the efficient execution of multi-parametric ranked queries

Bitmap index design and evaluation

An efficient bitmap encoding scheme for selection queries

Similar Documents

An efficient bitmap encoding scheme for selection queries

An efficient scheme for providing high availability

Generating efficient plans for queries using views

Optimizing bitmap indices with efficient compression

Towards an efficient evaluation of general queries: quantifier and disjunction processing revisited

Efficient evaluation of XML middle-ware queries

An extensible notation for spatiotemporal index queries

PREFER:a system for the efficient execution of multi-parametric ranked queries

Bitmap index design and evaluation

An efficient bitmap encoding scheme for selection queries