The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 18, 2010
Filed:
Jun. 22, 2007
Glen Seeds, Ottawa, CA;
David Cushing, Osgoode, CA;
Henk Cazemier, Spencerville, CA;
International Business Machines Corporation, Armonk, NY (US);
Abstract
A member unique name (MUN) structure and MUN translation system and method are provided. The MUN structure comprises a canonical business key for uniquely identifying a member across different dimensional data sources within a business enterprise and at least one of a dimension reference for defining the context in which the remaining portions of the MUN exist or a data source identifier (DSI) for uniquely identifying a member within a dimensional data source that implements its own unique member identifiers. The MUN translation system comprises a translation selection module for selecting a MUN transformation and a collection of MUN transformations for transforming a MUN structure of a first data source into a MUN structure of the second data source. The collection of MUN transformations comprises at least one of a different source technology OLAP to OLAP transformation for transforming a third OLAP MUN to a fourth OLAP MUN or a Dimensionally Modelled Relational (DMR) to OLAP transformation for transforming a DMR MUN to an OLAP MUN. The third OLAP MUN and fourth OLAP MUN are of different source technologies. The method comprises the steps of selecting a MUN transformation and transforming a MUN of a first data source into a MUN of the second data source. The step of transforming comprises at least one of the steps of transforming a first OLAP MUN to a second OLAP MUN, the first OLAP MUN and second OLAP MUN are of different source technologies or transforming a DMR MUN to an OLAP MUN.