Impact data manager for dynamic data delivery

• US 9,489,397 B1
• Filed: 06/11/2012
• Issued: 11/08/2016
• Est. Priority Date: 07/27/2011
• Status: Active Grant

• Current Assignee: AON Global Operations SE Singapore Branch
• Original Assignee: AON Benfield Global Incorporated (Aon Plc (Spain))
• Inventors: Olson, Douglas A.
• Primary Examiner(s): Gebresenbet, Dinku
• Application Number:
  US13/493,095
• Time in Patent Office: 1,611 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06Q 40/08 Insurance

Abstract

Techniques for dynamic delivery of client-indicated source data to an impact-on-demand or mapping system include a dynamic data delivery module configured to automatically transform the source data into a format that is compatible with the mapping system, validate at least a portion of the source data, and cause the transformed, validated source data to be delivered to the mapping system for storage in a client portfolio. The mapping system may, in real-time, map the client portfolio with impact events to determine risk exposure. The transformation may be based on one or more rules corresponding to the mapping system, and multiple original source data formats may be automatically transformed into the target format. The dynamic data delivery module may automatically correct or adjust source data contents or format to mitigate any anomalies or errors discovered during the transformation and/or validation processes.

Claims

1. A system for delivering source data to a mapping system, comprising:

a dynamic data delivery module comprising instructions stored on a non-transitory computer readable medium;

a link that communicatively connects said dynamic data delivery module and said mapping system, said mapping system configured to receive data from said dynamic data delivery module and to geographically map contents of the received data and impact events to determine risk exposure; and

a data storage entity configured to store, upon one or more non-transitory computer readable media, a set of transformation rules and a set of validation rules, wherein said sets of rules are different,

wherein the instructions of said dynamic data delivery module, when executed by a processor, cause the processor to;

receive, from a user via a graphical user interface, user input defining a first data format, and a plurality of properties corresponding to a plurality of data fields of the first format,

store, via the data storage entity, the properties as at least a portion of the set of validation rules,

import said source data into a database structure, wherein importing comprises transforming the source data from the first format to a second format of the database structure using at least one of said set of transformation rules,

automatically apply at least one of said set of validation rules to identify one or more anomalies within the source data, each anomaly of the one or more anomalies corresponding to a data incompatibility with the second format,

for each anomaly of the one or more anomalies, identify, for user review at said graphical user interface, a source data location and a characteristic of the respective anomaly,

for each anomaly of the one or more anomalies,

upon selection, by the user via the graphical user interface, of the respective anomaly, present, to the user via the graphical user interface, at least one recommended corrective action for repairing the respective anomaly,

provide to the user, through the graphical user interface, a selection control for providing, upon activation, an indication of a selected corrective action of the at least one recommended corrective action, and

responsive to receiving the indication of the selected corrective action, adjust the respective source data location of the source data in accordance with the selected corrective action, and

after adjusting the source data to correct all of the one or more anomalies, cause said validated source data to be delivered, via said link, to said mapping system to be stored in a client portfolio.

2. The system of claim 1, wherein the instructions, when executed by the processor, cause the processor to:

obtain said set of transformation rules and said set of validation rules; and

store said sets of rules in said data storage entity.

3. The system of claim 1, wherein the application of the at least one of said set of validation rules further comprises at least one of:

a numerical value validation, a control total validation or a geographical location validation.

4. The system of claim 3, wherein said geographical location validation is based on at least one of:

an indication of a latitude/longitude pair included in said source data, or an indication of at least a portion of a mailing address included in said source data.

5. The system of claim 1, wherein said processor is included in a first computing device and wherein said mapping system is resident on one or more other computing devices.

6. The system of claim 1, wherein said link includes an Internet connection.

7. The system of claim 1, wherein the instructions, when executed by the processor, cause the processor to encrypt said validated source data prior to causing said validated source data to be delivered to said mapping system.

8. The system of claim 1, wherein the instructions, when executed by the processor, cause the processor to compress said validated source data prior to causing said validated source data to be delivered to said mapping system.

9. The system of claim 1, wherein said source data corresponds to a set of insured properties.

10. A method of delivering source data to a mapping system, comprising:

receiving, from a user via a graphical user interface, user input defining a first data format, and a plurality of properties corresponding to a plurality of data fields of the first format;

receiving, at a computing device via a communications link from said mapping system, one or more portfolio rules and one or more validation rules;

importing, by processing circuitry of the computing device, said source data into a database structure, wherein importing comprises transforming the source data from the first format to a second format of the database structure using at least one of said one or more portfolio rules;

automatically applying, by the processing circuitry, at least one of said one or more validation rules to identify one or more anomalies within the source data, each anomaly of the one or more anomalies corresponding to a data incompatibility with the second format;

for each anomaly of the one or more anomalies, identifying, by the processing circuitry for user review at the graphical user interface, a source data location and a characteristic of the respective anomaly;

for each anomaly of the one or more anomalies,

upon selection, by the user via the graphical user interface, of the respective anomaly, presenting, to the user via the graphical user interface, at least one recommended corrective action for repairing the each identified anomaly,

providing to the user, through the graphical user interface, a selection control for a selection control for providing, upon activation, an indication of a selected corrective action of the at least one recommended corrective action, and

responsive to receiving the indication of the selected corrective action, adjusting, by the processing circuitry, the source data in accordance with the selected corrective action; and

after adjusting the source data to correct all of the one or more anomalies, causing said validated source data to be delivered, via said communications link from said computing device to said mapping system for mapping with one or more impact events for risk exposure analysis.

11. The method of claim 10, wherein applying the at least one of said one or more validation rules further comprises at least one of performing a numerical value validation, performing a control total validation, performing a property validation, or performing a geographical location validation.

12. The method of claim 11, wherein performing said geographical location validation is based on at least one of:

an indication of a latitude/longitude pair included in said source data, or an indication of at least a portion of a mailing address included in said source data.

13. The method of claim 10, further comprising receiving a second user input at said computing device, and wherein importing said source data is based on said second user input.

14. The method of claim 10, wherein causing said validated source data to be delivered via said communications link comprises causing said validated source data to be delivered via the public Internet.

15. The method of claim 10, further comprising at least one of encrypting, by the processing circuitry, said validated source data, and compressing, by the processing circuitry, said validated source data.

16. The method of claim 10, wherein causing said validated source data to be delivered to said mapping system comprises causing said validated source data, including an indication of at least one insured property, to be delivered to said mapping system.

17. A system for delivering source data to a mapping system, comprising:

a dynamic data delivery module stored on a non-transitory computer storage medium, said dynamic data delivery module including;

a first communicative connection to a user interface, and

a second communicative connection to said mapping system, said mapping system being configured to receive data from said dynamic data delivery module and to geographically map contents of said data and impact events to determine risk exposure; and

a processor;

wherein instructions of said dynamic data delivery module, when executed by said processor, cause the processor to;

receive, from a user via the user interface, user input defining a first data format, and a plurality of properties corresponding to a plurality of data fields of the first format,

store, via the data storage entity, the properties as at least a portion of one or more validation rules,

import said source data into a database structure, wherein importing comprises transforming the source data from the first format to a second format of the database structure using at least transform one or more portfolio rules,

automatically apply at least one of the one or more validation rules to identify one or more anomalies within the source data, each anomaly of the one or more anomalies corresponding to a data incompatibility with the second format,

for each anomaly of the one or more anomalies, identify, for user review at the user interface, a source data location and a characteristic of the respective anomaly,

for each anomaly of the one or more anomalies,

upon selection, by the user via the user interface, of the respective anomaly, present, to the user via the user interface, at least one recommended corrective action for repairing the respective anomaly,

provide to the user, through the user interface, a selection control for providing, upon activation, an indication of a selected corrective action of the at least one recommended corrective action, and

responsive to receiving the indication of the selected corrective action, adjust the respective source data location of the source data in accordance with the selected corrective action, and

after adjusting the source data to correct all of the one or more anomalies, cause said validated source data to be delivered, via said second communicative connection, to said mapping system to be stored in a client portfolio.

18. The system of claim 17, wherein said instructions, when executed by the processor, cause the processor to receive, via said second communicative connection, said portfolio and validation rules.

19. The system of claim 17, wherein said application of the at least one of the one or more validation rules further comprises at least one of:

a numerical value validation, a control total validation, a geographical location validation.

20. The system of claim 19, wherein said geographical location validation is based on at least one of:

an indication of a latitude/longitude pair included in said source data, or an indication of at least a portion of a mailing address included in said source data.

21. The system of claim 17, wherein said non-transitory computer storage medium is included in a first computing device, said user interface is communicatively connected to said first computing device, and said mapping system is resident on one or more other computing devices.

22. The system of claim 17, wherein at least one of said first communicative connection or said second communicative connection includes an Internet connection.

23. The system of claim 17, wherein said instructions, when executed by the processor, cause the processor to perform at least one of:

encryption of said validated source data prior to causing said validated source data to be delivered to said mapping system, and compression of said validated source data prior to causing said validated source data to be delivered to said mapping system.

24. The system of claim 17, wherein said source data corresponds to a set of insured properties and respective geographical locations.