Patent ID: 7089253

Claim:
A computer implemented method of establishing serialization ordering among database transactions in a database system, comprising: given a database transaction, storing a representation of an intended use of a database resource by the database transaction, wherein intended use of the database resource includes any of reads and writes based on history of the database transaction, wherein the intended use of the database resource includes at least one of: accessing state of the database resource and modifying the state of the database resource, and wherein storing the representation of the intended use of database resource comprises: creating a resource usage record; and associating the resource usage record with the database transaction, wherein the resource usage record is maintained for a period of time after the database transaction commits, and is not released until no serialization orderings is created that would involve the committed database transaction in a cycle of serialization orderings; and dynamically asserting serialization ordering between the database transaction and other database transactions based upon the intended use of the database resource by the database transaction and the other database transactions.