[go: up one dir, main page]

CN117196163A - Data standardization management method, device and medium - Google Patents

Data standardization management method, device and medium Download PDF

Info

Publication number
CN117196163A
CN117196163A CN202210576816.3A CN202210576816A CN117196163A CN 117196163 A CN117196163 A CN 117196163A CN 202210576816 A CN202210576816 A CN 202210576816A CN 117196163 A CN117196163 A CN 117196163A
Authority
CN
China
Prior art keywords
standardized
rule
verification
data
management
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
Application number
CN202210576816.3A
Other languages
Chinese (zh)
Inventor
李莹
张颖
赵凯
袁仕东
姜戈
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
CRRC Information Technology Co Ltd
Original Assignee
CRRC Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by CRRC Information Technology Co Ltd filed Critical CRRC Information Technology Co Ltd
Priority to CN202210576816.3A priority Critical patent/CN117196163A/en
Publication of CN117196163A publication Critical patent/CN117196163A/en
Pending legal-status Critical Current

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The embodiment of the application provides a data standardization management method, a device and a medium, wherein the method comprises the following steps: acquiring material standardized management requirement information; according to the material standardized management requirement information, designing standardized verification rules according to material grouping and material properties; the standardized check rule service is issued based on a rule engine, and a material standardized management interface is provided for a service system; and acquiring material data content input by a business system through a material standardized management interface, and auditing the material data content according to the standardized verification rule to acquire an auditing result. According to the embodiment, the standardized verification rule service is independent of the service system, only one-time interface integration is needed, the condition that the associated service system is needed to be changed when the standardized verification rule is newly built or updated is avoided, the influence on the service system is reduced, and the stability of the service system is improved.

Description

Data standardization management method, device and medium
Technical Field
The present application relates to the field of data management, and in particular, to a method, an apparatus, and a medium for data standardization management.
Background
The material cost is related to the manufacturing cost of each product, and good material standardization management plays a vital role for manufacturing enterprises, and is directly related to the effectiveness of product cost control.
The standard specification of the materials is often formed by organically combining a plurality of standards such as international, national, industry or enterprise internal standards. Meanwhile, in order to balance standardization and individualization, many standards are required to be set very flexibly so as to be suitable for more scenes. It is often difficult for business personnel in the enterprise to understand and memorize all the criteria, such as design, purchasing, inventory, etc. For enterprises with higher material standardization requirements, an audit link of standardization specialists is generally added, but flow efficiency is greatly reduced by manual audit of all material data.
In various business systems related to material information management, there is a method for realizing standardized verification of materials by a verification mode of software customization or configuration. For the higher flexibility parts, custom program implementation is basically required. When the material standard is revised, the service system is required to be revised in program or configuration, which may cause the following problems:
(1) The stability of the service system is not facilitated, the normal operation of the service system often relates to the production and operation efficiency of the whole enterprise, and the instability of the service system can cause great production hidden trouble and even economic loss;
(2) May have an impact on the business processes that have occurred but not completed;
(3) The fact that the historical data is inconsistent with the latest standard verification rule may cause that the historical data cannot develop new business.
Disclosure of Invention
In order to solve one of the technical defects, the embodiment of the application provides a data standardization management method, a device and a medium.
According to a first aspect of an embodiment of the present application, there is provided a data standardization management method, the method including:
acquiring material standardized management requirement information;
according to the material standardized management requirement information, designing standardized verification rules according to material grouping and material properties;
the standardized check rule service is issued based on a rule engine, and a material standardized management interface is provided for a service system;
and acquiring material data content input by a business system through a material standardized management interface, and auditing the material data content according to the standardized verification rule to acquire an auditing result.
According to a second aspect of the embodiment of the present application, there is provided a data standardization management apparatus including:
a memory;
a processor; and
a computer program;
wherein the computer program is stored in the memory and configured to be executed by the processor to implement the method according to the first aspect of the embodiment of the present application.
According to a third aspect of an embodiment of the present application, there is provided a computer-readable storage medium having a computer program stored thereon; the computer program is executed by a processor to implement the method according to the first aspect of the embodiment of the application.
By adopting the data standardization management method provided by the embodiment of the application, the standardization check rule is strictly designed according to the material standardization management requirement, and the standardization check rule service is provided for the service system, so that the material data content is standardized and checked. By enabling the standardized verification rule service to be independent of the service system, only one-time interface integration is needed, the condition that an associated service system is needed to be changed when the standardized verification rule is newly built or updated is avoided, influence on the service system is reduced, and stability of the service system is improved. Meanwhile, the new construction or updating of the standardized verification rule can be quickly adapted by utilizing good rule maintainability and release mechanism of the rule engine, and the standardized verification efficiency is improved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute a limitation on the application. In the drawings:
fig. 1 is a flow chart of a data standardization management method provided in embodiment 1 of the present application;
fig. 2 is a schematic diagram of a material data editing page provided in embodiment 1 of the present application;
fig. 3 is a schematic diagram of an audit result pop-up page provided in embodiment 1 of the present application.
Detailed Description
In order to make the technical solutions and advantages of the embodiments of the present application more apparent, the following detailed description of exemplary embodiments of the present application is provided in conjunction with the accompanying drawings, and it is apparent that the described embodiments are only some embodiments of the present application and not exhaustive of all embodiments. It should be noted that, without conflict, the embodiments of the present application and features of the embodiments may be combined with each other.
Example 1
As shown in fig. 1, the present embodiment provides a data standardization management method, which includes:
s101, acquiring material standardized management requirement information;
s102, designing a standardized verification rule according to the material grouping and material attribute according to the material standardized management requirement information;
s103, releasing the standardized check rule service based on a rule engine, and providing a material standardized management interface for a service system;
s104, acquiring material data content input by a service system through a material standardization management interface, and auditing the material data content according to the standardization verification rule to acquire an auditing result.
Specifically, the data standardization management method provided by the embodiment is suitable for material standardization audit and management, and based on a rule engine technology, decoupling of material standardization pre-audit and business system business processing logic is achieved.
Firstly, acquiring material standardized management requirement information, analyzing the material standardized management requirement, and designing standardized verification rules according to material grouping and material properties. Standardized calibration rules typically include special calibration rules that pertain to individual material groupings, calibration rules that pertain to special material attributes, calibration rules that pertain to combinations among material attributes, and calibration rules that pertain to reference external standards. And then, issuing the standardized check rule service through a rule engine and providing a material standardized management interface for a business system. Business personnel can input material data content through the material standardized management interface. And finally, auditing the material data content through a designed standardized check rule to obtain a final auditing result. The audit result may include a result description, a corresponding modification opinion, and the like.
Furthermore, in the embodiment, a material standardized audit data model and a standardized check data constant base can be established. After the standardized verification rule is designed, a material standardized audit data model is established in a rule engine and used for acquiring material data contents input by business personnel through a business system. Various standardized data constants can be entered in the standardized verification data constant library for providing data range constants in the standardized verification process. And finally, auditing the material data content according to the standardized check rule and the standardized check data constant database to obtain an auditing result.
Furthermore, the embodiment can also perform independent verification test on each standardized verification rule based on the rule engine technology so as to reserve the standardized verification rule passing the verification test and improve the accuracy of the standardized verification. And then, carrying out priority sorting on the standardized check rules passing the verification test, and determining the execution sequence of the standardized check rules according to the priority sorting so as to improve the execution efficiency. The keyword in the material attribute can be judged according to the priority sorting, and for the auditing flow which requires high execution efficiency and gives auditing results as early as possible, the auditing conclusion can be obtained quickly for the scene that only standardized auditing results need to be known. For the verification rule only referring to the standardized verification data constant library, the verification process is time-consuming due to the large data volume stored in the standardized verification data constant library, and the verification efficiency is lower than that of some special verification rules. Therefore, after the execution sequence is set, the priority of the execution sequence is properly reduced, and other auditing conclusions with high execution efficiency are output preferentially.
In addition, in this embodiment, a material data editing page may be set in the service system, and a calling module, such as a button or a link, that can call the material standardization management interface may be set in the material data editing page. Business personnel can input material data content through the material data editing page so as to audit the material data content according to the standardized verification rule to obtain an audit result.
If the material standardization management requirement is changed, new standardization check rule design can be carried out according to the changed material standardization management requirement, and new standardization check rule service is issued based on a rule engine, so that the related information of the material standardization management interface provided for the service system is kept unchanged, and the stability and convenience of the auditing process are improved. In addition, version change records and service release records of the standardized verification rules can be saved based on the rule engine. The material data content input by the business system through the material standardized management interface and the version information of the corresponding standardized verification rule are summarized and stored, so that the normal use of historical data and the normal circulation of the auditing flow after the material standardized management requirement is changed can be well kept, and the influence of the material standardized management requirement change on the business is reduced.
In the following, taking a standardized verification process of "material description" common in materials as an example, a specific workflow of the data standardized management method proposed in this embodiment is further described in detail.
In the material standardization management, "material description" requires filling in the material quality mark of the material of the processed material or the performance grade, the manufacturing mode, etc. of the material. Filling is required according to the material standard according to the requirement, and the material grouping is matched with the material group to which the specific material data belong.
Firstly, acquiring material standardized management requirement information, analyzing the material standardized management requirement, and designing standardized verification rules according to material grouping and material properties.
The wooden panel class of material group relates to two material group subclasses, is respectively: ECE (artificial board) and ECF wood and bamboo products, wherein the material group codes are respectively as follows: ECE and ECF.
For ECE material group material data, the material description must contain keyword information of equal or level, otherwise, the material standardized auditing requirement is not met.
For ECF material group material data, the material description must be filled with the material of timber, and the standard material name of timber is required as a reference.
The group fastener class refers to a group class IB, i.e., the group code data starting with IB all follow this standard rule.
For the IBA material group material data, the material description may not include "level" keyword information, but the material description must include "level" keyword information for all the material group material data under IB except IBA.
For all material group material data under IB types, material marks of corresponding fasteners must be filled in material descriptions. According to different material subclasses, a material grade standard name table is manufactured as a reference.
And then, issuing the standardized check rule service through a rule engine and providing a material standardized management interface for a business system. Interface address samples are for example:
http://xxx.xxx.xxx:xxxx/MATERIALSTANDAR/rulesApi/forXXXSystem。
and finally, auditing the material data content through a designed standardized check rule to obtain a final auditing result. The audit result may include a result description, a corresponding modification opinion, and the like.
The method comprises the steps of establishing a material standardization audit data model in a rule engine, and acquiring material data contents input by business personnel through a business system. And simultaneously, a standardized check data constant library is established and is used for providing data range constants in the standardized check process.
The material standardized audit data model may include a material name, a material group code, a material description, return information, and audit results. The material name, the material group code and the material description are input attributes, and the returned information and the auditing result are output attributes.
The standardized verification data constant library may include a wood material specification name table and a material brand specification name table. The wood material specification name table can assist in determining whether the material description contains the information of the compliant wood material, such as Korean pine. The material grade specification name table may assist in determining whether the material description includes information of a compliant material grade, such as Fe 410W.
The verification test of the regularization check rule can be realized by adopting a rule engine decision tree, then the normalized check rule passing the verification test is prioritized, and the execution sequence of the normalized check rule is determined according to the prioritized order.
A material data editing page may be set in the service system, and a calling module, such as a button or a link, which may call the material standardization management interface, may be set in the material data editing page, such as a "standardization prereview" button shown in fig. 2. After the business personnel inputs the material data content through the material data editing page, clicking the standardized pre-examination button. And auditing the material data content according to the standardized verification rule, and providing independent popup page display auditing results, as shown in figure 3.
If the material standardization management requirement is changed, new standardization check rule design can be carried out according to the changed material standardization management requirement, and new standardization check rule service is issued based on a rule engine, so that the related information of the material standardization management interface provided for the service system is kept unchanged. In addition, version change records and service release records of the standardized verification rules can be saved based on the rule engine. And summarizing and storing the material data content input by the business system through the material standardization management interface and version information of the corresponding standardization check rule.
According to the embodiment, the standardized check rule is strictly designed according to the material standardized management requirement, and the standardized check rule service is provided for the service system, so that the material data content is subjected to standardized audit. By enabling the standardized verification rule service to be independent of the service system, only one-time interface integration is needed, the condition that an associated service system is needed to be changed when the standardized verification rule is newly built or updated is avoided, influence on the service system is reduced, and stability of the service system is improved. Meanwhile, the new construction or updating of the standardized verification rule can be quickly adapted by utilizing good rule maintainability and release mechanism of the rule engine, and the standardized verification efficiency is improved. In addition, the method provided by the embodiment is also convenient for unified management of material standardization check among a plurality of service systems, and solves the problems that the response time of the service systems to material standardization management requirement change is inconsistent, so that material standardization check is asynchronous, and the service flow is influenced.
Example 2
Corresponding to embodiment 1, this embodiment proposes a data standardization management device, which includes:
a memory;
a processor; and
a computer program;
wherein the computer program is stored in the memory and configured to be executed by the processor to implement a data standardization management method. The data standardization management method can refer to the content described in embodiment 1, and the description of this embodiment is omitted.
Example 3
The present embodiment proposes a computer-readable storage medium having a computer program stored thereon; the computer program is executed by a processor to implement a data normalization management method. The data standardization management method can refer to the content described in embodiment 1, and the description of this embodiment is omitted.
According to the embodiment, the standardized check rule is strictly designed according to the material standardized management requirement, and the standardized check rule service is provided for the service system, so that the material data content is subjected to standardized audit. By enabling the standardized verification rule service to be independent of the service system, only one-time interface integration is needed, the condition that an associated service system is needed to be changed when the standardized verification rule is newly built or updated is avoided, influence on the service system is reduced, and stability of the service system is improved. Meanwhile, the new construction or updating of the standardized verification rule can be quickly adapted by utilizing good rule maintainability and release mechanism of the rule engine, and the standardized verification efficiency is improved.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein. The scheme in the embodiment of the application can be realized by adopting various computer languages, such as object-oriented programming language Java, an transliteration script language JavaScript and the like.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In the description of the present application, it should be understood that the terms "center", "longitudinal", "lateral", "length", "width", "thickness", "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", etc. indicate orientations or positional relationships based on the drawings are merely for convenience in describing the present application and simplifying the description, and do not indicate or imply that the device or element in question must have a specific orientation, be configured and operated in a specific orientation, and thus should not be construed as limiting the present application.
Furthermore, the terms "first," "second," and the like, are used for descriptive purposes only and are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include one or more such feature. In the description of the present application, the meaning of "plurality" means at least two, for example, two, three, etc., unless specifically defined otherwise.
In the present application, unless explicitly specified and limited otherwise, the terms "mounted," "connected," "secured," and the like are to be construed broadly, and may be, for example, fixedly connected, detachably connected, or integrally formed; may be mechanically connected, may be electrically connected or may communicate with each other; can be directly connected or indirectly connected through an intermediate medium, and can be communicated with the inside of two elements or the interaction relationship of the two elements. The specific meaning of the above terms in the present application can be understood by those of ordinary skill in the art according to the specific circumstances.
While preferred embodiments of the present application have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. It is therefore intended that the following claims be interpreted as including the preferred embodiments and all such alterations and modifications as fall within the scope of the application.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present application without departing from the spirit or scope of the application. Thus, it is intended that the present application also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.

Claims (10)

1. A method of data standardization management, the method comprising:
acquiring material standardized management requirement information;
according to the material standardized management requirement information, designing standardized verification rules according to material grouping and material properties;
the standardized check rule service is issued based on a rule engine, and a material standardized management interface is provided for a service system;
and acquiring material data content input by a business system through a material standardized management interface, and auditing the material data content according to the standardized verification rule to acquire an auditing result.
2. The method of claim 1, wherein the standardized verification rule comprises: the verification method comprises the steps of a special verification rule belonging to independent material grouping, a verification rule belonging to special material attributes, a verification rule belonging to combination among all material attributes and a verification rule belonging to reference external standards.
3. The method of claim 1, wherein after designing the standardized verification rules, the method further comprises:
establishing a material standardized audit data model and a standardized check data constant base in a rule engine;
acquiring material data content input by a business system through the material standardized audit data model;
and auditing the material data content according to the standardized check rule and the standardized check data constant database to obtain an auditing result.
4. The method of claim 1, wherein after designing the standardized verification rules, the method further comprises:
and carrying out verification test on the standardized verification rule based on a rule engine, and reserving the standardized verification rule passing the verification test.
5. The method of claim 4, wherein after retaining standardized verification rules that pass the validation test, the method further comprises:
and carrying out priority ordering on the standardized check rules passing the verification test, and determining the execution sequence of the standardized check rules according to the priority ordering.
6. The method according to claim 1, wherein the method further comprises:
setting a material data editing page in a business system;
and setting a calling module for calling the material standardized management interface in the material data editing page.
7. The method according to claim 1, wherein the method further comprises:
acquiring material standardized management requirement change information;
changing information according to the material standardized management requirements, and designing a new standardized verification rule according to material grouping and material properties;
the new standardized verification rule service is issued based on a rule engine.
8. The method according to claim 1, wherein the method further comprises:
storing version change records and service release records of the standardized verification rules based on a rule engine;
and summarizing and storing the material data content input by the business system through the material standardization management interface and version information of the corresponding standardization check rule.
9. A data standardization management apparatus, comprising:
a memory;
a processor; and
a computer program;
wherein the computer program is stored in the memory and configured to be executed by the processor to implement the method of any one of claims 1 to 8.
10. A computer-readable storage medium, characterized in that a computer program is stored thereon; the computer program being executed by a processor to implement the method of any one of claims 1 to 8.
CN202210576816.3A 2022-05-25 2022-05-25 Data standardization management method, device and medium Pending CN117196163A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210576816.3A CN117196163A (en) 2022-05-25 2022-05-25 Data standardization management method, device and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210576816.3A CN117196163A (en) 2022-05-25 2022-05-25 Data standardization management method, device and medium

Publications (1)

Publication Number Publication Date
CN117196163A true CN117196163A (en) 2023-12-08

Family

ID=89000232

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210576816.3A Pending CN117196163A (en) 2022-05-25 2022-05-25 Data standardization management method, device and medium

Country Status (1)

Country Link
CN (1) CN117196163A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN119721999A (en) * 2025-03-04 2025-03-28 中汽数据(天津)有限公司 A material data system collaborative management linkage method, device, medium and product

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN119721999A (en) * 2025-03-04 2025-03-28 中汽数据(天津)有限公司 A material data system collaborative management linkage method, device, medium and product
CN119721999B (en) * 2025-03-04 2025-09-05 中汽数据(天津)有限公司 A material data system collaborative management linkage method, equipment, medium and product

Similar Documents

Publication Publication Date Title
US9037549B2 (en) System and method for testing data at a data warehouse
CN104572122B (en) A kind of generating means and method of software application data
CN107291450B (en) Programming-friendly agile code automatic generation method
CN111126026B (en) Method and tool for generating visual report form by analyzing SQL statement
CN111061733A (en) Data processing method, apparatus, electronic device and computer-readable storage medium
WO2005026993A1 (en) A system and method for managing item interchange and identification in an extended enterprise
CN117742681B (en) Multistage data model code generation method, system, storage medium and electronic equipment
CN117196163A (en) Data standardization management method, device and medium
CN113158633A (en) Statistical report processing method and device
US8010217B2 (en) Reconfiguration of assets for reuse during manufacturing
CN116227454A (en) Universal automatic report generation method and system
CN114416750B (en) A modeling storage method, device and medium for electronic spreadsheet
CN115619329A (en) Server order verification method, device, equipment and readable storage medium
CN118035117A (en) A fine-grained test case system for component-based satellite service software
US7856428B2 (en) Method, computer program product and device for importing a plurality of data sets into a system
CN112131022B (en) Open API management method, device, system and computer readable storage medium
CN115858377B (en) Data testing system and method based on guest group management
CN116225957A (en) Software testing method and device, electronic equipment and storage medium
CN116227452B (en) Method, apparatus, device and storage medium for analyzing templates using assembled cards
CN119961226B (en) Automatic file arrangement framework, method and computer program product based on large language model
CN120257955A (en) A report generation method and device supporting multiple layouts and multiple templates
CN119691800A (en) Data sharing method, device and medium
CN119441053A (en) Automated testing method, device, equipment and storage medium
CN116841909A (en) Template-based universal automatic data inspection method and test case module
CN115952164A (en) Report frame generation method and 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