Efficient processing of set queries using bitmap indexes

مرکز و کتابخانه مطالعات اسلامی به زبان های اروپایی

منو

" Efficient processing of set queries using bitmap indexes "
Muhammad Assad Safiullah C. Li

Document Type	:	Latin Dissertation
Language of Document	:	English
Record Number	:	54299
Doc. No	:	TL24253
Call number	:	‭1456645‬
Main Entry	:	Muhammad Assad Safiullah
Title & Author	:	Efficient processing of set queries using bitmap indexes\ Muhammad Assad Safiullah
College	:	The University of Texas at Arlington
Date	:	2008
Degree	:	M.S.
student score	:	2008
Page No	:	39
Abstract	:	Growing complexity of enterprise-wide data and business processes necessitates the efficiency of complex decision support set queries. However, contemporary DBMS remain unsuccessful in handling set queries efficiently. In this thesis we propose efficient set query processing methods using bitmap index. The methods use bitmap vectors to represent attributes values in binary format. The methods test groups within a schema in a hierarchical fashion. Satisfying groups are bisected further and checked recursively while non-satisfying groups are pruned resulting in significant reduction in response times. In addition, our iterative implementation avoids the inefficiency that can be introduced by recursive implementation by reading the same bitmap vector for intersection many times. We also introduce pre-processing methods to reduce the complexity of the bitmap vectors, thus to improve the efficiency. Our implementation is based on FastBit, an open-source efficient compressed bitmap index framework. Experimental results on large datasets and comparison with results from PostgreSQL prove that our approach is superior owing to the fact that we are able to discard non-satisfying groups and capably optimize complex queries.
Subject	:	Applied sciences; Computer science; 0984:Computer science
Added Entry	:	C. Li
Added Entry	:	The University of Texas at Arlington