Performance Tradeoffs for Client-Server Query Processing

11 years 5 months ago
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...
Michael J. Franklin, Björn Þór J
Added 08 Aug 2010
Updated 08 Aug 2010
Type Conference
Year 1996
Authors Michael J. Franklin, Björn Þór Jónsson, Donald Kossmann
Comments (0)