6) Synchronization in an Embedded DBMS Environment (2006)
In this paper [8] author (Sang-Wook, Kim) had explained that the embedded DBMS is a lightweight DBMS for
effective management of quite small databases contained in tiny mobile devices. Synchronization is a core function
of the embedded DBMS to preserve the consistency of data replicated in the server and client databases. This paper
presents a framework for synchronization in embedded DBMS environment. His first address key issues for
realizing synchronization, and then propose solutions to them obtained from our development. The main issues
touched here are (1) classifying conflicts, (2) identifying changes in a client database, (3) detecting conflicts, and
(4) resolving conflicts. The proposed framework would help reduce the trial-and errors of embedded DBMS
developers in implementing their synchronization server.
As shown in Fig. 2 the steps for data synchronization algorithm are given below:-
Step 1. Enter the data in the form and upload the image to save in the database.
Step 2. Check the network connection either available or not.
Step 3. If a network connection is not available, we switch on the offline mode. Then data stored on client database
and image stored in the folder on the client machine and again, it will continuously check whether the network
connection is available or not.
Step 4. If a network connection is available, we switch on the online mode and it will perform the following
operations:
Check whether any entry exists on the client database
1.If no entry exists on the client database, then data with images stored on the server.
2.If any entry exists on the client database, then retrieve the minimum ID & its corresponding column with the
image until the database is empty.
Transfer the data with an image of that ID on the server and delete it from the client database and delete images
from client machine.
Then data with images stored on the server