Query generation
First Claim
1. A method for generating queries, the method comprising:
- receiving, at a computer system, a query;
identifying, by the computer system, a first replaceable token, a second replaceable token, and a third replaceable token in the query, wherein;
the first replaceable token comprises a first alias that designates a first instance of a first parameter;
the second replaceable token comprises a second alias that designates a second instance of the first parameter;
the third replaceable token comprises the first alias that designates a reuse of the first instance of a first parameter in the query;
retrieving, by the computer system, a parameter definition for the parameter from a plurality of parameter definitions, wherein the parameter definition comprises a text prompt that requests an input providing a value for the parameter;
generating, by the computer system, a first graphical user interface (GUI) comprising the text prompt that requests an input providing a value for the parameter;
receiving, by the computer system, and through the first GUI, input representing a first value for the parameter;
replacing, by the computer system, the first replaceable token and the third replaceable token in the query with the first value for the parameter;
generating, by the computer system, a second GUI comprising the text prompt that requests an input providing a value for the parameter;
receiving, by the computer system, and through the first GUI, input representing a second value of the parameter;
replacing, by the computer system, the second replaceable token in the query with the second value for the parameter; and
submitting, by the computer system, the query for evaluation.
1 Assignment
0 Petitions
Accused Products
Abstract
A query generator is operable to generate a query for retrieving data that satisfy a conditional expression from a database, and/or perform an arbitrary calculation on at least part of the retrieved data. The query generator can receive an input query and analyze the query to ascertain whether it contains a replaceable token. If the query contains a replaceable token, the query generator can replace that token with user input specifying a parameter of the conditional expression and/or the arbitrary calculation, thereby generating an output query for retrieving the data that satisfy the conditional expression and/or performing the arbitrary calculation on the retrieved data.
16 Citations
20 Claims
-
1. A method for generating queries, the method comprising:
-
receiving, at a computer system, a query; identifying, by the computer system, a first replaceable token, a second replaceable token, and a third replaceable token in the query, wherein; the first replaceable token comprises a first alias that designates a first instance of a first parameter; the second replaceable token comprises a second alias that designates a second instance of the first parameter; the third replaceable token comprises the first alias that designates a reuse of the first instance of a first parameter in the query; retrieving, by the computer system, a parameter definition for the parameter from a plurality of parameter definitions, wherein the parameter definition comprises a text prompt that requests an input providing a value for the parameter; generating, by the computer system, a first graphical user interface (GUI) comprising the text prompt that requests an input providing a value for the parameter; receiving, by the computer system, and through the first GUI, input representing a first value for the parameter; replacing, by the computer system, the first replaceable token and the third replaceable token in the query with the first value for the parameter; generating, by the computer system, a second GUI comprising the text prompt that requests an input providing a value for the parameter; receiving, by the computer system, and through the first GUI, input representing a second value of the parameter; replacing, by the computer system, the second replaceable token in the query with the second value for the parameter; and submitting, by the computer system, the query for evaluation. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A system comprising:
-
one or more processors; one or more memory devices comprising instructions that, when executed by the one or more processors, cause the one or more processors to perform operations comprising; receiving a query; identifying a first replaceable token, a second replaceable token, and a third replaceable token in the query, wherein; the first replaceable token comprises a first alias that designates a first instance of a first parameter; the second replaceable token comprises a second alias that designates a second instance of the first parameter; the third replaceable token comprises the first alias that designates a reuse of the first instance of a first parameter in the query; retrieving a parameter definition for the parameter from a plurality of parameter definitions, wherein the parameter definition comprises a text prompt that requests an input providing a value for the parameter; generating a first graphical user interface (GUI) comprising the text prompt that requests an input providing a value for the parameter; receiving and through the first GUI, input representing a first value for the parameter; replacing the first replaceable token and the third replaceable token in the query with the first value for the parameter; generating a second GUI comprising the text prompt that requests an input providing a value for the parameter; receiving and through the first GUI, input representing a second value of the parameter; replacing the second replaceable token in the query with the second value for the parameter; and submitting the query for evaluation. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A non-transitory, computer-readable memory device comprising instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:
-
receiving a query; identifying a first replaceable token, a second replaceable token, and a third replaceable token in the query, wherein; the first replaceable token comprises a first alias that designates a first instance of a first parameter; the second replaceable token comprises a second alias that designates a second instance of the first parameter; the third replaceable token comprises the first alias that designates a reuse of the first instance of a first parameter in the query; retrieving a parameter definition for the parameter from a plurality of parameter definitions, wherein the parameter definition comprises a text prompt that requests an input providing a value for the parameter; generating a first graphical user interface (GUI) comprising the text prompt that requests an input providing a value for the parameter; receiving and through the first GUI, input representing a first value for the parameter; replacing the first replaceable token and the third replaceable token in the query with the first value for the parameter; generating a second GUI comprising the text prompt that requests an input providing a value for the parameter; receiving and through the first GUI, input representing a second value of the parameter; replacing the second replaceable token in the query with the second value for the parameter; and submitting the query for evaluation. - View Dependent Claims (18, 19, 20)
-
Specification