On solving the view selection problem in distributed data warehouse architectures

2003 ◽  
Author(s):  
A. Bauer ◽  
W. Lehner
Keyword(s):  
Data Warehouse ◽  
Selection Problem ◽  
Distributed Data ◽  
View Selection ◽  
Distributed Data Warehouse

Materialized View Selection Using Swap Operator Based Particle Swarm Optimization

2021 ◽  
Vol 13 (1) ◽  
pp. 58-73
Author(s):  
Amit Kumar ◽  
T. V. Vijay Kumar
Keyword(s):  
Particle Swarm Optimization ◽  
Data Warehouse ◽  
Optimization Technique ◽  
Particle Swarm ◽  
Selection Problem ◽  
Data Repository ◽  
Swarm Optimization ◽  
View Selection ◽  
Particle Swarm Optimization Technique ◽  
Swap Operator

The data warehouse is a key data repository of any business enterprise that stores enormous historical data meant for answering analytical queries. These queries need to be processed efficiently in order to make efficient and timely decisions. One way to achieve this is by materializing views over a data warehouse. An n-dimensional star schema can be mapped into an n-dimensional lattice from which Top-K views can be selected for materialization. Selection of such Top-K views is an NP-Hard problem. Several metaheuristic algorithms have been used to address this view selection problem. In this paper, a swap operator-based particle swarm optimization technique has been adapted to address such a view selection problem.

A Hybrid Approach To Solving The View Selection Problem In Data Warehouse

2018 ◽  
Vol 6 (9) ◽  
pp. 270-275
Author(s):  
Mohammed El Alaoui ◽  
Karim El Moutaouakil ◽  
Mohamed Ettaouil
Keyword(s):  
Data Warehouse ◽  
Hybrid Approach ◽  
Selection Problem ◽  
View Selection

A Survey of Parallel and Distributed Data Warehouses

2010 ◽  
pp. 865-886
Author(s):  
Pedro Furtado
Keyword(s):  
Data Warehouse ◽  
The Other ◽  
Distributed Data ◽  
Data Warehouses ◽  
Research Results ◽  
Other Hand ◽  
Scientific Organizations ◽  
Globalized World ◽  
Distributed Data Warehouse

Data Warehouses are a crucial technology for current competitive organizations in the globalized world. Size, speed and distributed operation are major challenges concerning those systems. Many data warehouses have huge sizes and the requirement that queries be processed quickly and efficiently, so parallel solutions are deployed to render the necessary efficiency. Distributed operation, on the other hand, concerns global commercial and scientific organizations that need to share their data in a coherent distributed data warehouse. In this article we review the major concepts, systems and research results behind parallel and distributed data warehouses.

Sign in / Sign up

Export Citation Format

Share Document