Evaluating expressions in stored procedures
View Patent ↗A database system includes components for executing stored procedures that include at least one of a conditional expression, assignment expression, and dynamic database query language (e.g., SQL) statement. For each such expression, a predetermined type of code is generated and inserted into the object code corresponding to the stored procedure. When executing the stored procedure object code, the predetermined type of code is evaluated directly without having to generate a separate database query language statement.
1. A database system comprising:
a plurality of nodes;
an evaluator module in a first one of the plurality of nodes;
an access module in a second one of the plurality of nodes, the access module to manage access to a portion of data stored in the database system; and
a controller in the first node adapted to execute a stored procedure object code, the object code containing a first type of code to represent an expression that is one of a conditional expression, an assignment expression, and a dynamic statement, the object code containing a second, different type of code to represent a database query language statement,
the controller adapted to submit the first type of code to the evaluator module to evaluate the expression, and
the controller adapted to submit a command corresponding to the database query language statement to the access module.
2. The database system of claim 1 , wherein the controller comprises a parsing engine.
3. The database system of claim 1 , wherein the first type code comprises machine-level code.
4. The database system of claim 1 , wherein the first type code contains information identifying a type of the expression and a variable and constant used by the expression.