A reference-point-based multi-objective materialized view selection algorithm

Jay Prakash and T. V. Vijay Kumar ()
Additional contact information
Jay Prakash: Jawaharlal Nehru University
T. V. Vijay Kumar: Jawaharlal Nehru University

International Journal of System Assurance Engineering and Management, 2024, vol. 15, issue 12, No 15, 5676-5694

Abstract: Abstract Data warehouse plays a pivotal role in devising business strategies for organizations to stay competitive in the market. Analytical queries posed in the data warehouse must be answered efficiently. Using materialized views can be an effective strategy for reducing the response time of certain queries. Although materializing all potential views could enhance query performance, but this approach is impractical due to limited storage capacity. Moreover, choosing the optimal views is a problem of the NP-complete class. Consequently, a subset of views must be chosen to minimize query response time while adhering to storage constraints. This paper addresses this challenge by proposing a view selection algorithm that employs the reference-point-based non-dominated sorting algorithm (NSGA-III) to select views from a multi-dimensional lattice. The proposed algorithm is compared with the existing multi-objective view selection algorithms.

Keywords: Data warehouse; Analytical queries; Materialized view selection; Multi-objective optimization; Evolutionary algorithms; NSGA-III (search for similar items in EconPapers)
Date: 2024
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
http://link.springer.com/10.1007/s13198-024-02557-8 Abstract (text/html)
Access to the full text of the articles in this series is restricted.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:ijsaem:v:15:y:2024:i:12:d:10.1007_s13198-024-02557-8

Ordering information: This journal article can be ordered from
http://www.springer.com/engineering/journal/13198

DOI: 10.1007/s13198-024-02557-8

Access Statistics for this article

International Journal of System Assurance Engineering and Management is currently edited by P.K. Kapur, A.K. Verma and U. Kumar

More articles in International Journal of System Assurance Engineering and Management from Springer, The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().