Chapter 22, Problem 10PE

Explanation of Solution

Performing a join:

• Considered a cloud data storage is used to store the given two relations.
• Performing a join to the two relations r and s;
• Considering cloud data storage, joins are considered to be very expensive when the relation r or s needs to be partitioned based on the attributes other than the join attributes.
• It is because large amount of data needs to be transferred to perform a join operation.
• The join is retained to be a materialized view,
• The join can be updated at a low cost as and when the relation r or s is updated instead of making a huge cost instead of making huge cost when a query is executing...