Web services access with shared SQL

• US 8,250,086 B2
• Filed: 09/02/2008
• Issued: 08/21/2012
• Est. Priority Date: 09/02/2008
• Status: Active Grant

• Current Assignee: Teradata Corporation
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Ladha, Alnasir, Danesi, Lorenzo, Coutts, Michael
• Primary Examiner(s): WILSON, KIMBERLY LOVEL
• Application Number:
  US12/202,462
• Publication Number:
  US 20100057705A1
• Time in Patent Office: 1,449 Days
• Field of Search: 707/760, 707/999.004
• US Class Current: 707/760
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation

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.

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 in response to the web server request;

determining whether a response to the web service will include the results of posing the database query against the data warehouse or database query 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 database query 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.

2. The method of claim 1 further comprising, where the response to the web service request includes the database query syntax, the first enterprise application posing the database query against the data warehouse.

3. The method of claim 2 further comprising the second enterprise application determining to issue the database query syntax to the first client enterprise application if a combined cost of formatting the results of the query and issuing the results of the query to the first client enterprise application exceeds a cost of issuing the database query syntax as a response to the web service request.

4. The method of claim 2 further comprising the second enterprise application determining to issue the database query syntax to the first client enterprise application if a combined cost of the second server enterprise application posing the constructed query against the data warehouse and obtaining the results of the query exceeds a predefined maximum cost.

5. The method of claim 1, wherein determining whether the response to the web service will include the results of posing the database query against the data warehouse or the database query syntax necessary to pose the query against the data warehouse comprises determining whether the response to the web service will include the results of posing the database query against the data warehouse or SQL syntax necessary to pose the query against the data warehouse.

6. Non-transitory 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 in response to the web service request;

determining whether a response to the web service will include the results of posing the database query against the data warehouse or database query 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 database query 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.

7. The non-transitory computer readable media of claim 6, the method further comprising, where the response to the web service request includes the database query syntax, the first enterprise application posing the database query against the data warehouse.

8. The non-transitory computer readable media of claim 7, the method further comprising the second enterprise application determining to issue the database query syntax to the first client enterprise application if a combined cost of formatting the results of the query and issuing the results of the query to the first client enterprise application exceeds a cost of issuing the database query syntax as a response to the web service request.

9. The non-transitory computer readable media of claim 7, the method further comprising the second enterprise application determining to issue the database query syntax to the first client enterprise application if a combined cost of the second server enterprise application posing the constructed query against the data warehouse and obtaining the results of the query exceeds a predefined maximum cost.

10. The non-transitory computer readable media of claim 6, wherein determining whether the response to the web service will include the results of posing the database query against the data warehouse or the database query syntax necessary to pose the query against the data warehouse comprises determining whether the response to the web service will include the results of posing the database query against the data warehouse or SQL syntax necessary to pose the query against the data warehouse.

11. A shared access system for a data warehouse comprising:

a memory device configured to store the data warehouse;

a first processor in communication with the memory device, the first processor configured to execute a first client enterprise application;

a second processor in communication with the memory device, the second processor configured to execute a second server enterprise application; and

a data network in communication with the first processor and the second processor permitting data transfer between the first client enterprise application and the second server enterprise application,

wherein the first client enterprise application is configured to issue a web service request over the data network to the second server enterprise application, and

wherein the second server enterprise application is configured to issue a web service response to the first client enterprise application over the data network,

wherein the web service response includes;

results of posing a database query against the data warehouse in response to a determination of existence of a first predetermined condition by the second server application; and

database query syntax necessary to pose the query against the data warehouse in response to a determination of absence of the first predetermined condition by the second server application.

12. The shared access system of claim 11, wherein the web service response includes SQL syntax necessary to pose the query against the data warehouse in response to a determination of absence of the first predetermined condition by the second server application.