A relatively new pharmacy retail company, namely FarmaBee, is currently experiencing significant growth in the sales of medicines. Its headquarter is situated in Jakarta whereas its two branches are located in Surabaya and Medan. The increasing number of transaction leads to several challenges, such as: access latency, data availability, and server availability. As a Database Administrator (DBA), you are tasked to provide solutions for those problems.

1. [25%] In order to speed up the access to the database, each node reads the current data from the local database but write the updated data to the main database, as illustrated in Figure 1. 

(a) What kind of replication model which closely matches to the replication model in Figure 1? 

(b) Certain data needs certain type of replication. What are your considerations in determining the use of snapshot, transactional or merge replication among different sources of data? 

(c) What are possible problems related to the replication model in Figure 1?
 

Transcribed Image Text:

read write main database write JAKARTA replicate read SURABAYA local database Figure 1. Replication model. i read MEDAN read write main database write JAKARTA replicate read SURABAYA local database Figure 1. Replication model. i read MEDAN