System and method for optimizing business intelligence data queries within a client-server architecture

• US 20080189332A1
• Filed: 10/04/2007
• Published: 08/07/2008
• Est. Priority Date: 02/02/2007
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: Cognos Incorporated (International Business Machines Corporation)
• Inventors: Winter, Stewart James
• Granted Patent: US 9,342,799 B2
• Time in Patent Office: Days
• US Class Current: 707/104.1
• CPC Class Codes: G06F 16/24547 Optimisations to support specific applications; Extensibility of optimisers
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: G06Q 20/1235 with control of digital rights management [DRM]

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.

Claims

1. A business intelligence analysis server in a client-server business intelligence analysis system comprising:

a query processing component receiving a request from a client in the client-server business intelligence analysis system;

a query information collector capturing information in a response to the request, and including the information in an updated server context in the response; and

an adaptive query optimizer for optimizing a subsequent request from the client, the subsequent request utilizing the optimization information included in the server context.

2. The business intelligence analysis server as claimed in claim 1, wherein the information is information of an expression-defined set of members.

3. The business intelligence analysis server as claimed in claim 2, wherein the updated server context includes a maximum member count, a minimum member count, and an actual member count for the expression-defined set of members.

4. The business intelligence analysis server as claimed in claim 2, wherein the server further comprising a business intelligence object model module.

5. The business intelligence analysis server as claimed in claim 2, wherein the response to the request is used in a crosstab or a chart.

6. The business intelligence analysis server as claimed in claim 2, wherein the block includes a visible segment and a remainder segment.

7. A method of processing a request from a client at a business intelligence analysis server, the method comprising the steps of:

receiving the request;

building a response to the request

capturing information of the response in an updated server context, the updated server context forming part of the response to the request,

dispatching the response to the client;

including the updated server context in a subsequent request;

receiving the subsequent request from the client; and

optimizing the subsequent request, based on the included updated server context.

8. The method as claimed in claim 7 wherein the response including a block having segments, and wherein the information is segment information of the block.

9. The method as claimed in claim 8 wherein the block has a base expression, further comprising the step of determining the completeness of base expression in the block.

10. The method as claimed in claim 8 further comprising the step of determining an order of the segments of the block.

11. The method as claimed in claim 8 further comprising the step of determining a maximum member count and a minimum member count of the block.

12. The method as claimed in claim 8 further comprising the step of determining an actual member count of the block.

13. The method as claimed in claim 7 further comprising the step of verifying the applicability of the optimizing information as supplied in the round tripped server context.

14. A storage medium readable by a computer encoding a computer program for execution by the computer to carry out a method for processing a request from a client to a business intelligence analysis server, the computer program comprising:

code means for receiving the request;

code means for building a response to the request;

code means for capturing information of the response in an updated server context, the updated server context forming part of the response to the request;

code means for dispatching the response to the client;

code means for including the updated server context in a subsequent request;

code means for receiving the subsequent request from the client; and

code means for optimizing the subsequent request, based on the included updated server context.