Patent ID: 9195725
Filing Date: 2015-11-24
Classification: G06F

Abstract:
1. A computer-implemented method of resolving conflicts between data for database integration comprising: integrating data from first and second data sources to produce integrated data comprising one or more integrated database tables; determining, for each column of each row for the one or more integrated database tables, whether a foreign key reference is present; in response to determining that a foreign key reference is present, traversing a link corresponding to the foreign key reference to access data associated with the foreign key reference in one or more other database tables; determining a presence of conflicted data between data from the first data source and data from the second data source, wherein at least one of the first data source and the second data source includes data associated with the foreign key reference, one or more sets of prioritized policies for resolving conflicts is associated with data of the first and second data sources, and at least one policy comprises a manual resolution policy that provides an indication to implement manual resolution of the conflicted data by a user; selecting a policy for the column from the one or more sets of prioritized policies associated with the conflicted data based on database transaction log information indicating data provenance of the first and second data sources, wherein the selected policy is appropriate to resolve the conflicted data and is automatically selected from among the one or more sets of prioritized policies when the policy has a priority over all other prioritized policies, and in the event there is not a single policy from the one or more sets of prioritized policies that has priority over all other prioritized policies, selecting the policy that is the manual resolution policy; and applying the selected policy to the column to resolve the conflicted data and produce a resulting data value for the integrated data.