Systems and methods for non-disruptive complex variable calculation in online environments

• US 10,169,408 B1
• Filed: 04/06/2017
• Issued: 01/01/2019
• Est. Priority Date: 04/06/2017
• Status: Active Grant

• Current Assignee: The Travelers Indemnity Company (The Travelers Cos., Inc.)
• Original Assignee: The Travelers Indemnity Company (The Travelers Cos., Inc.)
• Inventors: Murikipudi, Syam S., Steben, Christine L.
• Primary Examiner(s): Peach, Polina G
• Application Number:
  US15/480,691
• Time in Patent Office: 635 Days
• Field of Search: None
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06Q 30/04 Billing or invoicing

Abstract

Systems, methods, and articles of manufacture provide for non-disruptive complex variable calculations in online environments, such as real time or near-real time transaction processing utilizing non-disruptive variable calculation logic and decision table array inputs.

Claims

1. A system for utilizing user input to drive multi-tiered queries of a memory array to compute a value for a complex variable, comprising:

a data transceiver device communicatively coupled to a first electronic network pathway;

a historic data aggregation device storing data defining values for each of a plurality of variables in correlation with specific historic time periods;

a memory array comprising a plurality of data tables, each data table storing data defining a relationship between a specific value for one of the plurality of variables and a corresponding variable adjustment factor;

a computational server cluster communicatively coupled to a second electronic network pathway, the computational server cluster comprising a plurality of cooperative processing units, and the computational server cluster being in communication with the data transceiver device and each of the historic data aggregation device and the memory array; and

a computational logic data storage device in communication with the computational server cluster, the computational logic data storage device storing (i) data correlating a plurality of versioning input variable values and different logical pathways and (ii) at least one programmatic logic routine defining how the value of the complex variable is computed in accordance with one or more of the different logical pathways, wherein execution of the at least one programmatic logic routine by the computational server cluster, results in;

receiving, by the data transceiver device and from a remote user device via the first electronic network pathway, information defining a value for a versioning input variable;

routing, by the data transceiver device and to the computational server cluster, the information defining the value for the versioning input variable;

comparing, by the computational server cluster, the information defining the value for the versioning input variable with the data stored in the computational logic data storage device that correlates the plurality of versioning input variable values and different logical pathways;

identifying, by the computational server cluster and based on the comparing, a first one of the different logical pathways that correlates to the information defining the value for the versioning input variable;

identifying, by the computational server cluster and by querying the historic data aggregation device in accordance with logic defined by the first one of the different logical pathways, a historic value for the complex variable;

identifying, by the computational server cluster and by querying the historic data aggregation device in accordance with logic defined by the first one of the different logical pathways, (i) a historic value for each one of the plurality of variables, the historic value comprising a value for the respective one of the plurality of variables for a historic time period, and (ii) a current value for each one of the plurality of variables, the current value comprising a value for the respective one of the plurality of variables for a current time period that is different than the historic time period;

computing, by the computational server cluster and by respectively querying each one of the plurality of data tables of the memory array utilizing, respectively, each of the current and historic values for the respective one of the plurality of variables, and in accordance with logic defined by the first one of the different logical pathways, a variable adjustment factor for the complex variable;

computing, by the computational server cluster and by executing the at least one programmatic logic routine defining how the value of the complex variable is computed in accordance with the first one of the different logical pathways, wherein the first one of the different logical pathways defines a formula that modifies the historic value for the complex variable based upon each of the computed variable adjustment factors, a current value for the complex variable;

transmitting, by the computational server cluster and to the data transceiver device, a signal indicative of the computed current value for the complex variable; and

providing, by the data transceiver device and to the remote user device via the first electronic network pathway, the data indicative of the computed current value for the complex variable.

2. The system of claim 1, wherein the computing of each of the variable adjustment factors for the complex variable, further comprises:

computing, for each respective one of the plurality of variables, a difference between the historic value and the current value; and

defining, based on the difference between the historic value and the current value and based on at least one of a minimum and a maximum differential threshold, the respective variable adjustment factor.

3. The system of claim 1, wherein the plurality of variables comprises each of:

(i) a risk variable, (ii) a loss variable, (iii) a billing experience variable, and (iv) a characteristics variable.

4. The system of claim 1, wherein each of the historic time periods comprises a time period spanning a single previous year.

5. The system of claim 1, wherein the value of the versioning input variable indicates one of a request for a new policy or a renewal of a previous policy.

6. The system of claim 1, wherein the computing of the current value for the complex variable, further comprises:

calculating, utilizing the computed current value for the complex variable as input into a policy rating formula, a rated premium value.

7. A system for utilizing user input to drive multi-tiered queries of a memory array to compute a value for a complex variable, comprising:

a data transceiver device communicatively coupled to a first electronic network pathway;

at least one interface generation device in communication with the data transceiver;

a historic data aggregation device storing data defining values for each of a plurality of variables in correlation with specific time periods in the past;

a memory array comprising a plurality of data tables, each data table storing data defining a relationship between a specific value for one of the plurality of variables and a corresponding variable adjustment factor;

a computational server cluster communicatively coupled to a second electronic network pathway, the computational server cluster comprising a plurality of cooperative processing units, and the computational server cluster being in communication with the interface generation device and each of the historic data aggregation device and the memory array; and

a computational logic data storage device in communication with the computational server cluster, the computational logic data storage device storing (i) data correlating a plurality of versioning input variable values and different logical pathways and (ii) at least one programmatic logic routine defining how the value of the complex variable is computed in accordance with one or more of the different logical pathways, wherein execution of the at least one programmatic logic routine by the computational server cluster, results in;

receiving, by the data transceiver device and from a remote user device via the first electronic network pathway, information defining a value for a versioning input variable;

routing, by the data transceiver device and to the at least one interface generation device, the information defining the value for the versioning input variable;

transmitting, by the at least one interface generation device and to the computational server cluster, the information defining the value for the versioning input variable;

comparing, by the computational server cluster, the information defining the value for the versioning input variable with the data stored in the computational logic data storage device that correlates the plurality of versioning input variable values and different logical pathways;

identifying, by the computational server cluster and based on the comparing, a first one of the different logical pathways that correlates to the information defining the value for the versioning input variable;

identifying, by the computational server cluster and by querying the historic data aggregation device in accordance with logic defined by the first one of the different logical pathways, a historic value for the complex variable;

determining, by the computational server cluster and by querying the historic data aggregation device in accordance with logic defined by the first one of the different logical pathways, a plurality of adjustment factors;

computing, by the computational server cluster and by executing the at least one programmatic logic routine defining how the value of the complex variable is computed in accordance with the first one of the different logical pathways, wherein the first one of the different logical pathways defines a formula that modifies the historic value for the complex variable based upon each of the plurality of adjustment factors, a current value for the complex variable;

transmitting, by the computational server cluster and to the at least one interface generation device, a signal indicative of the computed current value for the complex variable;

transmitting, by the at least one interface generation device and to the data transceiver device, data indicative of the computed current value for the complex variable; and

providing, by the data transceiver device and to the remote user device via the first electronic network pathway, the data indicative of the computed current value for the complex variable.

8. The system of claim 7, wherein determining the plurality of adjustment factors comprises:

identifying, by the computational server cluster and by querying a third party data acquisition device in accordance with logic defined by the first one of the different logical pathways, a current value for a first one of the plurality of variables comprising a risk variable;

identifying, by the computational server cluster and by querying the historic data aggregation device in accordance with logic defined by the first one of the different logical pathways, a historic value for the first one of the plurality of variables comprising the risk variable;

computing, by the computational server cluster and by querying a first one of the plurality of data tables of the memory array utilizing each of the current and historic values for the first one of the plurality of variables comprising the risk variable, and in accordance with logic defined by the first one of the different logical pathways, a first adjustment factor for the complex variable;

identifying, by the computational server cluster and by querying the historic data aggregation device in accordance with logic defined by the first one of the different logical pathways, (i) a historic value for a second one of the plurality of variables comprising a loss variable, the historic value comprising a value for the second one of the plurality of variables comprising the loss variable for a historic time period, and (ii) a current value for the second one of the plurality of variables comprising the loss variable, the current value comprising a value for the second one of the plurality of variables comprising the loss variable for a current time period that is different than the historic time period;

computing, by the computational server cluster and by querying a second one of the plurality of data tables of the memory array utilizing each of the current and historic values for the second one of the plurality of variables comprising the loss variable, and in accordance with logic defined by the first one of the different logical pathways, a second adjustment factor for the complex variable;

identifying, by the computational server cluster and by querying the historic data aggregation device in accordance with logic defined by the first one of the different logical pathways, (i) a historic value for a third one of the plurality of variables comprising a billing experience variable, the historic value comprising a value for the third one of the plurality of variables comprising the billing experience variable for a historic time period, and (ii) a current value for the third one of the plurality of variables comprising the billing experience variable, the current value comprising a value for the third one of the plurality of variables comprising the billing experience variable for a current time period that is different than the historic time period;

computing, by the computational server cluster and by querying a third one of the plurality of data tables of the memory array utilizing each of the current and historic values for the third one of the plurality of variables comprising the billing experience variable, and in accordance with logic defined by the first one of the different logical pathways, a third adjustment factor for the complex variable;

identifying, by the computational server cluster and by querying the historic data aggregation device in accordance with logic defined by the first one of the different logical pathways, (i) a historic value for a fourth one of the plurality of variables comprising a characteristics variable, the historic value comprising a value for the fourth one of the plurality of variables comprising the characteristics variable for a historic time period, and (ii) a current value for the fourth one of the plurality of variables comprising the characteristics variable, the current value comprising a value for the fourth one of the plurality of variables comprising the characteristics variable for a current time period that is different than the historic time period; and

computing, by the computational server cluster and by querying a fourth one of the plurality of data tables of the memory array utilizing each of the current and historic values for the fourth one of the plurality of variables comprising the characteristics variable, and in accordance with logic defined by the first one of the different logical pathways, a fourth adjustment factor for the complex variable.

9. The system of claim 7, wherein the interface generation device comprises a web server.

10. The system of claim 7, further comprising:

a mark-up language memory storage device in communication with the at least one interface generation device, the mark-up language memory storage device storing data defining a plurality of interface components; and

an eligibility verification memory storage device in communication with the at least one interface generation device, the eligibility verification memory storage device storing data correlating a plurality of eligibility input variables and different subsets of the plurality of interface components.

11. The system of claim 10, wherein the execution of the at least one programmatic logic routine by the computational server cluster, further results in:

receiving, by the data transceiver device and from the remote user device via the first electronic network pathway, information defining a value for an eligibility input variable;

routing, by the data transceiver device and to the at least one interface generation device, the information defining the value for the eligibility input variable;

identifying, by the at least one interface generation device and by querying the eligibility verification memory storage device utilizing the value for the eligibility input variable, a corresponding first subset of the plurality of interface components;

retrieving, by the at least one interface generation device and by querying the mark-up language memory storage device utilizing information identifying the first subset of the plurality of interface components, corresponding data defining the first subset of the plurality of interface components;

transmitting, by the at least one interface generation device and to the data transceiver device, the data defining the first subset of the plurality of interface components; and

providing, by the data transceiver device and to the remote user device via the first electronic network pathway, the data defining the first subset of the plurality of interface components, wherein implementation of the first subset of the plurality of interface components to generate a graphical user interface on the remote user device causes a presentation, to the user, of a first interactive input mechanism which prompts the user to enter the value for the versioning input variable.

12. The system of claim 11, wherein the information defining the value for the versioning input variable is received via input entered into the first interactive input mechanism.

13. The system of claim 7, wherein each of the historic time periods comprises a time period spanning a single previous year.

14. The system of claim 7, wherein the value of the versioning input variable indicates one of a request for a new policy and a renewal of a previous policy.

15. The system of claim 7, wherein the computing of the current value for the complex variable, further comprises:

calculating, utilizing the computed current value for the complex variable as input into a policy rating formula, a rated premium value.