Accessing a relational database over the Internet using macro language files

• US 5,737,592 A
• Filed: 06/19/1995
• Issued: 04/07/1998
• Est. Priority Date: 06/19/1995
• Status: Expired due to Term

• Current Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Nguyen, Tam Minh, Srinivasan, Venkatachary
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): ROBINSON, GRETA LEE
• Application Number:
  US08/491,742
• Time in Patent Office: 1,023 Days
• Field of Search: 395/611, 395/609, 395/604, 395/610, 395/602, 395/615
• US Class Current: 1/1
• 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
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

The present invention discloses a method and apparatus 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 executing Structured Query Language (SQL) queries in a computer-implemented relational database management system via a network, comprising the steps of:

(a) transmitting a HyperText Markup Language (HTML) input form to a browser executed by a client computer in the network for display on a monitor attached thereto;

(b) receiving a HyperText Transfer Protocol (HTTP) request from the browser to access the relational database, wherein the request includes data entered by the user into the HTML input form;

(c) substituting the data entered by the user into the HTML input form into a dynamic SQL query using a common name space, wherein the common name space comprises variables found in both the dynamic SQL query and the HTML input form;

(d) transmitting the SQL query to a relational database management system for execution;

(e) receiving an output table from the relational database management system in response to the transmitted SQL query;

(f) merging the output table from the relational database management system into an HTML report form; and

(g) transmitting the HTML report form to the browser for display on the monitor attached to the client computer.

2. The method of claim 1 above, wherein the merging step comprises the step of merging the output table from the relational database management system into an HTML report form using a common name space, wherein the common name space comprises variables found in both the output table and the HTML report form.

3. The method of claim 1 above, wherein the HTML input form, dynamic SQL query and HTML report form are stored in a macro language file.

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

5. A method of variable substitution in a macro language file, comprising the steps of:

(a) reading a macro language file containing both Structured Query Language (SQL) and HyperText Markup Language (HTML) statements;

(b) parsing each of the SQL and HTML statements to identify definitions and uses of variables in the SQL and HTML statements; and

(c) substituting values assigned to the variables from the definitions of the variables to the uses of the variables at the time that the SQL and HTML statements are processed.

6. The method of claim 5 above, wherein the substituting step comprises the steps of:

(1) looking up definitions of variables in a variable substitution table when an SQL or HTML statement containing the variable is processed;

(2) if the variable is present in the variable substitution table, then substituting the value from the variable substitution table into the SQL or HTML statements; and

(3) if the variable is not present in the variable substitution table, then leaving the variable name intact in the SQL or HTML statement until a next time that the SQL or HTML is processed by the system.

7. The method is defined is claim 6 above, wherein the substituting step further comprises performing the substitution step recursively.

8. A method of creating a macro language file, comprising the steps of:

(a) creating a macro language file to contain both Structured Query Language (SQL) statements and HyperText Markup Language statements (HTML);

(b) defining one or more variables in the macro language file;

(c) using the defined variables in both the SQL and HTML statements in the macro language file to represent a common name space for both data retrieval and display presentation; and

(d) storing the macro language file containing both the SQL and HTML statements to a data storage device.

9. A method of retrieving data from a relational database, comprising the steps of:

(a) retrieving a macro language file containing both Structured Query Language (SQL) statements and HyperText Markup Language (HTML) statements from a data storage device;

(b) transmitting the SQL statements to a relational database management system, wherein the relational database management system performs the SQL statements to generate an output result table; and

(c) receiving the output result table from the relational database management system; and

(d) mapping the output result table into the HTML statements of the macro language file using a common name space, wherein variable names identified in the HTML statements correspond to variable names identified in the SQL statements.

10. The method of claim 9 above, wherein the common name space comprises predefined variables associated with output table columns.

11. The method of claim 9 above, wherein the common name space comprises variables associated with output table columns.

12. The method of claim 9 above, wherein the common name space comprises output table column names.