Materialized View Selection Using Swap Operator Based Particle Swarm Optimization

Materialized View Selection Using Swap Operator Based Particle Swarm Optimization

Amit Kumar, T. V. Vijay Kumar
Copyright: © 2021 |Volume: 13 |Issue: 1 |Pages: 16
ISSN: 2637-7888|EISSN: 2637-7896|EISBN13: 9781799863564|DOI: 10.4018/ijdai.2021010103
Cite Article Cite Article

MLA

Kumar, Amit, and T. V. Vijay Kumar. "Materialized View Selection Using Swap Operator Based Particle Swarm Optimization." IJDAI vol.13, no.1 2021: pp.58-73. http://doi.org/10.4018/ijdai.2021010103

APA

Kumar, A. & Kumar, T. V. (2021). Materialized View Selection Using Swap Operator Based Particle Swarm Optimization. International Journal of Distributed Artificial Intelligence (IJDAI), 13(1), 58-73. http://doi.org/10.4018/ijdai.2021010103

Chicago

Kumar, Amit, and T. V. Vijay Kumar. "Materialized View Selection Using Swap Operator Based Particle Swarm Optimization," International Journal of Distributed Artificial Intelligence (IJDAI) 13, no.1: 58-73. http://doi.org/10.4018/ijdai.2021010103

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

The data warehouse is a key data repository of any business enterprise that stores enormous historical data meant for answering analytical queries. These queries need to be processed efficiently in order to make efficient and timely decisions. One way to achieve this is by materializing views over a data warehouse. An n-dimensional star schema can be mapped into an n-dimensional lattice from which Top-K views can be selected for materialization. Selection of such Top-K views is an NP-Hard problem. Several metaheuristic algorithms have been used to address this view selection problem. In this paper, a swap operator-based particle swarm optimization technique has been adapted to address such a view selection problem.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.