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

Ask an Expert

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

Write your message here..

Related Questions

List out user authorization to modify the database schema, List out various... List out various user authorization to modify the database schema. a)  Index authorization b)  Resource authorization c)  Alteration authorization d)  Drop authorizat

Databse Processing 12e, Chapter 10a review questions Chapter 10a review questions

Describe database state in details, Describe Database state in details? ... Describe Database state in details? Database state: The actual data within the database at a particular moment in time is known as a database state.

Online examination system project, entity relationship diagram for online e... entity relationship diagram for online examination system

Explain the exec statement in sql, Explain the EXEC statement in SQL  A... Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

Construct a generalization-specialization hierarchy, Construct a generaliza... Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass

Define the term- having clause and a where clause, What is the difference ... What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY

Search the salary of employees who are not ‘analyst’ , Example- Search the ... Example- Search the salary of employees who are not 'ANALYST' but get a salary below than or equal to any people employed as 'ANALYST'. SELECT EMPNO, ENAME, JOB, SAL FROMEMP

Determine the concept of process, Determine the concept of Process Pro... Determine the concept of Process Process: A process transforms the data values. It is represented as ellipse containing a description of transformation. Each procedure has a

Deletion operation - update operations, By using the delete operation some ... 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