System and method of member unique names

• US 8,090,658 B2
• Filed: 06/23/2006
• Issued: 01/03/2012
• Est. Priority Date: 06/23/2006
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Seeds, Glen, Cushing, David, Cazemier, Henk
• Primary Examiner(s): Fischer, Andrew J.
• Assistant Examiner(s): LE, NANCY LOAN T
• Application Number:
  US11/473,616
• Publication Number:
  US 20070299676A1
• Time in Patent Office: 2,020 Days
• Field of Search: 707/602, 707/809, 707/609, 707/610, 707/611, 707/626, 707/687, 707/692, 707812-820, 707953-963
• US Class Current: 705/50
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06Q 10/0637 Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals

Abstract

A member unique name (MUN) system and MUN translation system and method are provided. The MUN system comprises a dimension reference for defining the context in which the remaining portions of the MUN exist and a canonical business key for uniquely identifying a member across different dimensional data sources within a business enterprise. The MUN translation system comprises a translation selection module for selecting a MUN transformation and a collection of MUN transformations for transforming a MUN of a first data source into a MUN of the second data source.

Claims

1. A member unique name (MUN) translation system comprising:

a computer-readable storage medium comprising instructions for a translation module; and

a processor configured to execute the translation module to receive a first MUN that identifies a member of a first data source, the first MUN comprising a set of model information that describes a logical model for the first data source, to compare a data source identifier for the first data source to a data source identifier for a second data source, and, when the data source identifier for the first data source is the same as the data source identifier for the second data source, to copy the set of model information of the first MUN into a second MUN that identifies a member of the second data source corresponding to the member of the first data source, and wherein the data source identifier for the first data source indicates that the first data source comprises at least one of an Online Analytic Processing (OLAP) data source, a dimensionally modeled relational (DMR) data source, and a canonical data source.

4. The system of claim 1, wherein the logical model identifies one or more of a dimension, a hierarchy, a level, and a measure of the first data source.

5. The system of claim 1, wherein the first MUN comprises the data source identifier for the first data source.

6. The system of claim 1, wherein when the data source identifier for the first data source indicates that the first data source comprises an OLAP data source, the data source identifier for the first data source further indicates a particular OLAP data source technology for the first data source.

2. A method comprising:

receiving, by a computing device, a first member unique name (MUN) that identifies a member of a first data source, the first MUN comprising a set of model information that describes a logical model for the first data source;

comparing, by the computing device, a data source identifier for the first data source to a data source identifier for a second data source, wherein the data source identifier for the first data source indicates that the first data source comprises at least one of an Online Analytic Processing (OLAP) data source, a dimensionally modeled relational (DMR) data source, and a canonical data source; and

when the data source identifier for the first data source is the same as the data source identifier for the second data source, copying, by the computing device, the set of model information for the first MUN into a second MUN that identifies a member of the second data source corresponding to the member of the first data source.

7. The method of claim 2, wherein the logical model identifies one or more of a dimension, a hierarchy, a level, and a measure of the first data source.

8. The method of claim 2, wherein the first MUN comprises the data source identifier for the first data source.

9. The method of claim 2, wherein when the data source identifier for the first data source indicates that the first data source comprises an OLAP data source, the data source identifier for the first data source further indicates a particular OLAP data source technology for the first data source.

3. A computer-readable storage medium comprising instructions that, when executed, cause a processor to:

receive a first member unique name (MUN) that identifies a member of a first data source, the first MUN comprising a set of model information that describes a logical model for the first data source;

compare a data source identifier for the first data source to a data source identifier for a second data source, wherein the data source identifier for the first data source indicates that the first data source comprises at least one of an Online Analytic Processing (OLAP) data source, a dimensionally modeled relational (DMR) data source, and a canonical data source; and

when the data source identifier for the first data source is the same as the data source identifier for the second data source, copy the set of model information for the first MUN into a second MUN that identifies a member of the second data source corresponding to the member of the first data source.

10. The computer-readable storage medium of claim 3, wherein the logical model identifies one or more of a dimension, a hierarchy, a level, and a measure of the first data source.

11. The computer-readable storage medium of claim 3, wherein the first MUN comprises the data source identifier for the first data source.

12. The computer-readable storage medium of claim 3, wherein when the data source identifier for the first data source indicates that the first data source comprises an OLAP data source, the data source identifier for the first data source further indicates a particular OLAP data source technology for the first data source.