Method for creating a stored query

• US 7,562,093 B2
• Filed: 09/26/2007
• Issued: 07/14/2009
• Est. Priority Date: 07/02/2002
• Status: Expired due to Fees

• Current Assignee: Liberty Peak Ventures, LLC (Dominion Harbor Enterprises, LLC)
• Original Assignee: American Express Travel Related Services Company, Inc. (American Express Company)
• Inventors: Gelb, Elizabeth A, Whitney, Eric D
• Primary Examiner(s): Wong, Don
• Assistant Examiner(s): Brown, Sheree N
• Application Number:
  US11/861,913
• Publication Number:
  US 20080027952A1
• Time in Patent Office: 657 Days
• Field of Search: 707/102, 705/34
• US Class Current: 1/1
• CPC Class Codes: G06F 16/13 File access structures, e.g. distributed indices arrangements of input from, or output to, record carriers G06F3/06
• CPC Class Codes: G06F 16/2246 Trees, e.g. B+trees
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/2457 with adaptation to user needs
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 21/31 User authentication
• CPC Class Codes: G06F 21/6245 Protecting personal data, e.g. for financial or medical purposes
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

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.

Claims

1. 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.

2. The method of claim 1, further comprising:

generating a second file;

compressing said first file and said second file;

placing a result of the compressing step into a third file;

categorizing said third file such that it is available to said pre-determined group of users; and

,

placing said third file in a location accessible to said pre-determined group of users.

3. The method of claim 1, wherein said first file is accessible by way of and Internet connection or an inbox within a user interface.

4. The method of claim 1, wherein said predetermined group of users is based on validating authentication credentials of each of said predetermined group of users at said intermediary device.

5. The method of claim 2, wherein at least one of said first file, said second file, and said third file includes a query used to compile data from a defined data period.

6. The method of claim 2, wherein at least one of said first file, said second file, and said third file is platform independent.

7. The method of claim 1, further comprising sending said first file to said pre-determined group of users by way of at least one of email, web page, facsimile, text message, and postal service.

8. The method of claim 1, further comprising receiving formatting instructions for said first file.

9. The method of claim 2, wherein at least one of said first file and said second file comprises a plurality of reports.

10. The method of claim 1, further comprising receiving a request from one of said pre-determined group of users, wherein said request is to at least one of:

access data, modify data, and delete data relating to said first file.

11. The method of claim 1, further comprising receiving a query from one of said pre-determined group of users, wherein said query is executed at said location of said first file.

12. The method of claim 1, further comprising transmitting access data to a device of one of said pre-determined group of users in the form of a file, wherein said device obtains access credentials corresponding to said location of said first file.

13. The method of claim 1, wherein access to said first file is based on a type of device.

14. The method of claim 1, further comprising updating said first file based on generating a second file using data from a data period within said database.

15. The method of claim 1, further comprising generating a plurality of files based on a plurality of data periods within said database, wherein each of said plurality of files maintain corresponding data fields.

16. The method of claim 1, further comprising:

receiving a request to retrieve said input list;

providing said input list;

saving said query template within a first record of a query database;

receiving a selection of said stored query;

executing said stored query against said query database; and

, saving said stored query in a second record of said query database.

17. The method of claim 1, further comprising:

receiving a request to access said location to retrieve said first file;

transmitting said first authentication credentials to an intermediary program on a client computer, wherein said intermediary program;

authenticates said request;

retrieves a connection file based on said authenticating of said first authentication;

retrieves connection data from said connection file;

providing access to a server based on said connection data, wherein said client computer retrieves said first file from said location at said server.

18. A computer-readable memory tangibly embodying a program of instructions executable by a machine, said plurality of instructions comprising:

instructions to receive a selection of a query type, wherein said query type corresponds to a query template;

instructions to receive a query field and query criteria, wherein said query criteria is selected from said an input list having a profile;

instructions to create said query field, said query criteria, and said query type into a Structured Query Language (SQL) statement;

instructions to execute said SQL statement to add said query field and said query criteria to said query template;

instructions to create a stored query based on said query template, wherein said stored query is stored in a query database;

instructions to execute said stored query to create a first file instructions to categorize said first file such that it is available to a pre-determined group of users;

instructions to place said first file in a location accessible to said pre-determined group of users; and

,

instructions to communicate 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

instructions to perform 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.