Web-based user interface for searching metadata-driven relational databases
First Claim
1. A computer-implemented method of dynamically building SQL queries for use in a relational database system, the method comprising:
- providing a query builder page to a client system over a network connection, said page including at least one search parameter selection field including a plurality of searchable types, at least one operator selection field and at least one value selection field;
receiving a user selection of a first searchable type in the at least one search parameter selection field from the client system;
receiving a user selection of a first operator in the at least one operator parameter selection field from the client system;
receiving a user selection of a first value in the at least one search value parameter selection field from the client system; and
dynamically building a SQL query based on the user selections in the parameter selection field, operator selection field and value selection field.
1 Assignment
0 Petitions
Accused Products
Abstract
Web-based user interface systems and methods for searching metadata-driven relational databases. Instead of requiring developers to determine the exact type and number of search criteria for each application, the present invention advantageously provides a user-customizable search interface that, in certain aspects, leverages dynamic HTML, JavaScript, and dynamic SQL. A user may choose the exact type and number of search parameters, enabling the user to build a custom report without requiring the user to write any code. The system dynamically builds a SQL search query based on the user identified search parameters. Once a user has built a custom search using the interface, that search may be saved for re-use, and shared with other users.
-
Citations
30 Claims
-
1. A computer-implemented method of dynamically building SQL queries for use in a relational database system, the method comprising:
-
providing a query builder page to a client system over a network connection, said page including at least one search parameter selection field including a plurality of searchable types, at least one operator selection field and at least one value selection field;
receiving a user selection of a first searchable type in the at least one search parameter selection field from the client system;
receiving a user selection of a first operator in the at least one operator parameter selection field from the client system;
receiving a user selection of a first value in the at least one search value parameter selection field from the client system; and
dynamically building a SQL query based on the user selections in the parameter selection field, operator selection field and value selection field. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A database system, comprising:
-
a metadata-driven relational database, including a plurality of metadata lookup tables;
a server module for providing a query building page to a client system over a network connection, wherein the page includes at least one search parameter selection field including a plurality of searchable types, at least one operator selection field and at least one value selection field; and
a SQL engine for automatically generating SQL queries in response to user selections in the selection fields of the query building page. - View Dependent Claims (12, 13, 14, 15)
-
-
16. A computer-readable medium including code for controlling a processor to dynamically generate a SQL query for searching a database, the code including instructions to:
-
provide a query builder page to a client system over a network connection, said page including at least one search parameter selection field including a plurality of searchable types, at least one operator selection field and at least one value selection field;
receive user selected search parameters from the client system, the user selected search parameters including a user selection of a first searchable type in the at least one search parameter selection field, a user selection of a first operator in the at least one operator parameter selection field, and a user selection of a first value in the at least one search value parameter selection field; and
automatically build a SQL query based on the received user selected search parameters. - View Dependent Claims (17, 18, 19, 20, 21, 22, 23)
-
-
24. A computer-implemented method of performing a web-based search on a relational database system, the method comprising:
-
receiving a query builder page from a database server of the relational database system over a network connection, said page including at least one search parameter selection field including a plurality of searchable types, at least one operator selection field and at least one value selection field;
receiving user selected search parameters, the user selected search parameters including a first searchable type in the at least one search parameter selection field from the client system, a first operator in the at least one operator parameter selection field, and a first value in the at least one search value parameter selection field;
transmitting the user selected search parameters to the database server; and
receiving a search response page from the database server responsive to transmission of the user selected search parameters, wherein the database server dynamically builds a SQL query based on the user selected search parameters and executes the SQL query to generate the search response page. - View Dependent Claims (25, 26, 27, 28, 29, 30)
-
Specification