Dynamic graphical user interface and query logic SQL generator used for developing Web-based database applications
First Claim
Patent Images
1. A method for dynamically generating database queries, comprising:
- (a) storing query web interface data, including attributes for a database, in one more tables;
(b) retrieving the attributes from the table and displaying the attributes on a graphical user interface web page for user selection;
(c) dynamically generating a SQL query based on the attributes selected by the user; and
(d) displaying results of the SQL query to the user in graphical format, thereby enabling dynamic generation of custom queries.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for dynamically generating database queries is disclosed. The method and system include storing web interface data, including query attributes for a database, in one more tables. The attributes are then retrieved from the tables and displayed in a graphical user interface web page for user selection. Based on the attributes selected by the user, a SQL query is dynamically generated. The method and system further include displaying results of the SQL query to the user in graphical format, thereby enabling dynamic generation of custom queries.
-
Citations
20 Claims
-
1. A method for dynamically generating database queries, comprising:
-
(a) storing query web interface data, including attributes for a database, in one more tables;
(b) retrieving the attributes from the table and displaying the attributes on a graphical user interface web page for user selection;
(c) dynamically generating a SQL query based on the attributes selected by the user; and
(d) displaying results of the SQL query to the user in graphical format, thereby enabling dynamic generation of custom queries. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A dynamic query generator system, comprising
a client computer coupled to a network; -
a server coupled to the network in communication with the client computer; and
a query engine executing on the server, the query engine functioning to, generate and display GUI pages on the client computer for user selection of database attributes, using the inputs provided by the user to automatically generate a SQL query to retrieve data from a database, and display results of the query to the user in graphical format, thereby enabling dynamic generation of custom queries. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification