System and method for merging slowly changing data

A computer system comprising one or more processors that are configured to perform operations of:

• identifying a plurality of candidate data records keyed by a plurality of managed keys,
• wherein each of the plurality of managed keys spans a subset of dimensions included by a first volume of multiple data records and a second volume of multiple data records,
• wherein at least one dimension from the subset of dimensions is labelled differently between the first volume and the second volume,
• wherein the first volume of multiple data records are hosted on a first data server managed by a first entity,
• wherein the first volume covers a first period and includes a first set of dimensions, each dimension being labelled specifically to the first entity,
• wherein the second volume of multiple data records are hosted on a second data server managed by a second entity, and
• wherein the second volume covers a second period and includes a second set of dimensions, each dimension being labelled specifically to the second entity,
• determining that a managed key from the plurality of managed keys is invalid based on a comparison of the plurality of candidate data records from the first volume with the plurality of candidate data records from the second volume, wherein the plurality of candidate data records from the first volume and the plurality of candidate data records from the second volume both cover a period where the first period and the second period overlap;
• and
• consolidating the first volume with the second volume by combining the plurality of candidate data records from the first volume with the plurality of candidate data records from the second volume according to the invalid managed key such that the plurality of candidate data records from the first volume and the plurality of candidate data records from the second volume keyed by the invalid managed key are combined and accessible as one continuous entry.