Inventors:
Larry Brown - Austin TX, US
James Kleewein - San Jose CA, US
Rong Qu - Austin TX, US
Berthold Reinwald - Los Gatos CA, US
Peter Schwarz - San Jose CA, US
Charles Wolfson - Austin TX, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F007/00, G06F015/16, G06F017/30
US Classification:
709/227000, 715/513000, 707/010000
Abstract:
The present invention provides a method, system and program product for automatically generating an invoking mechanism from a web service description, thereby enabling integration of 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.