Implementation And Improvement Of Database Index Concurrency Control | Posted on:2008-03-05 | Degree:Master | Type:Thesis | Country:China | Candidate:B Su | Full Text:PDF | GTID:2178360212984979 | Subject:Computer application technology | Abstract/Summary: | PDF Full Text Request | Relation database becomes more and more important in our daily life. Every may contact with database everyday. To fulfill the need of database's good performance and correctness, it's important to study the concurrency control of database. Index of database makes database perform better in search the data which users query on. So in multi-users environment, the performance of index is the bottleneck of the database query. This paper focus on how to get a better performance of index's concurrency control access.First we show some others' methods, and then we discuss our method which has a improvement in index concurrency control locking protocol and the implement of index. In this paper, we talk about improvements as follow:a) We bring forward a locking protocol of index access, which has a better performance in index concurrency control.b) We improve the index structure modify process, and it's much more convenient to implement modify.c) We also improve the search, insert, delete operation of index accessWe also prove the correctness of our improvement. At last we talk about the recovery and deadlock of our index implementation. | Keywords/Search Tags: | Database, index, concurrency control, Lock, SMO, recovery | PDF Full Text Request | Related items |
| |
|