Methods and systems for using script files to obtain, format and disseminate database information

• US 20050222990A1
• Filed: 07/12/2004
• Published: 10/06/2005
• Est. Priority Date: 04/06/2004
• Status: Abandoned Application

• Current Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Original Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Inventors: Milne, Kenneth T.
• Application Number:
  US10/889,656
• Publication Number:
  US 20050222990A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24568 Data stream processing; Continuous queries
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

A computer-implemented method for managing a plurality of data feeds includes the steps of obtaining a script, the script for specifying a query and creating a data feed; executing the query against a database to produce a result set; and formatting the result set in accordance with the script to create the data feed. The script preferably also specifies a manner in which the data feed is to be formatted (such as a flat file, a spreadsheet file, an HTML file, an XML file, or a PDF file) and a transport method (such as electronic mail (e-mail), FTP, or ESItran). Preferably, the script specifies the database name and logon parameters. The query preferably references a procedure that executes SQL commands against the named database. The script can be stored as a text file written in a suitable specification language to provide direction as to obtaining, formatting, and disseminating the desired information. Preferably, the script is stored as a JAVA properties file.

Claims

1. A computer-implemented method for managing a plurality of data feeds, comprising the steps of:

obtaining a script, the script for specifying a query and creating a data feed;

executing the query against a database to produce a result set; and

formatting the result set in accordance with the script to create the data feed.

2. The method of claim 1, wherein the script further specifies a transport method.

3. The method of claim 2, further including the step of sending the data feed according to the specified transport method.

4. The method of claim 1, wherein the script further specifies a database name.

5. The method of claim 4, wherein the query is referenced as a stored procedure that executes SQL commands against the named database.

6. The method of claim 1, wherein the script is stored as a text file.

7. The method of claim 1, wherein the script is a JAVA properties file.

8. The method of claim 4, wherein the data feed is formatted as one of a flat file, an spreadsheet file, an HTML file, an XML file, and a PDF file.

9. The method of claim 2, wherein the transport method is one of electronic mail (e-mail), FTP, and ESItran.

10. The method of claim 1, wherein the format specifies one or more format type options.

17. The system of claim 1, wherein the script is a JAVA properties file.

11. A system for managing a plurality of data feeds, comprising:

a computer-readable memory; and

a processor communicatively coupled to the computer-readable memory, the processor programmed to perform actions comprising;

obtaining a script, the script for specifying a query and creating a data feed;

executing the query against a database to produce a result set; and

formatting the result set in accordance with the script to create the data feed.

12. The system of claim 11, wherein the script further specifies a transport method.

13. The system of claim 12, wherein the processor is further programmed to perform the action of sending the data feed according to the specified transport method.

14. The system of claim 11, wherein the script further specifies a database name.

15. The system of claim 14, wherein the query is referenced as a stored procedure that executes SQL commands against the named database.

16. The system of claim 11, wherein the script is stored as a text file.

18. The system of claim 14, wherein the data feed is formatted as one of a flat file, an spreadsheet file, an HTML file, an XML file, and a PDF file.

19. The system of claim 12, wherein the transport method is one of electronic mail (e-mail), FTP, and ESItran.

20. The system of claim 11, wherein the format specifies one or more format type options.

21. A program storage device readable by a machine, tangibly embodying a program of instructions executable on the machine to perform method steps managing a plurality of data feeds, the method steps comprising:

obtaining a script, the script for specifying a query and creating a data feed;

executing the query against a database to produce a result set; and

formatting the result set in accordance with the script to create the data feed.