Managing classification hierarchies in master data management environments

• US 8,595,269 B2
• Filed: 10/14/2011
• Issued: 11/26/2013
• Est. Priority Date: 09/02/2011
• Status: Active Grant

• Current Assignee: Infosys Limited
• Original Assignee: Infosys Limited
• Inventors: Farcasiu, Alexandru M., Radhakrishnan, Subramanian
• Primary Examiner(s): MOSER, BRUCE M
• Application Number:
  US13/274,178
• Publication Number:
  US 20130060825A1
• Time in Patent Office: 774 Days
• Field of Search: None
• US Class Current: 707/804
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Apparatus and methods are disclosed for managing master data in a master data management (MDM) environment using classification hierarchies. According to one embodiment of the disclosed technology, a method of classifying master data includes receiving a classification hierarchy defining one or more dimensions and one or more relations between a set of hierarchy levels, generating a dimensional level by associating at least one of the dimensions with a hierarchy level, the dimension defining a set of valid values for nodes associated with the dimensional level, associating one or more nodes with the dimensional level, and generating master data classifications for an MDM environment based on the classification hierarchy and the associated nodes, where one or more objects of the master data classifications are assigned valid values based on the associated nodes.

Claims

1. A computer-implemented method of developing master data classifications for a master data management (MDM) environment, the method comprising:

receiving a classification hierarchy defining one or more dimensions and one or more relations between a set of hierarchy levels, each of the hierarchy levels representing a collection of related objects in the MDM environment, and each of the dimensions representing a set of valid values for one or more nodes in the classification hierarchy;

generating a dimensional level by associating at least one of the dimensions with a level of the set of hierarchy levels, the at least one dimension defining a set of valid values for nodes associated with the dimensional level;

associating the dimensional level with one or more nodes;

receiving first input designating a node in the classification hierarchy as a dimensional node;

receiving selection input selecting two or more nodes to be associated with the dimensional node as dimensional combinations;

based on the selected nodes, selecting valid dimension values for the dimensional node; and

by a computer, generating master data classifications for the MDM environment based on the classification hierarchy and the associated nodes, the master data classifications including one or more objects assigned valid values based on the dimensional level and the associated nodes, the master data classifications including the valid dimension values for the dimensional node.

2. The method of claim 1, wherein the at least one dimension is an independent dimension associated with a respective one or more of the hierarchy levels regardless of values for nodes associated with the respective hierarchy level.

3. The method of claim 1, wherein the at least one dimension is a dependent dimension, wherein valid values for nodes associated with a respective one or more of the hierarchy levels for the dependent dimension are based at least in part on a value for a different node in the classification hierarchy.

4. The method of claim 1, wherein the generating the master data classifications further comprises:

receiving first input indicating that one of the dimensions is an independent dimension;

receiving second input indicating valid values for the independent dimension;

defining one or more dimensional levels based on the indicated valid values assigned to the indicated independent dimension.

5. The method of claim 1, further comprising defining the classification hierarchy by defining hierarchical relations between two or more levels of the classification hierarchy.

6. The method of claim 1, further comprising:

storing the master data classifications in an MDM repository;

generating a revised classification hierarchy based on the received classification hierarchy, the dimensional level, and the associated nodes; and

storing the revised classification hierarchy in an extended repository.

7. The method of claim 1, further comprising generating valid combinations for master data classification objects based on the dimensional level.

8. The method of claim 1, further comprising storing schemas, database records, or schemas and database records for the master data classifications in the MDM environment.

9. The method of claim 1, wherein not all possible combinations or dimensions associated with a respective hierarchy level are used as valid levels for at least one of the nodes associated with the dimensional level.

10. The method of claim 1, wherein the method further comprises activating a data synchronizer to update at least one MDM repository in the MDM environment when data changes are detected in the MDM environment.

11. One or more non-transitory computer-readable media storing computer-readable instructions that when executed by a computer, cause the computer to perform a method of generating mappings between objects in an MDM repository and a master data classification hierarchy stored in an extended repository, the method comprising:

receiving the master data classification hierarchy, the classification hierarchy defining relations between data elements of the classification hierarchy, the classification hierarchy including definitions of valid values for one or more of the data elements;

based on the master data classification hierarchy, generating one or more mappings between the data elements and a respective one or more object fields stored in the MDM repository to produce mapped object fields;

generating a set of unmapped object fields, unmapped object values, or unmapped object fields and unmapped object values stored in the MDM repository;

generating a set of unmapped data elements, unmapped valid values, or unmapped data elements and unmapped valid values in the classification hierarchy;

receiving input indicating a mapping between at least one or more of the unmapped object fields, object values, and unmapped object fields and object values, and at least one or more of the unmapped data elements, an unmapped valid values, and the unmapped data elements and an unmapped valid values; and

based on the indicated mapping, generating a mapping between the indicated fields, the indicated values, or the indicated fields and the indicated values.

12. The computer-readable media of claim 11, wherein the method further comprises:

selecting an object value associated with at least one of the mapped object fields, the object value being stored in the MDM repository; and

generating a mapping between the object value and one or more valid values for a data element mapped to the object field, the value values being determined by at least one of the relations of the master data classification hierarchy.

13. The computer-readable media of claim 11, wherein the method further comprises storing the mappings in an extended repository.

14. The computer-readable media of claim 11, wherein the mappings are generated using drag-and-drop functionality of a graphical user interface.

15. The computer-readable media of claim 11, wherein the method further comprises storing object data in the MDM repository based on the mapping.

16. The computer-readable media of claim 11, wherein the generating the mapping is performed automatically by using at least one or more of the following:

an MDM repository, an MDM extended repository, or a semantic dictionary.

20. A system comprising:

one or more processors configured to execute the computer-readable instructions stored on the computer-readable media of claim 11.

17. A computer-implemented method of generating two or more presentation hierarchies for an MDM environment, the method comprising:

receiving a classification hierarchy for the MDM environment,

generating a first presentation hierarchy and a second presentation hierarchy for the MDM environment, each of the presentation hierarchies being associated with a user role in the MDM environment, each of the presentation hierarchies including one or more presentation levels, one or more nodes of the first presentation hierarchy being mapped differently than one or more nodes of the second presentation hierarchy without redefining the classification hierarchy;

selecting one of the presentation levels;

selecting a level of the classification hierarchy to map to the selected presentation level; and

by a computer, generating a mapping between the selected level of the presentation hierarchy and one or more corresponding nodes of the selected classification hierarchy level.

18. The method of claim 17, further comprising presenting data from the MDM environment based on a selected presentation hierarchy, the presentation hierarchy being selected based on a user role in the MDM environment.

19. The method of claim 17, wherein the first presentation hierarchy is for internal use within an organization and the second presentation hierarchy is for use in an E-commerce product role.