Patent ID: 7562093

Claim:
A method for creating a stored query for remotely accessing information comprising: receiving, at said computer, a selection of a query type, wherein said query type corresponds to a query template; receiving, at said computer, a query field and query criteria, wherein said query criteria is selected from an input list having a profile and stored at said computer; creating, at said computer, said query field, said query criteria, and said query type into a Structured Query Language (SQL) statement; executing, by said computer, said SQL statement to add said query field and said query criteria to said query template; creating, by said computer, said stored query based on said query template, wherein said stored query is stored in a query database; executing, by said computer, said stored query to create a first file; categorizing, at said computer, said first file such that it is available to a pre-determined group of users; placing, by said computer, said first file in a location accessible to said pre-determined group of users, communicating, by said computer, with an intermediary device, wherein said intermediary device: remotely obtains access data including location information and authentication credentials, wherein said access data is used to locate and at least one of: grant and deny access to said secure system, using a device of one of said pre-determined group of users; transmits said access data to said secure system; receives a validation of said access data from said secure system; and, allows said access to said secure system; and performing, by said computer, an analysis of said query database, wherein said analysis is based on performance data resulting from execution of said stored query on a 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.