Remote Sites Need to Share a Database

Problem:
Your company has several remote sites (subsidiaries across the continent or world) that should have access to your database. Unfortunately, the network is too slow or too unreliable for direct access.

Solution:
Implement database servers on the remote sites. Connect them to the server in the head office and replicate the database between them. In this way, you have a copy of the database on both sites. The local users receive prompt responses to their data requests and head office receives data from the remote sits after a specified delay (e.g.: after a couple of minutes or during the following night).

This approach can also be used to solve synchronization problems for mobile users. They can use a database on their notebooks that allows them to work in the field. Once they connect to the LAN or Internet, they can replicate their database on their notebooks against the database at head office.