Analysis of affinity based routing in multi-system data sharing
Performance Evaluation
Principles of distributed database systems
Principles of distributed database systems
A performance analysis of alternative multi-attribute declustering strategies
SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
A framework for workload allocation in distributed transaction processing systems
Journal of Systems and Software
IBM Systems Journal
Snakes and sandwiches: optimal clustering strategies for a data warehouse
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Satisfying response time goals in transaction processing systems
PDIS '93 Proceedings of the second international conference on Parallel and distributed information systems
Extending TP—monitors for intra-transaction parallelism
DIS '96 Proceedings of the fourth international conference on on Parallel and distributed information systems
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Conflict-driven Load Control for the Avoidance of Data-Contention Thrashing
Proceedings of the Seventh International Conference on Data Engineering
Data placement in shared-nothing parallel database systems
The VLDB Journal — The International Journal on Very Large Data Bases
Working Together in Harmony - An Implementation of the CORBA Object Query Service and its Evaluation
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
OLAP Query Evaluation in a Database Cluster: A Performance Study on Intra-Query Parallelism
ADBIS '02 Proceedings of the 6th East European Conference on Advances in Databases and Information Systems
Memory Aware Query Routing in Interactive Web-Based Information Systems
BNCOD 18 Proceedings of the 18th British National Conference on Databases: Advances in Databases
Evaluating the Coordination Overhead of Replica Maintenance in a Cluster of Databases
Euro-Par '00 Proceedings from the 6th International Euro-Par Conference on Parallel Processing
High-Performance Query Processing of a Real-World OLAP Database with ParGRES
High Performance Computing for Computational Science - VECPAR 2008
DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
Verification of partitioning and allocation techniques on teradata DBMS
ICA3PP'11 Proceedings of the 11th international conference on Algorithms and architectures for parallel processing - Volume Part I
ICA3PP'10 Proceedings of the 10th international conference on Algorithms and Architectures for Parallel Processing - Volume Part I
| Hi-index | 0.00 |
This article quantifies the benefit from simple data organization schemes and elementary query routing techniques for the PowerDB engine, a system that coordinates a cluster of databases. We report on evaluations for a specific scenario: the workload contains OLAP queries, OLTP queries, and simple updates, borrowed from the TPC-R benchmark.We investigate affinity of OLAP queries and different routing strategies for such queries. We then compare two simple data placement schemes, namely full replication and a hybrid one combining partial replication with partitioning. We run different experiments with queries only, with updates only, and with queries concurrently to simple updates. It turns out that hybrid is superior to full replication, even without updates. Our overall conclusion is that coordinator-based routing has good scaleup properties for scenarios with complex analysis queries.