A product master data standard unification method and platform for the electrical industry

Abstract

This invention discloses a method and platform for unifying product master data standards in the electrical industry, belonging to the field of industrial internet and data governance technology. The method includes: connecting to multiple heterogeneous data sources to obtain raw master data of electrical industry products; performing feature extraction and standardized mapping on the raw master data according to a pre-defined electrical industry data standard system to generate standard master data; establishing a dynamic mapping relationship between the raw master data and the standard master data; and encapsulating the standard master data into standardized data services and opening up calling interfaces to upstream and downstream partners in the industry chain. This invention solves the pain points of inconsistent product data standards and difficulty in interoperating multi-source heterogeneous data in the electrical industry. By constructing a unified data standard system and dynamic mapping mechanism, it achieves standardized governance and sharing of product master data, reduces industry chain collaboration costs, and enhances data value.

Description

Technical Field

[0001] This invention relates to the technical field of the electrical industry, and in particular to a method and platform for unifying product master data standards in the electrical industry. Background Technology

[0002] The electrical industry is a crucial foundation of the national economy, encompassing all aspects of power generation, transmission, distribution, and consumption, including thousands of categories such as transformers, switchgear, circuit breakers, wires and cables, motors, and automated control equipment. With the rapid development of the Industrial Internet and intelligent manufacturing, the digitalization and intelligence of electrical equipment are continuously improving, and data interaction between upstream and downstream enterprises in the industrial chain is becoming increasingly frequent. Product master data (such as product models, technical parameters, material codes, and supplier information) has become the core foundation for enterprise information management and industrial collaboration.

[0003] However, the following problems are commonly found in the current product master data management of the electrical industry: Data for electrical products is often scattered across different information systems within an enterprise, such as Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), and Supply Chain Management (SCM). Simultaneously, it needs to exchange data with external systems such as those of suppliers, design institutes, and maintenance service providers. These systems were built by different manufacturers at different times, resulting in vastly different data formats, encoding rules, and storage methods, leading to severe data silos and making data sharing and interoperability difficult.

[0004] Although national or industry standards for electrical products (such as GB / T series standards and IEC standards) have been issued, these standards typically only specify the technical requirements and test methods for some products, lacking unified and mandatory specifications for the classification, coding, and definition of key parameters of product master data. Each company often develops its own internal coding and naming rules based on its own habits, resulting in inconsistent descriptions of the same product model in different companies or systems, and even data misalignment between different departments within the same company. For example, for "molded case circuit breaker," some record it as "MCCB," while others record it as "molded case circuit breaker," and the parameter units may also be mixed up, using "A" and "ampere," causing serious semantic conflicts.

[0005] Due to the lack of unified standards and automated governance tools, a large amount of product master data suffers from issues such as duplication, errors, missing data, and expiration. While traditional ETL (Extract-Transform-Load) tools can convert data formats, they cannot solve deep-seated semantic heterogeneity problems and struggle to automatically identify and correct logical errors in the data. Manual data cleaning is not only inefficient but also prone to introducing new errors, making it difficult to meet the needs of large-scale, high-frequency data governance.

[0006] With the widespread application of new technologies such as the Industrial Internet Identifier Resolution System and active identifier carriers in the electrical industry, upstream and downstream enterprises in the industrial chain have placed higher demands on the real-time sharing and interoperability of product master data. For example, in the construction of smart grids, it is necessary to uniformly model and digitally transfer all electrical equipment in the network; in e-commerce procurement platforms, it is necessary to accurately match supplier product information with the material requirements of the purchaser; and in the full life cycle management of equipment, data consistency is required throughout the design, production, installation, and operation and maintenance stages. However, existing technologies lack a unified master data management platform that can cover the entire industrial chain, be compatible with multi-source heterogeneous data, and support dynamic mapping and real-time services. This makes it difficult to fully release the value of data and restricts the digital transformation process of the electrical industry.

[0007] In summary, existing technologies lack a method and platform that can achieve standardized, dynamic mapping, and efficient sharing of product master data tailored to the characteristics of the electrical industry. A new technical solution is urgently needed to address these issues. Summary of the Invention

[0008] This invention proposes a unified method and platform for product master data standards in the electrical industry, which solves the aforementioned problems existing in the use of existing technologies.

[0009] The technical solution of this invention is implemented as follows: A method for unifying product master data standards for the electrical industry, applied in a platform including a data acquisition layer, a data processing layer, and a standard service layer, is characterized by comprising the following steps: Step S1: Through the data acquisition layer, connect to multiple heterogeneous data sources to obtain the original master data of electrical industry products; the original master data includes at least product identification information, technical parameter information, material attribute information and supplier information; Step S2: Through the data processing layer, the original master data is cleaned and preprocessed, and according to the preset electrical industry data standard system, the cleaned data is feature extracted and standardized to generate standard master data that conforms to the standard system; wherein, the standard system is built based on national standards, industry standards and supply chain collaboration needs, and includes multi-level classification coding specifications, key parameter definition specifications and data interface specifications; Step S3: Establish a dynamic mapping relationship between the original master data and the standard master data through the mapping engine in the data processing layer, and store the mapping relationship in the mapping relationship library to support real-time conversion of data in different formats; Step S4: Through the standard service layer, the standard master data is encapsulated into a standardized data service, and the calling interface is opened to the information systems of authorized enterprises in the upstream and downstream of the industry chain to realize the unified release, query and exchange of product master data.

[0010] Preferably, step S1 involves interfacing with multiple heterogeneous data sources, specifically including: It connects with the enterprise's internal production management system, enterprise resource planning system, product lifecycle management system, as well as external supplier collaboration platforms, industry databases, and the national industrial internet identifier resolution system to obtain multi-source heterogeneous raw master data.

[0011] Preferably, step S2 involves feature extraction and normalization mapping, specifically including: The cleaned raw master data is segmented and semantically recognized to extract key feature fields; these key feature fields are matched with standard fields in the standard system; for fields that match successfully, they are converted according to the standard format; for fields that fail to match, they are categorized through manual annotation or machine learning models and added to the standard system.

[0012] Preferably, the standard system includes a product coding specification based on an active identification carrier, and the method further includes: A unique master data identifier is generated for each standard master data, and this identifier is written into an active identifier carrier. The active identifier carrier is integrated into electrical equipment or products and is used to realize the active uploading and parsing of master data at each node of the industrial chain.

[0013] Preferably, establishing the dynamic mapping relationship in step S3 specifically includes: For different types of original data sources, field mapping rules are constructed between the source data model and the target standard data model respectively; when the original master data is updated, the mapping engine is triggered to automatically perform data transformation and update the corresponding standard master data.

[0014] Preferably, step S4 encapsulates the data into a standardized data service, specifically including: The standard master data is encapsulated into a RESTful API service according to a preset interface protocol; the service includes at least a standard data query service, a data subscription and push service, and a data consistency verification service; the access control module performs identity authentication and access control on the caller.

[0015] A unified platform for product master data standards in the electrical industry, comprising the following methods: The data acquisition module is used to connect to multiple heterogeneous data sources to obtain the raw master data of electrical industry products; The data cleaning module is used to perform deduplication, error correction, completion, and format standardization on the original master data. The standard system storage module is used to store the pre-set electrical industry data standard system, including classification coding specifications, parameter definition specifications, and data interface specifications; The standardization processing module is used to extract features and standardize the cleaned data according to the standard system to generate standard master data. The mapping engine module is used to establish and store dynamic mapping relationships between raw master data and standard master data, supporting real-time data conversion; The service publishing module is used to encapsulate the standard master data into standardized data services and expose calling interfaces to external systems; The security management module is used to authenticate access devices and callers, and to encrypt transmitted data.

[0016] Preferably, the platform further includes: The metadata management module is used to maintain the metadata in the standard system, including adding, deleting, modifying, versioning and exporting metadata, and supports automatically adjusting the database table structure according to changes in metadata.

[0017] Preferably, the platform is deployed in the industrial internet cloud and adopts a cloud-edge collaborative architecture, including: The cloud center is used to centrally store the standard system and global standard master data, and to perform complex standardization processing tasks; Edge nodes, deployed on the enterprise side, are used to collect raw master data in real time and perform preliminary cleaning. They also support local standardized processing and data service calls in the event of a network outage.

[0018] In summary, compared with existing technologies, the product master data standard unification method and platform provided by this invention for the electrical industry has the following significant advantages: This invention constructs a data standard system for the electrical industry, encompassing multi-layered classification and coding standards, parameter definition standards, and data interface standards. Combined with a data acquisition layer that interfaces with internal and external heterogeneous systems such as ERP, PLM, and SCM, it enables unified cleaning, feature extraction, and standardized mapping of raw master data scattered across different systems. This solves the data silo problem caused by diverse data formats and inconsistent coding rules in existing technologies, achieving deep data integration and standardized governance across systems, enterprises, and processes. It provides the electrical industry with a data foundation of "one book, one network, and one standard." This invention establishes and stores a dynamic mapping relationship between the original master data and the standard master data, and sets up a mapping engine to respond in real time to changes in the original data. This overcomes the shortcomings of traditional ETL tools, which only support batch timed transformations and cannot handle high-frequency data changes. When upstream system data is updated, it can automatically trigger data transformation, ensuring the real-time nature and accuracy of the standard master data, and significantly improving the efficiency and timeliness of data synchronization.

[0019] This invention encapsulates standard master data into standardized data services such as RESTful APIs through a standard service layer, and integrates access control and data encryption functions. This allows authorized enterprises such as suppliers, manufacturers, and maintenance providers across the industry chain to call unified data interfaces as needed. It changes the high-cost collaboration model of previous point-to-point interface development and repeated data format adaptation, significantly reducing the technical threshold and development costs for system integration, and accelerating data flow and business collaboration in the electrical industry.

[0020] This invention generates a unique identifier for each standard master data point and integrates an active identification carrier, supporting proactive uploading and traceability of data sources. Combined with encrypted transmission and identity authentication by a security management module, it effectively prevents the risk of data leakage and tampering during transmission and retrieval. Simultaneously, it adopts a cloud-edge collaborative architecture, executing complex standardized tasks in the cloud and performing localized data cleaning and service calls at the edge. This ensures centralized control of global data while meeting the enterprise's real-time response and offline availability requirements, thus resolving the network latency and reliability bottlenecks caused by centralized processing of large-scale industrial data.

[0021] This invention maintains metadata within the standard system through a metadata management module. It supports adding, deleting, modifying, and versioning standard fields and classification codes based on updates to national standards or changes in industry needs. Furthermore, it automatically adjusts the database table structure according to metadata changes. This overcomes the limitations of fixed standard systems that struggle to adapt to rapid industry development, giving the platform excellent scalability and foresight, and enabling it to continuously meet the data governance needs of emerging new products and business models in the electrical industry.

[0022] By deduplicating, correcting, completing, and semantically recognizing the original master data, this invention can automatically identify and correct logical errors and duplicate records in the data, solving the problems of low efficiency and error-proneness in manual data processing. Standardized, high-quality master data provides reliable data support for business scenarios such as product selection, inventory optimization, procurement price comparison, and equipment operation and maintenance, further exploring and releasing the potential value of data elements and assisting enterprises in making more accurate business decisions. In summary, this invention provides the electrical industry with a complete, efficient, and secure unified solution for product master data standards, which powerfully promotes the digital transformation and high-quality development of the electrical industry. Detailed Implementation

[0023] The technical solutions of the present invention will be clearly and completely described below with reference to the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative effort are within the scope of protection of the present invention. Example

[0024] This embodiment discloses a method for unifying product master data standards for the electrical industry, applied to a platform including a data acquisition layer, a data processing layer, and a standard service layer. The method comprises the following steps: Step S1: Through the data acquisition layer, multiple heterogeneous data sources are connected to obtain the original master data of electrical industry products; the original master data includes at least product identification information, technical parameter information, material attribute information, and supplier information; Step S2: Through the data processing layer, the original master data is cleaned and preprocessed, and according to a pre-defined electrical industry data standard system, feature extraction and standardized mapping are performed on the cleaned data to generate a standard body. The system comprises standard master data; wherein the standard system is constructed based on national standards, industry standards, and supply chain collaboration needs, and includes multi-level classification and coding specifications, key parameter definition specifications, and data interface specifications; Step S3: Through the mapping engine in the data processing layer, a dynamic mapping relationship between the original master data and the standard master data is established, and the mapping relationship is stored in the mapping relationship library to support real-time conversion of data in different formats; Step S4: Through the standard service layer, the standard master data is encapsulated into standardized data services, and the calling interface is opened to the information systems of authorized enterprises in the upstream and downstream of the supply chain to realize the unified release, query, and exchange of product master data.

[0025] In step S1, multiple heterogeneous data sources are connected, specifically including: connecting to the enterprise's internal production management system, enterprise resource planning system, and product lifecycle management system, as well as external supplier collaboration platforms, industry databases, and the National Industrial Internet Identifier Resolution System, to obtain multi-source heterogeneous raw master data. Step S2 involves feature extraction and standardized mapping, specifically including: performing word segmentation and semantic recognition on the cleaned raw master data to extract key feature fields; matching the key feature fields with standard fields in the standard system; converting successfully matched fields according to the standard format; and classifying unmatched fields through manual annotation or machine learning models and adding them to the standard system.

[0026] Preferably, the standard system includes a product coding specification based on an active identification carrier, and the method further includes: A unique master data identifier is generated for each standard master data, and this identifier is written into an active identifier carrier. The active identifier carrier is integrated into electrical equipment or products and is used to realize the active uploading and parsing of master data at each node of the industrial chain.

[0027] Preferably, establishing a dynamic mapping relationship in step S3 specifically includes: constructing field mapping rules between the source data model and the target standard data model for different types of original data sources; when the original master data is updated, triggering the mapping engine to automatically perform data transformation and update the corresponding standard master data. Encapsulating the data into a standardized data service in step S4 specifically includes: encapsulating the standard master data into a RESTful API service according to a preset interface protocol; the service includes at least a standard data query service, a data subscription push service, and a data consistency verification service; and performing identity authentication and access control for the caller through the permission management module. A method for a unified platform for product master data standards in the electrical industry includes: a data acquisition module for connecting to multiple heterogeneous data sources to acquire raw master data of electrical industry products; a data cleaning module for deduplication, error correction, completion, and format standardization of the raw master data; a standard system storage module for storing a pre-defined electrical industry data standard system, including classification coding specifications, parameter definition specifications, and data interface specifications; a standardization processing module for extracting features and standardizing the cleaned data according to the standard system to generate standard master data; a mapping engine module for establishing and storing a dynamic mapping relationship between the raw master data and the standard master data, supporting real-time data conversion; a service publishing module for encapsulating the standard master data into standardized data services and opening calling interfaces to external systems; and a security management module for authenticating access devices and callers and encrypting transmitted data.

[0028] Preferably, the platform further includes a metadata management module for maintaining the metadata in the standard system, including adding, deleting, modifying, versioning, and exporting metadata, and supporting automatic adjustment of the database table structure based on metadata changes. The platform is deployed in the industrial internet cloud, adopting a cloud-edge collaborative architecture, including: a cloud center for centrally storing the standard system and global standard master data, and performing complex standardization processing tasks; and edge nodes deployed on the enterprise side for real-time collection of raw master data and preliminary cleaning, supporting local standardization processing and data service calls in the event of a network outage.

[0029] To more clearly illustrate the technical solutions of the embodiments of the present invention, the following will describe in detail a method and platform for standardizing product master data for the electrical industry, in conjunction with specific application scenarios. This embodiment uses a large domestic electrical group (hereinafter referred to as "the Group") as the application subject. The Group covers multiple product lines including power transmission and distribution equipment, automation control equipment, and wires and cables, and has more than 10 subsidiaries and over 200 upstream and downstream suppliers. Internally, it has deployed multiple heterogeneous information systems such as ERP, PLM, and SCM, resulting in serious data silos, semantic conflicts, and data quality issues. Therefore, it urgently needs to achieve standardized management and collaborative sharing of product master data through the solution of the present invention.

[0030] I. Implementation Preparation 1.1 Platform Deployment In this embodiment, the unified platform for product master data standards for the electrical industry adopts a cloud-edge collaborative architecture and is deployed on the group's industrial internet cloud. The specific deployment scheme is as follows: Cloud Center: Deployed in the group's headquarters computer room, it adopts a distributed server cluster and is equipped with a standard system storage module, a standardized processing module, a mapping engine module, a service publishing module, a security management module, and a metadata management module. It is responsible for centrally storing the electrical industry data standard system and global standard master data, performing complex standardized processing tasks (such as semantic recognition and batch data conversion), and providing a unified data service interface to the outside world.

[0031] Edge nodes: Edge computing devices are deployed in the factories of the group's subsidiaries and core suppliers. They are equipped with data acquisition and data cleaning modules and are responsible for collecting raw master data from the internal systems of each enterprise in real time, performing preliminary cleaning (duplicate removal and format standardization), supporting local standardized processing and basic data service calls in the event of a network outage, and synchronizing the data to the cloud center after the network is restored.

[0032] 1.2 Standards System Construction Based on national GB / T series standards (such as GB / T 14048.1 "Low-voltage switchgear and controlgear - Part 1: General") and IEC international standards (such as IEC 60694 "High-voltage switchgear and controlgear"), and combined with the group's business needs and supply chain collaboration requirements, a master data standard system for electrical industry products has been constructed, specifically including the following: Classification and Coding Standards: A multi-level classification structure is adopted. The first-level classification includes four major categories: "Power Generation Equipment," "Power Transmission and Distribution Equipment," "Power Consumption Equipment," and "Automation Control Equipment." The second-level classification is further subdivided into each major category (e.g., power transmission and distribution equipment is divided into circuit breakers, transformers, switchgear, etc.). The third-level classification is the specific product model. The coding uses an 18-character code. The first 6 characters are the classification code, the middle 8 characters are the product feature code, and the last 4 characters are the unique serial number. For example, the first-level classification code for "molded case circuit breaker" is 02, the second-level classification code is 03, and the third-level classification code is 01. The coding example is 020301XXXXXXXX0001.

[0033] Key parameter definition specifications: Clearly define the core technical parameters, field names, data types, units, and value ranges for each product type. For example, for molded case circuit breakers, key parameters include "rated current" (data type: numerical value, unit: A), "rated voltage" (data type: numerical value, unit: kV), and "breaking capacity" (data type: numerical value, unit: kA), etc. Unify parameter expressions (e.g., prohibit the mixing of "ampere" and "A", and uniformly use "A" as the current unit).

[0034] Data Interface Specification: Specifies that data interaction adopts the RESTful API protocol, and clarifies the interface request format, response format, parameter description, and call frequency limit; at the same time, it defines the active identification carrier encoding specification, generates a unique 16-bit master data identifier code for each standard master data, and is compatible with active identification carriers such as RFID and NFC.

[0035] 1.3 Data Source Integration Through the platform's data acquisition module, it connects with heterogeneous data sources from the group and its upstream and downstream partners, specifically including: Internal enterprise systems: ERP system of the group and its subsidiaries (used to obtain material codes, inventory information, and supplier association information), PLM system (used to obtain product design parameters, model specifications, and life cycle information), and SCM system (used to obtain upstream and downstream supply chain data and procurement information). External systems: Collaboration platforms of core suppliers (used to obtain product parameters and quotation information provided by suppliers), industry databases (such as the China Electrical Equipment Industry Database), and the National Industrial Internet Identifier Resolution System (used to obtain product identifier-related data).

[0036] Data acquisition employs a combination of real-time and scheduled acquisition. Real-time acquisition is used to obtain frequently updated data (such as inventory changes and supplier product parameter updates), while scheduled acquisition (at 2:00 AM daily) is used to obtain batches of static data (such as historical product records and basic material information).

[0037] II. Implementation Process of Standardizing Product Master Data This embodiment is executed according to steps S1 to S4 of the method described in this invention, and the specific process is as follows: Step S1: Raw Master Data Acquisition By connecting to all the aforementioned heterogeneous data sources through the data acquisition module, the original master data of electrical industry products was obtained, covering product identification information (product name, model, manufacturer), technical parameter information (rated current, rated voltage, breaking capacity, etc.), material attribute information (material code, material, specifications and dimensions), and supplier information (supplier name, qualifications, contact information). In this implementation, a total of 1.2 million original master data records were obtained in the first collection, involving 8 major categories and 32 subcategories of products, including circuit breakers, transformers, switchgear, and wires and cables. The data formats included XML, JSON, Excel, relational database tables, and other types. There was a large amount of duplicate, erroneous, and semantically conflicting data (for example, the same molded case circuit breaker was recorded as "MCCB-100A" in the ERP system and as "molded case circuit breaker 100 amps" in the PLM system).

[0038] Step S2: Data Cleaning and Standardization Mapping First, the raw master data is preprocessed through the data cleaning module of the data processing layer: Deduplication: Deduplication rules were constructed based on product model and core parameter combinations to delete duplicate records. A total of 83,000 duplicate records were deleted in this process. Error correction: Based on preset parameter verification rules (such as rated current range and voltage unit specifications), erroneous data is identified and corrected (e.g., "rated current 1000A" is corrected to "rated current 100A", and "voltage 1000V" is corrected to "voltage 1kV"). A total of 57,000 erroneous data entries were corrected. Data completion: For missing key parameters (such as the missing "splitting capability" parameter for some products), data was completed by linking industry databases and obtaining supplementary submissions from suppliers, resulting in the completion of 32,000 missing data entries. Format standardization: Convert data of different formats into JSON format and standardize parameter units and field names (e.g., change "Ampere" to "A" and "Model Specification" to "Product Model").

[0039] Subsequently, feature extraction and normalization mapping are performed: The cleaned raw master data underwent word segmentation and semantic recognition (using a BERT-based machine learning model) to extract key feature fields (such as product name, rated current, rated voltage, etc.). The extracted key feature fields were then matched with standard fields in the standard system. For fields that matched successfully, they were converted according to the standard format (e.g., converting "MCCB-100A" to the standard name "molded case circuit breaker", and generating the code "020301XXXXXXXX0001" according to the classification coding specification). For fields that failed to match (such as special parameters of some new product models), they were manually annotated (by 5 electrical industry technical experts) and added to the standard system. A total of 12 new parameter fields were added this time to improve the content of the standard system.

[0040] At the same time, a unique 16-bit master data identifier (such as 0203010000000001) is generated for each standard master data, and this identifier is written into the RFID active identification carrier and integrated into the corresponding electrical equipment or product packaging for active uploading and parsing of master data at each node of the industrial chain.

[0041] Step S3: Establishing dynamic mapping relationships Through the mapping engine module of the data processing layer, field mapping rules between the source data model and the target standard data model are constructed for different types of raw data sources: For ERP system data sources, establish mapping rules between "material codes" and standard system "product codes", and between "inventory quantities" and standard system "inventory information"; For PLM system data sources, establish mapping rules between "design model" and "product model" in the standard system, and between "design parameters" and "technical parameters" in the standard system; For the data source of the supplier collaboration platform, establish mapping rules between "supplier product model" and "product code" in the standard system, and between "supplier quotation" and "reference price" in the standard system.

[0042] All mapping rules are stored in a mapping relationship database, and a trigger mechanism is set up: when the original master data is updated (such as a supplier updating product quotations or the PLM system updating product design parameters), the mapping engine is automatically triggered to perform data transformation and synchronously update the corresponding standard master data. For example, if a supplier updates the price of "MCCB-100A molded case circuit breaker" from 1200 yuan to 1150 yuan through a collaborative platform, the mapping engine automatically recognizes the update, matches the corresponding standard master data (code 020301XXXXXXXX0001), and updates its "reference price" field to 1150 yuan, ensuring the real-time performance and accuracy of the standard master data.

[0043] Step S4: Standardized Data Service Publishing and Invocation Through the service publishing module of the standard service layer, standard master data is encapsulated into standardized data services according to the RESTful API protocol, specifically including: Standard data query service: Supports querying standard master data by product code, product name, core parameters and other conditions, and returns complete standard information (including code, parameters, supplier information, etc.). Data subscription push service: Supports upstream and downstream enterprises to subscribe to master data of specific types of products. When the master data of such products is updated, the update information is automatically pushed to the subscriber's system. Data consistency verification service: Supports enterprises to upload their own system's product data for consistency verification with the platform's standard master data, and returns verification results and correction suggestions.

[0044] The security management module performs identity authentication on access devices and callers (using key authentication + IP whitelist dual authentication), and encrypts transmitted data using AES-256 to ensure data security. The API is open to all subsidiaries and authorized upstream and downstream suppliers within the group, allowing each enterprise to call standardized data services according to its own business needs. The group's procurement department can query standard master data of supplier products through interfaces to achieve accurate matching between procurement needs and supplier products, thereby reducing procurement errors. Subsidiary production department: Obtains standard master data through interfaces to ensure that product parameters are consistent with standards during the production process, thereby improving product quality; Suppliers: Upload their own product data through the interface, and after platform verification, it is incorporated into the standard master data system, achieving seamless integration with the group system and reducing integration costs.

[0045] III. Implementation of Additional Platform Functions The metadata management module maintains the metadata within the standard system. When national or industry standards are updated (e.g., GB / T 14048.1 replaces the old standard), technical personnel modify the classification codes and parameter definitions in the standard system using the module. When new electrical products (e.g., new intelligent circuit breakers) appear, corresponding classification codes and parameter fields are added, and the database table structure is automatically adjusted to ensure the timeliness and scalability of the standard system. In this implementation, the metadata management module completed two standard updates and added metadata definitions for three new product categories.

[0046] The cloud center is responsible for centrally storing global standard master data and performing complex standardization processes (such as batch semantic recognition and large-scale data transformation), while edge nodes are responsible for local data collection and preliminary cleaning. When a subsidiary's factory area experiences a network outage, the edge nodes can independently perform local standardization processes to ensure the normal access to data services during production. After the network is restored, the local data is automatically synchronized to the cloud center to ensure the consistency of global data.

[0047] In summary, the unified method and platform for product master data standards in the electrical industry provided by this invention can effectively solve problems such as data silos, semantic conflicts, poor data quality, and low collaboration efficiency in the management of product master data in the electrical industry. It provides reliable data support for the digital transformation of the electrical industry and has good practicality and promotion value.

[0048] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the protection scope of the present invention.

Claims

1. A method for unifying product master data standards in the electrical industry, applied to a platform including a data acquisition layer, a data processing layer, and a standard service layer, characterized in that: Includes the following steps: Step S1: Through the data acquisition layer, connect to multiple heterogeneous data sources to obtain the original master data of electrical industry products; the original master data includes at least product identification information, technical parameter information, material attribute information and supplier information; Step S2: Through the data processing layer, the original master data is cleaned and preprocessed, and according to the preset electrical industry data standard system, the cleaned data is feature extracted and standardized to generate standard master data that conforms to the standard system; wherein, the standard system is built based on national standards, industry standards and supply chain collaboration needs, and includes multi-level classification coding specifications, key parameter definition specifications and data interface specifications; Step S3: Establish a dynamic mapping relationship between the original master data and the standard master data through the mapping engine in the data processing layer, and store the mapping relationship in the mapping relationship library to support real-time conversion of data in different formats; Step S4: Through the standard service layer, the standard master data is encapsulated into a standardized data service, and the calling interface is opened to the information systems of authorized enterprises in the upstream and downstream of the industry chain to realize the unified release, query and exchange of product master data.

2. The method for unifying product master data standards for the electrical industry according to claim 1, characterized in that, Step S1, which involves connecting to multiple heterogeneous data sources, specifically includes: It connects with the enterprise's internal production management system, enterprise resource planning system, product lifecycle management system, as well as external supplier collaboration platforms, industry databases, and the national industrial internet identifier resolution system to obtain multi-source heterogeneous raw master data.

3. The method for unifying product master data standards for the electrical industry according to claim 1, characterized in that, The feature extraction and normalization mapping performed in step S2 specifically include: The cleaned raw master data is segmented and semantically recognized to extract key feature fields; these key feature fields are matched with standard fields in the standard system; for fields that match successfully, they are converted according to the standard format; for fields that fail to match, they are categorized through manual annotation or machine learning models and added to the standard system.

4. The method for unifying product master data standards for the electrical industry according to claim 1, characterized in that, The standard system includes product coding specifications based on active identification carriers, and the method further includes: A unique master data identifier is generated for each standard master data, and this identifier is written into an active identifier carrier. The active identifier carrier is integrated into electrical equipment or products and is used to realize the active uploading and parsing of master data at each node of the industrial chain.

5. The method for unifying product master data standards for the electrical industry according to claim 1, characterized in that, The establishment of the dynamic mapping relationship in step S3 specifically includes: For different types of original data sources, field mapping rules are constructed between the source data model and the target standard data model respectively; when the original master data is updated, the mapping engine is triggered to automatically perform data transformation and update the corresponding standard master data.

6. The method for unifying product master data standards for the electrical industry according to claim 1, characterized in that, The process of encapsulating data into a standardized data service in step S4 specifically includes: The standard master data is encapsulated into a RESTful API service according to a preset interface protocol; the service includes at least a standard data query service, a data subscription and push service, and a data consistency verification service; the access control module performs identity authentication and access control on the caller.

7. A unified platform for product master data standards in the electrical industry, used to implement the method described in any one of claims 1-6, characterized in that, include: The data acquisition module is used to connect to multiple heterogeneous data sources to obtain the raw master data of electrical industry products; The data cleaning module is used to perform deduplication, error correction, completion, and format standardization on the original master data. The standard system storage module is used to store the pre-set electrical industry data standard system, including classification coding specifications, parameter definition specifications, and data interface specifications; The standardization processing module is used to extract features and standardize the cleaned data according to the standard system to generate standard master data. The mapping engine module is used to establish and store dynamic mapping relationships between raw master data and standard master data, supporting real-time data conversion. The service publishing module is used to encapsulate the standard master data into standardized data services and expose calling interfaces to external systems; The security management module is used to authenticate access devices and callers, and to encrypt transmitted data.

8. The unified platform for product master data standards in the electrical industry according to claim 7, characterized in that, The platform also includes: The metadata management module is used to maintain the metadata in the standard system, including adding, deleting, modifying, versioning and exporting metadata, and supports automatically adjusting the database table structure according to changes in metadata.

9. The unified platform for product master data standards in the electrical industry according to claim 7, characterized in that, The platform is deployed in the industrial internet cloud and adopts a cloud-edge collaborative architecture, including: The cloud center is used to centrally store the standard system and global standard master data, and to perform complex standardization processing tasks; Edge nodes, deployed on the enterprise side, are used to collect raw master data in real time and perform preliminary cleaning. They also support local standardized processing and data service calls in the event of a network outage.