System and method for data capture and reporting
First Claim
1. A method for facilitating execution of a query on a database comprising:
- receiving an input list from a user, wherein said input list includes query criteria relating to a field in said database;
storing said input list with a profile corresponding to said user;
receiving a selection of a query type from said user, wherein said query type corresponds to a query template;
receiving a request from said user to retrieve said input list;
providing said user with said input list;
receiving a query field and query criteria from a user, wherein said query criteria is selected from said input list by said user;
creating a Structured Query Language (SQL) statement based on said query field, said query criteria, and said query type;
executing said SQL statement to add said query field and said query criteria to said query template;
saving said query template within a first record of a query database to create a stored query;
receiving a selection of said stored query;
executing said stored query against said database;
saving said stored query in a second record of said query database;
performing an analysis of said query database, wherein said analysis is based on performance data resulting from execution of said stored query on said database, and wherein said analysis determines at least one of;
database fields that are queried least often and database fields that are queried most often.
5 Assignments
0 Petitions
Accused Products
Abstract
A database system includes an intermediary program that provides a variety of functions. Logging on to the intermediary program results in log-in information being transmitted from an encrypted file to the database system via the intermediary program. The database system includes the ability for the user to enter criteria for a query in a variety of different manners, including the ability to directly modify generated SQL statements and the ability to use input lists in creating queries. In addition, the queries entered by the user can be stored in a separate database, such that the efficiency and operation of the database system can be improved. In addition, the delivery of query results and reports allows for delivery of files that are associated with a data period in any format and also allows the user to receive multiple reports in a single, compressed file.
-
Citations
13 Claims
-
1. A method for facilitating execution of a query on a database comprising:
-
receiving an input list from a user, wherein said input list includes query criteria relating to a field in said database; storing said input list with a profile corresponding to said user; receiving a selection of a query type from said user, wherein said query type corresponds to a query template; receiving a request from said user to retrieve said input list; providing said user with said input list; receiving a query field and query criteria from a user, wherein said query criteria is selected from said input list by said user; creating a Structured Query Language (SQL) statement based on said query field, said query criteria, and said query type; executing said SQL statement to add said query field and said query criteria to said query template; saving said query template within a first record of a query database to create a stored query; receiving a selection of said stored query; executing said stored query against said database; saving said stored query in a second record of said query database; performing an analysis of said query database, wherein said analysis is based on performance data resulting from execution of said stored query on said database, and wherein said analysis determines at least one of;
database fields that are queried least often and database fields that are queried most often. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A machine-readable medium having stored thereon a plurality of instructions, said plurality of instructions when executed by a processor, cause said processor to perform a method comprising:
-
receiving an input list from a user, wherein said input list includes query criteria relating to a field in said database; storing said input list with a profile corresponding to said user; receiving a selection of a query type from said user, wherein said query type corresponds to a query template; receiving a request from said user to retrieve said input list; providing said user with said input list; receiving a query field and query criteria from a user, wherein said query criteria is selected from said input list by said user; creating a Structured Query Language (SQL) statement based on said query field, said query criteria, and said query type; executing said SQL statement to add said query field and said query criteria to said query template; saving said query template within a first record of a query database to create a stored query; receiving a selection of said stored query; executing said stored query against said database; saving said stored query in a second record of said query database; performing an analysis of said query database, wherein said analysis is based on performance data resulting from execution of said stored query on said database, and wherein said analysis determines at least one of;
database fields that are queried least often and database fields that are queried most often.
-
Specification