System and method for data capture and reporting
First Claim
1. A method of accessing a secure system comprising:
- receiving log on information on an intermediary system;
validating the log on information by the intermediary system;
obtaining access data, said access data containing information used to locate and access said secure system, from a separate file;
transmitting said access data to the secure system;
validating the access data by the secure system; and
allowing access to the secure system via the intermediary system.
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
9 Claims
-
1. A method of accessing a secure system comprising:
-
receiving log on information on an intermediary system;
validating the log on information by the intermediary system;
obtaining access data, said access data containing information used to locate and access said secure system, from a separate file;
transmitting said access data to the secure system;
validating the access data by the secure system; and
allowing access to the secure system via the intermediary system. - View Dependent Claims (2)
-
-
3. A method of executing a query on a database comprising:
-
entering criteria by a user;
uploading a data file;
combining said data file with said database;
combining data file meta-data with said query criteria to create a query;
generating an SQL statement by a database system based on said query; and
executing the SQL statement. - View Dependent Claims (4, 5)
-
-
6. A method of delivering information comprising:
-
generating a first file using data from a specific data period within a database;
associating said first file with said data period;
categorizing said first file such that it is available to a pre-determined group of users; and
placing said first file in a location accessible to said pre-determined group of users. - View Dependent Claims (7, 8, 9)
-
Specification