Systems and user interfaces for dynamic access of multiple remote databases and synchronization of data based on user rules

• US 10,025,842 B1
• Filed: 10/17/2016
• Issued: 07/17/2018
• Est. Priority Date: 11/20/2013
• Status: Active Grant

• Current Assignee: Consumerinfo.com Incorporated (Experian plc)
• Original Assignee: Consumerinfo.com Incorporated (Experian plc)
• Inventors: Charyk, Mike, Yu, Nelson
• Primary Examiner(s): SIMITOSKI, MICHAEL J
• Application Number:
  US15/295,435
• Time in Patent Office: 638 Days
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 16/9538 Presentation of query results
• CPC Class Codes: G06F 21/45 Structures or tools for the administration of authentication
• CPC Class Codes: G06F 21/604 Tools and structures for managing or administering access control systems
• CPC Class Codes: G06F 2221/2115 Third party
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06Q 40/03 Credit; Loans; Processing thereof
• CPC Class Codes: H04L 63/08 for authentication of entities cryptographic mechanisms or cryptographic arrangements for entity authentication H04L9/32
• CPC Class Codes: H04L 63/0815 providing single-sign-on or federations
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
• CPC Class Codes: H04L 67/306 User profiles
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A computing system is configured to access a plurality of remote databases in order to identify data inconsistencies between the remote databases and provide user interfaces to a user in order to initiate communication via one or more APIs to certain remote databases indicating updates that reconcile said data inconsistencies.

Claims

1. A computing system comprising:

one or more storage devices configured to store electronic software instructions; and

one or more computer processors in communication with the one or more storage devices, the one or more computer processors configured to execute the stored electronic software instructions to cause the computing system to automatically;

access, over a network, user information stored in the one or more storage devices, the user information including master data values associated with respective data fields;

access a first remote database of a plurality of remote databases over the network;

determine first remote data associated with a user stored in the first remote database;

compare the first remote data to the user information by comparing the master data values in the user information to corresponding remote data values of remote data fields;

identify a particular master data value in a particular data field that do not include a corresponding remote data value in an associated remote data field;

identify a subset of the plurality of remote databases that each do not include the corresponding remote data value, said identifying comprising, for each of the plurality of remote databases;

accessing a remote database using security protocols and/or communication protocols, over the network;

determining that the corresponding remote data value is not included in a remote data field in the remote database corresponding to the remote data value; and

in response to determining that the remote data value is not included in the remote data field, including the remote database in the subset of remote databases;

generate a user interface for transmission to a remote user computing device, the user interface including;

an indication of the subset of remote databases; and

an interactive user interface control usable to select one or more of the subset of remote databases; and

in response to receiving the indication of a selected one or more of the subset of remote databases from the remote user computing device, for each of the one or more selected remote databases;

determine the security protocols and/or communication protocols; and

using the determined security protocols and/or communication protocols, initiate an update for the one or more selected remote databases.

2. The computing system of claim 1, wherein said accessing the first remote database comprises:

accessing access information in the one or more storage devices, the access information indicating one or more communication parameters for accessing the first remote database.

3. The computing system of claim 2, wherein

the one or more communication parameters comprise APIs, security protocols and/or communication protocols used to communicate to the first remote database over the network.

4. The computing system of claim 1, wherein the network comprises one or more of:

LAN, WAN, or Internet.

5. The computing system of claim 1, wherein the one or more computer processors configured to execute the stored electronic software instructions further cause the computing system to automatically:

receive from the user a selection of a master profile of a plurality of master profiles; and

update the master data values based on data values of the selected mater profile.

6. The computing system of claim 1, wherein the one or more computer processors configured to execute the stored electronic software instructions further cause the computing system to automatically:

track a status of updates for each remote databases in the subset of remote databases.

7. The computing system of claim 1, wherein to initiate the update for the one or more selected remote databases comprises sending a link, for the one or more selected remote databases, to the user to redirect the user to a website to update the remote database.

8. A method comprising:

accessing, over a network, user information stored in one or more storage devices, the user information including master data values associated with respective data fields;

accessing a first remote database of a plurality of remote databases over the network;

determining first remote data associated with a user stored in the first remote database;

comparing the first remote data to the user information by comparing the master data values in the user information to corresponding remote data values of remote data fields;

identifying a particular master data value in a particular data field that does not include a corresponding remote data value in an associated remote data field;

identifying a subset of the plurality of remote databases that each do not include the corresponding remote data value, said identifying comprising, for each of the plurality of remote databases;

accessing a remote database using security protocols and/or communication protocols, over the network;

determining that the corresponding remote data value is not included in the remote data field in the remote database corresponding to the remote data value;

in response to determining that the remote data value is not included in the remote data field, including the remote database in the subset of remote databases;

determining security protocols and/or communication protocols;

applying one or more rules to the subset of the plurality of remote databases to identify one or more remote databases to receive an update; and

using the determined security protocols and/or communication protocols, initiating the update for the remote database to the identified one or more remote databases to receive an update based on the one or more rules.

9. The method of claim 8, wherein said accessing the first remote database comprises:

accessing access information in the one or more storage devices, the access information indicating one or more communication parameters for accessing the first remote database.

10. The method of claim 9, wherein the one or more communication parameters comprise APIs, security protocols and/or communication protocols used to communicate to the first remote database over the network.

11. The method of claim 8, further comprising:

receiving from the user a selection of a master profile of a plurality of master profiles; and

updating the master data values based on data values of the selected mater profile.

12. The method of claim 8, further comprising:

tracking a status of updates for each remote databases in the subset of remote databases.

13. The method of claim 8, wherein initiating an update comprises sending a link, for the one or more remote databases, to the user to redirect the user to a website to update the remote database.

14. A non-transitory computer-readable medium storing instructions configured to cause one or more computer processors to perform operations comprising:

accessing, over a network, user information stored in the one or more storage devices, the user information including master data values associated with respective data fields;

accessing a first remote database of a plurality of remote databases over the network;

determining first remote data associated with a user stored in the first remote database;

identifying a particular master data value of the master data values that is not included in one or more remote data fields of the first remote data, wherein identifying the particular master data value includes;

determining the one or more remote data fields of the first remote data associated with the user stored in the first remote database;

comparing the at least one master data value with remote data values of the first remote data in the determined one or more remote data fields;

determining that the determined one or more remote data fields of the first remote data do not include the at least one master data value;

determining that the particular master data value of the at least one master data value is not included in the determined one or more remote data fields of the first remote data;

identifying a subset of the plurality of remote databases that each do not include the particular master data value in a remote data field, wherein identifying the subset of the plurality of remote databases comprises, for each of the plurality of remote databases;

accessing a remote database of the plurality of remote databases using security protocols and/or communication protocols over the network;

identifying one or more remote data fields of the remote database;

determining that the identified one or more remote data fields does not include the particular master data value; and

in response to determining that the identified one or more remote data fields does not include the particular master data value, adding the remote database to the subset of remote databases; and

for one or more of the remote databases;

determining security protocols and/or communication protocols;

identifying one or more remote databases that are accessible to be updated; and

using the determined security protocols and/or communication protocols, initiating an update for the one or more remote databases that are accessible to be updated.

15. The non-transitory computer-readable medium of claim 14, wherein said accessing the first remote database comprises:

accessing access information in the one or more storage devices, the access information indicating one or more communication parameters for accessing the first remote database.

16. The non-transitory computer-readable medium of claim 15, wherein the one or more communication parameters comprise APIs, security protocols and/or communication protocols used to communicate to the first remote database over the network.

17. The non-transitory computer-readable medium of claim 14, wherein initiating an update for the one or more remote databases comprises pushing the update to at least one of the one or more remote databases.

18. The non-transitory computer-readable medium of claim 14, wherein accessing a first remote database comprises pulling the first remote data from the first remote databases.

19. The non-transitory computer-readable medium of claim 14, further comprising:

receiving from the user a selection of a master profile of a plurality of master profiles; and

updating the master data values based on data values of the selected mater profile.

20. The non-transitory computer-readable medium of claim 14, further comprising:

tracking a status of updates for each remote databases in the subset of remote databases.