US 7,613,741 B2Granted

Utilizing rules in a distributed information sharing system

AssigneeOracle International Corporation

InventorsEdwina Lu, Lik Wong, Sanjay Kaluskar, James Stamos, Neerja Bhatt, Wei Wang

Life of this patent

Estimating the term…

Loading patent…

Abstract

Described herein are various approaches that allow rules to be used to specify actions, that alleviate the complexity and burden of developing and maintaining rules in a rules-based messaging system, and that provide more efficient ways of evaluating rules. The approaches allow rules to specify user-defined transformation functions for transforming messages, to specify when and how to perform row migration, and to specify other types of actions. Rules are grouped into rule sets. Several types of rule sets, referred to as positive and negative rule sets, allow users to use rules that are less complex to develop and maintain. Rule sets are evaluated more efficiently by attempting to evaluate the rule set with less information than is needed to evaluate all the rules in the rule set. Also, the results of rules evaluations that are based on a set of values are cached for later retrieval.

Claims20

Dependent claims

A method for controlling a capture process running on a source database server, the method comprising the steps of:

said capture process propagating messages between said source database server and a destination database server;
said capture process scanning one or more records from a redo log that records changes made at said source database server;
said capture process generating a particular message that includes data from said one or more records;
said capture process calling a rules engine to make an evaluation of a set of rules based on said data from said one or more records, wherein each rule of said set of rules is associated with a condition and first data that identifies an action;
for a particular rule of said set of rules whose corresponding condition is satisfied based on said evaluation, said rules engine returning said first data for said particular rule;
and
said capture process performing the action identified by the first data returned by said rules engine.

4 more elements

Dependencies are inferred from the claim text.

Facts

Application: 10/449,873Filed 30 May 2003 · continuation in part
Priority: 1 Aug 2002
Published: US 2004/0034618 A119 Feb 2004
Granted: 3 Nov 2009
Term ends: Not estimatedThe source records don’t support an estimate.

Classification4 codes

G06F 16/27
Of structured data, e.g. relational data: replication, distribution or synchronisation of data between databases or within a distributed database…
Y10S 707/99953
Coherency, e.g. same view to multiple users: recoverability
G06F
Computing and data processing
Y10S
Technical subjects covered by former uspc cross-reference art collections [xracs] and digests

Family

Application60/400,532Us provisional application · filed 1 Aug 2002
Application60/410,883Us provisional application · filed 13 Sep 2002
Application10/308,924Parent of this continuation-in-part · filed 2 Dec 2002
Application10/418,882Parent of this continuation-in-part · filed 17 Apr 2003
US 2004/0034618 A1Pre-grant publication · published 19 Feb 2004
US 7,366,713 B2Parent of this continuation-in-part
US 6,889,231 B1Parent of this continuation-in-part
US 2003/0212657 A1Published application
US 7,613,741 B2This patent

From the US filing history. Foreign family members aren’t listed.

Timeline

Citations

Open elsewhere

Building an agent or pulling many patents? Use the API or MCP server instead of scraping pages. Get an API key