Question: The design of distributed databases involves the same activities as the design of centralized database, plus which of the following? (Check all that are design

The design of distributed databases involves the same activities as the design of centralized database, plus which of the following? (Check all that are design activities for the distribution of databases on a DBMS that supports distribution transparency, so the distributed database designer doesn't need to worry about implementing the locations of data and other distribution details that affect names) Group of answer choices Renaming columns so that they are compatible with distributed databases Data fragmentation, in which the designer decides which tables are to be broken into segments, for example by geographic region for Sales data Changing the data types so they are compatible with distributed databases Data allocation, in which the distributed database designer determines the sites (database instances) where the fragments and replicas are located Data replication, in which fragments are replicated and stored at more than one site

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!