Patent ID: 8005854

Claim:
A method for performing database operations on data obtained from a web service, the method comprising: creating at least one proxy table in a database, each proxy table mapping to a method of the web service, wherein said at least one proxy table is automatically created based on a Web Services Description Language (WSDL) description of the web service; automatically generating meta data about the mapping and storing the meta data in a database table of the database; creating a shadow table in the database associated with the web service; in response to a database operation on a particular proxy table, using the meta data for converting the database operation into a format for invoking a particular method of the web service based upon the corresponding mapping, wherein a row is inserted into the shadow table in response to a database operation including an insert on the particular proxy table; invoking the particular method of the web service using data in the shadow table as input parameters for invoking the web service; converting results obtained from invoking the particular method into data for use at the database based upon the corresponding mapping; performing the database operation on the data at the database to generate a result set; and returning the result set in response to the database operation.