Dynamic interactive web applications have a database located on cloud or bigger physical servers for data operations and the modern need is the android or smart applications for such dynamic interactive applications. Development of android applications needs a local database within the application that should be synchronized with the main database later. SQLite is one of the reputed databases for android applications and is based on relational model. This paper aims at the development of synchronization tier of SQLite database that synchronizes the data between local database (SQLite) and SQL server located on physical servers using the concept of web services.

Data synchronization is the process of establishing consistency among data from a source to target data storage and vice versa and continuous harmonization of the data over time. Synchronization mechanisms replicate or synchronize data between the application and the backend data sources. Synchronization is important for mobile and embedded applications for the following reasons:

1. Mobile and embedded DBMSs are predominantly deployed in the client-tier and mid-tier.
2. Data is copied or replicated from the backend data sources close to the applications in the client and middle tier for better performance and ease of application management.
3. Occasional disconnection between the application and the backend data sources causes data to be offlined into the client databases. Offline databases must be periodically synchronized with the original backend data sources
4. Synchronization must work over a variety of communication networks (e.g., LAN, WAN, wireless networks, etc.), and to a variety of data sources (e.g., database systems, application systems and web services).
   

Computer Sciences Journal, SQLite, SQL server, Embedded database, Android, Web services, Synchronization, Oracle Corporation, CSQL( from csqlcache.com), Firebird Embedded, Infinity DB from Boiler Bay Inc, Informix Dynamic server (from IBM), Extensible Storage Engine (from Microsoft), InnoDB from Oracle Corporation, Solid DB, SQL Server Compact from Microsoft Corporation, Sophia Embeddable key-value storage, RDM Embedded.