Database system with methodology for providing stored procedures as web services
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.
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. The method of claim 1 , further comprising:
upon receiving the incoming request, verifying that the request comprises a valid HTTP request for a Web service.
3. The method of claim 1 , wherein client requests employ HTTP protocol.
4. The method of claim 3 , wherein client requests further specify a selected one of XML, SOAP, WSDL, and raw format.
5. The method of claim 1 , wherein said returning step further comprises:
formatting the result set into a particular presentation format; and thereafter
returning the formatted result set back to the particular client.
6. The method of claim 1 , wherein the incoming request comprises a URL.
7. The method of claim 6 , wherein the URL includes parameter information affecting how the identified stored procedure is executed.
8. The method of claim 1 , wherein the identified stored procedure may include any valid SQL statement.
9. The method of claim 1 , wherein the identified stored procedure itself may invoke other stored procedures.
10. The method of claim 1 , wherein the identified stored procedure selects data from a database, and wherein the result set returned to the particular client comprises that data formatted in a manner suitable for return via HTTP protocol.
11. The method of claim 10 , wherein the data is formatted for return as XML-formatted data.
12. The method of claim 11 , wherein the result set comprises a plurality of database rows, and wherein the XML-formatted data comprises said plurality of database rows delimited with XML row tags.
13. The method of claim 1 , wherein the identified stored procedure itself may set HTTP header information that is returned to the particular client.
14. The method of claim 1 , wherein the incoming request is received via a selected one of HTTP, FTP, and telnet protocol.
15. The method of claim 1 , wherein the system first checks user authentication for the particular client before executing the identified stored procedure.
16. A computer-readable medium having processor-executable instructions for performing the method of claim 1 .
17. The method of claimed 1 further comprising:
a downloadable set of processor-executable instructions stored on computer-readable medium for performing the method of claim 1 .
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.
19. The system of claim 18 , wherein the HTTP server verifies that the incoming request comprises a valid HTTP request for a Web service.
20. The system of claim 18 , wherein client requests employ HTTP protocol to communicate with the database system.
21. The system of claim 20 , wherein client requests further specify a selected one of XML, SOAP, WSDL, and raw format.
22. The system of claim 18 , wherein the presentation layer formats the result set into a particular presentation format before returning the result set to the particular client.
23. The system of claim 18 , wherein the incoming request comprises a URL.
24. The system of claim 23 , wherein the URL includes parameter information affecting how the identified stored procedure is executed.
25. The system of claim 18 , wherein the identified stored procedure may include any valid SQL statement.
26. The system of claim 18 , wherein the identified stored procedure itself may invoke other stored procedures.
27. The system of claim 18 , wherein the identified stored procedure selects data from the database, and wherein the result set returned to the particular client comprises that data formatted in a manner HTTP protocol.
28. The system of claim 27 , wherein the data is formatted for return as XML-formatted data.
29. The system of claim 28 , wherein the result set comprises a plurality of database rows selected from the database, and wherein the XML-formatted data comprises said plurality of database rows delimited with XML row tags.
30. The system of claim 18 , wherein the identified stored procedure itself may set HTTP header information that is returned to the particular client.
31. The system of claim 18 , wherein the incoming request is received via a selected one of HTTP, FTP, and telnet protocol.
32. The system of claim 18 , wherein the system first checks user authentication for the particular client before executing the identified stored procedure.
33. The system of claim 18 , wherein the request layer includes program logic for translating the request into a form that can be processed by the database engine.
34. The system of claim 18 , wherein the incoming request is received over an HTTP connection, and the result set is returned to the particular client over an HTTP connection.