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. read more...