Discuss the functionality required of a replication server.

What will be an ideal response?


At its basic level, we expect a distributed data replication service to be capable of copying data
from one database to another, synchronously or asynchronously. However, there are many other
functions that need to be provided, including:
? Scalability - The service should be able to handle the replication of both small and large
volumes of data.
? Mapping and transformation - The service should be able to handle replication across
heterogeneous DBMSs and platforms. mapping and transforming the data from one data model into a different data model, or the
data in one data type to a corresponding data type in another DBMS.
? Object replication - It should be possible to replicate objects other than data. For example,
some systems allow indexes and stored procedures (or triggers) to be replicated.
? Specification of replication schema - The system should provide a mechanism to allow a
privileged user to specify the data and objects to be replicated.
? Subscription mechanism - The system should provide a mechanism to allow a privileged user
to subscribe to the data and objects available for replication.
? Initialization mechanism - The system should provide a mechanism to allow for the
initialization of a target replica.
? Easy administration - It should be easy for the DBA to administer the system and to check the
status and monitor the performance of the replication system components.

Computer Science & Information Technology

You might also like to view...

Write a method for Turtle to draw an equilateral triangle. Pass in the length of the sides.

What will be an ideal response?

Computer Science & Information Technology

Pyramids and Hierarchies are two of the SmartArt categories

Indicate whether the statement is true or false

Computer Science & Information Technology

?An object's _____ are the tasks or functions that the object performs when it receives a command to do so.

A. ?roles B. ?utilities C. ?instances D. ?methods

Computer Science & Information Technology

COGNITIVE ASSESSMENT You want a form of backup that copies all program and data files. Which of the following will you use?

A. archival backup B. differential backup C. selective backup D. partial backup

Computer Science & Information Technology