System and method for optimizing business intelligence data queries within a client-server architecture
First Claim
Patent Images
1. A business intelligence analysis server in a client-server business intelligence analysis system comprising:
- a processor; and
a non-transitory computer-readable medium comprising instructions that, when executed by the processor, cause the processor to perform the steps of;
receiving a request from a client interface in the client-server business intelligence analysis system, wherein the request includes a query to be issued to a data source by the business intelligence analysis server;
retrieving data from the data source in accordance with the query of the request;
capturing optimization information from the data retrieved from the data source based on the query, and storing at least part of the retrieved data;
providing a response to the request, wherein the response includes information defining a server context, wherein the information defining the server context includes the optimization information, and wherein the server context defines object state resulting from the query;
dispatching the response to the client;
receiving a subsequent request from the client, the subsequent request including a second query to be issued to the data source by the business intelligence analysis server and the optimization information included in the server context of the response;
optimizing the second query by modifying the second query using the optimization information included in the server context of the response and the stored at least portion of the retrieved data, and removing information from the subsequent request that is not needed to retrieve data from the data source in accordance with the second query;
retrieving data from the data source in accordance with the modified second query; and
dispatching the retrieved data to the client.
4 Assignments
0 Petitions
Accused Products
Abstract
Method and server in a business intelligence analysis system for building a response to a client request. The response includes information regarding the response in an updated server context. The updated server context is round tripped to the client and included in a subsequent request. After being received from the client, the subsequent request is optimized based on the included updated server context.
-
Citations
20 Claims
-
1. A business intelligence analysis server in a client-server business intelligence analysis system comprising:
-
a processor; and a non-transitory computer-readable medium comprising instructions that, when executed by the processor, cause the processor to perform the steps of; receiving a request from a client interface in the client-server business intelligence analysis system, wherein the request includes a query to be issued to a data source by the business intelligence analysis server; retrieving data from the data source in accordance with the query of the request; capturing optimization information from the data retrieved from the data source based on the query, and storing at least part of the retrieved data; providing a response to the request, wherein the response includes information defining a server context, wherein the information defining the server context includes the optimization information, and wherein the server context defines object state resulting from the query; dispatching the response to the client; receiving a subsequent request from the client, the subsequent request including a second query to be issued to the data source by the business intelligence analysis server and the optimization information included in the server context of the response; optimizing the second query by modifying the second query using the optimization information included in the server context of the response and the stored at least portion of the retrieved data, and removing information from the subsequent request that is not needed to retrieve data from the data source in accordance with the second query; retrieving data from the data source in accordance with the modified second query; and dispatching the retrieved data to the client. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method of processing a request from a client interface at a business intelligence analysis server, the method comprising:
-
receiving, by the business intelligence analysis server, the request, wherein the request includes a query to be issued to a data source by the business intelligence analysis server; retrieving, by the business intelligence analysis server, data from the data source in accordance with the query of the request; capturing, by the business intelligence analysis server, optimization information from the data retrieved from the data source based on the query, and storing at least part of the retrieved data; providing, by the business intelligence analysis server, a response to the request, wherein the response includes information defining a server context, wherein the information defining the server context includes the optimization information, and wherein the server context defines object state resulting from the query; dispatching, by the business intelligence analysis server, the response to the client; receiving, by the business intelligence analysis server, a subsequent request from the client, the subsequent request including a second query to be issued to the data source by the business intelligence analysis server and the optimization information included in the server context of the response; optimizing, by the business intelligence analysis server, the second query included in the subsequent request, wherein optimizing the second query comprises modifying the second query using the optimization information included in the server context of the response and the at least part of the stored retrieved data, and removing information from the second query that is not needed to retrieve data from the data source, as indicated by the optimization information; retrieving, by the business intelligence analysis server, data from the data source in accordance with the modified second query; and dispatching, by the business intelligence analysis server, the retrieved data to the client. - View Dependent Claims (8, 9, 10, 11, 12, 13)
-
-
14. A non-transitory computer-readable storage medium comprising instructions that, when executed by a processor of a business intelligence server, causes the processor of the business intelligence analysis server to perform the steps of:
-
receiving a request from a client interface in the client-server business intelligence analysis system, wherein the request includes a query to be issued to a data source by the business intelligence analysis server; retrieving data from the data source in accordance with the query of the request; capturing optimization information from the data retrieved from the data source based on the query, and storing at least part of the retrieved data; providing a response to the request, wherein the response includes information defining a server context, wherein the information defining the server context includes the optimization information, and wherein the server context defines object state resulting from the query; dispatching the response to the client; receiving a subsequent request from the client, the subsequent request including a second query to be issued to the data source by the business intelligence analysis server and the optimization information included in the server context of the response; optimizing the second query by modifying the second query using the optimization information included in the server context of the response and the stored at least portion of the retrieved data, and removing information from the subsequent request that is not needed to retrieve data from the data source in accordance with the second query; retrieving data from the data source in accordance with the modified second query; and dispatching the retrieved data to the client. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification