Query generation
First Claim
1. A query generator operable to generate a query for at least one of retrieving data that satisfy a conditional expression from a database and performing an arbitrary calculation on at least part of the retrieved data, the query generator being adapted to:
- a) receive an input query;
b) analyze the input query to ascertain whether the input query contains a replaceable token; and
c) if the input query contains a replaceable token, replace the replaceable token with at least one of user input specifying a parameter of the conditional expression and the arbitrary calculation, thereby performing at least one of generating an output query for retrieving the data that satisfy the conditional expression and performing the arbitrary calculation on the retrieved data.
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.
-
Citations
27 Claims
-
1. A query generator operable to generate a query for at least one of retrieving data that satisfy a conditional expression from a database and performing an arbitrary calculation on at least part of the retrieved data, the query generator being adapted to:
-
a) receive an input query; b) analyze the input query to ascertain whether the input query contains a replaceable token; and c) if the input query contains a replaceable token, replace the replaceable token with at least one of user input specifying a parameter of the conditional expression and the arbitrary calculation, thereby performing at least one of generating an output query for retrieving the data that satisfy the conditional expression and performing the arbitrary calculation on the retrieved data. - View Dependent Claims (2, 3, 4, 5, 6, 17)
-
-
7. A method for generating a query for at least one of retrieving data that satisfy a conditional expression from a database and performing an arbitrary calculation on at least part of the retrieved data, the method comprising:
-
a) receiving an input query; b) analyzing the input query to ascertain whether the input query contains a replaceable token; and c) if the input query contains a replaceable token, replacing the replaceable with at least one of user input specifying a parameter of the conditional expression and the arbitrary calculation, thereby generating an output query for at least one of retrieving the data that satisfy the conditional expression and performing the arbitrary calculation on the retrieved data. - View Dependent Claims (8, 9, 10, 11, 12, 24, 25)
-
-
13. An information management system comprising:
-
a first data store containing database data; a query generator adapted to retrieve and output a subset of the database data that satisfies at least one conditional expression; a user interface configured to receive input from, and output information to, a user; and a second data store containing one or more persistent parameter definitions, each persistent parameter definition comprising data describing a parameter to be used in the at least one conditional expression; wherein the query generator is further adapted to verify whether the at least one conditional expression references a parameter having a persistent parameter definition, and if it does, obtain user input via the user interface for the parameter based on the persistent parameter definition. - View Dependent Claims (14, 15, 16)
-
-
18. A method for generating a query comprising:
-
a) defining one or more persistent parameter definitions, each persistent parameter definition comprising data describing a parameter to be used in a conditional expression; b) selecting a data source; c) receiving a query with at least one conditional expression, the at least one conditional expression defining a subset of data from the data source; d) verifying whether the at least one conditional expression references a parameter having a persistent parameter definition; e) if it does, obtaining user input for the parameter based on the persistent parameter definition and using said user input in the conditional expression; and f) executing the query and formatting and returning said subset of data. - View Dependent Claims (19, 20, 21, 22, 23, 26, 27)
-
Specification