Selection of structures with grid optimization, in multiagent data warehouse

Authors:
Marcin Gorawski;Sławomir Bańkowski;Michał Gorawski
Affiliations:
Silesian University of Technology;Silesian University of Technology;Silesian University of Technology
Venue:
IDEAL'10 Proceedings of the 11th international conference on Intelligent data engineering and automated learning
Year:
2010

Citing 3
Cited 0

Range Aggregate Processing in Spatial Databases

IEEE Transactions on Knowledge and Data Engineering
The Data Warehouse Lifecycle Toolkit

The Data Warehouse Lifecycle Toolkit
Modified R-MVB tree and BTV algorithm used in a distributed spatio-temporal data warehouse

PPAM'07 Proceedings of the 7th international conference on Parallel processing and applied mathematics

Quantified Score

Hi-index	0.00

Visualization

Abstract

The query optimization problem in data base and data warehouse management systems is quite similar. Changes to Joins sequences, projections and selections, usage of indexes, and aggregations are all decided during the analysis of an execution schedule. The main goal of these changes is to decrease the query response time. The optimization operation is often dedicated to a single node. This paper proposes optimization to grid or cluster data warehouses / databases. Tests were conducted in a multi-agent environment, and the optimization focused not only on a single node but on the whole system as well. A new idea is proposed here with multi-criteria optimization that is based on user-given parameters. Depending on query time, result admissible errors, and the level of system usage, task results were obtained along with grid optimization.