Universal drill-down system for coordinated presentation of items in different databases

• US 7,139,766 B2
• Filed: 12/16/2002
• Issued: 11/21/2006
• Est. Priority Date: 12/17/2001
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects SA (SAP SE)
• Inventors: Thomson, Neil, Petitclerc, Martin, Chow, Gordon, Gould, Dave, Paiement, Andre, Donnelly, Brian
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): DODDS, HAROLD E
• Application Number:
  US10/321,781
• Publication Number:
  US 20040034615A1
• Time in Patent Office: 1,436 Days
• Field of Search: 707/1, 707 3- 5, 707/10, 707100-1041, 707/200, 707/201, 707/203, 709200-203, 709/223, 709/224, 709/226, 715/500, 715/700, 715/764, 715/781, 715/804
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/3334 Selection or weighting of terms from queries, including natural language queries
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A computer implemented method for mapping data from one presentation to another includes capturing and transmitting the context of an original report based on an originating data source such that it preserves the organization of the query and variable levels of context “fidelity”. The context of the originating report is translated in terms of the originating data source to a target context for presentation of a target report based on a target data source. The translation of different mapping scenarios is controlled in accordance with a translation model with a translation map.

Claims

1. In a database system for accurately mapping data from one presentation to another, comprising:

means for capturing and transmitting the context of an original report based on an originating data source such that it preserves the organization of the query and variable levels of context fidelity;

said means further including translation means for translating the context of the originating report in terms of the originating data source to a target context for presentation of a target report based on a target data source; and

a translation model having a translation map and a set of rules for controlling the translation of different mapping scenarios.

2. The database system of claim 1, further comprising:

means for identifying selected types of mappings and preventing drill-through of irrelevant information or information that cannot be mapped.

3. The database system of claim 2, further comprising:

means for generating member exceptions for mapping between different data values at one level in an originating data source to alternate values in another level in a target data source.

4. The database system of claim 3 wherein said originating data source is an OLAP data source and said target data source is a relational data source.

5. The database system of claim 3 wherein said originating data source is an OLAP data source and said target data source is an OLAP data source.

6. The database system of claim 3 wherein said originating data source is a relational data source and said target data source is an OLAP data source.

7. The database system of claim 3 wherein said originating data source is an OLAP data source and said target data source is a multi-dimensional database.

8. The database system of claim 3 wherein said originating data source is a relational data source and said target data source is a multi-dimensional database.

9. The database system of claim 3 further comprising means for defining translation maps for accessing cube metadata if said originating or target data source is an OLAP data source and relational metadata if said originating or target data source is a relational data source and providing the originating and target data source metadata in response to a user request to drill-through on a selected member of said originating data source;

and

means for assigning drill-through target reports to the translation map.

10. A computer implemented method for mapping data from one presentation to another, comprising:

capturing and transmitting the context of an original report based on an originating data source such that it preserves the organization of the query and variable levels of context fidelity;

including translating the context of the originating report in terms of the originating data source to a target context for presentation of a target report based on a target data source; and

controlling the translation of different mapping scenarios in accordance with a translation model with a translation map.

11. The method of claim 10 further comprising:

identifying selected types of mappings and preventing drill-through of irrelevant information or information that cannot be mapped.

12. The method of claim 10 further comprising:

mapping between different data values at one level in an originating data source to alternate values in another level in a target data source.