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

• US 10,628,448 B1
• Filed: 06/11/2018
• Issued: 04/21/2020
• 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
• Application Number:
  US16/005,489
• Time in Patent Office: 680 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;

identify a remote data value in a particular data field in the first remote database;

identify a subset of the plurality of remote databases that do not include the corresponding remote data value, wherein to identify the subset comprises, for a second remote database of the plurality of remote databases;

accessing the second 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 second 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 second remote database in the subset of the plurality of remote databases;

for the second remote database that does not include the corresponding remote data value, initiate an update to the second remote database of the subset of the plurality of remote databases to include the corresponding remote data value, wherein to initiate an update comprises;

determine one or more security protocols and/or communication protocols for the second remote database;

determine a first profile of a plurality of profiles for updating the second remote database to include the corresponding remote data value; and

using the determined one or more security protocols and/or communication protocols, transmit the first profile to the second remote database to initiate the update to include the corresponding remote data value in the second remote database.

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 computer processors is further configured to execute the stored electronic software instructions to cause the computing system to automatically:

for a third remote database that does not include the corresponding remote data value, initiate an update to the third remote database of the subset of the plurality of remote databases to include the corresponding remote data value by transmitting a second profile to the third remote database, wherein the first profile is different than the second profile.

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 a 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 master 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 the plurality of remote databases.

7. The computing system of claim 1, wherein to initiate the update for the second remote database comprises sending a link, for the second remote database, to a user to redirect the user to a website to update the second 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;

identifying a remote data value in a particular data field in the first remote database;

identifying a subset of the plurality of remote databases that do not include the corresponding remote data value, wherein to identify the subset comprises, for a second remote database of the plurality of remote databases;

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

determining that the corresponding remote data value is included in the remote data field in the second 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 second remote database in the subset of the plurality of remote databases;

for the second remote database that does not include the corresponding remote data value, initiate an update to the second remote database of the subset of the plurality of remote databases to include the corresponding remote data value, wherein to initiate an update comprises;

determining one or more security protocols and/or communication protocols for the second remote database;

determining a first profile of a plurality of profiles for updating the second remote database to include the corresponding remote data value;

and

using the determined one or more security protocols and/or communication protocols, transmit the first profile the second remote database to initiate the update to include the corresponding remote data value in the second remote database.

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 method further comprises:

for a third remote database that does not include the corresponding remote data value, initiating an update to the third remote database of the subset of the plurality of remote databases to include the corresponding remote data value by transmitting a second profile to the third remote database, wherein the first profile is different than the second profile.

11. The method of claim 8, further comprising:

receiving from a 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 master profile.

12. The method of claim 8, further comprising:

tracking a status of updates for each remote databases in the subset of the plurality 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 a 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 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;

identifying a remote data value in a particular data field in the first remote database;

identifying a subset of the plurality of remote databases that do not include the corresponding remote data value, wherein to identify the subset comprises, for a second remote database of the plurality of remote databases;

accessing the second 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 second 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 second remote database in the subset of the plurality of remote databases;

for the second remote database that does not include the corresponding remote data value, initiating an update to the second remote database of the subset of the plurality of remote databases to include the corresponding remote data value, wherein to initiate an update comprises;

determining one or more security protocols and/or communication protocols for the second remote database;

determining a first profile of a plurality of profiles for updating the second remote database to include the corresponding remote data value; and

using the determined one or more security protocols and/or communication protocols, transmitting the first profile to the second remote database to initiate the update to include the corresponding remote data value in the second remote database.

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 operations further comprise, for a third remote database that does not include the corresponding remote data value, initiating an update to the third remote database of the subset of the plurality of remote databases to include the corresponding remote data value by transmitting a second profile to the third remote database, wherein the first profile is different than the second profile.

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 a 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 master 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 the plurality of remote databases.