Database system for triggering event notifications based on updates to database records

• US 9,690,820 B1
• Filed: 04/01/2016
• Issued: 06/27/2017
• Est. Priority Date: 09/27/2007
• Status: Active Grant

• Current Assignee: Experian Information Solutions Incorporated (Experian plc)
• Original Assignee: Experian Information Solutions Incorporated (Experian plc)
• Inventors: Girulat, Jr., Rollin M.
• Primary Examiner(s): Channavajjala, Srirama
• Application Number:
  US15/089,241
• Time in Patent Office: 452 Days
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06Q 10/0635 Risk analysis of enterprise or organisation activities
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/03 Credit; Loans; Processing thereof
• CPC Class Codes: G06Q 40/06 Asset management; Financial planning or analysis
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

A data processing system is disclosed for accessing databases and updated data items and triggering event notifications. The data processing system may comprise a first database including a plurality of records, and a second database including a plurality of trigger indicators. The database system may further include a hardware processor configured to execute computer-executable instructions in order to: receive an update data item; identify a record corresponding to the update data item; cause an update to the record based on information included with the update data item; identify a trigger indicator corresponding to the update to the record; determine that a type of the trigger indicator matches a type of the update to the record; and generate an event notification including information included in the update.

Claims

1. A computer implemented method for generating an alert, the method comprising:

providing a database system storing database records for a plurality of individual users, wherein each of the database records stored by the database system is associated with a particular user;

coupling a computing system of a first user with the database system via one or more network communication links;

receiving, by the database system and from the computing system of the first user, a request to monitor a particular database record associated with a particular individual, wherein the particular database record of the particular individual includes at least a current database record of the particular individual and a historical database record of the particular individual, wherein the request includes;

an identification of the particular individual usable by the database system to identify the particular database record associated with the particular individual, and

one or more rules indicating;

particular types of changes to database records that are of interest to the first user, and

that the computing system of the first user be notified when the database system determines that one or more of the particular types of change are made to the particular database record of the particular individual identified by the first user;

accessing, by the database system and from a historical database storing the historical database record of the particular individual identified by the first user, wherein;

the historical database record was created at a first point in time indicated by a first timestamp of the historical database record, and

the historical database record includes information indicating any accounts of the particular individual at the first point in time;

accessing, by the database system and from a current records database storing the current database record of the particular individual identified by the first user, wherein;

the current database record was created at a second point in time indicated by a second timestamp of the current database record,

the second point in time is later than the first point in time, and

the current database record includes information indicating any accounts of the particular individual at the second point in time;

applying the one or more rules provided by the first user to the current database record of the particular individual and the historical database record of the particular individual to determine whether the particular types of changes have occurred between the first point in time and the second point in time, said applying the one or more rules comprising;

comparing, by the database system, the historical database record of the particular individual to the current database record of the particular individual to determine whether information indicating accounts of the particular individual has changed between the first point in time and the second point in time;

if it is determined that information indicating accounts of the particular individual has changed between the first point in time and the second point in time;

identifying, by the database system, a first type of change or a second type of change to information regarding accounts of the particular individual between the historical database record at the first point in time and the current database record at the second point in time; and

determining whether the identified first type of change or second type of change matches any of the particular types of changes included in the one or more rules received from the first user; and

if it is determined that the identified first type of change or second type of change matches any of the particular types of changes;

automatically generating, by the database system, an electronic alert for communication to the computing system of the first user, wherein the electronic alert indicates the identified first type of change or second type of change between the historical database record of the particular individual and the current database record of the particular individual; and

transmitting, by the database system, the electronic alert to the computing system of the first user.

2. The computer implemented method of claim 1, wherein the request from the computing system of the first user further includes at least a name and address associated with the database record.

3. The computer implemented method of claim 1, wherein the first point in time and the second point in time are separated by at least one of:

one day, one week, one month, two months, three months, four month, six months, one year, two years, or five years.

4. The computer implemented method of claim 1, further comprising:

accessing, by the database system and from the historical database storing the historical database record of the particular individual identified by the first user, a second historical database record of the particular individual, wherein;

the second historical database record was created at a third point in time indicated by a third timestamp of the second historical database record,

the third point in time is earlier than the first point in time, and

the second historical database record includes information indicating any accounts of the particular individual at the third point in time; and

further applying the one or more rules provided by the first user to the historical database record of the particular individual and the second historical database record of the particular individual to determine whether the particular types of changes have occurred between the first point in time and the third point in time, said applying the one or more rules comprising;

comparing, by the database system, the historical database record of the particular individual to the second historical database record of the particular individual to determine information indicating accounts of the particular individual has changed between the first point in time and the third point in time.

5. The computer implemented method of claim 1 further comprising:

determining, by the database system, a historical score associated with the historical database record of the particular individual, wherein the historical score is associated with the first timestamp;

determining, by the database system, a current score associated with the current database record of the particular individual, wherein the current score is associated with the second timestamp;

determining, by the database system, a score difference between the historical score and the current score; and

comparing, by the database system, the score difference to a threshold score difference indicated by the one or more rules,

wherein automatically generating and communicating the electronic alert are performed in response to determining both that;

the identified first type of change or second type of change matches any of the particular types of changes, and

the score difference satisfies the threshold score difference indicated by the one or more rules.

6. The computer implemented method of claim 5 further comprising:

applying, by the database system, the one or more rules provided by the first user to determine that a specific change to the database record matches a specific change indicated by the one or more rules,

wherein automatically generating and communicating the electronic alert are performed in response to determining that;

the identified first type of change or second type of change matches and of the particular types of changes,

the score difference satisfies the threshold score difference indicated by the one or more rules, and

the specific change matches the specific change indicated by the one or more rules.