A novel coral reefs optimization algorithm for materialized view selection in data warehouse environments

2019 ◽  
Vol 49 (11) ◽  
pp. 3965-3989
Author(s):  
Hossein Azgomi ◽  
Mohammad Karim Sohrabi
Keyword(s):  
Coral Reefs ◽  
Data Warehouse ◽  
Optimization Algorithm ◽  
View Selection ◽  
Materialized View ◽  
Materialized View Selection ◽  
Coral Reefs Optimization Algorithm

Materialized View Selection in the Data Warehouse

2010 ◽  
Vol 29-32 ◽  
pp. 1133-1138 ◽  
Author(s):  
Li Juan Zhou ◽  
Hai Jun Geng ◽  
Ming Sheng Xu
Keyword(s):  
Decision Support ◽  
Data Warehouse ◽  
Materialized Views ◽  
Storage Space ◽  
View Selection ◽  
Materialized View ◽  
Query Response Time ◽  
Materialized View Selection ◽  
Optimal Efficiency ◽  
The Cost

A data warehouse stores materialized views of data from one or more sources, with the purpose of efficiently implementing decision-support or OLAP queries. Materialized view selection is one of the crucial decisions in designing a data warehouse for optimal efficiency. The goal is to select an appropriate set of views that minimizes sum of the query response time and the cost of maintaining the selected views, given a limited amount of resource, e.g., materialization time, storage space, etc. In this article, we present an improved PGA algorithm to accomplish the view selection problem; the experiments show that our proposed algorithm shows it’s superior.

Research on Materialized Views under Disk-Space Constraint in Data Warehouse

2014 ◽  
Vol 989-994 ◽  
pp. 1955-1958
Author(s):  
Lei Ma
Keyword(s):  
Data Warehouse ◽  
Space Constraint ◽  
Maintenance Cost ◽  
Materialized Views ◽  
Ranking Algorithm ◽  
Disk Space ◽  
View Selection ◽  
Materialized View ◽  
Processing Cost ◽  
Materialized View Selection

Materialized view is an important topic in data warehouse research, and also affects the query efficiency and maintenance cost. The disk-space view-selection problem is to select a set of materialized views for the purpose of minimizing the total query processing cost and the total maintenance cost. In this paper we introduce evolutionary algorithm using stochastic ranking algorithm, which can enable materialized view selection under disk-space constraint. The algorithm improve the stochastic ranking algorithm, which can find a near-optimal feasible solution. This paper use the algorithm in Police data warehouse.

The Design and Implementation of Agricultural Production Data Warehouse

2011 ◽  
Vol 52-54 ◽  
pp. 978-983
Author(s):  
Li Juan Zhou ◽  
Xiao Xu He ◽  
Kang Li
Keyword(s):  
Data Warehouse ◽  
Agricultural Production ◽  
High Capacity ◽  
Heterogeneous Data ◽  
Multidimensional Data ◽  
Production Data ◽  
Effective Management ◽  
View Selection ◽  
Materialized View ◽  
Materialized View Selection

This paper designed a data warehouse model of agricultural production. And it built an effective and viable agricultural production data warehouse, by using some key technologies: multidimensional data analysis, cube, materialized view selection, materialized view maintenance. Finally, it provided a solution for the effective management and maintenance problems about high-capacity heterogeneous data.

Sign in / Sign up

Export Citation Format

Share Document