The Research Of The Transaction Control Mechanism In The High Concurrent Environment

With the development of cloud computing and big data, there is a huge amounts of data being produced every day. A large number of concurrent data access requirements are existing in many application scenarios. In the meantime, with the multi-core processors and large memory trend of hardware upgrades, it provides a solid hardware foundation to solve the large-scale concurrent data processing problem. Database transactions are the most frequently used operation, which need to satisfy the ACID (atomicity, consistency, isolation, and durability) principle. In traditional database transaction processing, lock methods, such as shared lock, exclusive lock, etc., are used to realize the serializability and ensure the control mechanism. However, such traditional locking mechanisms can’t achieve the demand of the transaction throughput when dealing with huge amounts of concurrent processing. And obviously existing hardware abilities can’t be performed effectively.Aiming at these problems, after investigating and researching the latest relative work, this paper proposes a transaction processing mechanism in high concurrent environment. Compared to traditional transaction processing mechanism, there are three main contribution:①A unique multi version storage data framework is designed and implemented. It can support unlocked concurrent access and reduce the repeated write for public data. This framework effectively improve the ability of dealing with concurrent transactions;②We design and implement a solution for splitting transaction which divide the transaction into multiple execution stages. This solution strengthens the management of transaction execution and handles the possible concurrency problems in a more granular level. It can further improve the utilization of resources.③Design an OCC(optimistic concurrency control) based transaction commit scheme which is combined with multi version of the data index structure and fine-grained transaction control. It manages the submit dependencies between transactions and ensures the highest transaction isolation level (serializable). At the same time it improves the utilization of resources and increases transaction throughput. Compared with the traditional transaction processing mechanism, the experiment results show that our transaction processing mechanisms have large enhancement for the utilization of resources and the throughput of transactions in the high concurrent transactions environment.