US 11,868,370 B2
System and method for merging slowly changing data
Thomas Starr, Danbury, CT (US); Ivan Gudzei, Danbury, CT (US); Dave Musgrove, Danbury, CT (US); Katarzyna Jurkiewicz, Danbury, CT (US); Sergey Sinkevich, Danbury, CT (US); and Vladimir Karaychentsev, Danbury, CT (US)
Assigned to IQVIA Inc., Parsippany, NJ (US)
Filed by IQVIA Inc., Parsippany, NJ (US)
Filed on Apr. 11, 2022, as Appl. No. 17/717,246.
Application 17/717,246 is a continuation of application No. 17/027,044, filed on Sep. 21, 2020, granted, now 11,321,355.
Application 17/027,044 is a continuation of application No. 15/858,160, filed on Dec. 29, 2017, granted, now 10,795,915, issued on Oct. 6, 2020.
Prior Publication US 2022/0237207 A1, Jul. 28, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/27 (2019.01); G06F 16/11 (2019.01); H04L 67/1097 (2022.01); G06F 16/23 (2019.01)
CPC G06F 16/275 (2019.01) [G06F 16/119 (2019.01); G06F 16/23 (2019.01); H04L 67/1097 (2013.01)] 18 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
obtaining data records from a first volume and data records from a second volume, wherein each of the data records is keyed by a respective key,
wherein each key spans a subset of dimensions, wherein each of the dimensions indicates a respective attribute of the data records,
wherein at least one dimension from the subset of dimensions is labelled differently between the first volume and the second volume,
determining that a particular key is invalid based on a comparison of the data records from the first volume with the data records from the second volume, wherein the data records from the first volume and the data records from the second volume cover an overlapping period of time; and
combining the data records from the first volume with the data records from the second volume according to the invalid key such that the data records from the first volume and the data records from the second volume keyed by the invalid key are accessible as a single entry.