Generating a common gateway interface adaptor customized for a stored procedure

• US 6,067,414 A
• Filed: 12/30/1998
• Issued: 05/23/2000
• Est. Priority Date: 05/31/1996
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Sidik, Judianto, Wu, Rita S., Wang, I-Shin Andy, Yeh, Shu-Huar Joseph
• Primary Examiner(s): Hafiz, Tariq R.
• Assistant Examiner(s): Chaki, Kakali
• Application Number:
  US09/222,005
• Time in Patent Office: 510 Days
• Field of Search: 395/701, 395/702, 395/703, 395/705, 395/708, 395/200.33, 395/200.47, 395/200.48, 395/200.49, 395/200.5, 395/200.51, 395/200.52, 395/200.53 , 395/200.54, 707/100, 707/101, 709/302, 709/304, 709/216-223
• US Class Current: 717/106
• CPC Class Codes: G06F 16/2443 Stored procedures
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 8/00 Arrangements for software engineering testing or debugging G06F11/36; administrative, planning or organisation aspects of software project management G06Q10/06
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A method and apparatus for generating a Common Gateway Interface (CGI) adaptor customized for a stored procedure. In accordance with the present invention, stored procedure application developers can provides their stored procedure to a builder, which creates a CGI adaptor customized for the stored procedure. To generate the CGI adaptor, the builder parses the stored procedure to identify the arguments of the stored procedure. Then, using the stored procedure arguments, the builder generates logic to extract variables from an input data stream, wherein the variables correspond to the arguments of the stored procedure. The builder also generates logic to invoke the stored procedure using the variables extracted from the input data stream. The generated logic comprises the customized CGI adaptor.

Claims

1. A method of generating a Common Gateway Interface (CGI) adaptor customized for a stored procedure to facilitate communication between a client and a server, comprising the steps of:

parsing the stored procedure to identify one or more arguments of the stored procedure, wherein the stored procedure is stored at the server;

generating procedure-specific logic to extract variables from an input form received from the client, wherein the variables correspond to the arguments of the stored procedure; and

generating procedure-specific logic to invoke the stored procedure at the server using the variables extracted from the input data stream from the client.

2. The method of claim 1, further comprising the step of generating logic to extract information from the input data stream that does not correspond to the arguments and to create a universal data structure from the information.

3. The method of claim 1, wherein the logic generating step comprises the step of generating a call to a CGI run-time library.

4. The method of claim 1, wherein the generating step comprises the step of generating logic to extract the variables from a command line.

5. The method of claim 1, wherein the generating step comprises the step of generating logic to call the stored procedure.

6. The method of claim 1, wherein the stored procedure comprises source language statements, and wherein the parsing step comprises the step of reading the source language statements of the stored procedure.

7. A Common Gateway Interface (CGI) adaptor generating apparatus for facilitating communication between a client and a server, comprising:

a computer; and

one or more computer programs, performed by the computer, for parsing the stored procedure to identify one or more arguments of the stored procedure, wherein the stored procedure is stored at the server for generating procedure-specific logic to extract variables from an input form received from the client, wherein the variables correspond to the arguments of the stored procedure, and for generating procedure-specific logic to invoke the stored procedure at the server using the variables extracted from the input data stream from the client.

8. The apparatus of claim 7, further comprising one or more computer programs, performed by the computer, for generating logic to extract information from the input data stream that does not correspond to the arguments and to create a universal data structure from the information.

9. The apparatus of claim 7, wherein the apparatus further comprises one or more computer programs, performed by the computer, for generating a call to a CGI run-time library.

10. The apparatus of claim 7, wherein the apparatus further comprises one or more computer programs, performed by the computer, for generating logic to extract the variables from a command line.

11. The apparatus of claim 7, wherein the apparatus further comprises one or more computer programs, performed by the computer, for generating logic to call the stored procedure.

12. The apparatus of claim 7, wherein the stored procedure comprises source language statements, and wherein the parsing means comprises means for reading the source language statements of the stored procedure.

13. An article of manufacture for use in generating a Common Gateway Interface (CGI) adaptor to facilitate communication between a client and a server, the article of manufacture comprising a computer-readable storage medium having a computer program embodied therein that causes the computer to perform the steps of:

parsing the stored procedure to identify one or more arguments of the stored procedure, wherein the stored procedure is stored at the server;

generating procedure-specific logic to extract variables from an input form received from the client, wherein the variables correspond to the arguments of the stored procedure; and

generating procedure-specific logic to invoke the stored procedure at the server using the variables extracted from the input data stream from the client.

14. The article of manufacture of claim 13, further comprising the step of generating logic to extract information from the input data stream that does not correspond to the arguments and to create a universal data structure from the information.

15. The article of manufacture of claim 13, wherein the generating step comprises the step of generating a call to a CGI run-time library.

16. The article of manufacture of claim 13, wherein the generating step comprises the step of generating logic to extract the variables from a command line.

17. The article of manufacture of claim 13, wherein the generating step comprises the step of generating logic to call the stored procedure.

18. The article of manufacture of claim 13, wherein the stored procedure comprises source language, statements, and wherein the parsing step comprises the step of reading the source language statements of the stored procedure.