Popuri Srinivasarao, Aravapalli Rama Satish*
Computer Systems Science and Engineering, Vol.47, No.2, pp. 1527-1547, 2023, DOI:10.32604/csse.2023.038951
Abstract Responding to complex analytical queries in the data warehouse
(DW) is one of the most challenging tasks that require prompt attention.
The problem of materialized view (MV) selection relies on selecting the most
optimal views that can respond to more queries simultaneously. This work
introduces a combined approach in which the constraint handling process
is combined with metaheuristics to select the most optimal subset of DW
views from DWs. The proposed work initially refines the solution to enable
a feasible selection of views using the ensemble constraint handling technique
(ECHT). The constraints such as self-adaptive penalty, epsilon (ε)-parameter
and stochastic… More >
Login
Register
