You are considering the possibility of horizontally partitioning the relation Employee (SSN, Name, Salary, Title, Location) by location and storing each partition in the database at that location, with the possibility of replicating some partitions at different sites. Discuss the types of queries and updates (and their frequencies) that might influence your decision.
What will be an ideal response?
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...
________ positions the document so that the page is wider than it is tall
Fill in the blank(s) with correct word
The criteria for a parameter query is entered only the first time it is run
Indicate whether the statement is true or false
The ISO/IEC 27000 series is derived from an earlier standard, BS7799.
Answer the following statement true (T) or false (F)
Because displaying graphics demands a lot of the CPU, a video card also comes with its own ________
Fill in the blank(s) with correct word