REUSABLE DATA QUERY LANGUAGE STATEMENTS
First Claim
Patent Images
1. A method, comprising:
- receiving a parameter type and a parameter variable for a data query language statement;
iterating the processing associated with receiving zero or more additional times for additional parameter types and additional parameter variables for the data query language statement or for additional data query language statements; and
creating a rule that represents the parameter type, the parameter variable, the data query language statement, and any additional parameter types, any additional parameter variables, and any additional data query language statements.
2 Assignments
0 Petitions
Accused Products
Abstract
Techniques are presented for reusable data query language statements. User-defined parameter variables with parameter types are interspersed in data query language statements to form a rule. The rule may execute as a standalone application or as part of another application or service. When the rule is executed, parameter values for the parameter variables are dynamically acquired and populated into the data query language statements.
-
Citations
20 Claims
-
1. A method, comprising:
-
receiving a parameter type and a parameter variable for a data query language statement; iterating the processing associated with receiving zero or more additional times for additional parameter types and additional parameter variables for the data query language statement or for additional data query language statements; and creating a rule that represents the parameter type, the parameter variable, the data query language statement, and any additional parameter types, any additional parameter variables, and any additional data query language statements. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method, comprising:
-
providing a graphical user interface (GUI) tool for defining user-defined parameter variables to intersperse in one or more SQL statements; interacting with a user via the GUI tool to define a rule that includes the one or more SQL statements with the interspersed user-defined parameter variables; and storing the rule for subsequent use. - View Dependent Claims (9, 10, 11, 12, 13)
-
-
14. A system comprising:
-
a graphical user interface (GUI) tool; and an rule generator service, where the GUI tool is to interact with a user to receive SQL parameter variables, parameter types associated with the parameter variables, and SQL statements having references to the parameter variables interspersed therein, and wherein the rule generator service is to generate a rule representing modified SQL statements having the interspersed references. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification