Dynamic generation of database queries in query builders
AssigneeOracle International Corporation
InventorDeepak Goel
Life of this patent
Estimating the term…
Loading patent…
AssigneeOracle International Corporation
InventorDeepak Goel
Estimating the term…
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.
A method of generating database queries directed to a database server, said database server storing data elements organized according to attributes, said method comprising:
A non-transitory machine readable medium storing one or more sequences of instructions for causing a system to generate database queries directed to a database server, said database server storing data elements organized according to attributes, wherein execution of said one or more instructions by one or more processors contained in said system causes said system to perform the actions of:
The machine readable medium of claim 8, wherein said database server is implemented according to a relational database technology, wherein said first database query is formed according to SQL (structured query language) as an SQL query.
A digital processing system comprising:
Dependencies are inferred from the claim text.