Systems and methods for real-time de-duplication

A non-transitory machine-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to carry out the steps of:

• creating a first data object in a first database system, wherein the first data object includes a first plurality of data fields capable of storing a corresponding first plurality of data values;
• executing a trigger function in response to creating the first data object, wherein the trigger function causes one or more servers in a second database system to determine if one or more existing data objects stored in the second database system include a combination of a second plurality of data values corresponding to a second plurality of data fields that match the combination of the first corresponding plurality of data values included in the first plurality of data fields, and wherein the trigger function further causes one or more servers in the first database system to retrieve one or more data values from the one or more existing data objects, wherein the first data object and the one or more existing data objects are different types of records;
• storing the retrieved one or more data values of the second plurality of data values in one or more data fields of the first plurality of data fields;
• storing the first data object in the first database system;
• automatically creating a link between the stored first data object and the one or more existing data objects stored in the second database system that include the matching combination of the second plurality of data values, the link being automatically created in response to storing the retrieved one or more data values of the second plurality of data values in the data fields of the first plurality of data fields of the first data object;
• periodically checking the one or more existing data objects to identify whether or not any subsequent changes have been made to the one or more existing data objects;
• and
• automatically updating, using the created link, the stored first data object in response to identifying a subsequent change made to any of the one or more linked existing data objects.

An apparatus comprising:

• a processor;
• and
• one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of:
• creating a first data object in a first database system, wherein the first data object includes a first plurality of data fields capable of storing a corresponding first plurality of data values;
• executing a trigger function in response to creating the first data object, wherein the trigger function causes one or more servers in a second database system to determine if one or more existing data objects stored in the second database system include a combination of a second plurality of data values corresponding to a second plurality of data fields that match the combination of the first corresponding plurality of data values included in the first plurality of data fields, and wherein the trigger function further causes one or more servers in the first database system to retrieve one or more data values from the one or more existing data objects, wherein the first data object and the one or more existing data objects are different types of records;
• storing the retrieved one or more data values of the second plurality of data values in one or more data fields of the first plurality of data fields;
• storing the first data object in the first database system;
• automatically creating a link between the stored first data object and the one or more existing data objects stored in the second database system that include the matching combination of the second plurality of data values, the link being automatically created in response to storing the retrieved one or more data values of the second plurality of data values in the data fields of the first plurality of data fields of the first data object;
• periodically checking the one or more existing data objects to identify whether or not any subsequent changes have been made to the one or more existing data objects;
• and
• automatically updating, using the created link, the stored first data object in response to identifying a subsequent change made to any of the one or more linked existing data objects.