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

The External or View Level The external or view level is the highest level of abstraction of database. It gives a window on the conceptual view, which permits the user to see

sir, could anybody help me in getting complete information about the mentioned topic

List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

Briefly describe concurrency execution? Lock - based protocols Locks There are several modes in which a data item may be locked in this section we restrict our attention

Q.   Why would you choose a database system instead of simply storing data in operating system file? Define  at a base concept in details. Sol. Advantages of Database over Fil


What is the use of integrity constraints? Integrity constraints make sure that changes made to the database by authorized users do not result in a loss of data consistency. The

Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.

Explain the term - Control as Concurrent Tasks As we know, any object can be implemented as a task in programming language or operating system. This is the most general approa