Research And Application Of Mobile Database Synchronization

As mobile communications and computing technology integrated development, Mobile terminal has a broader range of uses, People use mobile devices to handle and store various data—Cards, scheduling, e-mail and even documents, directories and other structured or unstructured data, these data also often needs to be exchanged between different users to complete the complex interaction and cooperation。To ensure the proper completion of this collaborative tasks, we must have a means to ensure that the data sets of different devices and the consistency of the timeliness of the content, which we have to define data synchronization.Data synchronization has become a basic application of mobile computing model.,currently some of the world's leading database vendors have also launched its own mobile database system.Current mobile devices can not maintain a real-time communication central server due to facts such as own resources and network conditions, the demands of data access can not be satisfied in the disconnected network. The data accessing and processing must be realized urgently no matter in anywhere and at anytime. Mobile database data synchronization method is particularly important. The paper focuses on this issue.Currently SQL Server database synchronization solution is divided into two, One is the merge replication, which allows mobile applications to copy data on their own changes, then these changes combined with the SQL Server database and data necessary to resolve conflict. Another is the remote data access (RDA),which allows mobile applications to easily remote Microsoft SQL Server database table data read (pull) to the local SQL Server Mobile database table, or move data in a database table to send (push) to a remote Microsoft SQL Server database table.Using the RDA solution for secure, installation and setup process is relatively simple.,this program works well on a simple table.,but if works on association list or the user data may involve a large number of programming. In this article,we will describe the advantages of RDA solution and the problems of such programs through two different solutions of RDA and Replication and specific examples of comparison.