Title :
Using Data Clustering to Optimize Scatter Bitmap Index for Membership Queries
Author :
Weahama, Weahason ; Vanichayobon, Sirirut ; Manfuekphan, Jarin
Author_Institution :
Fac. of Eng., Prince of Songkhla Univ. Songkhla, Songkhla
Abstract :
Decision support systems that retrieve information from a data warehouse environment are usually designed to process complex and ad hoc queries. Indexing techniques based on bitmap representations can be used to improve the efficiency of information retrieval. Scatter Bitmap Index uses less space and is more CPU-efficient than other bitmap indexing techniques. It is simple to represent, and improves query processing time by utilizing low-cost Boolean operations and multiple index scans. The Scatter Bitmap Index technique performs simple predicate conditions on the index level before going to the primary data source. Furthermore, Scatter Bitmap Index can be optimized by applying K-mode Clustering, which finds relationships among attribute values in queries. In this paper, we show that Data Clustering with Scatter Bitmap Index can improve query processing time for membership queries.
Keywords :
data warehouses; pattern clustering; query processing; K-mode clustering; ad hoc queries; bitmap indexing techniques; bitmap representations; data clustering; data warehouse; decision support systems; information retrieval; low-cost Boolean operations; membership queries; multiple index scans; query processing; scatter bitmap index; Data engineering; Data warehouses; Design automation; Design engineering; Design optimization; Indexing; Information analysis; Information retrieval; Query processing; Scattering; bitmap index; clustering; data warehouse;
Conference_Titel :
Computer and Automation Engineering, 2009. ICCAE '09. International Conference on
Conference_Location :
Bangkok
Print_ISBN :
978-0-7695-3569-2
DOI :
10.1109/ICCAE.2009.33