Method and apparatus for preserving data coherency in a database by generating a command object that includes instructions for writing a data record to a local cache

• US 7,328,222 B2
• Filed: 08/26/2004
• Issued: 02/05/2008
• Est. Priority Date: 08/26/2004
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Keith, Michael L., Vo, Steven
• Primary Examiner(s): CHANNAVAJJALA, SRIRAMA T
• Application Number:
  US10/927,773
• Publication Number:
  US 20060047718A1
• Time in Patent Office: 1,258 Days
• Field of Search: 707 1- 2, 707 4- 5, 707/104.1, 707/200, 707/100, 707/103.R, 707/103.Y, 707/103.Z, 711/3, 711/113, 711119-123, 711125-126, 711130-132, 711/144, 711141-142, 709225-229, 717/108, 717/114, 717/116, 717/120, 717/165
• US Class Current: 1/1
• CPC Class Codes: G06F 12/0831 using a bus scheme, e.g. with bus monitoring or watching means
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A method of and system for managing cached data across disparate systems is disclosed. A system for providing cached data coherency includes: a client computer, an application server, a main database, one or more remote application servers, and a communication network interconnecting the client computer, the application server, the main database, and the one or more remote application servers. The application server being operable to respond to a data record being updated by the client computer, by: updating a cache local to the application server, updating the main database, generating a command object defining the updating of the data record, and sending the command object to the one or more remote application servers. The one or more remote application servers being operable to respond to the receipt of the command object by executing the command object, thereby storing the updated data record on caches local to the one or more remote application servers.

Claims

1. 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.

2. The method of claim 1, wherein when executing the command object, the method further comprises converting the data record into a data format used by the second software application.

3. The method of claim 2, wherein converting the data record involves:

determining local parameters for the second software application; and

converting the data record into the data format used by the second software application in accordance with the local parameters.

4. The method of claim 1, wherein producing a command object involves adding functions for writing the data record in the entry in the local cache associated with the second software application from a library of functions to a template command object.

5. The method of claim 1, wherein the command object comprises a pluggable software module, and wherein executing the command object involves plugging the command object into the second software application.

6. The method of claim 1, wherein the first software application and the second software application are coupled to one another through a communication network.

7. The method of claim 6, wherein the communication network comprises the Internet.

8. The method of claim 1, wherein the first software application and the second software application run on different platforms.

9. The method of claim 1, wherein receiving a data record involves receiving a new data record or receiving an update to an existing data record.

10. A computer-readable storage medium containing instructions that when executed by a computer cause the computer to perform a method for preserving data coherency in a computer system, the method 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.

11. A system for preserving data coherency in a computer system, comprising:

a client computer;

an application server;

a main database;

one or more remote application servers; and

a communication network interconnecting the client computer, the application server, the main database, and the one or more remote application servers;

the application server being operable to;

receive a data record from a client computer that is to be written to an entry in a local cache for the application server, wherein a main database includes an entry associated with the entry in the local cache;

write the data record in the entry in the local cache;

attempt to write the data record in the entry in the main database; and

if the write to the entry in the main database fails,

restore a prior state to the entry in the local cache for the first software application, discard the data record, and generate an error signal to a user;

but

if the write to the entry in the main database is successful,

identify 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;

produce 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 the one or more remote application servers; and

send the command object to the one or more remote application servers;

the one or more remote application servers being operable to execute the received command object, thereby storing the updated data record on caches local to the one or more remote application servers.