Materialized view selection using HBMO

详细信息    查看全文

• 作者：T. V. Vijay Kumar ; Biri Arun
• 关键词：Data warehouse ; Materialized view selection ; Swarm intelligence ; Honey bee mating optimization
• 刊名：International Journal of System Assurance Engineering and Management
• 出版年：2017
• 出版时间：January 2017
• 年：2017
• 卷：8
• 期：1-supp
• 页码：379-392
• 全文大小：
• 刊物类别：Engineering
• 刊物主题：Quality Control, Reliability, Safety and Risk; Engineering Economics, Organization, Logistics, Marketing;
• 出版者：Springer India
• ISSN：0976-4348
• 卷排序：8

文摘

Strategic business decision making has become far more complex, challenging and consequential in today’s modern and highly competitive economy. So, managers have been using decision support systems to assist them in making accurate, efficient and effective decisions. These systems takes hours and days to process massive data sets in order to find relevant information for answering analytical queries. As a result the query response times are high. This response time can be reduced substantially by selecting and materializing pre-computed views that can provide answers to analytical queries. In this paper, an attempt has been made to select optimal sets of views, which would significantly reduce response time of analytical queries. In this regard, honey bee mating optimization based view selection algorithm (HBMOVSA) is proposed that selects Top-K views, from amongst all possible views, in a multidimensional lattice. Experimental results show that HBMOVSA is able to select comparatively better quality of views when compared with those selected by the most fundamental view selection algorithm HRUA.