Materialized View Selection using Marriage in Honey Bees Optimization

摘要: Data warehouse was designed to cater the strategic decision making needs of an organization. Most queries posed on them are on-line analytical queries, which complex and computation intensive in nature have high query response times when processed against a large data warehouse. This time can be substantially reduced by materializing pre-computed summarized views storing All possible cannot materialized due storage space constraints. Also, optimal selection subsets is shown NP-Complete problem. problem view has been addressed this paper selecting beneficial set views, from amongst all using swarm intelligence technique Marriage Honey Bees Optimization MBO. An MBO based algorithm MBOVSA, aims select that incur minimum total cost evaluating TVEC, proposed. In search intensified incorporating royal jelly feeding phase into compared with most fundamental greedy HRUA, able comparatively better quality views.