A plug-and-play master data consistency monitoring method for master data management systems

Abstract

This invention belongs to the field of digital business management, specifically relating to a plug-and-play master data consistency monitoring method for master data management systems. Existing master data management systems require customized development for different types of master data for monitoring and comparison, resulting in high costs and difficulties in modification and maintenance. This invention achieves configurability of monitoring content, monitoring attributes, attribute mapping, and monitoring mechanisms by abstracting the master data monitoring model. This enables flexible, on-demand configuration and changes to master data monitoring in business systems, without relying on customized development by developers, thus improving the efficiency of master data monitoring and modification.

Description

Technical Field

[0001] This invention belongs to the field of digital business management, specifically relating to a plug-and-play master data consistency monitoring method for master data management systems. Background Technology

[0002] Master data management occupies a core and fundamental position in an enterprise's information strategy, serving as the central hub for basic data. Controlled through a master data management system, master data management enables enterprises to use consistent and shared master data across systems, providing high-quality, coordinated master data from authoritative data sources, reducing costs and complexity, and thus supporting cross-departmental and cross-system data integration and applications.

[0003] Currently, master data management processes and cleans collected master data according to business rules and data quality standards, establishes a workflow approval mechanism for master data creation and modification, and synchronizes various related systems with the master data management system. This facilitates the modification, monitoring, and updating of master data changes in related systems, thereby achieving master data consistency. However, these processes involve manual management, online approval, and interface synchronization, and errors can occur at any stage, leading to inconsistencies between the master data management system and business systems. Therefore, a data consistency comparison function between the master data management system and business systems is needed to monitor and ensure master data consistency. However, the existing master data management system's monitoring and comparison requires customized development for different types of master data, such as... Figure 1 As shown, the high cost and difficulty in changing and maintaining master data make it difficult to achieve rapid monitoring of various master data, avoid custom development, and reduce maintenance costs. These are issues that those responsible for master data management information system construction need to consider. Summary of the Invention

[0004] The purpose of this invention is to enable the configuration of monitoring content, monitoring attributes, attribute mapping, and monitoring mechanisms by abstracting the master data monitoring model, thereby achieving flexible configuration changes for on-demand monitoring of master data in business systems, without relying on custom development by developers, and improving the efficiency of master data monitoring and changes.

[0005] This invention proposes a plug-and-play master data consistency monitoring method for master data management systems. This method requires establishing a master data monitoring model between the master data management system and business systems. This model includes a master data model, monitoring comparison attributes, attribute mapping, monitoring business systems, monitoring business system interfaces, interface parameters, monitoring permissions, and monitoring methods. The monitoring includes the following steps:

[0006] S1. The master data business manager configured in the master data model requests monitoring and describes the monitoring requirements;

[0007] S2. The master data administrator configures the corresponding monitoring information in the master data monitoring model based on the monitoring requirements;

[0008] S3, the master data monitoring model reads the configured monitoring information and automatically generates an intermediate database;

[0009] S4. The master data monitoring model periodically reads and calls the monitoring business system interface in the monitoring information, and marks the collection status as ready to collect.

[0010] S5. The master data monitoring model pushes data synchronously to the intermediate database through the monitoring business system interface. After the data collection is completed, the collection status is marked as completed.

[0011] S6. The master data monitoring model performs the corresponding comparison operation according to the configured attribute comparison rules;

[0012] S7. After the comparison is completed, the master data monitoring model will send the comparison results to the master data business manager.

[0013] S8. The person in charge of master data business reviews and processes the monitoring results to ensure master data consistency.

[0014] Advantageously, the master data model includes a monitoring subject for master data; monitoring comparison attributes include a business primary key used to uniquely identify the comparison data; attribute mapping includes a configuration mapping relationship with the business dictionary; the monitoring business system is the business system that monitors and compares with the master data; the monitoring business system interface and interface parameters represent the interface address and parameters for obtaining the master data of the business system; monitoring permissions are used to verify user terminal permissions; and the monitoring methods are manual and scheduled.

[0015] Advantageously, the master data monitoring model includes a configuration unit, a monitoring unit, a data acquisition unit, a comparison unit, and a transmission unit.

[0016] Advantageously, the intermediate database table name is the main data model + "_JK", and the table attributes refer to the configured monitoring comparison attributes.

[0017] Advantageously, after receiving the "collection complete" instruction, the master data monitoring model reads the monitoring information, obtains the monitoring comparison attributes, attribute mapping relationships and monitoring permissions of the master data, queries and obtains the latest version of the master data in the master data management system according to the monitoring permissions, and compares it with the business system master data in the intermediate database according to the unique identifier, business primary key and attribute type configured in the monitoring comparison attributes.

[0018] Advantageously, when comparing attributes, if the attribute type is a business dictionary, it is also necessary to perform conversion and comparison in conjunction with the attribute mapping relationship.

[0019] Advantageously, after the comparison is completed, monitoring comparison statistics and detailed results are generated.

[0020] Advantageously, the detailed results are divided into three dimensions: data exists in the master data management system but not in the business system; no data exists in the master data management system but in the business system; and there are discrepancies between the data in the master data management system and the data in the business system.

[0021] Advantageously, for situations where there are differences between the master data management system and the business system, it is also necessary to list the differences by identifying the differences in the attribute identifiers.

[0022] This method solves the problems of high development costs and difficult maintenance associated with custom master data monitoring. By using a configurable master data monitoring system, it ensures master data consistency, enables configurable monitoring, reduces custom development work, and improves efficiency. Attached Figure Description

[0023] Figure 1 This is a diagram illustrating a customized master data consistency monitoring method;

[0024] Figure 2 This is the master data monitoring model of the present invention;

[0025] Figure 3 This is a schematic diagram of the plug-and-play master data consistency monitoring method for master data management systems according to the present invention;

[0026] Figure 4 This example illustrates the process of monitoring the master data of finished product suppliers. Detailed Implementation

[0027] like Figure 2 As shown, this invention summarizes the dimensions and methods of master data monitoring, abstracting a master data monitoring model, which mainly includes a master data model, monitoring comparison attributes, attribute mapping, monitoring business systems, monitoring business system interfaces, interface parameters, monitoring permissions, and monitoring methods. The master data model indicates which master data to monitor, such as supplier or human resources data; the monitoring comparison attributes indicate the attributes to be monitored and compared, and must include a business primary key for unique identification of the comparison data; the attribute mapping indicates that when business dictionaries are inconsistent, mapping relationships need to be configured to ensure data consistency; the monitoring business system refers to which business system the master data monitoring comparison will be performed against; the monitoring business system interface and interface parameters represent the interface address and parameters for obtaining the business system's master data; monitoring permissions are used to verify user terminal permissions; and the monitoring methods include manual and scheduled monitoring.

[0028] like Figure 3The diagram illustrates a plug-and-play master data consistency monitoring method. Based on the master data monitoring model, this method provides a plug-and-play master data consistency monitoring approach for master data management systems. It automatically generates an intermediate database corresponding to the master data model based on the configuration of the master data monitoring model, enabling unified collection of master data from various business systems. The collected business system data is then synchronized to the intermediate database, and the contents of the intermediate database and the master database are automatically compared to generate multi-dimensional data consistency comparison results. This achieves configurable and automated master data monitoring and comparison.

[0029] The following is combined Figure 4 The following is a further explanation through a specific implementation case of finished product supplier master data monitoring:

[0030] 1) In the master data management system, establish a master database for finished product suppliers, including data cleaning, transformation, modeling, and storage, and perform data initialization and online use;

[0031] 2) The person in charge of finished product supplier master data business applies to monitor finished product supplier master data and describes the corresponding monitoring requirements, such as which business systems to monitor, which attributes, attribute comparison rules, etc.

[0032] 3) After receiving the application, the person in charge of the master data management system configures the monitoring information corresponding to the monitoring requirements in the master data monitoring model through the configuration unit, such as master data model, monitoring comparison attributes, attribute mapping, monitoring business system, monitoring business system interface, interface parameters, monitoring permissions, monitoring methods, etc.

[0033] 4) The monitoring unit in the master data monitoring model reads the configured monitoring information and automatically generates an intermediate database for finished product suppliers;

[0034] 5) The monitoring unit in the master data monitoring model reads and calls the monitoring business system interface in the monitoring information, and marks the collection status as ready to collect.

[0035] 6) In the master data monitoring model, the acquisition unit pushes data synchronously to the intermediate database through the monitoring business system interface. After the acquisition is completed, the acquisition status is marked as acquisition completed.

[0036] 7) The comparison units in the master data monitoring model perform corresponding comparison operations according to the configured attribute comparison rules;

[0037] 8) After the comparison is completed, the sending unit of the master data monitoring model will send the comparison results to the master data manager of the finished product supplier configured in the master data model;

[0038] 9) The person in charge of the finished product supplier's master data reviews and processes the monitoring results to ensure master data consistency.

Claims

1. A plug-and-play master data consistency monitoring method for master data management systems, characterized in that: This method requires establishing a master data monitoring model between the master data management system and business systems. This model includes a master data model, monitoring comparison attributes, attribute mapping, monitoring business systems, monitoring business system interfaces, interface parameters, monitoring permissions, and monitoring methods. The master data model includes the monitoring subject of the master data; the monitoring comparison attributes include business primary keys used to uniquely identify the comparison data; the attribute mapping includes the configuration mapping relationship with the business dictionary; the monitoring business system is the business system compared with the master data monitoring; the monitoring business system interface and interface parameters represent the interface address and parameters for obtaining the business system's master data; monitoring permissions are used to verify user terminal permissions; the monitoring methods are manual and scheduled, and the monitoring includes the following steps: S1. The master data business manager configured in the master data model requests monitoring and describes the monitoring requirements; S2. The master data administrator configures the corresponding monitoring information in the master data monitoring model based on the monitoring requirements; S3, the master data monitoring model reads the configured monitoring information and automatically generates an intermediate database; S4. The master data monitoring model periodically reads and calls the monitoring business system interface in the monitoring information, and marks the collection status as ready to collect. S5. The master data monitoring model pushes data synchronously to the intermediate database through the monitoring business system interface. After the data collection is completed, the collection status is marked as completed. S6. The master data monitoring model performs the corresponding comparison operation according to the configured attribute comparison rules; S7. After the comparison is completed, the master data monitoring model will send the comparison results to the master data business manager. S8. The person in charge of master data business reviews and processes the monitoring results to ensure master data consistency.

2. The master data consistency monitoring method according to claim 1, characterized in that: The master data monitoring model includes a configuration unit, a monitoring unit, a data acquisition unit, a comparison unit, and a transmission unit.

3. The master data consistency monitoring method according to claim 1, characterized in that: The intermediate database table name is "main data model + "_JK", and the table attributes refer to the configured monitoring comparison attributes.

4. The master data consistency monitoring method according to claim 1, characterized in that: After receiving the "collection complete" instruction, the master data monitoring model reads the monitoring information, obtains the monitoring comparison attributes, attribute mapping relationships and monitoring permissions of the master data, queries and obtains the latest version of the master data in the master data management system according to the monitoring permissions, and compares it with the business system master data in the intermediate database according to the unique identifier, business primary key and attribute type configured in the monitoring comparison attributes.

5. The master data consistency monitoring method according to claim 4, characterized in that: When comparing attributes, if the attribute type is a business dictionary, it is also necessary to perform conversion and comparison in conjunction with the attribute mapping relationship.

6. The master data consistency monitoring method according to claim 1, characterized in that: After the comparison is completed, monitoring comparison statistics and detailed results are generated.

7. The master data consistency monitoring method according to claim 1, characterized in that: The detailed results are divided into three dimensions: data exists in the master data management system but not in the business system; no data exists in the master data management system but in the business system; and there are discrepancies between the data in the master data management system and the data in the business system.

8. The master data consistency monitoring method according to claim 7, characterized in that: If there are differences between the master data management system and the business system, it is also necessary to list the differences by identifying the differences in the attribute identifiers.

Images