Database system with methodology for providing stored procedures as web services
First Claim
1. In a database system, a method for providing a stored procedure as a Web service, the method comprising:
- predefining a stored procedure to be invoked upon receiving a client request for a particular Web service;
receiving an incoming request from a particular client for the particular Web service at an HTTP server built into database engine of the database system;
in response to the incoming request, identifying the stored procedure that is predefined for the particular Web service;
executing the identified stored procedure for generating a result set, wherein said executing step includes creating a temporary pseudo connection to the database engine of the database system, and executing the stored procedure asynchronously through said temporary pseudo connection with respect to incoming requests; and
returning the result set back to the particular client.
2 Assignments
0 Petitions
Accused Products
Abstract
A database system providing stored procedures as web services is described. In one embodiment, for example, in a database system, a method of the present invention is described for providing a stored procedure as a Web service, the method comprises steps of: predefining a stored procedure to be invoked upon receiving a client request for a particular Web service; receiving an incoming request from a particular client for the particular Web service; in response to the incoming request, identifying the stored procedure that is predefined for the particular Web service; executing the identified stored procedure for generating a result set; and returning the result set back to the particular client.
60 Citations
34 Claims
-
1. In a database system, a method for providing a stored procedure as a Web service, the method comprising:
-
predefining a stored procedure to be invoked upon receiving a client request for a particular Web service; receiving an incoming request from a particular client for the particular Web service at an HTTP server built into database engine of the database system; in response to the incoming request, identifying the stored procedure that is predefined for the particular Web service; executing the identified stored procedure for generating a result set, wherein said executing step includes creating a temporary pseudo connection to the database engine of the database system, and executing the stored procedure asynchronously through said temporary pseudo connection with respect to incoming requests; and returning the result set back to the particular client. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. A database system providing stored procedures as Web services, the system comprising:
-
a database engine store on a computer-read medium, which when executed controls a database that includes a stored procedure to be invoke upon receiving a request for a particular Web service; a communications layer for receiving an incoming request from a particular client for the particular Web service; an HTTP server built into a database engine of the database system for parsing and validating the incoming request; a request layer of the database system for identifying the store procedure corresponding to the particular Web service and executing the identified stored procedure for the particular Web service, for generating a result set, wherein the request layer creates a temporary pseudo connection to the database engine of the database system, and executes the stored procedure asynchronouly through said temporary pseudo connection with respect to incoming requesting; a presentation layer of the database system for returning the result set back to the particular client. - View Dependent Claims (19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34)
-
Specification