Get premium membership and access questions with answers, video lessons as well as revision papers.
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, such as:
•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.
•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 different DBMSs and platforms. This may involve 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.
•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.
kalvinspartan answered the question on July 4, 2018 at 16:45
- Discuss the Update-anywhere (symmetric replication) ownership in replication(Solved)
Discuss the Update-anywhere (symmetric replication) ownership in replication
Date posted: July 4, 2018. Answers (1)
- Discuss the workflow ownership as portrayed in replication(Solved)
Discuss the workflow ownership as portrayed in replication.
Date posted: July 4, 2018. Answers (1)
- Discuss the master/slave type of ownership model in replication(Solved)
Discuss the master/slave type of ownership model in replication
Date posted: July 4, 2018. Answers (1)
- Give a definition of an OODBMS.(Solved)
Give a definition of an OODBMS.
Date posted: July 4, 2018. Answers (1)
- Give a definition of a data warehouse. Discuss the benefits of implementing a data warehouse(Solved)
Give a definition of a data warehouse. Discuss the benefits of implementing a data warehouse
Date posted: July 4, 2018. Answers (1)
- Describe the characteristics of the data held in a data warehouse.(Solved)
Describe the characteristics of the data held in a data warehouse.
Date posted: July 4, 2018. Answers (1)
- Describe what relationships represent in an ER model and provide examples of unary, binary, and ternary relationships(Solved)
Describe what relationships represent in an ER model and provide examples of unary, binary, and ternary relationships
Date posted: July 4, 2018. Answers (1)
- Describe what entities represent in an ER model and provide examples of entities with a physical or conceptual existence.(Solved)
Describe what entities represent in an ER model and provide examples of entities with a physical or conceptual existence.
Date posted: July 4, 2018. Answers (1)
- How do the contents of a users’ requirements specification differ from a systems specification?(Solved)
How do the contents of a users’ requirements specification differ from a systems specification?
Date posted: July 4, 2018. Answers (1)
- What is the purpose of the systems definition stage?(Solved)
What is the purpose of the systems definition stage?
Date posted: July 4, 2018. Answers (1)
- Describe how fact-finding is used throughout the stages of the database system development lifecycle(Solved)
Describe how fact-finding is used throughout the stages of the database system development lifecycle
Date posted: July 4, 2018. Answers (1)
- Briefly describe what the process of fact-finding attempts to achieve for a database developer. (Solved)
Briefly describe what the process of fact-finding attempts to achieve for a database developer.
Date posted: July 4, 2018. Answers (1)
- Discuss Redundant Array of Independent Disks (RAID)(Solved)
Discuss Redundant Array of Independent Disks (RAID)
Date posted: July 4, 2018. Answers (1)
- Explain the purpose and scope of database security.(Solved)
Explain the purpose and scope of database security.
Date posted: July 4, 2018. Answers (1)
- Discuss the process of testing the database system and its purpose(Solved)
Discuss the process of testing the database system and its purpose
Date posted: July 4, 2018. Answers (1)
- What are the main activities associated with operational maintenance stage.(Solved)
What are the main activities associated with operational maintenance stage.
Date posted: July 4, 2018. Answers (1)
- Describe the purpose of the data conversion and loading stage.(Solved)
Describe the purpose of the data conversion and loading stage.
Date posted: July 4, 2018. Answers (1)
- Discuss the main activities associated with the implementation stage.(Solved)
Discuss the main activities associated with the implementation stage.
Date posted: July 4, 2018. Answers (1)
- Describe the potential benefits of developing a prototype database system.(Solved)
Describe the potential benefits of developing a prototype database system.
Date posted: July 4, 2018. Answers (1)
- Discuss the two main activities associated with application design.(Solved)
Discuss the two main activities associated with application design.
Date posted: July 4, 2018. Answers (1)