Database interface system
A database interface system uses individual application program interfaces to receive, convert, combine, and normalize if necessary, datasets received from disparate sources. The datasets may include quotes from various insurance providers. The categorized and normalized data may be further processed for presentation via a user interface that allows selective display of the full combined datasets or graphically selected subsets of the full datasets.
1. A method of processing partially correlated data from disparate data sources, the method comprising:
communicating, via a processor, a request for first data from a first data source to an Application Programming Interface (API);
receiving, via the processor, a response from the API comprising encrypted first data from the first data source, the encrypted first data in a first non-standard format;
decrypting, via the processor, the encrypted first data;
converting, via a formatting module, the decrypted first data from the first non-standard format to a standard format;
extracting, via the processor, first elements from the decrypted first data in the standard format;
storing, via the processor, the first elements in a data lake in a non-hierarchical format;
analyzing, via the processor, the first elements for differences from second elements in the data lake;
generating, via the processor, display data that includes the differences between the first elements and the second elements;
sending, via the processor, the display data to an application of a customer having a user interface; and
presenting, at the application of the customer, the display data showing the differences and at least one of the first elements and at least one of the second elements.
2. The method of claim 1 , wherein extracting the first elements from the decrypted first data is performed by a map/reduce function.
3. The method of claim 1 , wherein encrypted second data is received in response to a second request.
4. The method of claim 3 , wherein the encrypted second data is received from a second data source.
5. The method of claim 4 , further comprising decrypting, via the processor, the encrypted second data using second keys stored in a second secure element.
6. The method of claim 1 , wherein the first elements and the second elements comprise benefits related data.
7. The method of claim 6 , wherein the benefits related data comprise benefits premium data.
8. The method of claim 1 , further comprising allowing the customer to select a benefits plan based on the display data.
9. The method of claim 8 , wherein the benefits plan is one or more of medical insurance, dental insurance, or vision insurance.
10. The method of claim 1 , wherein the API returns census data and quote parameters provided by the customer.
11. The method of claim 1 , wherein the first elements are decrypted using keys stored in a secure element.
12. A method of providing data to an end user comprising:
communicating, via a processor, a request for first data from a first data source to an Application Programming Interface (API);
receiving, via the processor, a response from the API comprising encrypted first data from the first data source, the encrypted first data in a first non-standard format;
decrypting, via the processor, the encrypted first data;
converting, via a formatting module, the decrypted first data from the first non-standard format to a standard format;
extracting, via the processor, first elements from the decrypted first data in the standard format;
storing, via the processor, the first elements in a data lake in a non-hierarchical format;
analyzing, via the processor, the first elements for differences from second elements in the data lake;
generating, via the processor, display data that includes the differences between the first elements and the second elements;
sending, via the processor, the display data to an application of the end user having a user interface; and
presenting, at the application of the end user, the display data showing the differences and at least one of the first elements and at least one of the second elements.
13. The method of claim 12 , wherein first data is communicated using a private blockchain.
14. The method of claim 12 , wherein the first element and the second element comprise benefits premium data.
15. The method of claim 14 , further comprising allowing the end user to select a benefits plan based on the displayed data.
16. The method of claim 15 , wherein the benefits plan is one or more of medical insurance, dental insurance, or vision insurance.
17. The method of claim 12 , wherein the end user is a customer.
18. The method of claim 12 , wherein the end user is a broker.
19. The method of claim 12 , wherein the API returns census data and quote parameters provided by the end user.
20. The method of claim 12 , wherein the first elements and second elements comprise benefits related data.
21. The method of claim 20 , wherein the display data comprises differences in the benefits related data.