Patent ID: 7376675
Filing Date: 2008-05-20
Classification: G06F,Y10S

Abstract:
1. A method of maintaining order of a plurality of transactions originating from a source database and being replicated to a target database, comprising: receiving, at said target database, a first transaction and a second transaction of said plurality of transactions, wherein said first transaction was committed prior to said second transaction at said source database; assigning, at said target database, a first lockable object to said first transaction; prior to committing said second transaction at said target database, attempting, at said target database, to obtain a lock on said first lockable object, wherein being unable to obtain said lock on said first lockable object indicates that said second transaction and said first transaction will not be committed at said target database in a same order as at said source database; in response to being unable to obtain said lock, causing said second transaction to be committed after said first transaction at said target database; prior to said attempting to obtain said lock on said first lockable object, committing said first transaction, wherein said committing said first transaction unlocks said first lockable object; and in response to no deadlock being detected in response to said attempting to obtain said lock, committing said second transaction in said target database, wherein said no deadlock being detected in response to said attempting to obtain said lock indicates that said second transaction will be committed in said target database in the same order as in said source database.