Master Data Management Statistics Dashboard

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Master data management consolidation processes are time-consuming and costly, making it difficult for enterprises to determine the benefits and justify the resources devoted to these programs, as the effectiveness of the consolidation is hard to quantify.

Innovation Solution

A system and method for providing master data management statistics through a two-phase process of identifying duplicates and merging records, using a rule-based mechanism to automate the consolidation, and displaying statistics in a dashboard format to demonstrate the program's impact, including record distribution, cleansing, matching, and consumption data.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If master data management consolidation is performed manually or with basic automation, then record matching and merging can be achieved, but the process becomes time-consuming and costly

Engineering Contradiction:

Improveaccuracy of record matchingVSAvoidconsolidation process time

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The patent replaces manual mechanical review processes with automated statistical analysis and machine learning algorithms. The system automatically calculates match probabilities, generates consolidation recommendations, and provides statistical evidence for decision-making, eliminating the need for time-consuming manual verification while maintaining high accuracy through algorithmic analysis of multiple data sources

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The patent creates statistical models and digital representations of consolidation outcomes that can be analyzed and validated before actual implementation. By generating virtual copies of matched records with associated confidence scores and statistical metrics, the system allows stakeholders to review and approve consolidations efficiently without time-consuming manual processing of each individual record

Inventive Principle:

Principle #26Copying

2Reliability

If extensive master data management consolidation is performed on millions of records, then data quality improves, but the cost and resource requirements increase significantly

Engineering Contradiction:

Improvedata qualityVSAvoidcomputational resources and costs

Core Design Contradiction:

ReliabilityVSLoss of energy

Solution Approach 1:

The patent segments the consolidation process into distinct statistical analysis phases: data profiling, duplicate detection, match probability calculation, and consolidation recommendation. Each phase processes only the necessary subset of records with appropriate computational methods, avoiding the need to apply full computational power to all millions of records simultaneously, thereby reducing overall resource consumption while maintaining data quality

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent dynamically adjusts computational parameters such as match threshold probabilities, sampling rates, and analysis depth based on data characteristics and stakeholder requirements. By changing these parameters, the system can optimize the balance between data quality improvement and resource consumption, performing more detailed analysis only where necessary and using lighter-weight methods for routine consolidations

Inventive Principle:

Principle #35Parameter changes

3Device complexity

If master data management consolidation is performed without statistical analysis, then the process is simpler, but it is difficult to demonstrate the benefits and justify resources

Engineering Contradiction:

Improvesystem complexityVSAvoidconsolidation benefits and metrics

Core Design Contradiction:

Device complexityVSLoss of information

Solution Approach 1:

The patent implements comprehensive statistical feedback mechanisms that automatically generate metrics on consolidation outcomes, including data quality improvements, duplicate elimination rates, and resource utilization statistics. These feedback reports provide objective evidence of benefits to stakeholders, enabling informed decision-making about resource allocation while maintaining relatively simple operational processes through automated tracking and reporting

Inventive Principle:

Principle #23Feedback

Data Source

PatentUS9336245B2Systems and methods providing master data management statistics

Publication Date: 2016.05.10 SAP SE

AI summary

According to some embodiments, a plurality of records may be received over a period of time from a plurality of sources. As the records are received during the period of time, master data management may be performed to match at least some records from different sources with each other. A statistics window within the period of time may be determined, and at least one master data management statistics value may be calculated based on the master data management that was performed during the statistics window. The calculated master data management statistics value may then be displayed.