Get premium membership and access questions with answers, video lessons as well as revision papers.
With master/slave ownership, asynchronously replicated data is owned by one site, the master or primary site, and can be updated by only that site. Using a ‘publish-and-subscribe’ metaphor, the master site (the publisher) makes data available. Other sites ‘subscribe’ to the data owned by the master site, which means that they receive read-only copies on their local systems. Potentially, each site can be the master site for non-overlapping data sets. However, there can only ever be one site that can update the master copy of a particular data set, and so update conflicts cannot occur between sites.
A master site may own the data in an entire table, in which case other sites subscribe to read-only copies of that table. Alternatively, multiple sites may own distinct fragments of the table, and other sites then subscribe to read-only copies of the fragments. This type of replication is also known as asymmetric replication.
kalvinspartan answered the question on July 4, 2018 at 16:42
- 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)
- Explain why it is necessary to select the target DBMS before beginning the physical database design phase. (Solved)
Explain why it is necessary to select the target DBMS before beginning the physical database design phase.
Date posted: July 4, 2018. Answers (1)
- Discuss what a user view represents when designing a database system.(Solved)
Discuss what a user view represents when designing a database system.
Date posted: July 4, 2018. Answers (1)
- Describe the purpose of creating a mission statement and mission objectives for the required database during the database planning stage.(Solved)
Describe the purpose of creating a mission statement and mission objectives for the required database during the database planning stage.
Date posted: July 4, 2018. Answers (1)