Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
Optimistic Concurrency Control for Maintaining the Global Integrity Constraint in MDBSs
Proceedings of the IFIP TC11 Working Group 11.5, First Working Conference on Integrity and Internal Control in Information Systems: Increasing the confidence in Information Systems
| Hi-index | 0.00 |
The objectives of global transaction management in multidatabase systems (MDBS) are to avoid the inconsistent retrievals and guarantee the global serializability under the existence of indirect conflict which is unknown to to the global transaction manager(GTM). Many researches have shown that it is diffcult to design the global concurrency control method because of local autonomy. In these method global transactions have a few opportunities to be executed concurrently. We concentrate our attention on 1) investigation into the more accurate indirect conflict situation and 2) supporting the higher concurrency degree by using the concept of global integrity constraints. We define the multidatabase transaction model and then propose the concurrency control protocols. In our method the more global transaction can be concurrently executed, since the refined boundary of possibility of indirect conflict is offered.