Query abstraction high level parameters for reuse and trend analysis
AssigneeInternational Business Machines Corporation
InventorsRichard D. Dettinger, Richard J. Stevens
Life of this patent
Estimating the term…
Abstract
The present invention is generally directed to a method, article of manufacture, and system for generating and executing queries with high level parameter markers having one or more associated query conditions. In contrast to conventional parameter markers that are limited to association with simple values of a query condition, high level parameter markers may be associated with a set of entire query conditions.
Claims23
A method for accessing data, comprising:
- building a query with at least one parameter marker embedded therein;
- associating one or more query conditions with the parameter marker;
- and
- programmatically, for each query condition,
- building a complete query by substituting the query condition for the parameter marker,
- executing the complete query against a data source,
- receiving results from executing the complete query, and
- storing the results from executing the complete query.
A computer-readable medium containing a program which, when executed by a processor, performs operations comprising:
- receiving a query with one or more parameter markers embedded therein, wherein a set of query conditions are associated with each parameter marker;
- generating combinations of query conditions, wherein each combination comprises a query condition from each set of query conditions;
- and
- for each combination of query conditions,
- building a complete query by substituting the combination of query conditions for the parameter markers,
- executing the complete query,
- receiving results from executing the complete query, and
- storing the results from executing the complete query.
A database system, comprising:
- a graphical user interface (GUI) configured to receive, from a user, a query including at least one parameter marker and one or more query conditions associated with the parameter marker;
- a query building component configured to build complete queries based on the received query by substituting, for the parameter marker, the one or more query conditions associated with the parameter marker;
- and
- a query executing component configured to execute the complete queries.
Dependencies are inferred from the claim text.