Question

1. Discuss the data transfer costs of distributed query processing with the help of an example

Answer 1

In a distributed database system, processing a query comprises of optimization at both the global and the local level. The query enters the database system at the client or controlling site. Here, the user is validated, the query is checked, translated, and optimized at a global level.