Complete replication-data replication, Database Management System

Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized. Though, storage costs, communication costs, and updates are costly. To overcome some of these troubles relation, snapshots are sometimes used. A snapshot is definite as the copy of the data at a given time. These copies are updated periodically, like, hourly or weekly. Therefore, snapshots may not always be up to date.

 

Posted Date: 3/13/2013 8:31:29 AM | Location : United States







Related Discussions:- Complete replication-data replication, Assignment Help, Ask Question on Complete replication-data replication, Get Answer, Expert's Help, Complete replication-data replication Discussions

Write discussion on Complete replication-data replication
Your posts are moderated
Related Questions
Describe Participation Constraints? Participation Constraints - The participation constraint exacts whether the existence of an entity depends on its being related to another

Example -GRANT CREATE SESSION TO MCA12; (This command gives system level permission on creating a session - not portable) GRANT SELECT ON EMP TO MCA12; (Object level permi

Describe the different RAID levels.  Discuss the choices of the different RAID levels for different applications.          Ans:   There are several combinations of these approa

What is OCR? OCR (Optical Character Recognition) is a technology that enables you to change different types of machine-readable documents, like scanned paper documents, PDF fil

Events4Fun is an event management company in Europe with branches in South America as well. The company is well-known for its efficiency, good-quality services, and affordable char

What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.

By using the delete operation some consisting records can be deleted from a relation. To delete some definite records from the database a condition is also specified based on which

Load sample data into the database tables design and test queries to return the following information • All rows and columns for employees • All rows and columns for customers •

Explain the rules for creating a labelled precedence graph for testing view serializability.            Ans: A schedule S is view serializable if it is view equivalent to a ser

List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements  c) Finding the loops  d) Finding error ro