Synchronizing database on mobile devices{2}

by Ricardo C
This article relates to the synchronization between mobile devices and databases. Since mobile technology as advanced and equipment have led to the emergence of a new computing environment and a variety of small sized mobile devices such as smartphones and PDAs that has been popularized. The problem is that mobile devices do not have much computing power and they rely on batteries; constant access to network is difficult due to narrow bandwidth. Mobile devices need to download the database when connected and then work off-line and by doing so there are inevitable inconsistencies between the server-side database and the mobile database. Commercial DBMS vendors offer solutions to maintain the database synchronized between the two devices however these solutions are dependent of the server-side database using dependent information such as metadata. Because of these restrictions, the extensibility, adaptability and flexibility of mobile business systems are markedly decreased. The article suggests the implementation of SAMD (Synchronization algorithms based on message digest) which resolves synchronization problems using only standard SQL queries. The SAMD makes the images at the table of the server-side database and the mobile database using a message digest algorithm; then the images and the message digest values are saved in the message digest tables on both sides. The images are compared and select the rows needed for synchronization. The SAMD would provide extensibility, adaptability and flexibility.

The mobile technology is advancing so fast that solutions like this one would be necessary for many databases. Mobile devices have their limitation like mentioned above such as computing power and connectivity and developers need to be aware of them to develop their softwares suitable for this limitations. SAMD would solve the problems of database synchronization when working offline but ultimately we desire our devices to be connected all the time to have a real-time update of databases. Telecommunication technologies are advancing and providing faster and more reliable connections between devices.

Mi-Young Choi; Eun-Ae Cho; Dae-Ha Park; Chang-Joo Moon; Doo-Kwon Baik; , “A database synchronization algorithm for mobile devices,”Consumer Electronics, IEEE Transactions on , vol.56, no.2, pp.392-398, May 2010