{"title":"利用频繁项集挖掘优化编码位图索引","authors":"J. Sainui, S. Vanichayobon, N. Wattanakitrungroj","doi":"10.1109/ICCEE.2008.150","DOIUrl":null,"url":null,"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.","PeriodicalId":365473,"journal":{"name":"2008 International Conference on Computer and Electrical Engineering","volume":"547 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2008-12-20","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Optimizing Encoded Bitmap Index Using Frequent Itemsets Mining\",\"authors\":\"J. Sainui, S. Vanichayobon, N. Wattanakitrungroj\",\"doi\":\"10.1109/ICCEE.2008.150\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":365473,\"journal\":{\"name\":\"2008 International Conference on Computer and Electrical Engineering\",\"volume\":\"547 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2008-12-20\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2008 International Conference on Computer and Electrical Engineering\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICCEE.2008.150\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2008 International Conference on Computer and Electrical Engineering","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICCEE.2008.150","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Optimizing Encoded Bitmap Index Using Frequent Itemsets Mining
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.