US 12,393,592 B2
System and method for comparing and selectively merging database records
Pradeep Reddy Bobbala, R. R. Dist (IN); Srinivas Mallepally, Secunderabad (IN); and Satish Subramanya Hota, Skillman, NJ (US)
Assigned to Hexagon Technology Center GmbH, Heerbrugg (CH)
Filed by Hexagon Technology Center GmbH, Heerbrugg (CH)
Filed on Aug. 4, 2021, as Appl. No. 17/394,146.
Application 17/394,146 is a continuation of application No. 16/104,361, filed on Aug. 17, 2018, granted, now 11,120,025.
Claims priority of application No. 201841022589 (IN), filed on Jun. 16, 2018.
Prior Publication US 2021/0365447 A1, Nov. 25, 2021
Int. Cl. G06F 16/2455 (2019.01); G06F 7/14 (2006.01); G06F 16/215 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2456 (2019.01) [G06F 7/14 (2013.01); G06F 16/215 (2019.01); G06F 16/2282 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A method of comparing a source database to a target database, the method comprising:
for each of a plurality of objects in the source database, each of said plurality of objects in the source database including a dependent parent object that categorizes a property of the object in a multiple level object hierarchy:
querying the target database for the object and the dependent parent object in the multiple level object hierarchy, including joining a database table related to the dependent parent object;
characterizing the object as a source-only object when the object does not exist in the target database; and
characterizing the object as a difference object when the object does exist in the target database but the target database does not include a dependent parent object with a matching categorization of the property of the object;
for each of a plurality of objects in the target database, each of said plurality of objects in the target database including a dependent parent object that categorizes a property of the object in the multiple level object hierarchy:
querying the source database for the object and the dependent parent object in the multiple level object hierarchy, including joining a database table related to the dependent parent object;
characterizing the object as a target-only object when the object does not exist in the source database; and
characterizing the object as a difference object when the object does exist in the source database but the source database does not include a dependent parent object with a matching categorization of the property of the object; and
generating a graphical user interface displaying the source-only objects, the target-only objects, and the difference objects in a manner that visually shows the characterization of each displayed object and each displayed object is user-selectable via the graphical user interface to obtain information about the object and for difference objects differences between the source database and the target database with respect to the object including the dependent parent object categorizations of the properties of the object.