Performance tradeoffs for client-server query processing

摘要: The construction of high-performance database systems that combine the best aspects relational and object-oriented approaches requires design client-server architectures can fully exploit client server resources in a flexible manner. two predominant paradigms for query execution are data-shipping query-shipping We first define these policies terms restrictions they place on operator site selection during optimization. then investigate performance tradeoffs between them bulk processing. While each strategy has advantages, neither one its own is efficient across wide range circumstances. describe evaluate more policy called hybrid-shipping, which execute queries at clients, servers, or any combination two. Hybrid-shipping shown to least match "pure" policies, some situations, perform better than both. implementation hybrid-shipping raises number difficult problems an initial investigation into use 2-step optimization as way addressing issues.