Modifying structured query language statements

摘要

An approach is provided to modifying structured query language (SQL) statements to more efficient forms. In the approach, an SQL statement is received and compared to a number of predefined malformation rules with at least one of the predefined malformation rules includes a syntactical pattern. If the comparison reveals that the received SQL statement includes a malformed expression that would be inefficiently processed by a database engine, the malformed expression is modified to an efficient SQL expression form and the efficient SQL expression form is executed by the database engine.

主权项

1. A method of modifying structured query language (SQL) statements, the method, implemented by an information handling system, comprising: receiving an SQL statement; comparing the received SQL statement to a plurality of predefined malformation rules, wherein at least one of the predefined malformation rules includes a syntactical pattern; determining that the received SQL statement includes a malformed expression, wherein the malformed expression is inefficiently handled by a database engine; and
modifying the malformed expression to an efficient SQL expression form in response to the determination, wherein the modifying comprises: retrieving one or more numerical methods and mathematical principles; and applying the retrieved numerical methods and mathematical principles to the malformed expression to create the efficient SQL expression form.