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...
Aamir is preparing a research paper. He needs to insert a parenthetical reference that gives credit to the source of a quotation. What is the best way for him to achieve this?
A) Enter the parenthetical reference manually. B) Insert a footnote with the source information. C) Insert an endnote with the source information. D) Insert a citation.
What is the difference between Case and Searched Case statements?
What will be an ideal response?