Syncing Mobile Devices with Databases {2}

by Andrew M
The article I read was entitled “A Database Synchronization Algorithm for Mobile Devices” by Mi-Young Choi, Eun-Ae Cho, Dae-Ha Park, Chang-Joo Moon and Doo-Kwon Baik. This article talks about the synchronization problems that occur when trying to synch mobile devices to a database. Right now mobile devices create a small sized local copy of the database so that the user can do some work while disconnected. This is done also because having constant access to the network using a lot of power and bandwidth. The authors proposed solution is to have an algorithm that works around this and is known as Synchronization Algorithms based on Message Digest or SAMD. Essentially, this algorithm looks at tables of data and compares the mobile copy of the information to a server copy. If the data is different a synch will initiate. read more...

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