Patent ID: 6751617
Filing Date: 2004-06-15
Classification: G06F,Y10S

Abstract:
A method for processing and managing requests for concurrent access to at least one data resource present in a database in a multiuser environment, wherein access to said at least one data resource is requested through a first transaction operating within a context of the database, comprising:creating, at a first hierarchical level representing the database, a first data structure representing a lock status of a data resource present in the database, setting one or more fields of said first data structure to indicate that said data resource is locked by said first transaction; creating, at a second hierarchical level representing a subdatabase of said database, a second data structure representing a lock status of said data resource within the subdatabase, wherein the created subdatabase comprises a subset of the at least one data resource in the database and the created subdatabase includes at least said data resource; creating an association between said first data structure at said first hierarchical level and said second data structure at said second hierarchical level; setting one or more fields of said second data structure at said second hierarchical level to indicate that said data resource is not locked and is accessible to transactions operating within a context of the subdatabase; and granting access to said data resource to a second transaction operating within said context of the subdatabase by indicating in said second data structure that said data resource is locked at said second hierarchical level.