Dynamic network database integration system

• US 10,642,804 B2
• Filed: 06/28/2018
• Issued: 05/05/2020
• Est. Priority Date: 06/28/2018
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Bagga, Charanjit S., Shetty, Pawan Kumar, Mohammed, Abdul Rahim F., Alksnin, Igor, Velayudhasamy, Karthikeyan Bimmanaar, Ngou, Matthew David, Mansabdar, Nagesh, Chowdarapu, Muralidhar
• Primary Examiner(s): Torgrimson, Tyler J
• Application Number:
  US16/022,497
• Publication Number:
  US 20200004847A1
• Time in Patent Office: 677 Days
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• 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/951 Indexing; Web crawling techniques
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
• CPC Class Codes: H04L 67/567 Integrating service provisioning from a plurality of service providers

Abstract

Embodiments of the present invention relate to apparatuses, systems, methods and computer program products for dynamic network database integration. Specifically, the system typically provides dynamic correlation, transformation and combination of data stored at a plurality of database locations. In some aspects, the system receives a retrieval request for retrieving one or more records. The system then typically retrieves, transforms and dynamically integrates unstructured data stored at disparate database locations to construct one or more structured records. The system may also construct the one or more structured records such that the one or more structured records are compatible with the user interface of the user device application API. The system may also be configured to facilitate dynamic modification of the retrieval request, in run-time, using custom HTTP headers.

Claims

1. A computerized system for dynamic network database integration, wherein the computerized system is configured for dynamic correlation, transformation and combination of data stored at a plurality of database locations, comprising:

a memory device with computer-readable program code stored thereon;

a communication device, wherein the communication device is configured to establish operative communication with a plurality of networked devices via a communication network;

a processing device operatively coupled to the memory device and the communication device, wherein the processing device is configured to execute the computer-readable program code to;

receive, from a user device, a retrieval request for retrieving one or more records, wherein receiving the retrieval request comprises;

receiving a plurality of data elements to be integrated for each of the one or more records; and

receiving a data element transformation structure for integrating the plurality of data elements;

determine that (i) first unstructured data associated with a first data element of the plurality of data elements is stored at a first database location associated with a first application programming interface (API) and (ii) second unstructured data associated with a second data element of the plurality of data elements is stored at a second database location associated with a second API;

construct a data schema structured for retrieving the first unstructured data stored at the first database location and the second unstructured data stored at the second database location;

retrieve the first unstructured data from the first database location and the second unstructured data from the second database location based on executing the data schema;

determine a user API format of a user device application API of the user device, wherein the user device application API is configured to present a user interface on the user device, wherein the first unstructured data and the second unstructured data are not compatible with the user interface of the user device application API;

construct one or more structured records associated with the retrieval request, wherein the one or more structured records comprise the plurality of data elements, wherein constructing the one or more structured records comprises transforming the first unstructured data and the second unstructured data into structured data such that at least (i) the one or more structured records comprise the data element transformation structure and (ii) the one or more structured records are associated with the user API format such that the one or more structured records are compatible with the user interface of the user device application API; and

initiate, via the user device, a presentation of the one or more structured records on the user interface of the user device application API.

2. The system of claim 1, wherein the processing device is further configured to execute the computer-readable program code to:

receive, from the user device, a modification request at a time following the retrieval request and following the construction of the data schema, wherein the modification request comprises a modification to at least one of the plurality of data elements and the data element transformation structure of the retrieval request; and

in response to the modification request, construct a custom Hypertext Transfer Protocol (HTTP) header structured for dynamically abstracting the presentation of the one or more structured records on the user interface based on the modification request, wherein the custom HTTP header is structured for;

preventing the presentation of the one or more structured records on the user interface; and

initiating a presentation of dynamically modified structured records, wherein the dynamically modified structured records comprise the one or more structured records modified based on the modification request.

3. The system of claim 2, wherein, in response to the modification request, the processing device is further configured to execute the computer-readable program code to:

identify that the one or more structured records are being currently presented on the user interface; and

wherein preventing the presentation of the one or more structured records on the user interface further comprises blocking functionality of the presentation of the one or more structured records on the user interface; and

wherein initiating the presentation of the dynamically modified structured records comprises overlaying the presentation of the dynamically modified structured records on the user interface over the presentation of the one or more structured records having blocked functionality.

4. The system of claim 2, wherein, in response to the modification request, the processing device is further configured to execute the computer-readable program code to:

identify that the one or more structured records are being currently presented on the user interface;

wherein, preventing the presentation of the one or more structured records on the user interface further comprises revoking the presentation of the one or more structured records on the user interface.

5. The system of claim 2, wherein the processing device is further configured to execute the computer-readable program code to:

store the constructed one or more structured records associated with the retrieval request in a first temporary memory location; and

in response to the modification request, dynamically modify at run time, via the custom HTTP header, the one or more structured records stored at the first temporary memory location based on the modification request, without constructing a modified data schema.

6. The system of claim 1, wherein the processing device is further configured to execute the computer-readable program code to:

determine a logical relationship between the first data element and the second data element based on analyzing the first data element and the second data element, wherein the logical relationship comprises a parent object comprising the first data element and a child object comprising the second data element; and

wherein constructing the one or more structured records associated with the retrieval request comprises;

constructing a logical data model based on the determined logical relationship; and

transforming the first unstructured data and the second unstructured data based on the logical model.

7. The system of claim 6, wherein initiating the presentation of the one or more structured records on the user interface further comprises:

presenting, for each record of the one or more structured records, an abstracted view comprising a selectable graphical element associated with the first data element, wherein the selectable graphical element is structured such that selection of the selectable graphical element at the user device is configured to trigger the presentation of the second data element.

8. The system of claim 1, wherein the first API is a Microservices API associated with the first data element, wherein the processing device is further configured to execute the computer-readable program code to:

determine that storage address of the first unstructured data has changed from the first database location to a third database location; and

update the first API such that the third database location is a source for the first API, wherein the data schema is structured for retrieving the first unstructured data stored at the third database location without modifying the data schema.

9. The system of claim 1, wherein the user API format comprises a data serialization format.

10. The system of claim 1, wherein the processing device is further configured to execute the computer-readable program code to:

receive a connection request for establishing an operative communication channel with the user device;

identify a Gateway Proxy associated with the connection request;

determine whether a Client Certificate associated with the Gateway Proxy is verified by mutual authentication; and

based on determining that the Client Certificate associated with the Gateway Proxy is verified by mutual authentication;

establish a secure operative communication channel with the user device;

receive the retrieval request for retrieving the one or more records from the user device via the secure operative communication channel; and

authorize the retrieval request for retrieving the one or more records.

11. The system of claim 1, wherein the first API is structured for retrieving a global number of data elements stored at the first database location, wherein the global number of data elements comprises the first data element associated with the retrieval request, and a third data element not associated with the retrieval request.

12. The system of claim 1, wherein the user API format of the user device application is associated with XML attributes format, wherein transforming the first unstructured data and the second unstructured data such that the one or more structured records are associated with the user API format further comprises:

transforming the first unstructured data and the second unstructured data into XML element format; and

transforming the first unstructured data and the second unstructured data in the XML element format into an XML attribute format.

13. A computer program product for dynamic network database integration, wherein the computer program product is configured for dynamic correlation, transformation and combination of data stored at a plurality of database locations, the computer program product comprising a non-transitory computer-readable storage medium having computer-executable instructions for causing a computer processor to:

receive, from a user device, a retrieval request for retrieving one or more records, wherein receiving the retrieval request comprises;

receiving a plurality of data elements to be integrated for each of the one or more records; and

receiving a data element transformation structure for integrating the plurality of data elements;

determine that (i) first unstructured data associated with a first data element of the plurality of data elements is stored at a first database location associated with a first application programming interface (API) and (ii) second unstructured data associated with a second data element of the plurality of data elements is stored at a second database location associated with a second API;

construct a data schema structured for retrieving the first unstructured data stored at the first database location and the second unstructured data stored at the second database location;

retrieve the first unstructured data from the first database location and the second unstructured data from the second database location based on executing the data schema;

determine a user API format of a user device application API of the user device, wherein the user device application API is configured to present a user interface on the user device, wherein the first unstructured data and the second unstructured data are not compatible with the user interface of the user device application API;

construct one or more structured records associated with the retrieval request, wherein the one or more structured records comprise the plurality of data elements, wherein constructing the one or more structured records comprises transforming the first unstructured data and the second unstructured data into structured data such that at least (i) the one or more structured records comprise the data element transformation structure and (ii) the one or more structured records are associated with the user API format such that the one or more structured records are compatible with the user interface of the user device application API; and

initiate, via the user device, a presentation of the one or more structured records on the user interface of the user device application API.

14. The computer program product of claim 13, wherein the non-transitory computer-readable storage medium further comprises computer-executable instructions for causing the computer processor to:

receive, from the user device, a modification request at a time following the retrieval request and following the construction of the data schema, wherein the modification request comprises a modification to at least one of the plurality of data elements and the data element transformation structure of the retrieval request; and

in response to the modification request, construct a custom Hypertext Transfer Protocol (HTTP) header structured for dynamically abstracting the presentation of the one or more structured records on the user interface based on the modification request, wherein the custom HTTP header is structured for;

preventing the presentation of the one or more structured records on the user interface; and

initiating a presentation of dynamically modified structured records, wherein the dynamically modified structured records comprise the one or more structured records modified based on the modification request.

15. The computer program product of claim 13, the non-transitory computer-readable storage medium further comprises computer-executable instructions for causing the computer processor to:

determine a logical relationship between the first data element and the second data element based on analyzing the first data element and the second data element, wherein the logical relationship comprises a parent object comprising the first data element and a child object comprising the second data element; and

wherein constructing the one or more structured records associated with the retrieval request comprises;

constructing a logical data model based on the determined logical relationship; and

transforming the first unstructured data and the second unstructured data based on the logical model.

16. The computer program product of claim 13, the non-transitory computer-readable storage medium further comprises computer-executable instructions for causing the computer processor to:

receive a connection request for establishing an operative communication channel with the user device;

identify a Gateway Proxy associated with the connection request;

determine whether a Client Certificate associated with the Gateway Proxy is verified by mutual authentication; and

based on determining that the Client Certificate associated with the Gateway Proxy is verified by mutual authentication;

establish a secure operative communication channel with the user device;

receive the retrieval request for retrieving the one or more records from the user device via the secure operative communication channel; and

authorize the retrieval request for retrieving the one or more records.

17. A method for dynamic network database integration, wherein the method is configured for dynamic correlation, transformation and combination of data stored at a plurality of database locations, the method comprising:

receiving, from a user device, a retrieval request for retrieving one or more records, wherein receiving the retrieval request comprises;

receiving a plurality of data elements to be integrated for each of the one or more records; and

receiving a data element transformation structure for integrating the plurality of data elements;

determining that (i) first unstructured data associated with a first data element of the plurality of data elements is stored at a first database location associated with a first application programming interface (API) and (ii) second unstructured data associated with a second data element of the plurality of data elements is stored at a second database location associated with a second API;

constructing a data schema structured for retrieving the first unstructured data stored at the first database location and the second unstructured data stored at the second database location;

retrieving the first unstructured data from the first database location and the second unstructured data from the second database location based on executing the data schema;

determining a user API format of a user device application API of the user device, wherein the user device application API is configured to present a user interface on the user device, wherein the first unstructured data and the second unstructured data are not compatible with the user interface of the user device application API;

constructing one or more structured records associated with the retrieval request, wherein the one or more structured records comprise the plurality of data elements, wherein constructing the one or more structured records comprises transforming the first unstructured data and the second unstructured data into structured data such that at least (i) the one or more structured records comprise the data element transformation structure and (ii) the one or more structured records are associated with the user API format such that the one or more structured records are compatible with the user interface of the user device application API; and

initiating, via the user device, a presentation of the one or more structured records on the user interface of the user device application API.

18. The method of claim 17, wherein the method further comprises:

receiving, from the user device, a modification request at a time following the retrieval request and following the construction of the data schema, wherein the modification request comprises a modification to at least one of the plurality of data elements and the data element transformation structure of the retrieval request; and

in response to the modification request, constructing a custom Hypertext Transfer Protocol (HTTP) header structured for dynamically abstracting the presentation of the one or more structured records on the user interface based on the modification request, wherein the custom HTTP header is structured for;

preventing the presentation of the one or more structured records on the user interface; and

initiating a presentation of dynamically modified structured records, wherein the dynamically modified structured records comprise the one or more structured records modified based on the modification request.

19. The method of claim 17, wherein the method further comprises:

determining a logical relationship between the first data element and the second data element based on analyzing the first data element and the second data element, wherein the logical relationship comprises a parent object comprising the first data element and a child object comprising the second data element; and

wherein constructing the one or more structured records associated with the retrieval request comprises;

constructing a logical data model based on the determined logical relationship; and

transforming the first unstructured data and the second unstructured data based on the logical model.

20. The method of claim 17, wherein the method further comprises:

receiving a connection request for establishing an operative communication channel with the user device;

identifying a Gateway Proxy associated with the connection request;

determining whether a Client Certificate associated with the Gateway Proxy is verified by mutual authentication; and

based on determining that the Client Certificate associated with the Gateway Proxy is verified by mutual authentication;

establishing a secure operative communication channel with the user device;

receiving the retrieval request for retrieving the one or more records from the user device via the secure operative communication channel; and

authorizing the retrieval request for retrieving the one or more records.