Peter H Schwarz

US Patent:

8166006, Apr 24, 2012

Filed:

Sep 28, 2001

Appl. No.:

09/968353

Inventors:

Larry Brown - Austin TX, US
James C. Kleewein - San Jose CA, US
Berthold Reinwald - Los Gatos CA, US
Peter M. Schwarz - San Jose CA, US
Charles Daniel Wolfson - Austin TX, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707702

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.

US Patent:

20040199636, Oct 7, 2004

Filed:

Sep 28, 2001

Appl. No.:

09/967553

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.