CN114691793A - Master data management method based on unified platform - Google Patents
Master data management method based on unified platform Download PDFInfo
- Publication number
- CN114691793A CN114691793A CN202210366646.6A CN202210366646A CN114691793A CN 114691793 A CN114691793 A CN 114691793A CN 202210366646 A CN202210366646 A CN 202210366646A CN 114691793 A CN114691793 A CN 114691793A
- Authority
- CN
- China
- Prior art keywords
- product
- subsystem
- management method
- main system
- code
- 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.)
- Pending
Links
Images
Classifications
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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
Abstract
The invention discloses a master data management method based on a unified platform, and relates to the technical field of data management methods. The management method comprises the following steps: a data receiving module: the system comprises a subsystem, a database and a database, wherein the subsystem is used for receiving initial information of an existing product of the subsystem, and the initial information comprises a name of the product and original parameters of the product; the coding module: naming the original parameters of the product by a specific naming rule to form unique codes of the product, inputting the unique codes into a main system, wherein each code only corresponds to one product, and the unique codes of the product and the original parameters of the product can be mutually converted through a specific mapping path; a decoding module: and converting the unique code of the product into the original parameters of the product according to the mapping path, and outputting the original parameters to the subsystem. According to the main data management method based on the unified platform, products between the subsystem and the main system can be mutually transcoded and mapped, so that information statistics and resource allocation are unified conveniently.
Description
Technical Field
The invention relates to the technical field of data management methods, in particular to a master data management method based on a unified platform.
Background
Data management is a process of effectively collecting, storing, processing and applying data by using computer hardware and software technologies, and in the big data era, products produced by various subsystems are the same or similar under the same main system often between a group company and a subsidiary company or between the main system and the various subsystems. However, under the condition that the identification forms of the parameters of the product in the database table are different, the problems of information islands, application islands, resource islands and the like are exposed, so that the problems that the product data information is inconsistent and inaccurate, the unified management and the later maintenance are not facilitated and the like can occur when a main system unifies statistical information and allocates resources; in view of this, we propose a master data management method based on a unified platform.
Disclosure of Invention
Technical problem to be solved
Aiming at the defects of the prior art, the invention provides a master data management method based on a unified platform, which solves the problems mentioned in the background technology.
(II) technical scheme
In order to achieve the purpose, the invention is realized by the following technical scheme: a unified platform based master data management method, the management method comprising:
a data receiving module: the system is used for receiving initial information of an existing product of the subsystem, wherein the initial information comprises a product name and an original parameter of the product, the initial information and the original parameter of the product are input by a user side of the subsystem, are uniformly received and stored by a data receiving module after being input, can be used for performing data caching by a relational database MySQL and a non-relational database Redis, and is used for cluster containerization management by a Docker + k8s cluster.
The coding module: naming the original parameters of the product by using a specific naming rule to form unique codes of the product, inputting the unique codes into a main system, wherein each code only corresponds to one product, the unique codes of the product and the original parameters of the product can be mutually converted through a specific mapping path, the naming rule and the mapping relation are formulated and input by a main system user side, the naming rule and the mapping relation can be realized based on java projects, and spring, spring MVC and mybatis are used as main frames.
And a decoding module: and converting the unique code of the product into the original parameter of the product according to the mapping path, outputting the original parameter to a subsystem, and decoding the original parameter by performing reverse operation on the same mapping relation.
Preferably, the encoding rule of the encoding module is: the universal parameter in the original parameters of the product is used as a main code, the special parameter is used as a sub-code, and the unique code of the product is formed in the form of the main code and the sub-code.
Preferably, the general parameters are determined by the type and specification of the product, and the special parameters are determined by the number generated when the product enters the subsystem.
Preferably, the main system and the subsystems are connected through a network server, the main system can form mapping with the subsystems to uniformly store and manage product information in the subsystems, and the subsystems are independent and do not interfere with each other.
Preferably, the management method further comprises the management module: the system is used for providing an operation interface for the main system, presenting the name, product and parameter information of each subsystem, and receiving and issuing a user instruction of the main system.
Preferably, the management method further comprises the access module: the system is used for providing an operation interface for the subsystem, so that the subsystem can access the unique coded information mapped by the products in the system in the main system.
Preferably, the management method further comprises the table module: the mapping relation between the original parameters of the product and the unique code of the product corresponding to the original parameters is stored.
Preferably, the table module includes:
cross table: and writing the corresponding coding numerical value of the general parameter of the main system and the subsystem data into the same row, and forming a transverse table by using the product and the parameter as field names.
Vertical table: the mapping between the special parameters of the main system and the subsystem products forms a longitudinal table, and when the subsequent main system updates the products or the product parameters, the corresponding standard code mapping relation and the transverse table longitudinal table of the product and parameter mapping between the subsystem and the main system need to be updated. The general product does not add new general parameters, only adds new special parameters, and only needs to map the new special parameters to the related vertical table.
Preferably, the unified platform-based master data management method includes the following steps:
s1, each subsystem is connected with the main system through a network server, a subsystem user inputs initial information of the existing product in the system, including information such as product name and original parameters of the product, into a user side, and a data receiving module receives the input information; the user of the main system makes a naming rule and a mapping method, determines a standard code mapping relation and inputs the standard code mapping relation into the coding module.
And S3, naming the original parameters of the product by a preset naming rule by the coding module to form a unique code of the product, and inputting the unique code into the main system.
S4, the table module stores the unique code input by the coding module and the initial information of the product according to the one-to-one mutual mapping relation to form a mapping table, and the product information can be intuitively inquired through the mapping table.
S5, the main system user checks the name, product and parameter information of each subsystem through the management interface and issues a user instruction; and the subsystem user views the unique coded information mapped by the product in the system in the main system through the access interface.
(III) advantageous effects
The invention provides a master data management method based on a unified platform. The method has the following beneficial effects:
the main data management method based on the unified platform uniformly codes products according to rules, determines a uniform parameter naming standard according to different product parameters among systems, and performs mapping between the uniform parameter naming standard and subsystem parameters, so that the main system product codes determine a unique subsystem product, and the products between the subsystems and the main system can be mutually transcoded and mapped. Therefore, after the main system unifies the specifications of all subsystem products, the accuracy and consistency of data are obviously improved, and the unified statistical information, resource allocation and later maintenance are more convenient.
Drawings
FIG. 1 is a schematic diagram of a mapping between a host system and a subsystem according to the present invention;
FIG. 2 is a schematic diagram of a module of the present invention;
FIG. 3 is a flow chart of an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1-3, the present invention provides a technical solution:
a main data management method based on a unified platform comprises a main system and a subsystem, wherein the main system and the subsystem are connected through a network server, the main system and the subsystem can adopt two interaction modes of webservice and rest, and the management method comprises the following steps:
a data receiving module: the system is used for receiving initial information of an existing product of the subsystem, wherein the initial information comprises a product name and an original parameter of the product, the initial information and the original parameter of the product are input by a user side of the subsystem, are uniformly received and stored by a data receiving module after being input, can be used for performing data caching by a relational database MySQL and a non-relational database Redis, and is used for cluster containerization management by a Docker + k8s cluster.
The coding module: naming original parameters of the product according to a specific naming rule to form unique codes of the product, inputting the unique codes into a main system, wherein each code only corresponds to one product, and the unique codes of the product and the original parameters of the product can be mutually converted through a specific mapping path; the naming rule and the mapping relation are formulated and input by a main system user side, the naming rule and the mapping relation can be realized based on java projects, spring MVC and mybatis are used as main frames, and the coding rule of a coding module is as follows: the method comprises the following steps of forming a unique code of a product in a main code plus sub-code mode by taking a general parameter in original parameters of the product as a main code and a special parameter as a sub-code; the general parameters are determined by the type and specification of the product, and the special parameters are determined by the number generated when the product enters the subsystem.
For a better understanding, the coding module is explained in connection with specific examples: assuming that product 1 has four universal product parameters of ABCD, the A parameter has 100 specifications in all systems, 100 codes of 001-100 represent code value specification 1-specification 100, specification code value of BCD parameter is counted by analogy, the product has three special product parameters of EFG besides the four universal product parameters in a subsystem, the E parameter has 10 specifications in a system, the code value specification 1-specification 10 is represented by 01-10, FG parameter code value and the like, product 1 can be represented by 1001001001001010101, specification 1 in the universal parameters of ABCD, specification 1 in the special parameters of EFG, and the like, each product can generate a unique code because of having special parameters different from other products.
A decoding module: converting the unique code of the product into the original parameter of the product according to the mapping path, outputting the original parameter to a subsystem, and decoding the original parameter by performing reverse operation on the same mapping relation;
a table module: the mapping relation between the original parameters of the product and the unique code of the product corresponding to the original parameters is stored; the table module comprises a transverse table and a longitudinal table, wherein corresponding coding numerical values of general parameters of the main system and subsystem data are written into the same row, and products and parameters are used as field names to form the transverse table; and mapping between the special parameters of the main system and the subsystem products to form a longitudinal table. When the subsequent main system updates the product or the product parameters, the corresponding standard code mapping relation and the horizontal and vertical tables of the product and parameter mapping between the subsystem and the main system need to be updated. The general product does not add new general parameters, only adds new special parameters, and only needs to map the new special parameters to the related vertical table.
A management module: the system is used for providing an operation interface for the main system, presenting the name, product and parameter information of each subsystem, and receiving and issuing a user instruction of the main system.
An access module: the system is used for providing an operation interface for the subsystem, so that the subsystem can access the unique coded information mapped by the products in the system in the main system.
In this embodiment, the main system may form a mapping with the plurality of subsystems, and store and manage product information in the plurality of subsystems in a unified manner, and the subsystems are independent from each other and do not interfere with each other.
When the management method is used specifically, the management method is carried out according to the following steps:
s1, each subsystem is connected with the main system through a network server, the subsystem user inputs the initial information of the existing product in the system, including the name of the product and the original parameter of the product, into the user terminal, the data receiving module receives the input information; the user of the main system makes a naming rule and a mapping method, determines a standard code mapping relation and inputs the standard code mapping relation into the coding module.
And S2, naming the original parameters of the product by a preset naming rule by the coding module to form a unique code of the product, and inputting the unique code into the main system.
S3, the table module stores the unique code input by the coding module and the initial information of the product according to the one-to-one mutual mapping relation to form a mapping table, and the product information can be intuitively inquired through the mapping table.
S4, the main system user checks the name, product and parameter information of each subsystem through the management interface and issues a user instruction; and the subsystem user views the unique coded information mapped by the product in the system in the main system through the access interface.
The main data management method based on the unified platform uniformly codes products according to rules, determines a uniform parameter naming standard according to different product parameters among systems, and performs mapping between the uniform parameter naming standard and subsystem parameters, so that the main system product codes determine a unique subsystem product, and the products between the subsystems and the main system can be mutually transcoded and mapped. Therefore, after the main system unifies the specifications of all subsystem products, the accuracy and consistency of data are obviously improved, and the unified statistical information, resource allocation and later maintenance are more convenient.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (9)
1. A master data management method based on a unified platform is characterized in that: the management method comprises the following steps:
a data receiving module: the system comprises a subsystem, a database and a database, wherein the subsystem is used for receiving initial information of an existing product of the subsystem, and the initial information comprises a name of the product and original parameters of the product;
the coding module: naming the original parameters of the product by a specific naming rule to form unique codes of the product, inputting the unique codes into a main system, wherein each code only corresponds to one product, and the unique codes of the product and the original parameters of the product can be mutually converted through a specific mapping path;
a decoding module: and converting the unique code of the product into the original parameters of the product according to the mapping path, and outputting the original parameters to the subsystem.
2. The unified platform based master data management method according to claim 1, wherein: the coding rule of the coding module is as follows: the universal parameter in the original parameters of the product is used as a main code, the special parameter is used as a sub-code, and the unique code of the product is formed in the form of the main code and the sub-code.
3. The unified platform based master data management method according to claim 2, wherein: the general parameters are determined by the type and specification of the product, and the special parameters are determined by the number generated when the product enters the subsystem.
4. The unified platform based master data management method according to claim 1, wherein: the main system is connected with the subsystems through the network server, mapping can be formed between the main system and the subsystems, product information in the subsystems is stored and managed in a unified mode, and the subsystems are independent and do not interfere with each other.
5. A unified platform based master data management method according to any of claims 1 to 4, characterized in that: the management method further comprises a management module: the system is used for providing an operation interface for the main system, presenting the name, product and parameter information of each subsystem, and receiving and issuing a user instruction of the main system.
6. The unified platform based master data management method according to claim 5, wherein: the management method further comprises an access module: the system is used for providing an operation interface for the subsystem, so that the subsystem can access the unique coded information mapped by the products in the system in the main system.
7. A unified platform based master data management method according to any of claims 1 to 4, characterized in that: the management method further comprises a table module: the mapping relation between the original parameters of the product and the unique code of the product corresponding to the original parameters is stored.
8. The unified platform based master data management method according to claim 7, wherein: the table module includes:
cross table: writing corresponding coding numerical values of general parameters of the main system and subsystem data into the same row, and taking products and parameters as field names to form a transverse table;
vertical table: and mapping between the special parameters of the main system and the subsystem products to form a longitudinal table.
9. A unified platform based master data management method according to any of claims 1 to 8, characterized by: the master data management method based on the unified platform comprises the following steps:
s1, each subsystem is connected with the main system through a network server, a subsystem user inputs initial information of the existing product in the system, including information such as product name and original parameters of the product, into a user side, and a data receiving module receives the input information; the user of the main system formulates a naming rule and a mapping method, determines a standard code mapping relation and inputs the standard code mapping relation into a coding module;
s3, naming the original parameters of the product by a preset naming rule by the coding module to form a unique code of the product, and inputting the unique code into the main system;
s4, the table module stores the unique code input by the code module and the initial information of the product according to a one-to-one mutual mapping relation to form a mapping table, and the product information can be intuitively inquired through the mapping table;
s5, the main system user checks the name, product and parameter information of each subsystem through the management interface and issues a user instruction; and the subsystem user views the unique coded information mapped by the product in the system in the main system through the access interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210366646.6A CN114691793A (en) | 2022-04-08 | 2022-04-08 | Master data management method based on unified platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210366646.6A CN114691793A (en) | 2022-04-08 | 2022-04-08 | Master data management method based on unified platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114691793A true CN114691793A (en) | 2022-07-01 |
Family
ID=82143440
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210366646.6A Pending CN114691793A (en) | 2022-04-08 | 2022-04-08 | Master data management method based on unified platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114691793A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115190107A (en) * | 2022-07-07 | 2022-10-14 | 四川川大智胜系统集成有限公司 | Multi-subsystem management method based on extensive domain name, management terminal and readable storage medium |
-
2022
- 2022-04-08 CN CN202210366646.6A patent/CN114691793A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115190107A (en) * | 2022-07-07 | 2022-10-14 | 四川川大智胜系统集成有限公司 | Multi-subsystem management method based on extensive domain name, management terminal and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106951694B (en) | Adaptive modeling method for online monitoring system of secondary equipment of power system | |
| CN111339073A (en) | Real-time data processing method and device, electronic equipment and readable storage medium | |
| CN109241159B (en) | Partition query method and system for data cube and terminal equipment | |
| CN116680648B (en) | Service fusion data generation method and system for digital twin city | |
| CN109213820B (en) | Method for realizing fusion use of multiple types of databases | |
| CN114253228B (en) | Industrial equipment object modeling method and device based on digital twin | |
| CN113139227B (en) | BIM component construction code creation method based on Revit | |
| CN114430353B (en) | Modbus protocol-based data acquisition method, system, device and medium | |
| CN108491445A (en) | The methods of exhibiting and system of achievement data in region | |
| CN114691793A (en) | Master data management method based on unified platform | |
| CN111241129A (en) | Industrial production enterprise index data acquisition and calculation system | |
| CN112052134A (en) | Service data monitoring method and device | |
| CN114461600A (en) | Engineering project data multidimensional multiplexing method based on BIM and component identity label | |
| CN114443656A (en) | Customizable automated data model analysis tool and use method thereof | |
| CN107025214B (en) | Data processing method and device | |
| CN103051480B (en) | The storage means of a kind of DN and DN storage device | |
| CN115982177A (en) | Data collection method, device, equipment and medium based on tree dimensionality | |
| CN111984723A (en) | Data synchronization method and device and terminal equipment | |
| CN109977516B (en) | Automatic modeling logic node processing method | |
| CN113868138A (en) | Method, system, equipment and storage medium for acquiring test data | |
| CN112506919A (en) | Structured ICD generation method | |
| CN112685456A (en) | User access data processing method and device and computer system | |
| CN117271480B (en) | Data processing method, device, electronic equipment and medium | |
| CN117033952B (en) | Distributed multi-data source acquisition implementation method | |
| CN110807229B (en) | Data updating method and server for WEB wiring diagram of distribution network main station system |
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 |