Stored procedure interface

• US 8,185,542 B1
• Filed: 05/19/2004
• Issued: 05/22/2012
• Est. Priority Date: 05/19/2004
• Status: Active Grant

• Current Assignee: Unisys Corporation
• Original Assignee: Unisys Corporation
• Inventors: Vanyo, Tadd E., Hanson, Craig D., Lambert, Neil A., Parenteau, Michael F.
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): Hoffler, Raheem
• Application Number:
  US10/849,511
• Time in Patent Office: 2,925 Days
• Field of Search: None
• US Class Current: 707/762
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation

Abstract

An apparatus for and method of utilizing an Internet terminal coupled to the world wide web to access a legacy data base management system having a dialog-based request format to prepare, modify, and execute stored procedures. The user request is passed to the legacy data base management system via the Internet. The command type is determined whereby list, parameter, column, and execute commands are defined. In response to the user request, the scripted procedure is accessed, prepared, modified, or executed, as appropriate. Invalid and/or undefined requests result in an error response. Valid and defined requests result in performance of the requested command and transfer of an appropriate response to the user terminal.

Claims

1. An apparatus comprising:

a. a user terminal which generates a user request;

b. a publicly accessible digital data communication network responsively coupled to said user terminal;

c. a legacy data base management system having access to at least one data base responsively coupled to said user terminal via said publicly accessible digital data communication network; and

d. a stored procedure having a sequence of command script statements responsively coupled to said legacy data base management system which is executed by said legacy data base management system in response to said user request.

2. The apparatus of claim 1 wherein said user terminal generates a second user request which causes said legacy data base management system to add parameters to said stored procedure.

3. The apparatus of claim 2 wherein said at least one data base further comprises an ODBC data base.

4. The apparatus of claim 3 wherein said at least one data base further comprises an OLEDB data base.

5. The apparatus of claim 4 wherein said legacy data base management system further comprises BIS.

6. A method of utilizing a user terminal to access a command language scripted stored procedure within a legacy data base management system having at least one data base comprising:

a. transmitting a service request requesting access to said command language scripted stored procedure from said user terminal to said legacy data base management system via a publicly accessible digital data communication network;

b. receiving said service request by said legacy data base management system;

c. accessing said command language scripted stored procedure in accordance with said service request; and

d. transferring an appropriate response from said legacy data base management system to said user terminal via said publicly accessible digital data communication network.

7. A method according to claim 6 wherein said accessing step further comprises executing said command language scripted store procedure corresponding to said service request by said legacy data base management system.

8. A method according to claim 7 wherein said publicly accessible digital data communication network further comprises the Internet.

9. A method according to claim 8 further comprising transferring a second service request from said user terminal to said legacy data base management system which causes said accessing step to enter parameters into said command language scripted stored procedure.

10. A method according to claim 9 wherein said legacy data base management system further comprises BIS data base management system.

11. In a data processing system having a user terminal which generates a service request responsively coupled via a publicly accessible digital data communication network to a legacy data base management system having at least one data base, the improvement comprising:

a scripted command language stored procedure within said at least one data base which is accessed in response to said service request.

12. The improvement according to claim 11 further comprising a plurality of variables loaded into said scripted command language stored procedure in response to said service request.

13. The improvement according to claim 12 further comprising a second service request generated by said user terminal causes said legacy data base management system to execute said scripted command language stored procedure.

14. The improvement according to claim 11 wherein said publicly accessible digital data communication network further comprises the Internet.

15. The improvement according to claim 14 wherein said legacy data base management system further comprises BIS.

16. An apparatus for permitting a user to access a stored procedure comprising:

a. a user terminal which generates a first user request containing a parameter and a second user request;

b. a publicly accessible digital data communication network responsively coupled to said user terminal which transfers said first user request and said second user request;

c. a legacy data base management system having access to at least one OLE DB data base responsively coupled to said user terminal via said publicly accessible digital data communication network which receives said first user request and said second user request; and

d. a stored procedure having a sequence of command script statements responsively coupled to said legacy data base management system which is modified in accordance with said parameter of said first user request and which is executed in response to said second user request.