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

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 querie...

Full description

Saved in:
Bibliographic Details
Published in:International journal of system assurance engineering and management 2024-12, Vol.15 (12), p.5676-5694
Main Authors: Prakash, Jay, Vijay Kumar, T. V.
Format: Article
Language:English
Subjects:
Engineering
Engineering Economics
Logistics
Marketing
Organization
Original Article
Quality Control
Reliability
Safety and Risk
Citations: Items that this one cites
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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.
ISSN:0975-6809
0976-4348
DOI:10.1007/s13198-024-02557-8