A materialized view selection in data warehouse management is important to speed up query processing. The data presented in data warehouses is generally stored as a set of materialized views. The major challenge is determining which views to materialize and satisfy the response time with reduced cost functions. This paper proposed an effective multi objective cost model based flamingo search algorithm for materialized view selection in data warehouse design. The multiple view processing plan structure of the data warehouse describes the search space of problem in order to select the optimal materialized views. The proposed model evaluates a multi-objective optimization problem based on the cost functions resulting from materialization. The multiple objective functions of the proposed model are maintenance costs, current query processing costs, response cost and previous query processing costs. This model selects the top-k views for materialization by satisfying the mentioned multi-objective functions. The experimental results are simulated using the TPC-H dataset. The efficacy of proposed model is measured by comparing the obtained results of the proposed model with various existing approaches.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.