| Nowadays, information has become more and more important and a Database system is aimed to store and administrate such huge amount of information. Meanwhile, network quickly spreads all over the world with its depending on its efficiency and convenience and gets in touch with human society and life. Therefore, the integration of database and network technology has become one of the focuses in computer science field; meanwhile data sharing between multiple users with high efficiency is demanding.Thus multi-transaction concurrency control has a high value of application in web database.On the other hand, in the design of DBS, the data accessing is very important. It is necessary to resolve that how to do the concurrency control and keep data consistency under the disconnection model in the application development. But little research work has been done. Under this condtion, we present a timestamp validation-based multi-version two-phase locking protocol by analysing ADO.NET.This paper first reviews the data access technology, analyzes the infrastructure of AD0.NET and data access mechanism and focuses on the research of the two AD0.NET core components: DataSet and .NET data provider. Then, it concludes the main mechanisms of the concurrency control, and discusses their advantages and disadvantages.In addition, based on the analysis of AD0.NET disconnection model, the advantage of disconnection model and connection model, we design a concurrency control protocol which can apply to networking database system.The experiments' data of the protocol proves its advantage. Then, the main cause of database accessing performance problem is concluded and solution is provided. Meanwhile, an example is developed based on .Net framework and Microsoft SQL Server 2000.Finally, we conclud our research work and talk about the future research direction. Hope the protocol can apply to distributed database systems. |
PDF Full Text Request