data replicationif a relation r has its copies
Data Replication
"If a relation R has its copies kept at two or more sites, then it is considered replicated".
But why do we replicate a relation?
There are several advantages and drawbacks of replication of relation
Expected delivery within 24 Hours
design of distributed databases the distributed databases are mainly relational at local level so a local database schema is the similar as that of a
replication it is definite as a copy of a relation every replica is stored at a dissimilar site the alternative to replication is to store only
write a fully modular c program that reads in a string of a defined size from the keyboard and reports how many times each letter of the alphabet
fragmentation it is definite as partitioning of a relation into various fragmentsevery fragment can be stored at a dissimilar
data replicationif a relation r has its copies kept at two or more sites then it is considered replicatedbut why do we replicate a relationthere are
availability a site having the copy of a replicated relation fails even then the relation may be found in another site therefore the system may carry
increased parallelism since the replicated date has several copies a query can be distributed or can be answered from the smallest loaded site also
increased overheads on update on the drawbacks side it will need the system to ensure that all replicas of a relation are consistent this shows that
complete replication it implies maintaining of a whole copy of the database at every site thus the reliability amp availability and performance for
1925938
Questions Asked
3,689
Active Tutors
1413359
Questions Answered
Start Excelling in your courses, Ask a tutor for help and get answers for your problems !!
View the Google Maps satellite map of Benten Island and Angel Road in Japan. Notice the road connecting the mainland to Benten Island is underwater here.
Calculate how far away the epicenter of the earthquake was in kilometers from that location. Round your answer to the nearest 100 mark
Why are there two tidal bulges on earth? Question options: All the animals in the sea shift toward the bulge, creating a standing wave.
Question: What type of sediment is found in Esturaries? Question options: fine grained sediment fine grained from both land and ocean ocean sediment land sedime
Ocean tides are caused by the gravitational attraction. Question options: of the Sun and Moon on the Earth of the Moon and planets on the Earth
To investigate how increased flow rate, simulating storm water, affects patterns of erosion and deposition in a stream.
What evidence should indicate the presence of this third arm? Zoom in and out to see if you can see any.