公开(公告)号：US11665247B2

公开(公告)日：2023-05-30

申请号：US17715934

申请日：2022-04-07

Applicant: STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY

Inventor： Richard Simon ,  Richard Berglund ,  Erik Donahue ,  Joseph W. Norton ,  Vladyslava Matviyenko ,  Jeremy Lee Rambo ,  John M. VanAntwerp ,  Dan Kalmes ,  Burton J. Floyd ,  Thad Garrett Craft ,  Marc Anderson ,  Nick U. Christopulos ,  Patrick Mead

IPC: G06F15/16 ,  H04L67/51 ,  G06F16/9535

CPC classification number: H04L67/51 ,  G06F16/9535

Abstract: A computer-implemented method for retrieving information from information services and providing it to a public application programming interface (API) includes receiving a first request data message using a core discovery agent, the request data message including at least one requested datum, for which a value is sought, and at least one known datum, for which a value is known; calling a resource locator to request a location of an information service that provides a value for the requested datum; calling a resource façade to contact the information service; transmitting a first information service message including the requested datum and known datum from the resource façade to the information service; receiving a second information service message from the information service including a value for the requested datum; and transmitting a resolved data message including the requested datum and its value from the core discovery agent to the public API.

公开(公告)号：US11169997B1

公开(公告)日：2021-11-09

申请号：US14816327

申请日：2015-08-03

Applicant: STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY

Inventor： Gregory James Debo ,  Richard J. Simon ,  Larry Koenen ,  Adam Jelinek ,  Vaidya Balasubramanian Pillai ,  Richard Berglund ,  Jerry Burger

IPC: G06F16/2455 ,  G06F16/2453

Abstract: Methods, systems, apparatus, and non-transitory media are described for governing resources used to execute and retrieve database entries in accordance with an ad-hoc structured query language (SQL) script. Various aspects are described to determine whether a written SQL script is optimized, to execute the SQL script if it is optimized, and to otherwise reject unoptimized SQL scripts. The resources used during the execution of the SQL script may further be monitored to control resource use, and the execution of SQL scripts may be ceased if a processor-based resource limit threshold is exceeded. The SQL script execution system may be implemented in a wide variety of systems, such as database servers. The scripts may be executed in conjunction with scrubbing and encryption scripts to protect sensitive data, and thus the SQL scripts may be received via one or more public APIs.

公开(公告)号：US10979515B1

公开(公告)日：2021-04-13

申请号：US16703662

申请日：2019-12-04

Applicant: State Farm Mutual Automobile Insurance Company

Inventor： Richard Simon ,  Jeremy Lee Rambo ,  John M. VanAntwerp ,  Dan Kalmes ,  Burton J. Floyd ,  Thad Garrett Craft ,  Marc Anderson ,  Nick U. Christopulos ,  Patrick Mead ,  Richard Berglund ,  Erik Donahue ,  Joseph W. Norton ,  Vladyslava Matviyenko

IPC: H04L29/08 ,  G06F16/9535

Abstract: A computer-implemented method for retrieving information from information services and providing it to a public application programming interface (API) includes receiving a first request data message using a core discovery agent, the request data message including at least one requested datum, for which a value is sought, and at least one known datum, for which a value is known; calling a resource locator to request a location of an information service that provides a value for the requested datum; calling a resource façade to contact the information service; transmitting a first information service message including the requested datum and known datum from the resource façade to the information service; receiving a second information service message from the information service including a value for the requested datum; and transmitting a resolved data message including the requested datum and its value from the core discovery agent to the public API.

公开(公告)号：US20220303355A1

公开(公告)日：2022-09-22

申请号：US17715934

申请日：2022-04-07

Applicant: STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY

Inventor： Richard Simon ,  Jeremy Lee Rambo ,  John M. VanAntwerp ,  Dan Kalmes ,  Burton J. Floyd ,  Thad Garrett Craft ,  Marc Anderson ,  Nick U. Christopulos ,  Patrick Mead ,  Richard Berglund ,  Erik Donahue ,  Joseph W. Norton ,  Vladyslava Matviyenko

IPC: H04L67/51 ,  G06F16/9535

Abstract: A computer-implemented method for retrieving information from information services and providing it to a public application programming interface (API) includes receiving a first request data message using a core discovery agent, the request data message including at least one requested datum, for which a value is sought, and at least one known datum, for which a value is known; calling a resource locator to request a location of an information service that provides a value for the requested datum; calling a resource façade to contact the information service; transmitting a first information service message including the requested datum and known datum from the resource façade to the information service; receiving a second information service message from the information service including a value for the requested datum; and transmitting a resolved data message including the requested datum and its value from the core discovery agent to the public API.

公开(公告)号：US10536536B1

公开(公告)日：2020-01-14

申请号：US15808575

申请日：2017-11-09

Applicant: STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY

Inventor： Richard Simon ,  Jeremy Lee Rambo ,  John M. VanAntwerp ,  Dan Kalmes ,  Burton J. Floyd ,  Thad Garrett Craft ,  Marc Anderson ,  Nick U. Christopulos ,  Patrick Mead ,  Richard Berglund ,  Erik Donahue ,  Joseph W. Norton ,  Vladyslava Matviyenko

IPC: H04L29/08 ,  G06F16/9535

Abstract: A computer-implemented method for retrieving information from information services and providing it to a public application programming interface (API) includes receiving a first request data message using a core discovery agent, the request data message including at least one requested datum, for which a value is sought, and at least one known datum, for which a value is known; calling a resource locator to request a location of an information service that provides a value for the requested datum; calling a resource façade to contact the information service; transmitting a first information service message including the requested datum and known datum from the resource façade to the information service; receiving a second information service message from the information service including a value for the requested datum; and transmitting a resolved data message including the requested datum and its value from the core discovery agent to the public API.