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 database interface system comprising:
a physical network interface installed on a server coupled to a first data source, the first data source providing information in a non-standard format;
a data storage unit coupled to the server that stores the information received from the first data source via the network interface;
a first application program interface that operates on the information received from the first data source to generate a first data in a standard format and store the first data in the data storage unit;
a modeling engine, the modeling engine including:
a server;
a map/reduce function coupled to the server;
a plurality of templates providing data processing formats to the map/reduce function;
an analytics engine that receives the first data from the data storage unit, processes the received first data according to a selected one of the plurality of templates, and stores full or partial results to the data storage unit;
a user interface module that receives a request for a visual presentation of an aspect of the full or partial results; and
an output module coupled to the data storage unit and the user interface module that presents the requested aspect of the full or partial results via a display.
2. The database interface system of claim 1 , wherein the network interface is further coupled to a second data source, the second data source providing information in another non-standard format; and
a second application program interface that operates on the information received from the second data source to generate a second data in the standard format and store the second data in the data storage unit.
3. The database interface system of claim 2 , wherein the first application program interface includes inbound and outbound communication modules that support upstream and downstream communication with the first data source.
4. The database interface system of claim 1 , wherein the data storage unit is a data lake storing data in a non-hierarchical format.