IP Library Granted Patent US 9,075,859
Granted Patent B2
US 9,075,859 · App. 10/624,490 · Granted Jul 7, 2015

Parameterized database drill-through

Inventors: Ralf Vierich (Ontario, CA); Kevin Ferguson (Ontario, CA)
Assignee: International Business Machines Corporation
G06F17/30592G06F17/30395
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,075,859
App. No.
10/624,490
Granted
Jul 7, 2015
Kind
B2
Abstract

A database interface for generating drill-through pats for various data cubes, derived from different report generating applications is disclosed. The interface comprises: (a) means for accepting a request from a user for data; (b) means for translating the request into a drill-through path selected from a plurality of possible drill-through paths between a source and a target; (c) means for applying one or more parameters to the selected drill-rough path to produce a valid drill-through path and to transfer the requested data over the valid drill-through path to an application; and (d) display means for displaying the requested data to the user.

Claims (61)

1. A method comprising:

generating, by a computer system, a drill-through path between a first meta-model on which a first drill-through source is based and a second meta-model on which a drill-through target is based to service a first request for first data, wherein the drill-through path comprises a parameter mapping between a first source parameter associated with the first drill-through source and at least one target parameter associated with the drill-through target;

in response to receiving a second request for second data, the second request being based at least in part on a second source parameter associated with a second drill-through source:

determining, by the computer system, that the drill-through path that was already defined between the first meta-model and the second meta-model and that was generated by the computer system in response to servicing the first request for first data is usable to service the second request for the second data; and

performing, based on determining that the drill-through path that was already defined is usable to service the second request, a drill-through operation to convert data from the drill-through target to converted data for the second drill-through source, wherein the drill-through operation is provided by a drill-through service associated with the drill-through path.

2. The method of claim 1 , further comprising:

determining, by the computer system, a plurality of potential drill-through mappings between the drill-through target and the first drill-through source;

generating, by the computer system, a plurality of source parameters associated with the first drill-through source and a plurality of target parameters associated with the drill-through target; and

associating, by the computer system, the first source parameter with the first drill-through source and the at least one target parameter with the drill-through target to generate the parameter mapping.

3. The method of claim 2 , further comprising:

in response to determining that at least two of the plurality of source parameters associated with the first drill-through source map to the target parameter of the plurality of target parameters, generating, by the computer system, first and second parameter mappings,

wherein the first parameter mapping comprises a first association between the target parameter of the plurality of target parameters and a first source parameter of the at least two of the plurality of source parameters, and

wherein the second parameter mapping comprises a second association between the target parameter of the plurality of output parameters and a second source parameter of the at least two of the plurality of input parameters.

4. The method of claim 1 , wherein the computer system is a first computer system, the method further comprising:

generating, by the first computer system, at least one of a Uniform Resource Locator or a markup language template that specifies the second source parameter,

wherein receiving the second request for data further comprises receiving, by the first computer system, the second request from a second computer system using the at least one of a Uniform Resource Locator or a markup language template; and

sending, by the first computer system, the converted data to the second computer system.

5. The method of claim 1 , further comprising:

providing, by the computer system, the drill-through service in association with the drill-through path to process requests for data included in at least one of the drill-through target, the first drill-through source, and the second drill-through source; and

receiving, by the computer system, the second request that is based at least in part on the second source parameter associated with the drill-through source to perform a drill-through operation that selects data from the drill-through target, wherein the drill-through operation is provided by the drill-through service.

6. The method of claim 1 , further comprising, outputting for display, by the computer system, the converted data.

7. A computer system comprising:

at least one processor configured to:

generate a drill-through path between a first meta-model on which a first drill-through source is based and a second meta-model on which a drill-through target is based to service a first request for first data, wherein the drill-through path comprises a parameter mapping between a first source parameter associated with the first drill-through source and at least one target parameter associated with the drill-through target;

in response to receiving a second request for second data and the second request being based at least in part on a second source parameter associated with a second drill-through source:

determine that the drill-through path that was already defined between the first meta-model and the second meta-model and that was generated by the at least one processor in response to servicing the first request for first data is usable to service the second request for the second data; and

perform, based on determining that the drill-through path that was already defined is usable to service the second request, a drill-through operation to convert data from the drill-through target to converted data for the second drill-through source, wherein the drill-through operation is provided by a drill-through service associated with the drill-through path.

8. The computer system of claim 7 , wherein the at least one processor is further configured to:

determine a plurality of potential drill-through mappings between the drill-through target and the first drill-through source;

generate a plurality of source parameters associated with the first drill-through source and a plurality of target parameters associated with the drill-through target; and

associate the first source parameter with the first drill-through source and the at least one target parameter with the drill-through target to generate the parameter mapping.

9. The computer system of claim 8 , wherein the at least one processor is further configured to:

generate, in response to determining that at least two of the plurality of source parameters associated with the first drill-through source map to the target parameter of the plurality of target parameters, first and second parameter mappings,

wherein the first parameter mapping comprises a first association between the target parameter of the plurality of target parameters and a first source parameter of the at least two of the plurality of source parameters, and

wherein the second parameter mapping comprises a second association between the target parameter of the plurality of output parameters and a second source parameter of the at least two of the plurality of input parameters.

10. The computer system of claim 7 , wherein the computer system is a first computer system and wherein the at least one processor is further configured to:

generate at least one of a Uniform Resource Locator or a markup language template that specifies the second source parameter;

receive the second request from a second computer system using the at least one of a Uniform Resource Locator or a markup language template; and

send the converted data to the second computer system.

11. The computer system of claim 7 , wherein the at least one processor is further configured to:

provide the drill-through service in association with the drill-through path to process requests for data included in at least one of the drill-through target, the first drill-through source, and the second drill-through source; and

receive the second request that is based at least in part on the second source parameter associated with the drill-through source to perform a drill-through operation that selects data from the drill-through target, wherein the drill-through operation is provided by the drill-through service.

12. The computer system of claim 7 , wherein the at least one processor is further configured to output for display the converted data.

13. A computer program product for servicing requests using a drill-through path, the computer program product comprising a non-transitory machine readable storage device having computer-readable program code embodied therein, the computer-readable program code comprising:

computer-readable program code to generate a drill-through path between a first meta-model on which a first drill-through source is based and a second meta-model on which a drill-through target is based to service a first request for first data, wherein the drill-through path comprises a parameter mapping between a first source parameter associated with the first drill-through source and at least one target parameter associated with the drill-through target;

computer-readable program code to, in response to receiving a second request for second data, the second request being based at least in part on a second source parameter associated with a second drill-through source:

determine that the drill-through path that was already defined between the first meta-model and the second meta-model and that was generated by a computing device in response to servicing the first request for first data is usable to service the second request for the second data; and

perform, based on determining that the drill-through path that was already defined is usable to service the second request, a drill-through operation to convert data from the drill-through target to converted data for the second drill-through source, wherein the drill-through operation is provided by a drill-through service associated with the drill-through path.

14. The computer program product of claim 13 for servicing requests using the drill-through path, the computer program product comprising the non-transitory machine readable storage device having computer-readable program code embodied therein, the computer-readable program code further comprising:

computer-readable program code to determine a plurality of potential drill-through mappings between the drill-through target and the first drill-through source;

computer-readable program code to generate a plurality of source parameters associated with the first drill-through source and a plurality of target parameters associated with the drill- through target; and

computer-readable program code to associate the first source parameter with the first drill-through source and the at least one target parameter with the drill-through target to generate the parameter mapping.

15. The computer program product of claim 13 for servicing requests using the drill-through path, the computer program product comprising the non-transitory machine readable storage device having computer-readable program code embodied therein, the computer-readable program code further comprising:

computer-readable program code to generate, by a first computer system, at least one of a Uniform Resource Locator or a markup language template that specifies the second source parameter;

computer-readable program code to receive the second request from a second computer system using the at least one of a Uniform Resource Locator or a markup language template; and

computer-readable program code to send, by the first computer system, the converted data to the second computer system.

16. The computer program product of claim 13 for servicing requests using the drill-through path, the computer program product comprising the non-transitory machine readable storage device having computer-readable program code embodied therein, the computer-readable program code further comprising:

computer-readable program code to provide the drill-through service in association with the drill-through path to process requests for data included in at least one of the drill-through target, the first drill-through source, and the second drill-through source; and

computer-readable program code to receive the second request that is based at least in part on the second source parameter associated with the drill-through source to perform a drill- through operation that selects data from the drill-through target, wherein the drill-through operation is provided by the drill-through service.

17. The computer program product of claim 13 for servicing requests using the drill-through path, the computer program product comprising the non-transitory machine readable storage device having computer-readable program code embodied therein, the computer-readable program code further comprising:

computer-readable program code to generate the converted data for display.

Assignments (4)
CERTIFICATE OF AMALGAMATION Recorded Aug 15, 2008
From: COGNOS INCORPORATED
To: COGNOS ULC
Reel/Frame 021387/0813 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 15, 2008
From: COGNOS ULC
To: IBM INTERNATIONAL GROUP BV
Reel/Frame 021387/0837 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 15, 2008
From: IBM INTERNATIONAL GROUP BV
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 021398/0001 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 29, 2004
From: VIERICH, RALF; FERGUSON, KEVIN
To: COGNOS INCORPORATED
Reel/Frame 015280/0823 →
Priority Claims (1)
CA 2394514 · Jul 23, 2002 · national
Continuity (1)
Related Publication 20040139102A1 · Jul 15, 2004