DEFERRED CONTROL OF SURROGATE KEY GENERATION IN A DISTRIBUTED PROCESSING ARCHITECTURE

• US 20100235371A1
• Filed: 05/27/2010
• Published: 09/16/2010
• Est. Priority Date: 08/08/2005
• Status: Active Grant

• Current Assignee: Avaya Incorporated
• Original Assignee: Avaya Incorporated
• Inventors: Jennings, Terry Don, Friedl, Stephan Edward, Olson, Jeffrey James, Bland, Michael Alan, Youngkin, Richard Shaffer
• Granted Patent: US 8,578,396 B2
• Time in Patent Office: Days
• US Class Current: 707/756
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

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.

Claims

1-9. -9. (canceled)

10. A method for correlating information, comprising:

receiving an event notification, the event notification comprising event information and a natural key;

mapping the natural key to a normalized key; and

selecting a first hint for the normalized key, the first hint indicating which of a plurality of surrogate keys associated with the normalized key will be used in a record corresponding to the event information.

11. The method of claim 10, further comprising:

determining whether to use the first hint;

when the first hint is to be used, mapping the normalized key and first hint to identify a second surrogate key in the plurality of surrogate keys; and

when the first hint is not to be used, selecting a second hint for the normalized key, the second hint being associated with a first surrogate key in the plurality of surrogate keys.

12. The method of claim 11, further comprising:

selecting the second surrogate key when the first hint is used and the first surrogate key when the second hint is used; and

adding a row to a fact table using the selected one of the first and second surrogate keys.

13. The method of claim 10, wherein the natural key is associated with context.

14. A logic circuit operable to perform the steps of claim 10.

15. A computer readable medium comprising executable instructions to perform the steps of claim 10.

16-24. -24. (canceled)