Performance Tradeoffs for Client-Server Query Processing

The constructionof high-performance databasesystems that combine the best aspects of the relational and object-oriented approaches requires the design of client-server architectures that can fully exploit client and server resources in a flexible manner. The two predominant paradigms for client-server query execution are datashipping and query-shipping. We first define these policies in terms of the restrictions they place on operator site selection during query optimization. We then investigate the performance tradeoffs between them for bulk query processing. While each strategy has advantages, neither one on its own is efficient across a wide range of circumstances. We describe and evaluate a moreflexible policy called hybrid-shipping, which can execute queries at clients, servers, or any combination of the two. Hybrid-shipping is shown to at least match the best of the two "pure"policies, and in some situations, to perform better than both. The implementation of hybrid-sh...

• Type: Conference
• Year: 1996
• Where: SIGMOD
• Authors: Michael J. Franklin, Björn Þór Jónsson, Donald Kossmann
• Keywords: Bulk Query Processing, Client-server Query Execution, Database, Query Optimization, SIGMOD 1996