You are considering the possibility of horizontally partitioning the relation by location and storing each partition in the database at that location, with the possibility of replicating some partitions at di?erent sites. Discuss the types of queries and updates (and their frequencies) that might in?uence your decision.
Employee (SSN, Name, Salary, Title, Location)
If most of the queries and updates of that table are done at that location, partitioning the table might be appropriate. If there are queries at other locations, it might be appropriate to replicating the partition at other locations. However, if there are many
updates, replication might not be appropriate because all replicas would have to be updated and that might increase communication costs.
You might also like to view...
Explain in which respects DSM is suitable or unsuitable for client-server systems.
What will be an ideal response?
A(n) ____________________ is a special graphic effect, such as a drop shadow, that you can apply to movie clips, buttons, and text.
Fill in the blank(s) with the appropriate word(s).
Supervisors often initiate root cause analysis steps when they notice trends in the help desk incidents
Indicate whether the statement is true or false
The W3C CSS Validation Service is primarily used for ____________________ style sheets.
Fill in the blank(s) with the appropriate word(s).