Invention Grant
- Patent Title: System and method for merging slowly changing data
-
Application No.: US15858160Application Date: 2017-12-29
-
Publication No.: US10795915B1Publication Date: 2020-10-06
- Inventor: Thomas Starr , Ivan Gudzei , Dave Musgrove , Katarzyna Jurkiewicz , Sergey Sinkevich , Vladimir Karaychentsev
- Applicant: IQVIA Inc.
- Applicant Address: US NJ Parsippany
- Assignee: IQVIA Inc.
- Current Assignee: IQVIA Inc.
- Current Assignee Address: US NJ Parsippany
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/27 ; H04L29/08 ; G06F16/23 ; G06F16/11

Abstract:
The disclosure generally describes computer-implemented methods, software, and systems for accessing volumes of data records structured to include sets dimensions, each dimension labelled in a manner specific to respective entities; identifying candidates data records keyed by managed keys that span a subset of dimensions even though at least one dimension from the subset of dimensions is labelled differently between the different volumes; comparing the candidate data records from the different volumes to determine whether a particular managed key is valid based on contents of the candidate data records from the different volumes; in response to determining that the particular managed key is valid, combining the candidate data records keyed by the valid managed key to be merged and accessible as one continuous entry; and in response to determining that the particular managed key is invalid, combining the candidate data records from the different volumes as separate entries.
Information query