Reducing Programming Complexity In Client Applications When Interfacing With Database Servers Operating With Different Programming Interfaces

• US 20070260622A1
• Filed: 07/11/2006
• Published: 11/08/2007
• Est. Priority Date: 05/03/2006
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Mishra, Amulya
• Granted Patent: US 9,037,542 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

Reducing programming complexity in client applications when interfacing with database servers operating with corresponding programming interfaces. In one embodiment, a client system merely specifies a procedure of interest to be executed on a database server of interest, and a system forms the specific instructions according to the programming interface requirements of the specific database server. Thus, the client applications may be implemented independent of the programming interface requirements of the database servers. The client system may also send data indicating the programming environment (e.g., Java or Visual Basic) in which applications are supported (in the client system). The application sever may form the instructions consistent with the programming environment as well, thereby further reducing the complexity of implementations in the client applications.

Claims

1. A method of reducing programming complexity in client applications when interfacing with a plurality of database servers operating with a corresponding one of a plurality of programming interfaces, wherein each programming interface specifies a format in which instructions are to be provided to cause execution of a corresponding procedure in a corresponding database server, said method being implemented in a server, said method comprises:

receiving a request from a first client system, wherein said request indicates a procedure to be executed and an identifier of a first database server operating with a first programming interface, wherein said first database server and said first programming interface are respectively contained in said plurality of database servers and said plurality of programming interfaces;

forming a plurality of instructions according to said first programming interface, wherein said plurality of instructions would cause execution of said procedure on said first database server; and

sending said plurality of instructions to said first database server identified by said identifier.

2. The method of claim 1, wherein said forming and sending together comprises:

generating a software code which when executed in said server causes said plurality of instructions to be generated and sent to said first database server.

3. The method of claim 2, further comprising:

receiving a response corresponding to execution of said plurality of instructions on said first database server; and

sending said response to said first client system.

4. The method of claim 3, wherein said request received from said first client system does not contain a type of a parameter used in execution of said procedure of interest, wherein said forming comprises:

determining said type of said parameter; and

incorporating said type into said plurality instructions.

5. The method of claim 4, wherein said determining comprises sending a query to said database server and receiving a corresponding response, wherein said corresponding response indicates said type.

6. The method of claim 4, wherein said determining comprises retrieving data indicating said type from a secondary storage.

7. The method of claim 3, wherein said request received from said first client system does not contain a mode of a parameter used in execution of said procedure of interest, wherein said forming comprises:

determining said mode of said parameter; and

incorporating said mode into said plurality instructions.

8. The method of claim 7, wherein said determining comprises sending a query to said database server and receiving a corresponding response, wherein said corresponding response indicates said mode.

9. The method of claim 3, wherein said request is received in the form of a markup language which specifies said identifier and said programming environment are specified associated with corresponding tags according to said markup language.

10. A method of implementing a client application in a client system, wherein said client application is to execute a procedure of interest in a database server, wherein said database server executes said procedure upon receiving a plurality of instructions according to a programming interface, said method comprising:

sending to a server a request containing a first identifier identifying said procedure of interest and a second identifier identifying said database server, wherein said request does not include said plurality of instructions; and

receiving a response containing a result of execution of said procedure of interest on said database server.

11. The method of claim 10, wherein said request specifies a input parameter name and a corresponding value.

12. The method of claim 10, wherein said request does not specify a type of said input parameter and said server determines said type.

13. A computer readable medium carrying one or more sequences of instructions which when executed on a server system reduces programming complexity in client applications when interfacing with a plurality of database servers operating with a corresponding one of a plurality of programming interfaces, wherein each programming interface specifies a format in which instructions are to be provided to cause execution of a corresponding procedure in a corresponding database server, wherein execution of said one or more sequences of instructions by one or more processors contained in said server system causes said one or more processors to perform the actions of:

receiving a request from a first client system, wherein said request indicates a procedure to be executed and an identifier of a first database server operating with a first programming interface, wherein said first database server and said first programming interface are respectively contained in said plurality of database servers and said plurality of programming interfaces;

forming a plurality of instructions according to said first programming interface, wherein said plurality of instructions would cause execution of said procedure on said first database server; and

sending said plurality of instructions to said first database server identified by said identifier.

14. The computer readable medium of claim 13, wherein said forming and sending together comprises:

generating a software code which when executed in said server causes said plurality of instructions to be generated and sent to said first database server.

15. The computer readable medium of claim 14, further comprising:

receiving a response corresponding to execution of said plurality of instructions on said first database server; and

sending said response to said first client system.

16. A computer readable medium carrying one or more sequences of instructions for implementing a client application in a client system, wherein said client application is to execute a procedure of interest in a database server, wherein said database server executes said procedure upon receiving a plurality of instructions according to a programming interface, wherein execution of said one or more sequences of instructions by one or more processors contained in said client system causes said one or more processors to perform the actions of:

sending to a server a request containing a first identifier identifying said procedure of interest and a second identifier identifying said database server, wherein said request does not include said plurality of instructions; and

receiving a response containing a result of execution of said procedure of interest on said database server.

17. A server system reducing programming complexity in client applications when interfacing with a plurality of database servers operating with a corresponding one of a plurality of programming interfaces, wherein each programming interface specifies a format in which instructions are to be provided to cause execution of a corresponding procedure in a corresponding database server, said server system comprises:

means for receiving a request from a first client system, wherein said request indicates a procedure to be executed and an identifier of a first database server operating with a first programming interface, wherein said first database server and said first programming interface are respectively contained in said plurality of database servers and said plurality of programming interfaces;

means for forming a plurality of instructions according to said first programming interface, wherein said plurality of instructions would cause execution of said procedure on said first database server; and

means for sending said plurality of instructions to said first database server identified by said identifier.

18. The system of claim 17, wherein said means for forming and means for sending together generate a software code which when executed in said server causes said plurality of instructions to be generated and sent to said first database server.

19. The system of claim 18, further comprising:

means for receiving a response corresponding to execution of said plurality of instructions on said first database server; and

means for sending said response to said first client system.

20. A client system implementing a client application, wherein said client application is to execute a procedure of interest in a database server, wherein said database server executes said procedure upon receiving a plurality of instructions according to a programming interface, said client system comprising:

means for sending to a server a request containing a first identifier identifying said procedure of interest and a second identifier identifying said database server, wherein said request does not include said plurality of instructions; and

means for receiving a response containing a result of execution of said procedure of interest on said database server.