The Study On Data Management Of Mobile Database

In recent years, with the graphic development of network technology and wireless communication technology, people's target is hope to achieve unconstrained communication and sharing resources, this is a flexible and complicated distributed computing environment and usually called mobile computing environment. The main characteristics of mobile computing environment is the mobility, frequent broken, diversification network condition, and these characteristics make mobile computing environment can not be supported by the traditional distributed database technology effectively, and formed a kind of new database technology, i.e. the mobile database.Microsoft SQL Server Windows CE Edition (SQL Server CE) is a streamlining database product launched by Microsoft and is suitable for mobile application development, with more stable function and performance. But there are some deficiencies when SQL Server CE will be applied to some mobile application。SQL Server CE does not have local backup and restore function, and SQL Server CE can not provides a stored procedure for application. In order to remedy the deficiency of SQL Server CE, the document proposed that a mobile database management model for mobile applications. And this model is divided into three layers structure:mobile database, data conversion, applications.The mobile database is using SQL Server CE mobile database engine. Data conversion layer provides backup restore function (fully backup and restore, table with import and export) of SQL Server CE' local database, and to provide similar interface functions of storage procedure (it include:function of operating local database, function of remote upload and download, function of operation remote database) for upper mobile applications. Application is running on a mobile device and need to be provided services by the mobile database.Finally, the document discussed the mobile database management model using the.NET Compact Framework in technology, and added the function of data conversion on the basis of query analyzer, so realizing a high safety and convenient management tools of SQL Server CE.