EVENT DETECTION WITH CONCURRENT DATA UPDATES

• US 20020174109A1
• Filed: 05/16/2001
• Published: 11/21/2002
• Est. Priority Date: 05/16/2001
• Status: Abandoned Application

• Current Assignee: iSpheres Corp. (Avaya Incorporated)
• Original Assignee: iSpheres Corp. (Avaya Incorporated)
• Inventors: Chandy, Kanianthra Mani, Bax, Eric T.
• Application Number:
  US09/858,801
• Publication Number:
  US 20020174109A1
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

Abstract

An event detection system allows data to be inserted while event conditions are being checked. Each record is assigned a time stamp as it is inserted into a database. Each event condition check is assigned a time stamp range. The event condition check then produces only those matches that have at least one record with a time stamp in the range and no record with a time stamp after the range. After each event condition check, the range is changed so that, in subsequent checks, no part of a previous range is duplicated and no time stamps are excluded from every checked range. As a result of this process, records may be inserted while event conditions are being checked.

Claims

1. A method for detecting matching records among a flow of records into a database, said method comprising the steps of:

establishing a condition for use in selecting a set of matching records;

applying a time stamp to each record in a flow of records as said each record enters a database;

incrementing said time stamp after applying said time stamp to said each record so that said each record has a different time stamp;

defining a sequence of time stamps from a first time stamp to a latest time stamp;

defining a set of current records from records in said flow of records wherein each record in said set of current records has a time stamp falling between said first time stamp and said latest time stamp;

applying said condition to said database to find a set of matching records wherein said set of matching records includes at least one current record from said set of current records and no records having a time stamp greater than said latest time stamp; and

outputting said matching records.

2. The method as recited in claim 1, further comprising the step, following said condition applying step, of redefining said sequence of time stamps wherein said latest time stamp becomes said first time stamp and a later time stamp becomes said latest time stamp.

3. The method as recited in claim 1, wherein said time stamp applying step further comprises the steps of:

applying said time stamp to said record; and

then

inserting said record into said database.

4. The method as recited in claim 1, wherein said time stamp applying step further comprises the steps of:

inserting said record into said database;

applying said time stamp to said record while blocking said condition applying step until said time stamp is applied to said record.

5. The method as recited in claim 1, wherein said database includes plural tables, said each record being inserted into one table of said plural tables, and wherein said matching records include at most one record from said one table and at most one record from another table of said plural tables.

6. A method for detecting matching records among a flow of records into a database, said method comprising the steps of:

establishing an event condition;

establishing a latest variable, an old variable and a new variable;

setting said new variable to a value of zero;

receiving a record from a flow of records;

augmenting said record with a time stamp;

replacing the value of said latest variable with said timestamp;

replacing the value of said old variable with the value of said new variable;

replacing the value of said new variable with the value of said latest variable;

inserting said augmented record into a database; and

finding all matches among records in said database for said event condition that have at least one record with a timestamp greater than said old time stamp and no records with time stamps greater than said new time stamp.

7. A system for detecting records that meet pre-selected conditions, said system comprising:

means for creating a flow of records;

a database for receiving each record in said flow of records;

time stamp manager means for issuing a time stamp to said each record entering said database and for incrementing said time stamp;

means for establishing a range of time stamps beginning with a first time stamp and ending with a latest time stamp;

means for storing a preselected condition;

condition manager means for applying a pre-selected condition to each record in said flow of records having a time stamp in said range of time stamps in order to find a current match between a record having a time stamp within said range and a record within said flow of records; and

means for outputting said current match.

8. The system as recited in claim 7, wherein said time stamp manager applies said time stamps to said each record before said each record enters said database.

9. The system as recited in claim 7, wherein said time stamp manager increments said time stamp after issuing said time stamp to said each record.

10. The system as recited in claim 7, wherein said database includes plural tables and wherein said system further comprises means for collecting current matches from said plural tables.