Research and Improvement of SQLite's Concurrency Control Mechanism

On the basis of the study of SQLite and other concurrency control mechanisms in memory database, an adaptive concurrency control mechanism is proposed according to the operating environment of SQLite in intelligent mobile devices. The function and concrete flow of improved concurrency control are introduced and discussed. The data structure and the main functions of each part are analyzed. The function and performance of the improved concurrency control mechanism are tested. The results verify the correctness and validity of the adaptive concurrency control.