检索结果-南通市图书馆

A Novel Hybrid Optimization Algorithm for Materialized View Selection from Data Warehouse Environments

Computer Systems Science & Engineering 2023年第11期47卷 1527-1547页

作者： popuri srinivasarao Aravapalli Rama Satish School of Computer Science and Engineering VIT-AP UniversityAmaravatiIndia

Responding to complex analytical queries in the data warehouse(DW)is one of the most challenging tasks that require prompt *** problem of materialized view(MV)selection relies on selecting the most optimal views that can respond to more queries *** 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 *** 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 ranking(SR)are considered for constraint *** two constraints helped the proposed model select the finest views that minimize the objective ***,a novel and effective combination of Ebola and coot optimization algorithms named hybrid Ebola with coot optimization(CHECO)is introduced to choose the optimal *** and Coot have recently introduced metaheuristics that identify the global optimal set of views from the given *** combining these two algorithms,the proposed framework resulted in a highly optimized set of views with minimized *** cost functions are described to enable the algorithm to choose the finest solution from the problem ***,extensive evaluations are conducted to prove the performance of the proposed approach compared to existing *** proposed framework resulted in a view maintenance cost of 6,329,354,613,784,query processing cost of 3,522,857,483,566 and execution time of 226 s when analyzed using the TPC-H benchmark dataset.

关键词： Materialization ensemble approach stochastic ranking optimization optimal view selection

来源：

维普期刊数据库评论

在线全文

维普期刊数据库

学校读者我要写书评

暂无评论

欢迎您,

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

在线全文

请选择保存的检索档案：

请选择收藏分类：

通借通还

欢迎您,

建议与咨询 留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

在线全文

请选择保存的检索档案： 新增检索档案 确定 取消

请选择收藏分类： 新增自定义分类 确定 取消

通借通还

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

请选择保存的检索档案：

请选择收藏分类：