Science and Development Network (SciDev.Net)
In this paper, a semantic based multi-granular lock model for object-oriented database systems is proposed. It addresses the concurrency control issues related to all types of transactions to an object: run time transactions and design time transactions. In the case of run time transactions, it ensures consistency while providing fine granularity. In the case of design time transactions, the proposed work has the following features: it provides separate lock modes for all types of design time operations, it provides fine granularity for design time transactions and it reduces deadlocks due to lock escalation. The proposed paper shows how concurrency can be maximized while ensuring consistency for all types of transactions.