Deferred control of surrogate key generation in a distributed processing architecture
First Claim
Patent Images
1. In a computer system, a method for correlating information from one or more sources, comprising:
- receiving, at a key authority, notification of a change to an attribute of an entity, the entity prior to the change being associated with a first surrogate key;
deferring the use of a second surrogate key, generated in response to the change, until a selected time, wherein the second surrogate key was generated to reflect the change;
receiving from a first source system an event notification, the event notification comprising event information and a source specific key;
determining a third surrogate key corresponding to the source specific key;
determining a hint associated with at least one of the first and second surrogate keys;
mapping the hint and third surrogate key to determine the first surrogate key; and
using the first surrogate key in a row of a table.
24 Assignments
0 Petitions
Accused Products
Abstract
An event reporting system includes a computational component 228 operable (a) to receive notification of a change to an attribute of an entity, the entity, prior to the change, being associated with a first surrogate key, and (b) to defer the use of a second surrogate key for the entity until a selected time. The second surrogate key was generated to reflect the change.
-
Citations
13 Claims
-
1. In a computer system, a method for correlating information from one or more sources, comprising:
-
receiving, at a key authority, notification of a change to an attribute of an entity, the entity prior to the change being associated with a first surrogate key; deferring the use of a second surrogate key, generated in response to the change, until a selected time, wherein the second surrogate key was generated to reflect the change; receiving from a first source system an event notification, the event notification comprising event information and a source specific key; determining a third surrogate key corresponding to the source specific key; determining a hint associated with at least one of the first and second surrogate keys; mapping the hint and third surrogate key to determine the first surrogate key; and using the first surrogate key in a row of a table. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. An event reporting system including at least one processor for correlating information from one or more resources, the event reporting system comprising:
-
a key authority that receives notification of a change to an attribute of an entity, the entity, prior to the change, being associated with a first surrogate key, and defers the use of a second surrogate key for the entity until a selected time, wherein the second surrogate key was generated to reflect the change; an input adapter that receives from a first source system an event notification, the event notification comprising event information and a source specific key; and an identity resolution authority that determines a third surrogate key corresponding to the source specific key, wherein the key authority determines a hint associated with at least one of the first and second surrogate keys, and wherein the key authority maps the hint and third surrogate key to determine the first surrogate key and use the first surrogate key in a row of a table. - View Dependent Claims (8, 9, 10, 11, 12, 13)
-
Specification