DYNAMIC GENERATION OF DATABASE QUERIES IN QUERY BUILDERS

摘要

A query builder provided according to an aspect of the present invention facilitates users to conveniently generate database queries directed to database servers storing data elements organized according to attributes. In an embodiment, configuration data indicating a comparison predicate to be used for each combination of an attribute and a conditional operation is maintained. A user may then provide as inputs a first attribute, a first conditional operation and a first value. In response, the query builder examines the configuration data to determine a first comparison predicate specified for the combination of the first attribute and the first conditional operation. The query builder incorporates the first value in the first comparison predicate to construct a second comparison predicate and then forms a first database query with the second comparison predicate.

主权项

1. A method of generating database queries directed to a database server, said database server storing data elements organized according to attributes, said method comprising:
maintaining configuration data indicating a comparison predicate to be used for each combination of an attribute and a conditional operation; receiving from a user a first attribute, a first conditional operation and a first value; examining said configuration data to determine a first comparison predicate specified for the combination of said first attribute and said first conditional operation; incorporating said first value in said first comparison predicate to construct a second comparison predicate; and forming a first database query with said second comparison predicate.