Title :
Optimizing Encoded Bitmap Index Using Frequent Itemsets Mining
Author :
Sainui, Janya ; Vanichayobon, Sirirut ; Wattanakitrungroj, Niwan
Author_Institution :
Dept. of Comput. Sci., Prince of Songkla Univ., Songkhla
Abstract :
Indexing techniques based on bitmap representations are well suited to a warehouse system. They significantly improve query processing time by utilizing low-cost Boolean operations and multiple index scans, executing queries by performing simple predicate conditions on the index level before going to the primary data source. To optimize existing Encoded Bitmap Index, in this paper, we apply a data mining technique called frequent itemsets mining to find a well-defined encoding scheme, leading to improve query processing time. Our comparative study show that in the best case the performance of optimizing Encoded Bitmap Index using frequent itemsets mining is better than those found by existing techniques for membership queries from the point of view of space-time trade-off.
Keywords :
data mining; data warehouses; indexing; query processing; Boolean operations; bitmap representations; data mining technique; encoded bitmap index; frequent itemsets mining; membership queries; query processing; warehouse system; Computer science; Data mining; Data warehouses; Delay; Electronic mail; Encoding; Indexing; Itemsets; Parallel machines; Query processing; bitmap index; frequent itemsets mining;
Conference_Titel :
Computer and Electrical Engineering, 2008. ICCEE 2008. International Conference on
Conference_Location :
Phuket
Print_ISBN :
978-0-7695-3504-3
DOI :
10.1109/ICCEE.2008.150