The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 09, 2021
Filed:
Aug. 03, 2015
State Farm Mutual Automobile Insurance Company, Bloomington, IL (US);
Gregory James Debo, Normal, IL (US);
Richard J. Simon, Bloomington, IL (US);
Larry Koenen, Bloomington, IL (US);
Adam Jelinek, Bloomington, IL (US);
Vaidya Balasubramanian Pillai, Springfield, IL (US);
Richard Berglund, Bloomington, IL (US);
Jerry Burger, Bloomington, IL (US);
STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY, Bloomington, IL (US);
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.