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. |
Year | Venue | Keywords |
---|---|---|
2010 | IDEAL | multi-criteria optimization,data warehouse management system,data base,cluster data warehouse,grid optimization,query optimization problem,single node,multiagent data warehouse,query time,optimization operation,query response time |
DocType | Volume | ISSN |
Conference | 6283 | 0302-9743 |
ISBN | Citations | PageRank |
3-642-15380-1 | 0 | 0.34 |
References | Authors | |
3 | 3 |
Name | Order | Citations | PageRank |
---|---|---|---|
Marcin Gorawski | 1 | 243 | 36.46 |
Slawomir Bankowski | 2 | 1 | 1.06 |
Michal Gorawski | 3 | 39 | 7.00 |