Automated SQL source code review
AssigneeState Farm Mutual Automobile Insurance Company
InventorsMatthew Anderson, Richard T. Snyder, Daniel George Galvin
Life of this patent
Estimating the term…
Loading patent…
AssigneeState Farm Mutual Automobile Insurance Company
InventorsMatthew Anderson, Richard T. Snyder, Daniel George Galvin
Estimating the term…
A computer-implemented automated review method for structured query language (SQL) source code files seeking to access a data store comprises the steps of calculating an SQL complexity score; setting an issue flag if the SQL complexity score is greater than a threshold; checking the SQL source code for SQL-92 compliance; setting the issue flag if any of the SQL source code files is not SQL-92 compliant; comparing a type of data in the SQL source code files to be input to the data store with a type of a field in the data store set to receive the input data; setting the issue flag if the type of any input data does not match the type of a corresponding data store field; checking the SQL source code for SQL triggers set to activate when selected SQL commands are executed; and setting the issue flag if there are any SQL triggers.
A computer-implemented automated review method for structured query language (SQL) source code files seeking to access a data store, the method comprising the steps of:
Dependencies are inferred from the claim text.