Invocation of web services from a database

• US 8,166,006 B2
• Filed: 09/28/2001
• Issued: 04/24/2012
• Est. Priority Date: 09/28/2001
• Status: Active Grant

• Current Assignee: ServiceNow Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Brown, Larry, Kleewein, James C., Reinwald, Berthold, Schwarz, Peter M., Wolfson, Charles Daniel
• Primary Examiner(s): Chbouki, Tarek
• Application Number:
  US09/968,353
• Publication Number:
  US 20030093436A1
• Time in Patent Office: 3,861 Days
• Field of Search: 707/1, 707/4, 707/100, 707/104.1, 707/103, 707/203, 707/229, 707/2, 707/10, 709/200, 709/202, 709/229, 709/203, 709/330, 709/217, 717/124, 705/1, 715/700
• US Class Current: 707/702
• CPC Class Codes: G06F 16/24553 of query operations

Abstract

The present invention provides a method, system and program product for integrating a service external to a database into a database such that the service may be easily invoked from the database. Preferably, the service is a web service available over the internet The service may be invoked from any of a number of invoking mechanisms of the database. In a first specific embodiment, the mechanism comprises a user-defined function within an SQL statement. In a second specific embodiment, the mechanism comprises a virtual table. In a third specific embodiment, the mechanism comprises a stored procedure. In a fourth specific embodiment, the mechanism comprises a trigger. In a fifth specific embodiment, the mechanism comprises a federated table accessed via a nickname and implemented using a wrapper.

Claims

1. A method to integrate a web service external to a database into the database, comprising:

receiving a query at the database describing the web service that is external to the database using a web address, wherein the web service provides an application service, wherein the database is at a first computer, wherein the web service executes at a second computer, and wherein the first computer and the second computer are coupled via an Internet;

invoking the web service that is external to the database with an invoking mechanism within the database, wherein the web service is described by a web services description language;

performing, with the web service, at least one of finding data outside of the database, returning data to the database, and invoking a business process described by a Web Services Flow Language; and

executing the query using a response returned by the web service.

2. The method of claim 1, wherein the invoking mechanism further comprises a virtual table.

3. The method of claim 1, wherein the invoking mechanism further comprises a user-defined function.

4. The method of claim 1, wherein the invoking mechanism further comprises a stored procedure.

5. The method of claim 1, wherein the invoking mechanism further comprises a trigger function.

6. The method of claim 1, wherein the invoking mechanism further comprises a federated wrapper created around the web service.

7. The method of claim 1, further comprising invoking the web service using a query language.

8. The method of claim 1, wherein the database further comprises a relational database.

39. The method of claim 1, further comprising exposing the invoking mechanism as a service available externally to the database.

9. A method to invoke an external web service from a database, comprising:

at the database,

invoking the web service that is external to the database from a database query received at the database, wherein the database query specifies a web address for the web service, wherein the web service is invoked within the database, wherein the web service provides an application service, and wherein the web service is described by a web services description language; and

executing the database query using a response returned by the web service.

10. The method of claim 9, wherein the query further comprises SQL.

11. The method of claim 9, wherein the query further comprises a virtual table representing the web service.

12. The method of claim 9, wherein the query further comprises a user-defined function to invoke the web service.

13. The method of claim 9, wherein the query is in a stored procedure.

14. The method of claim 9, wherein the query is in a trigger function.

15. The method of claim 9, wherein the database further comprises a relational database.

16. A program product containing instructions executable by a computer, the instructions embodying a method to integrate a service external to a database into the database, comprising:

receiving a query at the database describing the web service that is external to the database using a web address, wherein the web service provides an application service, wherein the database is at a first computer, wherein the web service executes at a second computer, and wherein the first computer and the second computer are coupled via an Internet;

invoking the web service that is external to a database with an invoking mechanism within the database, wherein the web service is described by a web services description language;

performing, with the web service, at least one of finding data outside of the database, returning data to the database, and invoking a business process described by a Web Services Flow Language ; and

executing the query using a response returned by the web service.

17. The method of claim 16, wherein the invoking mechanism further comprises a virtual table.

18. The method of claim 16, wherein the invoking mechanism further comprises a user-defined function.

19. The method of claim 16, wherein the invoking mechanism further comprises a stored procedure.

20. The method of claim 16, wherein the invoking mechanism further comprises a trigger function.

21. The method of claim 16, wherein the invoking mechanism further comprises a federated wrapper created around the web service.

22. The method of claim 16, further comprising invoking the web service using a query language.

23. The method of claim 16, wherein the database further comprises a relational database.

40. The method of claim 16, further comprising exposing the invoking mechanism as a service available externally to the database.

24. A program product containing instructions executable by a computer, the instructions embodying a method to invoke an external web service from a database, comprising:

at the database,

invoking the web service that is external to the database from a database query received at the database, wherein the database query specifies a web address for the web service, wherein the web service is invoked within the database, wherein the web service provides an application service, and wherein the web service is described by a web services description language; and

executing the database query using a response returned by the web service.

25. The method of claim 24, wherein the query further comprises SQL.

26. The method of claim 24, wherein the query further comprises a virtual table representing the web service.

27. The method of claim 24, wherein the query further comprises a user-defined function to invoke the web service.

28. The method of claim 24, wherein the query is in a stored procedure.

29. The method of claim 24, wherein the query is in a trigger function.

30. The method of claim 24, wherein the database further comprises a relational database.

31. A system to integrate a web service external to a database into the database, comprising:

a database;

a receiving mechanism to receive a query at the database describing the web service that is external to the database using a web address, wherein the web service provides an application service, wherein the database is at a first computer, wherein the web service executes at a second computer, and wherein the first computer and the second computer are coupled via an Internet;

an invoking mechanism to invoke the web service that is external to the database, wherein the invoking mechanism is within the database, and wherein the service further comprises a web service that performs at least one of finding data outside of the database, returning data to the database, and invoking a business process described by a Web Services Flow Language, wherein the web service is described by a web services description language; and

wherein the database executes the query using a response returned by the web service.

32. The system of claim 31, wherein the invoking mechanism further comprises a virtual table.

33. The system of claim 31, wherein the invoking mechanism further comprises a user-defined function.

34. The system of claim 31, wherein the invoking mechanism further comprises a stored procedure.

35. The system of claim 31, wherein the invoking mechanism further comprises a trigger function.

36. The system of claim 31, wherein the invoking mechanism further comprises a federated wrapper created around the web service.

37. The system of claim 31, further comprising invoking the web service using a query language.

38. The system of claim 31, wherein the database further comprises a relational database.

41. The system of claim 31, further comprising an exposing mechanism to expose the invoking mechanism as a service available externally to the database.

42. A system to invoke an external web service from a database, comprising:

the database, wherein the database includes;

means for executing a query received at the database and having a mechanism to invoke the external web service that is external to the database from within the database, wherein the query specifies a web address for the external web service, wherein the external web service provides an application service, wherein the external web service is described by a web services description language; and

means for executing the query using a response returned by the web service.

43. The system of claim 42, wherein the query further comprises SQL.

44. The system of claim 42, wherein the query further comprises a virtual table representing the external web service.

45. The system of claim 42, wherein the query further comprises a user-defined function to invoke the external web service.

46. The system of claim 42, wherein the query is in a stored procedure.

47. The system of claim 42, wherein the query is in a trigger function.

48. The system of claim 42, wherein the database further comprises a relational database.

49. A method to integrate a web service external to a database into the database, comprising:

receiving a query at the database describing the web service that is external to the database using a web address, wherein the web service provides an application service, wherein the database is at a first computer, and wherein the web service executes at a second computer;

invoking the web service that is external to the database with an invoking mechanism within the database, wherein the web service is described using a web services description language;

receiving data returned from the web service; and

combining information returned from the web service with data residing in the database.

50. The method of claim 49, wherein the invoking mechanism further comprises one of the group consisting of:

a virtual table, user-defined function, a stored procedure, a trigger function, and a federated wrapper created around the web service.

51. The method of claim 49, further comprising invoking the web service using a query language.

52. The method of claim 49, wherein the database further comprises a relational database.

53. The method of claim 49, further comprising exposing the invoking mechanism as a service available externally to the database.

54. A method to invoke an external web service from a database, comprising:

at the database,

invoking the web service that is external to the database from a database query received at the database and having a mechanism to invoke the web service from within the database, wherein the web service is described using a web services description language, wherein the database query specifies a web address for the web service, and wherein the web service performs at least one of finding data outside of the database, returning data to the database, and invoking a business process; and

processing the database query using a response returned by the web service.

55. The method of claim 54, wherein the query further comprises SQL.

56. The method of claim 54, wherein the mechanism further comprises one of the group consisting of:

a virtual table, user-defined function, a stored procedure, a trigger function, and a federated wrapper created around the web service.

57. The method of claim 54, wherein the database further comprises a relational database.

58. The method of claim 54, further comprising exposing the mechanism as a service available externally to the database.

59. A method to integrate a web service external to a database into the database, comprising:

receiving a query at the database describing the web service using a web address;

invoking the web service that is external to the database with an invoking mechanism within the database, the invoking mechanism comprising one of the group consisting of;

a virtual table, user-defined function, a stored procedure, a trigger function, and a federated wrapper created around the web service, wherein the web service is described using a web services description language; and

processing the query using a response returned by the web service.

60. A program product containing instructions executable by a computer, the instructions embodying a method to integrate a web service external to a database into the database, comprising:

receiving a query at the database describing the web service that is external to the database using a web address, wherein the web service provides an application service, wherein the database is at a first computer, and wherein the web service executes at a second computer;

invoking the web service that is external to the database with an invoking mechanism within the database, wherein the web service is described using a web services description language;

receiving data returned from the web service; and

combining information returned from the web service with data residing in the database.

61. The method of claim 60, wherein the invoking mechanism further comprises one of the group consisting of:

a virtual table, user-defined function, a stored procedure, a trigger function, and a federated wrapper created around the web service.

62. The method of claim 60, further comprising invoking the web service using a query language.

63. The method of claim 60, wherein the database further comprises a relational database.

64. The method of claim 60, further comprising exposing the invoking mechanism as a service available externally to the database.

65. A program product containing instructions executable by a computer, the instructions embodying a method to invoke an external web service from a database, comprising:

at the database,

invoking the web service that is external to the database from a database query received at the database and having a mechanism to invoke the web service from within the database, wherein the web service is described using a web services description language, wherein the database query specifies a web address for the web service, and wherein the web service performs at least one of finding data outside of the database, returning data to the database, and invoking a business process; and

processing the database query using a response returned by the web service.

66. The method of claim 65, wherein the query further comprises SQL.

67. The method of claim 65, wherein the mechanism further comprises one of the group consisting of:

a virtual table, user-defined function, a stored procedure, a trigger function, and a federated wrapper created around the web service.

68. The method of claim 65, wherein the database further comprises a relational database.

69. The method of claim 65, further comprising exposing the mechanism as a service available externally to the database.

70. A program product containing instructions executable by a computer, the instructions embodying a method to integrate a web service external to a database into the database, comprising:

receiving a query at the database describing the web service that is external to the database using a web address;

invoking the web service that is external to the database with an invoking mechanism within the database, the invoking mechanism comprising one of the group consisting of;

a virtual table, user-defined function, a stored procedure, a trigger function, and a federated wrapper created around the web service, wherein the web service is described using a web services description language; and

processing the query using a response returned by the web service.

71. A system to invoke an external web service from a database, comprising:

the database;

means to receive a query at the database describing the web service that is external to the database using a web address, wherein the web service provides an application service, wherein the database is at a first computer, and wherein the web service executes at a second computer;

means to invoke the web service that is external to the database with an invoking mechanism within the database, wherein the web service is described using a web services description language;

means to receive data returned from the web service; and

means to combine information returned from the web service with data residing in the database.

72. The system of claim 71, wherein the invoking mechanism further comprises one of the group consisting of:

a virtual table, user-defined function, a stored procedure, a trigger function, and a federated wrapper created around the web service.

73. The system of claim 71, further comprising invoking the web service using a query language.

74. The system of claim 71, wherein the database further comprises a relational database.

75. The system of claim 71, further comprising exposing the invoking mechanism as a service available externally to the database.

76. A system to invoke an external web service from a database, comprising:

the database; and

means for executing a query received at the database and having a mechanism to invoke the web service that is external to the database from within the database, wherein the web service is described using a web services description language, wherein the query specifies a web address for the web service, and wherein the web service performs at least one of finding data outside of the database, returning data to the database, and invoking a business process; and

means for processing the query using a response returned by the web service.

77. The system of claim 76, wherein the query further comprises SQL.

78. The system of claim 76, wherein the mechanism further comprises one of the group consisting of:

a virtual table, user-defined function, a stored procedure, a trigger function, and a federated wrapper created around the web service.

79. The system of claim 76, wherein the database further comprises a relational database.

80. The system of claim 76, further comprising exposing the mechanism as a service available externally to the database.

81. A system to integrate a web service external to a database into the database, comprising:

the database;

means to receive a query at the database describing the web service that is external to the database using a web address;

means to invoke the web service that is external to the database with an invoking mechanism within the database, the invoking mechanism comprising one of the group consisting of;

a virtual table, user-defined function, a stored procedure, a trigger function, and a federated wrapper created around the web service, wherein the web service is described using a web services description language; and

processing the query using a response returned by the web service.