Creating macro language files for executing structured query language (SQL) queries in a relational database via a network

• US 6,105,043 A
• Filed: 12/16/1997
• Issued: 08/15/2000
• Est. Priority Date: 12/16/1997
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Goldberg, Michael Scott, Francisco, Grace
• Primary Examiner(s): Lintz, Paul R.
• Assistant Examiner(s): Colbert, Ella
• Application Number:
  US08/991,323
• Time in Patent Office: 973 Days
• Field of Search: 707/4, 707/104, 707/103, 707/513, 707/2, 395/200.33, 345/326
• US Class Current: 715/234
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing

Abstract

A method, apparatus, and article of manufacture for creating macro language files for executing SQL queries in a relational database management system via the World Wide Web of the Internet. In accordance with the present invention, Web users can request information from RDBMS software via HTML input forms, which request is then used to create an SQL statement for execution by the RDBMS software. The results output by the RDBMS software are themselves transformed into HTML format for presentation to the Web user.

Claims

1. A method for creating macro language files for executing Structured Query Language (SQL) queries in a computer-implemented relational database management system via a network, comprising the steps of:

(a) creating a HyperText Markup Language (HTML) input form to be displayed on a browser executed by a client computer in the network, wherein the HTML input form formats and transmits data entered by the user to a server computer in the network, the data entered by the user is substituted from the HTML input form into a dynamic SQL query using a common name space, the common name space comprising variables found in both the dynamic SQL query and the HTML input form;

(b) creating a HyperText Markup Language (HTML) report form to be displayed by the browser executed by the client computer in the network, wherein the HTML report form formats and transmits data returned by the computer-implemented relational database management system in response to the data entered by the user into the HTML input form and transmitted to the server computer, the data returned by the computer-implemented relational database management system is substituted from the dynamic SQL query into the HTML report form using a common name space, the common name space comprising variables found in both the dynamic SQL query and the HTML report form; and

(c) merging the HTML input form, dynamic SQL query, and HTML report form into the macro language file;

wherein a macro file developer creates the input form and report form via a dialog box having a plurality of inputs including a first input for opening a document to be displayed;

a second input for choosing the input and output display format of the displayed document;

a third input for receiving user information to access the database;

a fourth input for selecting searching and error options; and

a fifth input for directing the storage of the macro file.

2. The method of claim 1 above, wherein the macro language file comprises an SQL command section, an HTML input form section, and an HTML report form section.

3. The method of claim 1 above, further comprising the steps of:

displaying a dialog box on a monitor attached to a computer, wherein the dialog box comprises a step-by-step procedure for creating the macro language file; and

accepting user input into the computer in response to the step-by-step procedure and creating the macro language file using the user input.

4. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify one or more documents used to define the HTML input form, dynamic SQL query, and HTML output form.

5. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify one or more HTML input forms and one or more HTML report forms to associate in the macro language file.

6. The method of claim 5 above, wherein a list of all available HTML input forms and report forms are displayed.

7. The method of claim 5 above, wherein the HTML report form is used as the HTML input form.

8. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify one or more images to use for a background of both the HTML input and report forms.

9. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify a user identifier and password to be used in accessing the computer-implemented relational database management system.

10. The method of claim 9 above, wherein the user identifier and password are common for all users.

11. The method of claim 9 above, wherein the user identifier and password are entered by each user at a prompt.

12. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify a database name to be used by the relational database management system.

13. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify a path for storing the macro language file.

14. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify whether the dynamic SQL query is displayed to the user.

15. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify a type of search to be performed by the dynamic SQL query.

16. The method of claim 15 above, wherein the type of search is specified by the user.

17. The method of claim 15 above, wherein the type of search comprises "ANDed" input fields of the HTML input form.

18. The method of claim 15 above, wherein the type of search comprises "ORed" input fields of the HTML input form.

19. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify a maximum number of rows to display in the HTML report form.

20. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to define error and warning messages for error codes returned by the relational database management system.

21. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specific one or more characteristics of the macro language selected from a group comprising an image path, a subdirectory for storing the macro language file, and an executable name of the macro language file.

22. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify whether the data entered by user is case converted before being transmitted to the server computer.

23. The method of claim 3 above, further comprising the steps of displaying a user interface on the monitor and accepting user input via the displayed user interface to specify a method of transmitting the data entered by the user into the Input form to the server computer.

24. An apparatus for creating macro language files for executing Structured Query Language (SQL) queries in a computer-implemented relational database management system via a network, comprising:

(a) a computer;

(b) one or more computer programs, executed by the computer, for;

(1) creating a HyperText Markup Language (HTML) input form to be displayed on a browser executed by a client computer in the network, wherein the HTML input form formats and transmits data entered by the user to a server computer in the network, the data entered by the user is substituted from the HTML input form into a dynamic SQL query using a common name space, the common name space comprising variables found in both the dynamic SQL query and the HTML input form;

(2) creating a HyperText Markup Language (HTML) report form to be displayed by the browser executed by the client computer in the network, wherein the HTML report form formats and transmits data returned by the computer-implemented relational database management system in response to the data entered by the user into the HTML input form and transmitted to the server computer, the data returned by the computer-implemented relational database management system is substituted from the dynamic SQL query into the HTML report form using a common name space, the common name space comprising variables found in both the dynamic SQL query and the HTML report form; and

(3) merging the HTML input form, dynamic SQL query, and HTML report form into the macro language file;

wherein a macro file developer creates the input form and report form via a dialog box having a plurality of inputs including a first input for opening a document to be displayed;

a second input for choosing the input and output display format of the displayed document;

a third input for receiving user information to access the database;

a fourth input for selecting searching and error options; and

a fifth input for directing the storage of the macro file.

25. An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more computer programs that when executed by the computer causes the computer to perform method steps for creating macro language files for executing Structured Query Language (SQL) queries in a computer-implemented relational database management system via a network, the method comprising the steps of:

(a) creating a HyperText Markup Language (HTML) input form to be displayed on a browser executed by a client computer in the network, wherein the HTML input form formats and transmits data entered by the user to a server computer in the network, the data entered by the user is substituted from the HTML input form into a dynamic SQL query using a common name space, the common name space comprising variables found in both the dynamic SQL query and the HTML input form;

(b) creating a HyperText Markup Language (HTML) report form to be displayed by the browser executed by the client computer in the network, wherein the HTML report form formats and transmits data returned by the computer-implemented relational database management system in response to the data entered by the user into the HTML input form and transmitted to the server computer, the data returned by the computer-implemented relational database management system is substituted from the dynamic SQL query into the HTML report form using a common name space, the common name space comprising variables found in both the dynamic SQL query and the HTML report form; and

(c) merging the HTML input form, dynamic SQL query, and HTML report form into the macro language file;

wherein a macro file developer creates the input form and report form via a dialog box having a plurality of inputs including a first input for opening a document to be displayed;

a second input for choosing the input and output display format of the displayed document;

a third input for receiving user information to access the database;

a fourth input for selecting searching and error options; and

a fifth input for directing the storage of the macro file.