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
[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?
main database
write
write
- 1
replicate
JAKARTA
SURABAYA
MEDAN
read
Iread
iread
local database
Figure 1. Replication model1.