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
Foreign Keys and NULL Let us take the relation:                 DEPT DEPT ID DNAME BUDGET D1 M

Identify the need and use of data control through problem solving, illustration

Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov


Define Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur

What does conceptual design work? A conceptual design involves modelling independent of the DBMS.

ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.

Which is another name for weak entity? Child is another name of weak entity.

composite attribute

When every condition appears with equality condition (=) only. c)   Natural join (denoted by R*S) When two join attributes have the similar name in both relations. (Tha