System with Methodology for Executing Relational Operations Over Relational Data and Data Retrieved from SOAP Operations
First Claim
1. 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;
in response to a database operation on a particular proxy table, converting the database operation into a format for invoking a particular method of the web service based upon the corresponding mapping;
invoking the particular method of the web service;
converting results obtained from invoking the particular method into data for use at the database based upon the corresponding mapping; and
performing the database operation on the data at the database.
1 Assignment
0 Petitions
Accused Products
Abstract
A system with methodology for performing relational operations over relational data and data retrieved from Simple Object Access Protocol (SOAP) operations is described. In one embodiment, a method of the present invention is described for performing database operations on data obtained from a web service, the method comprises steps of: creating at least one proxy table in a database, each proxy table mapping to a method of the web service; in response to a database operation on a particular proxy table, converting the database operation into a format for invoking a particular method of the web service based upon the corresponding mapping; invoking the particular method of the web service; converting results obtained from invoking the particular method into data for use at the database based upon the corresponding mapping; and performing the database operation on the data at the database.
-
Citations
55 Claims
-
1. 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;
in response to a database operation on a particular proxy table, converting the database operation into a format for invoking a particular method of the web service based upon the corresponding mapping;
invoking the particular method of the web service;
converting results obtained from invoking the particular method into data for use at the database based upon the corresponding mapping; and
performing the database operation on the data at the database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)
-
-
22. A system for performing operations at a database on data obtained from a remote service, the system comprising:
-
a mapping module for creating database tables representing at least some methods of a remote service accessed through a defined interface;
an invocation module for converting a database operation on a database table representing a method of the remote service into a call for invoking the method;
a communication module for transmitting the call for invoking the method to the remote service, and returning result values from invoking the method to the database; and
a conversion module for converting result values received from the method into database format. - View Dependent Claims (23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
-
-
40. In a database system, a method for performing database queries on data available from an application, the method comprising:
-
establishing communication between a database and an application having an interface;
creating database tables to represent at least some functions of the application based on the interface, each database table corresponding to a function of the application;
in response to a database query received on a database table corresponding to a function of the application, generating input arguments expected by the function based on the database query;
invoking the function with the input arguments and receiving results from invoking the function;
converting the results into a database result set; and
returning the database result set in response to the database query. - View Dependent Claims (41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55)
-
Specification