CN113516459A - Bit number main data management system, method, terminal equipment and storage medium - Google Patents
Bit number main data management system, method, terminal equipment and storage medium Download PDFInfo
- Publication number
- CN113516459A CN113516459A CN202111071656.9A CN202111071656A CN113516459A CN 113516459 A CN113516459 A CN 113516459A CN 202111071656 A CN202111071656 A CN 202111071656A CN 113516459 A CN113516459 A CN 113516459A
- Authority
- CN
- China
- Prior art keywords
- code
- main data
- bit number
- management
- equipment
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a bit number main data management system, a method, a terminal device and a storage medium, wherein the bit number main data management system comprises: the system comprises a main data management platform, a data processing platform and a data processing platform, wherein the main data management platform is used for setting corresponding bit numbers aiming at equipment and materials of an enterprise so as to uniformly manage the equipment and the materials based on the bit numbers; and the enterprise service bus is respectively connected with the bit number master data management system built based on the master data management platform and a preset external business system. The invention not only can realize the unified management of the equipment and the materials involved in the enterprise operation process, but also can realize the information sharing between the main data system in the enterprise and the preset external system.
Description
Technical Field
The present invention relates to the field of data management technologies, and in particular, to a bit number master data management system, a bit number master data management method, a terminal device, and a storage medium.
Background
Master data is data that is shared between computer systems and is an important component of enterprise data. The main data management system built in the enterprise can order the complicated and huge data, reduce the management difficulty and promote the digital and intelligent development of the enterprise.
The current main data management system fails to manage equipment and materials in purchasing, manufacturing, engineering project, equipment operation and maintenance, quality management and other links in an enterprise, so that the phenomenon of disjointing among all links occurs in the operation process of the enterprise, managers cannot timely acquire change information of the equipment and the materials, and each business system is lack of interactivity before and cannot effectively cooperate with business.
Disclosure of Invention
The invention mainly aims to provide a bit number main data management system, a bit number main data management method, terminal equipment and a storage medium, aiming at avoiding the disjointing phenomenon in the enterprise management process and realizing the unified management of equipment and materials involved in the enterprise operation process.
To achieve the above object, the present invention provides a bit number master data management system, including:
the system comprises a main data management platform, a data processing platform and a data processing platform, wherein the main data management platform is used for setting corresponding bit numbers aiming at equipment and materials of an enterprise so as to uniformly manage the equipment and the materials based on the bit numbers;
and the enterprise service bus is respectively connected with the bit number master data management system built based on the master data management platform and a preset external business system.
In one embodiment, the master data management platform comprises:
the main data maintenance management module is used for creating, maintaining and managing main data of the equipment and the materials;
the main data modeling module is connected with the main data maintenance management module and used for modeling according to the equipment and the main data of the materials to obtain a business main data warehouse model;
the main data coding library module is connected with the main data modeling module and is used for obtaining a Work Breakdown Structure (WBS) code, a device code, a material code, a quality code and an order code of the device and the material according to the business main data warehouse model and coding to form the bit number.
In one embodiment, the bit number master data management system further includes:
and the basic service management module is respectively connected with the main data management platform and the enterprise service bus, and is used for performing basic management on the bit number main data management system.
In one embodiment, the bit number master data management system further includes:
and the system operation and maintenance module is respectively connected with the main data management platform and the enterprise service bus and is used for maintaining the bit number main data management system.
In addition, in order to achieve the above object, the present invention further provides a bit number main data management method, which is applied to the bit number main data management system described above, and the bit number main data management method includes:
acquiring the main data of the equipment and the material;
setting the corresponding bit numbers of the equipment and the materials aiming at the main data, and carrying out unified management on the equipment and the materials according to the bit numbers;
and sharing information with the preset external business system through the enterprise service bus.
Optionally, the step of setting the bit numbers corresponding to the device and the material for the main data includes:
modeling according to the equipment and the main data of the materials to obtain a business main data warehouse model;
and acquiring the item WBS code, the equipment code, the material code, the quality code and the order code of the equipment and the material according to the business main data warehouse model, and encoding to form the bit number.
Optionally, the item WBS code includes: the method comprises the following steps of (1) engineering total codes, engineering codes, units, unit engineering codes, step-by-step engineering codes, project codes and subsection engineering codes;
the device encoding includes: base code, equipment serial number, PBS (customer call management and tracking system) code, PBS spreading code, specialty code, and replacement serial number;
the material code includes: the material type code, the material characteristic code, the surface treatment code, the serial number and the serial number of the position are obtained;
the quality code includes: organizing code number, level number and sequence number;
the order code comprises: a customer code, an order serial number, and an order type code.
Optionally, the unified management includes: factory management, according to the said bit number to carry on the step of unified management to the said apparatus and the said supplies, including:
performing the factory management on the equipment and the material according to the bit number, wherein the factory management comprises: project management, equipment management, material management, quality management and order management.
In addition, to achieve the above object, the present invention further provides a terminal device, which includes a memory, a processor, and a bit number master data management program stored on the memory and executable on the processor, and when executed by the processor, the terminal device implements the steps of the bit number master data management method as described above.
In addition, to achieve the above object, the present invention further provides a storage medium having stored thereon a bit number master management program, which when executed by a processor, implements the steps of the bit number master management method as described above.
Furthermore, to achieve the above object, the present invention also provides a computer program product comprising a computer program which, when executed by a processor, implements the steps of the bit number master data management method as described above.
The invention provides a bit number main data management system, a method, a terminal device, a storage medium and a computer program product, wherein the bit number main data management system comprises: the system comprises a main data management platform, a data processing platform and a data processing platform, wherein the main data management platform is used for setting corresponding bit numbers aiming at equipment and materials of an enterprise so as to uniformly manage the equipment and the materials based on the bit numbers; and the enterprise service bus is respectively connected with the bit number master data management system built based on the master data management platform and a preset external business system.
The method and the system are characterized in that after equipment and material main data related to an enterprise operation process are obtained on the basis of a main data management platform, corresponding bit numbers are set for the equipment and the material main data, so that the equipment and the material are uniformly managed according to the bit numbers, and meanwhile, an enterprise service bus is connected with a bit number main data management system and a preset external service system on the basis of the main data management platform, so that the bit number main data management system and the preset external service system realize information sharing.
The invention not only can realize the unified management of the equipment and the materials involved in the enterprise operation process, but also can realize the information sharing between the main data system and the external system in the enterprise.
Drawings
Fig. 1 is a schematic terminal structure diagram of a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a block diagram of an embodiment of a bit number master data management system according to the present invention;
FIG. 3 is a diagram illustrating an exemplary application scenario of an embodiment of a bit number master data management system according to the present invention;
FIG. 4 is a flowchart illustrating a method for managing bit number master data according to an embodiment of the present invention;
the implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Referring to fig. 1, fig. 1 is a schematic terminal structure diagram of a hardware operating environment according to an embodiment of the present invention.
It should be noted that, the terminal device in the embodiment of the present invention may be a device that interfaces with a bit number master data management system, and the device may specifically be a smart phone, a personal computer, a server, and the like.
As shown in fig. 1, the apparatus may include: a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, a communication bus 1002. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1005 may be a high-speed RAM memory or a non-volatile memory (e.g., a magnetic disk memory). The memory 1005 may alternatively be a storage device separate from the processor 1001.
Those skilled in the art will appreciate that the configuration of the apparatus shown in fig. 1 is not intended to be limiting of the apparatus and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
As shown in fig. 1, a memory 1005, which is a kind of computer storage medium, may include therein an operating system, a network communication module, a user interface module, and a bit number master data management program. The operating system is a program that manages and controls the hardware and software resources of the device, supporting the operation of the bit number master data management program as well as other software or programs. In the device shown in fig. 1, the user interface 1003 is mainly used for data communication with a client; the network interface 1004 is mainly used for establishing communication connection with a server; and the processor 1001 may be configured to call the bit number master data manager stored in the memory 1005 and perform the following operations:
acquiring the main data of the equipment and the material;
setting the corresponding bit numbers of the equipment and the materials aiming at the main data, and carrying out unified management on the equipment and the materials according to the bit numbers;
and sharing information with the preset external business system through the enterprise service bus.
Further, the processor 1001 may be further configured to call the bit number master data management program stored in the memory 1005, and perform the following operations:
modeling according to the equipment and the main data of the materials to obtain a business main data warehouse model;
and acquiring the item WBS code, the equipment code, the material code, the quality code and the order code of the equipment and the material according to the business main data warehouse model, and coding to form the bit number.
Further, the item WBS code includes: the method comprises the following steps of (1) engineering total codes, engineering codes, units, unit engineering codes, step-by-step engineering codes, project codes and subsection engineering codes;
the device encoding includes: base code, equipment serial number, PBS code, PBS spreading code, specialty code, and replacement serial number;
the material coding comprises the following steps: the material type code, the material characteristic code, the surface treatment code, the serial number and the serial number of the position are obtained;
the quality encoding includes: organizing code number, level number and sequence number;
the order code comprises: a customer code, an order serial number, and an order type code.
Further, the unified management includes: for factory management, the processor 1001 may be further configured to call the bit number master data management program stored in the memory 1005, and perform the following operations:
performing the factory management on the equipment and the material according to the bit number, wherein the factory management comprises: project management, equipment management, material management, quality management and order management.
Further, based on the above hardware structure, an embodiment of the bit number master data management system of the present invention is provided. As shown in fig. 2, in an embodiment of the master data management system of the present invention, the bit number master data management system of the present invention includes:
the system comprises a main data management platform, a data processing platform and a data processing platform, wherein the main data management platform is used for setting corresponding bit numbers aiming at equipment and materials of an enterprise so as to uniformly manage the equipment and the materials based on the bit numbers;
and the enterprise service bus is respectively connected with the bit number master data management system built based on the master data management platform and a preset external business system.
In this embodiment, main data of equipment and materials related to an enterprise operation process is obtained based on a main data management platform, a bit number corresponding to the equipment and the materials is set for the main data, the equipment and the materials related to the enterprise operation process are managed in a unified manner according to the bit number, and meanwhile, the bit number main data management system and a preset external business system based on the main data management platform are connected through an enterprise service bus, so that the bit number main data management system and the preset external business system achieve information sharing.
It should be noted that, in this embodiment, the bit number master data management system includes: a master data management platform, and an enterprise service bus. And the master data management platform comprises: the system comprises a group data portal module, a subsidiary company data portal module, a main data maintenance management module, a main data modeling module, a data quality management module, a data security management module, a main data service module, a data flow approval module, a main data integration module, a data standard management module, a main data coding base module and a main data coding standard module.
Specifically, for example, as shown in a specific application scenario in fig. 3, the terminal device creates and manages main data of devices and materials based on a main data maintenance management module and a main data service module, performs data modeling on the main data created by the main data management module through a main data modeling module, a data stream approval module, a data standard management module and a main data integration module to obtain a business main data warehouse model, and encodes related devices and materials according to the business main data warehouse model through a main data encoding library module and a main data encoding specification module to obtain a bit number, and uniformly manages the devices and materials related to an enterprise operation process through the bit number. Meanwhile, quality management and safety management are carried out on the main data related to the main data in the main data management platform according to a data quality management module and a data safety management module in the main data management platform, an online platform is set up for the company through a group data portal module and a subsidiary company data portal module, the online platform can display information of company business for users, and a business retrieval function is provided for the company business. In addition, the position number main data management system and the preset external business system which are built based on the main data management platform are connected through an enterprise service bus, so that the position number main data management system and the preset external business system share information.
In one possible embodiment, the master data management platform includes:
the main data maintenance management module is used for creating, maintaining and managing main data of the equipment and the materials;
it should be noted that, in this embodiment, the master data maintenance management module includes a data creation unit, a data auditing unit, a maintenance management unit, a dictionary management unit, and a daily management unit.
Specifically, for example, as shown in a specific application scenario in fig. 3, the terminal device extracts all information of devices and materials involved in an enterprise operation process through the data creating unit and the data auditing unit, creates main data corresponding to the devices and the materials, and simultaneously manages and maintains the main data in time through the maintenance management unit, the dictionary management unit, and the daily management unit, so as to ensure security and stability of the enterprise operation process.
In one possible embodiment, the master data management platform further comprises:
the main data modeling module is connected with the main data maintenance management module and used for modeling according to the equipment and the main data of the materials to obtain a business main data warehouse model;
it should be noted that, in this embodiment, the main data modeling module includes: the system comprises an object definition unit, an encoding rule unit, an attribute definition unit and a flow definition unit.
Specifically, for example, after the terminal device obtains the main data of the device and the material generated by the main data maintenance management module, different subject domains are divided for the content of the main data through an object definition unit, an encoding rule unit, an attribute definition unit and a flow definition unit in the main data modeling module, a connection between the different subject domains is established, field names of the plurality of subject domains are standardized, service source data is generated, and the service source data is mapped and integrated into a data warehouse to form a service main data warehouse model.
In one possible embodiment, the master data management platform further comprises:
and the main data coding library module is connected with the main data modeling module and is used for acquiring the item WBS code, the equipment code, the material code, the quality code and the order code of the equipment and the material according to the business main data warehouse model and coding the item WBS code, the equipment code, the material code, the quality code and the order code to form the position number.
It should be noted that, in this embodiment, the main data encoding library module must comply with the main data encoding specification when encoding the WBS code, the equipment code, the material code, the quality code, and the order code in the main data, and the objects limited by the main data encoding specification include: item WBS code, equipment code, material code, quality code, and order code.
Specifically, for example, as shown in the specific application scenario of fig. 3, after the terminal device establishes a service master data warehouse model through a master data modeling module, the terminal device obtains master data of required devices and materials from the service master data warehouse model, numbers the master data of the devices and the materials according to a master data coding specification to obtain a WBS code, a device code, a material code, a quality code, and an order code, and codes the WBS code, the device code, the material code, the quality code, and the order code through a master data coding library to finally obtain a bit number composed of the WBS code, the device code, the material code, the quality code, and the order code.
In one possible embodiment, the bit number master data management system further includes:
and the basic service management module is respectively connected with the main data management platform and the enterprise service bus, and is used for performing basic management on the bit number main data management system.
It should be noted that, in this embodiment, the basic service management module includes: the system comprises a user management unit, a configuration management unit, a log management unit, a work flow engine unit and a task flow unit.
Specifically, for example, as shown in a specific application scenario in fig. 3, the terminal device enables a user management unit, a configuration management unit, a log management unit, a workflow engine unit, and a task flow unit in the basic service management module to manage a main data maintenance management process, a main data modeling process, a data quality management process, a data security management process, a main data service process, a data flow approval process, a main data integration process, a data standard management process, a main data encoding process, and a main data encoding specification process related to the main data management platform by connecting the basic service management module and the main data management platform. Meanwhile, the user management unit, the configuration management unit, the log management unit, the workflow engine unit and the task flow unit in the basic service management module can manage the information sharing process of the bit number main data management system and the external business system based on the main data management platform by connecting the basic service management module and the enterprise service bus.
In one possible embodiment, the bit number master data management system further includes:
and the system operation and maintenance module is respectively connected with the main data management platform and the enterprise service bus and is used for maintaining the bit number main data management system.
It should be noted that, in this embodiment, the system operation and maintenance module includes: the system comprises a system monitoring unit, a system upgrading unit and an interface management unit.
Specifically, for example, as shown in a specific application scenario in fig. 3, the terminal device connects the system operation and maintenance module with the master data management platform, so that the system monitoring unit, the system upgrade unit, and the interface management unit in the system operation and maintenance module can maintain a master data maintenance management process, a master data modeling process, a data quality management process, a data security management process, a master data service process, a data stream approval process, a master data integration process, a data standard management process, a master data encoding process, and a master data encoding specification process related to the master data management platform. Meanwhile, the system operation and maintenance module is connected with the enterprise service bus, so that a system monitoring unit, a system upgrading unit and an interface management unit in the system operation and maintenance module can maintain the information sharing process of the bit number master data management system and the external service system based on the master data management platform.
The invention provides a bit number main data management system, which comprises a main data management platform, wherein the main data management platform is used for setting corresponding bit numbers aiming at equipment and materials of an enterprise so as to uniformly manage the equipment and the materials based on the bit numbers; and the enterprise service bus is respectively connected with the bit number master data management system built based on the master data management platform and a preset external business system. The main data management platform comprises a group data portal module, a subsidiary company data portal module, a main data maintenance management module, a main data modeling module, a data quality management module, a data security management module, a main data service module, a data flow approval module, a main data integration module, a data standard management module, a main data coding base module and a main data coding standard module. The main data maintenance management module is used for creating, maintaining and managing main data of the equipment and the materials, the main data modeling module is used for modeling according to the main data of the equipment and the materials to obtain a business main data warehouse model, and the main data coding library module is used for obtaining project WBS codes, equipment codes, material codes, quality codes and order codes of the equipment and the materials according to the business main data warehouse model and coding to form the bit number. The bit number master data management system further includes: a basic service management module for performing basic management for the bit number master data management system; and the system operation and maintenance module is used for maintaining the bit number master data management system.
Further, embodiments of the bit number master data management method according to the present invention are proposed based on the hardware structure and the embodiments of the bit number master data management system. The bit number main data management method of the invention is applied to the bit number main data management system.
Referring to fig. 4, fig. 4 is a flowchart illustrating a bit number master data management method according to a first embodiment of the present invention.
In the present embodiment, an embodiment of a bit number master data management method is provided, it should be noted that although a logical order is shown in the flow chart, in some cases, the steps shown or described may be performed in an order different from that here.
Step S10, acquiring the main data of the equipment and the material;
and acquiring complete information of all equipment and all materials from an enterprise internal business system, and further identifying and acquiring main data from mass information related to the equipment and the materials.
Specifically, for example, when the terminal device acquires mass data from the internal business system of the enterprise, from the business perspective, systematically analyzing the business processes of the whole enterprise on different granularities and dimensions, dividing all business entities such as personnel, organizations, equipment, materials, grinding tools, products, warehouses, events, processes, work orders and the like involved in the business processes into identification objects of main data, determining the main data of the equipment and the materials according to a main data identification scoring template, the main data identification scoring template consists of a main data scoring index and an index weight, the score of each business entity is obtained based on the main data scoring index and the index weight, and determining a threshold value of the score according to the plurality of scores, wherein if the score of the business entity is greater than the threshold value, the data corresponding to the business entity can be determined as the main data of the equipment and the material.
Step S20, setting the corresponding position numbers of the equipment and the materials according to the main data, and carrying out unified management on the equipment and the materials according to the position numbers;
after the main data of the internal business of the enterprise is determined, the data related to the equipment and the materials in the main data are coded to form a unique bit number for identifying the equipment and the materials, and then the equipment and the materials related to the operation process of the enterprise are managed and maintained in a unified mode according to the bit number.
It should be noted that, in this embodiment, the bit numbers include: item WBS code, equipment code, material code, quality code, and order code.
Specifically, for example, after acquiring the main data of the device and the material of the internal business of the enterprise, the terminal device acquires an item WBS code, a device code, a material code, a quality code, and an order code based on the main data according to the main data coding specification, and codes the item WBS code, the device code, the material code, the quality code, and the order code to obtain the corresponding bit numbers of the device and the material. And then the change of the internal equipment and materials of the enterprise can be timely known according to the position number, and the equipment and materials related to the operation process of the enterprise can be uniformly managed and maintained.
Further, in an embodiment, in the step S20, the setting, for the master data, a bit number corresponding to the device and the material includes:
step S201, modeling is carried out according to the equipment and the main data of the materials to obtain a business main data warehouse model;
after the main data of the internal business of the enterprise is determined and obtained, modeling is carried out on the main data based on different business entity types related in the main data, and a business main data warehouse model formed by the internal business of the enterprise is obtained.
It should be noted that, in this embodiment, the process of establishing the master data model includes: establishing a conceptual model, and abstracting a subject domain of a business entity by establishing the conceptual model; establishing a logic model, and linking the relation between the data entities by establishing the logic model; standardizing a model, namely defining writing standards of tables and fields through the standardization of the model; and establishing a physical model, and refining the attribute of the entity primary key and the reference attribute by establishing the physical model.
Specifically, for example, the terminal device divides a plurality of topic domains according to the contents of the business entities in the material and the device main data, and the common topic domain classification includes: personnel (such as production management personnel, product manufacturing workers), organization (such as internal organization and external organization), equipment (such as equipment point inspection, equipment failure and equipment maintenance), materials (such as material basic data and material materials), molds (such as mold service life and mold state), products (such as finished products and semi-finished products), storage (such as storage content and storage structure), events (such as sampling detection and rework), processes (such as definition of manufacturing process), work orders (such as production work orders and shipment work orders), cross-theme and the like.
Further, the relationship between the plurality of subject domains based on the business entity is hooked.
Specifically, for example, the terminal device establishes a data table about a subject field of the device, splits the data table into a plurality of small tables with table names of device type, device rule, device fault code, and the like, and establishes an association between a parent data table and a child data table by means of a main key and an external key, and also establishes an association between a plurality of child data tables, for example, if a device ID in a parent data table with a table name of the device is set as the main key of the parent data table, and a device ID in a child data table with a table name of device specification is set as the external key of the child data table, the parent data table with a table name of the device and the child data table with a table name of device specification can be associated by means of a field name device ID, thereby implementing a multi-table combined query.
Further, based on the conceptual model and the logical model, the terminal device standardizes writing of tables and fields to obtain service source data, and maps and integrates the service source data type in a data warehouse to form a service master data warehouse model.
Specifically, for example, the terminal device matches fields of a plurality of tables in the business master data warehouse model to a data warehouse through a mapping operation based on the business master data warehouse model, integrates the business master data warehouse model into the data warehouse according to the mapping operation to form the business master data warehouse model, and further may extract a required data subset from the business master data warehouse model, and perform drilling, slicing, dicing, rotating and other operations on the data subset to obtain required device and material information.
Step S202, acquiring the item WBS code, the equipment code, the material code, the quality code and the order code of the equipment and the material according to the business main data warehouse model, and coding to form the bit number.
After a business main data warehouse model is established, acquiring complete main data of required equipment and materials from the business main data warehouse model, numbering the main data according to a main data coding specification to obtain a WBS code, an equipment code, a material code, a quality code and an order code, and further coding the WBS code, the equipment code, the material code, the quality code and the order code to form a bit number.
Further, in step S202, the step of obtaining, according to the business master data warehouse model, a WBS code, an equipment code, a material code, a quality code, and an order code of the equipment and the material, and encoding the WBS code, the equipment code, the material code, the quality code, and the order code to form the bit number further includes:
step S2021, the item WBS code includes: the method comprises the following steps of (1) engineering total codes, engineering codes, units, unit engineering codes, step-by-step engineering codes, project codes and subsection engineering codes;
and after acquiring complete main data of required equipment and materials from the business main data warehouse model, numbering a project total code, a project code, a unit project code, a step project code, a sub-project code and a subsection project code in the project WBS code according to a main data coding specification, and coding the project WBS code based on a plurality of numbers.
In this embodiment, the specific specification of the main data encoding specification to the project WBS code is that the project total code, the project code, the unit project code, the step project code, the project sub-project code and the project sub-project code in the project WBS code are numbered by using numbers between 01 and 99.
Specifically, for example, the terminal device numbers the engineering total code to 03, the engineering code to 08, the crew to 18, the unit engineering code to 22, the step engineering code to 67, the subentry engineering code to 24, and the segmentation engineering code to 85, and the code to obtain the WBS code of the project is 03081822672485.
Step S2022, the device encoding includes: base code, equipment serial number, PBS code, PBS spreading code, specialty code, and replacement serial number;
and after acquiring complete main data of required equipment and materials from the business main data warehouse model, numbering a base code, an equipment serial number, a PBS (packet buffer solution) code, a PBS (packet buffer solution) spreading code, a professional code and a replacement serial number in the equipment code according to a main data coding specification, and coding the equipment code based on a plurality of numbers.
In this embodiment, the specific specification of the main data encoding specification for encoding the device is that the base code, the device serial number, the PBS code, the PBS spreading code, the professional code, and the replacement serial number are numbered with numbers between 01 and 99, and the device code is identified by the first three letters of the english name of the device.
Specifically, for example, the terminal device numbers the base code to 22, the device serial number to 87, the PBS code to 54, the PBS spreading code to 04, the professional code to 11, and the replacement serial number to 88, and the device code to PRT, resulting in the device code to 22PRT 8754041188.
Step S2023, the material coding includes: the material type code, the material characteristic code, the surface treatment code, the serial number and the serial number of the position are obtained;
and after acquiring complete main data of required equipment and materials from the business main data warehouse model, numbering material type codes, material characteristic codes, surface treatment codes, serial numbers and position numbers in the material codes according to the main data coding specification, and coding the material codes based on a plurality of numbers.
In this embodiment, the main data encoding specification is a specific specification of the material encoding, and the material type code, the material characteristic code, the surface treatment code, the serial number and the position number are all numbered by using numbers between 01 and 99.
Specifically, for example, the terminal device numbers the material type code as 22, the material characteristic code as 87, the surface treatment code as 54, the others as 04, the serial number as 18, and the location as 80, resulting in the material code as 228754041880.
Step S2024, the quality encoding includes: organizing code number, level number and sequence number;
and after acquiring complete main data of required equipment and materials from the business main data warehouse model, numbering the organization code number, the layer number and the sequence number in the quality code according to the main data coding specification, and coding the quality code based on a plurality of numbers.
In this embodiment, the specific specification of the main data encoding specification for quality encoding is that the organization code number, the hierarchy number, and the serial number are all numbered with numbers between 01 and 99.
Specifically, for example, the terminal device numbers the organization number 22, the hierarchy number 87, and the serial number 54, and obtains the quality code 228754.
Step S2025, the order code includes: a customer code, an order serial number, and an order type code.
And after acquiring complete main data of required equipment and materials from the business main data warehouse model, numbering a customer code, an order serial number and an order type code in an order code according to a main data coding specification, and coding the order code based on a plurality of numbers.
In this embodiment, the main data encoding specification specifically encodes the order, and the customer code, the order serial number, and the order type code are numbered by using numbers between 01 and 99.
Specifically, for example, the terminal device numbers the customer code to 21, the order serial number to 17, and the order type code to 14, resulting in a quality code of 211714.
Further, step S20, performing unified management on the equipment and the material according to the position number; further comprising:
step S203, performing the factory management on the device and the material according to the bit number, wherein the factory management includes: project management, equipment management, material management, quality management and order management.
After the WBS code, the equipment code, the material code, the quality code and the order code are coded to form a bit number, the equipment and the material in the enterprise are subjected to item management, equipment management, material management, quality management and order management based on the bit number.
Specifically, for example, after detecting that a component inside the device is damaged and an abnormal component is replaced, the serial number portion of the replacement part in the device code will change according to the new component parameter, at this time, the device code will be updated accordingly, and the bit number will be refreshed along with the update of the device code, and the terminal device will acquire and record the maintenance information of the device through the new bit number.
Further, in an embodiment, the bit number master data management method according to the present invention may further include:
and step S30, sharing information with the preset external business system through the enterprise service bus.
It should be noted that, in this embodiment, the preset external service system includes: business information warehouse (BW), Enterprise Resource Planning (ERP), project management, Building Information Model (BIM), Quality Management System (QMS), Warehouse Management System (WMS), and business system.
Specifically, for example, the terminal device establishes a communication connection between the position number master data management system and a preset external service system such as a business information warehouse (BW), an Enterprise Resource Planning (ERP), project management, a Building Information Model (BIM), a Quality Management System (QMS), a Warehouse Management System (WMS), and a service system based on an enterprise service bus in the position number master data management system, so that the position number master data management system based on the master data management platform and the preset external service system realize information sharing.
In this embodiment, complete information of all devices and all materials is obtained from an enterprise internal business system, and then main data is identified and obtained from mass information related to the devices and the materials; after determining the main data of the internal business of the enterprise, coding the data related to the equipment and the materials in the main data to form a unique bit number for identifying the equipment and the materials, and further uniformly managing and maintaining the equipment and the materials related to the operation process of the enterprise according to the bit number; based on an enterprise service bus in the position number master data management system, communication connection between the position number master data management system and preset external service systems such as a business information warehouse (BW), an Enterprise Resource Planning (ERP), project management, a Building Information Model (BIM), a Quality Management System (QMS), a Warehouse Management System (WMS) and a service system is built, so that the position number master data management system based on the master data management platform and the preset external service systems realize information sharing.
In addition, an embodiment of the present invention further provides a storage medium, which may be a computer-readable storage medium, where a bit number main data management program is stored on the storage medium, and when being executed by a processor, the bit number main data management program implements the steps of the bit number main data management method described above.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A bit number master data management system, the bit number master data management system comprising:
the system comprises a main data management platform, a data processing platform and a data processing platform, wherein the main data management platform is used for setting corresponding bit numbers aiming at equipment and materials of an enterprise so as to uniformly manage the equipment and the materials based on the bit numbers;
and the enterprise service bus is respectively connected with the bit number master data management system built based on the master data management platform and a preset external business system.
2. The bit number master data management system of claim 1, wherein the master data management platform comprises:
the main data maintenance management module is used for creating, maintaining and managing main data of the equipment and the materials;
the main data modeling module is connected with the main data maintenance management module and used for modeling according to the equipment and the main data of the materials to obtain a business main data warehouse model;
and the main data coding library module is connected with the main data modeling module and is used for acquiring the item WBS code, the equipment code, the material code, the quality code and the order code of the equipment and the material according to the business main data warehouse model and coding the item WBS code, the equipment code, the material code, the quality code and the order code to form the position number.
3. The bit-number master data management system according to claim 1 or 2, wherein the bit-number master data management system further comprises:
and the basic service management module is respectively connected with the main data management platform and the enterprise service bus, and is used for performing basic management on the bit number main data management system.
4. The bit number master data management system according to claim 3, wherein the bit number master data management system further comprises:
and the system operation and maintenance module is respectively connected with the main data management platform and the enterprise service bus and is used for maintaining the bit number main data management system.
5. A bit number main data management method is applied to a bit number main data management system, and the bit number main data management system comprises: the bit number master data management system built based on the master data management platform is in communication connection with a preset external business system through the enterprise service bus;
the bit number main data file management method comprises the following steps:
acquiring main data of equipment and materials;
setting the corresponding bit numbers of the equipment and the materials aiming at the main data, and carrying out unified management on the equipment and the materials according to the bit numbers;
and sharing information with the preset external business system through the enterprise service bus.
6. The bit number master data management method according to claim 5, wherein the step of setting the bit numbers corresponding to the device and the material for the master data includes:
modeling according to the equipment and the main data of the materials to obtain a business main data warehouse model;
and acquiring the item WBS code, the equipment code, the material code, the quality code and the order code of the equipment and the material according to the business main data warehouse model, and coding to form the bit number.
7. The bit number master data management method of claim 6, wherein the item WBS code includes: the method comprises the following steps of (1) engineering total codes, engineering codes, units, unit engineering codes, step-by-step engineering codes, project codes and subsection engineering codes;
the device encoding includes: base code, equipment serial number, PBS code, PBS spreading code, specialty code, and replacement serial number;
the material coding comprises the following steps: the material type code, the material characteristic code, the surface treatment code, the serial number and the serial number of the position are obtained;
the quality encoding includes: organizing code number, level number and sequence number;
the order code comprises: a customer code, an order serial number, and an order type code.
8. The bit number master data management method according to claim 5, wherein the unified management includes: factory management, according to the said bit number to carry on the step of unified management to the said apparatus and the said supplies, including:
performing the factory management on the equipment and the material according to the bit number, wherein the factory management comprises: project management, equipment management, material management, quality management and order management.
9. A terminal device, characterized in that the terminal device comprises a memory, a processor and a bit number master data management program stored on the memory and executable on the processor, the bit number master data management program when executed by the processor implementing the steps of the bit number master data management method according to any one of claims 5 to 8.
10. A storage medium having stored thereon a bit number master management program, the bit number master management program when executed by a processor implementing the steps of the bit number master management method according to any one of claims 5 to 8.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111071656.9A CN113516459B (en) | 2021-09-14 | 2021-09-14 | Bit number main data management system, method, terminal equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111071656.9A CN113516459B (en) | 2021-09-14 | 2021-09-14 | Bit number main data management system, method, terminal equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113516459A true CN113516459A (en) | 2021-10-19 |
CN113516459B CN113516459B (en) | 2022-01-07 |
Family
ID=78063011
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111071656.9A Active CN113516459B (en) | 2021-09-14 | 2021-09-14 | Bit number main data management system, method, terminal equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113516459B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115237898A (en) * | 2022-07-25 | 2022-10-25 | 浪潮卓数大数据产业发展有限公司 | Business-through master data management method and system |
CN116383669A (en) * | 2023-03-18 | 2023-07-04 | 宝钢工程技术集团有限公司 | Method and system for generating factory object position number identification through data |
CN116383670A (en) * | 2023-03-18 | 2023-07-04 | 宝钢工程技术集团有限公司 | Operation equipment coding similarity association method based on factory object position |
Citations (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110087632A1 (en) * | 2009-10-09 | 2011-04-14 | International Business Machines Corporation | Data Synchronization Between a Data Management System and an External System |
CN103729742A (en) * | 2014-01-06 | 2014-04-16 | 中国南方电网有限责任公司 | Data resource management system based on SOA framework and model drive framework |
CN104361424A (en) * | 2014-10-11 | 2015-02-18 | 中国电子科技集团公司第十研究所 | Master data system integration method based on enterprise service bus (ESB) |
CN104751291A (en) * | 2015-04-09 | 2015-07-01 | 成都卡莱博尔信息技术有限公司 | Main data management platform |
CN105208097A (en) * | 2015-08-24 | 2015-12-30 | 用友网络科技股份有限公司 | Main data sharing device and method |
CN105787070A (en) * | 2016-03-02 | 2016-07-20 | 浪潮软件集团有限公司 | Tax data theme framework based on cloud monitoring |
CN108228601A (en) * | 2016-12-14 | 2018-06-29 | 陕西省地方电力(集团)有限公司 | A kind of master data read-write system and master data reading/writing method |
CN109508176A (en) * | 2018-07-20 | 2019-03-22 | 苏州百捷信息科技有限公司 | A kind of corporate boss's data management platform |
CN110599124A (en) * | 2019-09-04 | 2019-12-20 | 北京华科软科技有限公司 | Integration-oriented engineering data center |
CN110796339A (en) * | 2019-09-27 | 2020-02-14 | 新凤鸣集团股份有限公司 | Intelligent chemical fiber production operation platform based on industrial internet |
CN110888878A (en) * | 2019-11-15 | 2020-03-17 | 国家电投集团科学技术研究院有限公司 | Service-oriented main data management method and system |
CN111061789A (en) * | 2019-12-10 | 2020-04-24 | 国家电网有限公司 | Smart power grids capital construction information management system |
CN111784108A (en) * | 2020-05-29 | 2020-10-16 | 远光软件股份有限公司 | Modeling method and device for main data management platform |
CN112364094A (en) * | 2020-11-17 | 2021-02-12 | 珠海市卓轩科技有限公司 | Visual modeling method, device and medium for data warehouse |
-
2021
- 2021-09-14 CN CN202111071656.9A patent/CN113516459B/en active Active
Patent Citations (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110087632A1 (en) * | 2009-10-09 | 2011-04-14 | International Business Machines Corporation | Data Synchronization Between a Data Management System and an External System |
CN103729742A (en) * | 2014-01-06 | 2014-04-16 | 中国南方电网有限责任公司 | Data resource management system based on SOA framework and model drive framework |
CN104361424A (en) * | 2014-10-11 | 2015-02-18 | 中国电子科技集团公司第十研究所 | Master data system integration method based on enterprise service bus (ESB) |
CN104751291A (en) * | 2015-04-09 | 2015-07-01 | 成都卡莱博尔信息技术有限公司 | Main data management platform |
CN105208097A (en) * | 2015-08-24 | 2015-12-30 | 用友网络科技股份有限公司 | Main data sharing device and method |
CN105787070A (en) * | 2016-03-02 | 2016-07-20 | 浪潮软件集团有限公司 | Tax data theme framework based on cloud monitoring |
CN108228601A (en) * | 2016-12-14 | 2018-06-29 | 陕西省地方电力(集团)有限公司 | A kind of master data read-write system and master data reading/writing method |
CN109508176A (en) * | 2018-07-20 | 2019-03-22 | 苏州百捷信息科技有限公司 | A kind of corporate boss's data management platform |
CN110599124A (en) * | 2019-09-04 | 2019-12-20 | 北京华科软科技有限公司 | Integration-oriented engineering data center |
CN110796339A (en) * | 2019-09-27 | 2020-02-14 | 新凤鸣集团股份有限公司 | Intelligent chemical fiber production operation platform based on industrial internet |
CN110888878A (en) * | 2019-11-15 | 2020-03-17 | 国家电投集团科学技术研究院有限公司 | Service-oriented main data management method and system |
CN111061789A (en) * | 2019-12-10 | 2020-04-24 | 国家电网有限公司 | Smart power grids capital construction information management system |
CN111784108A (en) * | 2020-05-29 | 2020-10-16 | 远光软件股份有限公司 | Modeling method and device for main data management platform |
CN112364094A (en) * | 2020-11-17 | 2021-02-12 | 珠海市卓轩科技有限公司 | Visual modeling method, device and medium for data warehouse |
Non-Patent Citations (1)
Title |
---|
李媛: "《基于主数据管理平台的应用集成在攀矿***中的应用》", 《中国优秀博硕士学位论文全文数据库(硕士) 信息科技辑》 * |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115237898A (en) * | 2022-07-25 | 2022-10-25 | 浪潮卓数大数据产业发展有限公司 | Business-through master data management method and system |
CN116383669A (en) * | 2023-03-18 | 2023-07-04 | 宝钢工程技术集团有限公司 | Method and system for generating factory object position number identification through data |
CN116383670A (en) * | 2023-03-18 | 2023-07-04 | 宝钢工程技术集团有限公司 | Operation equipment coding similarity association method based on factory object position |
CN116383669B (en) * | 2023-03-18 | 2024-04-16 | 宝钢工程技术集团有限公司 | Method and system for generating factory object position number identification through data |
CN116383670B (en) * | 2023-03-18 | 2024-04-19 | 宝钢工程技术集团有限公司 | Operation equipment coding similarity association method based on factory object position |
Also Published As
Publication number | Publication date |
---|---|
CN113516459B (en) | 2022-01-07 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN113516459B (en) | Bit number main data management system, method, terminal equipment and storage medium | |
US11551105B2 (en) | Knowledge management using machine learning model trained on incident-knowledge relationship fingerprints | |
Philpotts | An introduction to the concepts, benefits and terminology of product data management | |
US11783254B2 (en) | Method and system for implementing an adaptive data governance system | |
CN108052584B (en) | Feature model based product code generation and data management method | |
CN112184177B (en) | Project supervision method, equipment and storage medium | |
CN105512856A (en) | Wechat-based potential safety hazard management method and system for large-scale civil engineering | |
US20120265720A1 (en) | Infrastructure and architecture for development and execution of predictive models | |
US20090276446A1 (en) | Process and method for classifying structured data | |
CN110990620A (en) | Intelligent transformer substation drawing and document data management method based on intelligent technology application | |
CN111985902B (en) | Cross-system information collaborative management method, device, equipment and storage medium | |
CN117472874A (en) | Government affair data resource integrated management system and method based on big data analysis | |
CN112330299A (en) | Business process management method, device, equipment and storage medium | |
US20200387802A1 (en) | Dynamically adaptable rules and communication system for managing process controls | |
US20240127379A1 (en) | Generating actionable information from documents | |
JP4630691B2 (en) | Database apparatus and processing method thereof | |
CN112084177A (en) | Data pool application method and device based on data acquisition management and mining analysis | |
CN109242259B (en) | Data integration method and system based on basic data resource library | |
CN113568873B (en) | Intelligent policy file matching method and device | |
CN115525778A (en) | Enterprise document processing method, device and storage medium | |
US20140149186A1 (en) | Method and system of using artifacts to identify elements of a component business model | |
CN114281306A (en) | IT architecture management and control method, IT architecture management and control device, IT architecture processor and IT architecture electronic equipment | |
CN113918511A (en) | Multi-factor data analysis processing method, system and storage medium | |
CN111143322A (en) | Data standard treatment system and method | |
CN115185923B (en) | Method and system for managing meteorological observation metadata and intelligent terminal |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |