Systems and methods for sharing resources in a multi-user environment

Claim 2

A client-server database system comprising: a database server storing a database; a database engine for performing database operations on said database in response to requests from clients, said database engine including an interface for receiving said requests; at least one stored procedure, operably coupled to said database engine, for invoking a pre-defined sequence of operations of the database engine, said at least one stored procedure having a data object shared concurrently by said clients; and a surrogate mutex for providing nested mutual exclusive access of said data object to a particular client in response to multiple, nested requests by said particular client for mutual exclusive access, said surrogate mutex encapsulating a system mutex from an operating system which does not support nested mutual exclusive access.

Claim 3

The system of claim 1, wherein said surrogate mutex comprises a record describing access to said data object, said record having an identifier field for storing an identity of said particular client, an identifier for said system mutex from an operating system, and having a count field for storing how many times said particular client has requested access to said data object.

Claim 4

The system of claim 2, further comprising a means for storing a value of 1 in said count field and granting said particular client access to said data object if said identifier field indicates no client is requesting access to said data object.

Claim 5

The system of claim 2, further comprising a means for placing said particular client in a sleep state until said identifier field indicates no other client has access to said data object if said identifier field does not specify said particular client.

Claim 6

The system of claim 2, further comprising a means for incrementing said count field if said identifier field specifies said particular client.

Claim 7

The system of claim 2, further comprising a means for decrementing said count field when said particular client finishes a requested access to said data object.

Claim 8

The system of claim 2, further comprising a means for allowing another client to access said data object once said count field reaches zero.

Claim 9

The system of claim 1, further comprising a table for maintaining said at least one stored procedure.

Claim 10

In a client-server database system including a server maintaining a database and a plurality of clients, a method for providing nested mutual exclusive access to a data object specified by a shared stored procedure, said shared stored procedure comprising user-specified data manipulation statements for instructing said server to perform a predefined sequence of operations on said database, the method comprising the steps of: allocating within storage a surrogate mutex including a record describing access to a data object specified by said shared stored procedure and shared concurrently by said plurality of clients, said record having an identifier field for storing an identity of a client, having a mutex field for accessing a system mutex from an operating system that does not allow nested mutual exclusive access, and having a count field for storing how many times said client has requested access to said data object; receiving at least one request from a particular client to access said data object; and for each said at least one request from said particular client to access said data object, performing one of the following: storing an identity of said particular client in said identifier field, storing a pointer to a system mutex that does not allow nested mutual exclusive access in said mutex field, storing a value of 1 in said count field, and granting said particular client access to said data object if said identifier field indicates no client has access to said data object, placing said particular client in a sleep state until said identifier field indicates no other client has access to said data object if said identifier field does not specify said particular client, and incrementing said count field if said identifier field specifies said particular client.

Claim 11

In a client-server database system including a server maintaining a database and a plurality of clients, a method for providing nested mutual exclusive access to a data object specified by a shared stored procedure, said shared stored procedure comprising user-specified data manipulation statements for instructing said server to perform a predefined sequence of operations on said database, the method comprising the steps of: allocating within storage a surrogate mutex including a record describing access to a data object specified by said shared stored procedure and shared concurrently by said plurality of clients, said record having an identifier field for storing an identity of a client, having a mutex field for accessing a system mutex from an operating system that does not allow nested mutual exclusive access, and having a count field for storing how many times said client has requested access to said data object; receiving at least one request from a particular client to access said data object; and for each said at least one request from said particular client to access said data object, performing one of the following: storing an identity of said particular client in said identifier field, storing a pointer to a system mutex that does not allow nested mutual exclusive access in said mutex field, storing a value of 1 in said count field, and granting said particular client access to said data object if said identifier field indicates no client has access to said data object, placing said particular client in a sleep state until said identifier field indicates no other client has access to said data object if said identifier field does not specify said particular client, and incrementing said count field if said identifier field specifies said particular client.

Claim 12

The method of claim 9, wherein said particular client requests access to said data object a plurality of times so that said particular client has nested access to said data object.

Claim 13

The method of claim 9, further comprising the step of decrementing said count field when said particular client finishes a requested access to said data object.

Claim 14

The method of claim 11, further comprising the step of allowing another client to access said data object once said count field reaches zero.

Claim 15

The method of claim 11, further comprising the step of storing a blank value in said identifier field indicating no client has access to said data object when said count field reaches zero.

Claim 16

The method of claim 9, further comprising the step of initializing said record by storing a blank value in said identifier field and storing a blank value in said count field.

Claim 17

The method of claim 13, wherein said blank value in said identifier field has a numeric value equal to 0.

Claim 18

The method of claim 13, wherein said blank value in said count field has a numeric value equal to 0.

Claim 19

The method of claim 9, wherein said identifier field stores an ID provided by said system.

Claim 20

The method of claim 9, further comprising the steps of: obtaining said system mutex from said system; and providing mutual exclusive access to said shared stored procedure through said system mutex.

Claim 21

The method of claim 9, wherein said system mutex is released back to said system when no other client requires access to said data object.

Claim 22

The method of claim 9, wherein said first program is suspended from execution when placed in said sleep state.

Claim 23

The method of claim 9, further comprising the step of allocating within storage a table for maintaining a plurality of shared stored procedures, each shared stored procedure instructing said server to perform a predefined sequence of operations comprising stored data manipulation statements operating on said database.

Claim 24

A computer program product for providing nested mutual exclusive access to a data object specified by a shared stored procedure in a client-server database system including a server maintaining a database and a plurality of clients, said computer program product comprising: a computer readable storage medium storing a computer program, said computer program comprising: code that allocates within storage a record describing access to a data object specified by said shared stored procedure storing user-specified data manipulation statements for instructing said server to perform a predefined sequence of data manipulation operations on said database and shared concurrently by said plurality of clients, said record having an identifier field for storing an identity of a client, having a mutex field for accessing a system mutex which does not support nested mutual exclusive access, and having a count field for storing how many times said client has requested access to said data object; code that receives at least one request from a particular client to access said data object; and code that for each said at least one request from said particular client to access said data object, performs one of the following: stores an identify of said particular client in said identifier field, stores in said mutex field a pointer to a system mutex that does not allow nested mutual exclusive access, stores a value of 1 in said count field, and granting said particular client access to said data object if said identifier field indicates no client has access to said data object, places said particular client in a sleep state until said identifier field indicates no other client has access to said data object if said identifier field does not specify said particular client, and increments said count field if said identifier field specifies said particular client.

Claim 25

A computer program product for providing nested mutual exclusive access to a data object specified by a shared stored procedure in a client-server database system including a server maintaining a database and a plurality of clients, said computer program product comprising: a computer readable storage medium storing a computer program, said computer program comprising: code that allocates within storage a record describing access to a data object specified by said shared stored procedure storing user-specified data manipulation statements for instructing said server to perform a predefined sequence of data manipulation operations on said database and shared concurrently by said plurality of clients, said record having an identifier field for storing an identity of a client, having a mutex field for accessing a system mutex which does not support nested mutual exclusive access, and having a count field for storing how many times said client has requested access to said data object; code that receives at least one request from a particular client to access said data object; and code that for each said at least one request from said particular client to access said data object, performs one of the following: stores an identify of said particular client in said identifier field, stores in said mutex field a pointer to a system mutex that does not allow nested mutual exclusive access, stores a value of 1 in said count field, and granting said particular client access to said data object if said identifier field indicates no client has access to said data object, places said particular client in a sleep state until said identifier field indicates no other client has access to said data object if said identifier field does not specify said particular client, and increments said count field if said identifier field specifies said particular client.

Claim 26

The computer program product of claim 22, wherein said computer program allows said particular client nested access to said data object.

Claim 27

The computer program product of claim 22, further comprising code that decrements said count field when said particular client finishes a requested access to said data object.

Claim 28

The computer program product of claim 24, further comprising code that allows another client to access said data object once said count field reaches zero.

Claim 29

The computer program product of claim 24, further comprising code that stores a blank value in said identifier field indicating no client has access to said data object when said count field reaches zero.

Claim 30

The computer program product of claim 22, further comprising: code that obtains said system mutex from said system; and code that provides mutual exclusive access to said shared stored procedure through said system mutex.

Claim 31

The computer program product of claim 27, wherein said system mutex is released back to said system when no other client requires access to said data object.

Claim 32

The computer program product of claim 22, further comprising code that allocates within storage a table for maintaining a plurality of shared stored procedures, each shared stored procedure instructing said server to perform a predefined sequence of operations on said database.