Matching and merging using metadata configuration based on an n-layer model

A system comprising:

• one or more processors;
• and
• memory storing instructions that, when executed by the one or more processors, cause the system to perform:
• assigning a data item entity ID (EID) to a data item;
• onboarding a data point;
• assigning a data point EID to the data point;
• matching the data point with the data item in a multitenant EID lineage-persistent relational database management system (RDBMS), wherein the multitenant EID lineage-persistent RDBMS retains EIDs for each piece of data, even if the data is merged or assigned a new EID, wherein the multitenant EID lineage-persistent RDBMS has an n-layer architecture, and wherein the data item comprises a record stored in an object datastore of the multitenant EID lineage-persistent RDBMS, the object datastore including records that have been matched to real-world entities;
• merging the data point with the data item to create a merged data item, wherein the data point is merged with the record in the object datastore while retaining a primary EID of the record as a primary EID of the merged data item and retaining the data point EID as a legacy EID in a legacy EID datastore associated with the multitenant EID lineage-persistent RDBMS;
• changing the merged data item;
• triggering survivorship and lineage EID promotion rules based on the changing of the merged data item.

A method comprising:

• assigning a data item entity ID (EID) to a data item;
• onboarding a data point;
• assigning a data point EID to the data point;
• matching the data point with the data item in a multitenant EID lineage-persistent relational database management system (RDBMS), wherein the multitenant EID lineage-persistent RDBMS retains EIDs for each piece of data, even if the data is merged or assigned a new EID, wherein the multitenant EID lineage-persistent RDBMS has a n-layer architecture, and wherein the data item comprises a record stored in an object datastore of the multitenant EID lineage-persistent RDBMS, the object datastore including records that have been matched to real-world entities;
• merging the data point with the data item to create a merged data item, wherein the data point is merged with the record in the object datastore while retaining a primary EID of the record as a primary EID of the merged data item and retaining the data point EID as a legacy EID in a legacy EID datastore associated with the multitenant EID lineage-persistent RDBMS;
• changing the merged data item;
• triggering survivorship and lineage EID promotion rules based on the changing of the merged data item.