Research On The Concurrency Control Of The Vehicle Weighting Management System Based On The RFID

Under current situation of the enterprise, how to manage the information of the transport vehicle efficiently has become an important issue that many enterprises encountered. In this thesis, in order to manage vehicles more efficiently, vehicle management system based on the RFID technology was proposed after full investigation and research management of the vehicles. Then, after analysis and designing the system, we compared the existing anti-collision algorithm for RFID, and imposed an improved anti-collision algorithm.The purpose of developing this system is to automatically collect and transport real-time vehicle information, the system adopted a real-time database in order to implement real-time transport data, and then, we studied concurrency control mechanism which was one of the issues in the database security. First, the disadvantage of the traditional transaction was found after research on concurrency control. Second, those issues were proposed through analysis of optimistic and pessimistic concurrency control mechanisms, the existence issue of these mechanisms were following: the wasted restart, the wasted execution, the wasted wait. Last, new methods called sacrifice of restarted transaction were proposed to resolve wasted execution problem, those methods included abandon conflict transaction and reduce priority of transaction, which could improve the performance of RTDBS under different load conditions. Abandon conflict transactions could improve the performance of the system under high load condition, and reduce priority of transaction could improve the performance of the system under low load condition.