Patent ID: 7328222

Claim:
A method for preserving data coherency in a computer system, comprising: in a first software application, receiving a data record that is to be written to an entry in a local cache for the first software application, wherein the entry in the local cache is associated with an entry in a main database; writing the data record in the entry in the local cache; attempting to write the data record in the entry in the main database; and if the write to the entry in the main database fails, restoring a prior state to the entry in the local cache for the first software application, discarding the data record, and generating an error signal to a user; but if the write to the entry in the main database is successful, identifying the second software application as a software application that should execute the command object to write the data record in the entry in the local cache associated with the second software application; producing a command object, wherein the command object is a software module that includes instructions for writing the data record in an entry in a local cache associated with a second software application; and in a second software application, executing the command object to write the data record in the entry in the local cache associated with the second software application.