WEB SERVICES ACCESS WITH SHARED SQL
First Claim
1. A method of providing two or more enterprise applications with shared access to a data warehouse, the method comprising:
- issuing a web service request over a data network from a first client enterprise application to a second server enterprise application;
processing the web service request at the second server enterprise application;
constructing a database query at the second server enterprise application;
determining whether a response to the web service will include the results of posing the database query against the data warehouse or the SQL syntax necessary to pose the query against the data warehouse;
if the response to the web service is to include the results of posing the database query against the data warehouse then;
the second server enterprise application posing the constructed query against the data warehouse;
the second server enterprise application obtaining the results of the query;
the second server enterprise application formatting the results of the query for issuing to the first client enterprise application over the data network;
issuing the results of the query to the first client enterprise application as a response to the web service request;
if the response to the web service is to include the SQL syntax necessary to pose the query against the data warehouse then;
the second server enterprise application issuing the database query syntax to the first client enterprise application as a response to the web service request.
1 Assignment
0 Petitions
Accused Products
Abstract
A method of providing enterprise applications with shared access to a data warehouse. A web service request is issued over a data network from a first client enterprise application to a second server enterprise application. A database query is then constructed at the second server enterprise application. It is then determined whether a response to the web service request will include the results of posing the database query against the data warehouse, or the SQL syntax necessary to pose the query. If the response is to include the results of posing then the second server enterprise application poses the query against the data warehouse and issues the results to the first client enterprise application. If the response to the request is to include the SQL syntax necessary to pose the query, then the second server enterprise application provides the database query syntax to the first client enterprise application.
-
Citations
9 Claims
-
1. A method of providing two or more enterprise applications with shared access to a data warehouse, the method comprising:
-
issuing a web service request over a data network from a first client enterprise application to a second server enterprise application; processing the web service request at the second server enterprise application; constructing a database query at the second server enterprise application; determining whether a response to the web service will include the results of posing the database query against the data warehouse or the SQL syntax necessary to pose the query against the data warehouse; if the response to the web service is to include the results of posing the database query against the data warehouse then; the second server enterprise application posing the constructed query against the data warehouse; the second server enterprise application obtaining the results of the query; the second server enterprise application formatting the results of the query for issuing to the first client enterprise application over the data network; issuing the results of the query to the first client enterprise application as a response to the web service request; if the response to the web service is to include the SQL syntax necessary to pose the query against the data warehouse then; the second server enterprise application issuing the database query syntax to the first client enterprise application as a response to the web service request. - View Dependent Claims (2, 3, 4)
-
-
5. Computer readable media having stored thereon computer executable instructions for performing a method of providing two or more enterprise applications with shared access to a data warehouse, the method comprising:
-
issuing a web service request over a data network from a first client enterprise application to a second server enterprise application; processing the web service request at the second server enterprise application; constructing a database query at the second server enterprise application; determining whether a response to the web service will include the results of posing the database query against the data warehouse or the SQL syntax necessary to pose the query against the data warehouse; if the response to the web service is to include the results of posing the database query against the data warehouse then; the second server enterprise application posing the constructed query against the data warehouse; the second server enterprise application obtaining the results of the query, the second server enterprise application formatting the results of the query for issuing to the first client enterprise application over the data network; issuing the results of the query to the first client enterprise application as a response to the web service request; if the response to the web service is to include the SQL syntax necessary to pose the query against the data warehouse then; the second server enterprise application issuing the database query syntax to the first client enterprise application as a response to the web service request. - View Dependent Claims (6, 7, 8)
-
-
9. A shared access system for a data warehouse comprising:
-
a first client enterprise application having access to a data warehouse; a second server enterprise application having access to the data warehouse; and a data network permitting data transfer between the first client enterprise application and the second server enterprise application; the first client enterprise application configured to issue a web service request over the data network to the second server enterprise application; the second server enterprise application configured to issue a web service response to the first client enterprise application over the data network, the web service response including, determined by the second server enterprise application, either the results of posing a database query against the data warehouse or the SQL syntax necessary to pose the query against the data warehouse.
-
Specification