Data consistency detection method, device, computer equipment and storage medium

Abstract

The present application relates to a data consistency detection method, device, computer equipment, storage medium and computer program article. The method includes: obtaining material procurement data from a first database, and obtaining material design data from a second database; comparing the function position code of the material in the material procurement data with the function position code of the material in the material design data, and obtaining target material procurement data and target material design data whose function position codes are inconsistent; when the target material procurement data contains both equipment items and function position codes, determining the equipment type to which the material belongs based on the equipment items and function position codes; matching the equipment type with the material in the target material design data to obtain a matching result; and generating a consistency detection result based on the matching result. The present method can more accurately monitor the consistency of material design data and material procurement data.

Description

Technical Field

[0001] The present application relates to the technical field of data detection, and in particular to a data consistency detection method, device, computer equipment, storage medium and computer program product. Background Art

[0002] During the planning and construction phases of the project, it may be necessary to modify the design plan or change related details, which may change the equipment demand plan and procurement plan. The advance or delay in the construction progress will also affect the demand plan and procurement plan.

[0003] In traditional technical solutions, if the design department changes the design plan or changes the details of the design plan, the revised design plan will be sent to the procurement department, and the procurement department will manually check the procurement plan based on the design plan. After the check is completed, the checked procurement plan will be stored in the warehouse. If the design department changes the design plan multiple times, the procurement department needs to manually check it multiple times, which may cause false detection during the check process. Summary of the invention

[0004] Based on this, it is necessary to provide a data detection method, device, computer equipment, computer-readable storage medium and computer program product that can accurately perform data consistency detection in response to the above technical problems.

[0005] In a first aspect, the present application provides a method for detecting consistency of data, the method comprising:

[0006] Acquiring material procurement data from a first database, and acquiring material design data from a second database;

[0007] Compare the function position code of the material in the material procurement data with the function position code of the material in the material design data to obtain target material procurement data and target material design data whose function position codes of the materials are inconsistent;

[0008] When the target material procurement data includes both the equipment item and the function location code, determining the equipment type to which the material belongs based on the equipment item and the function location code;

[0009] Matching the equipment type with the material in the target material design data to obtain a matching result;

[0010] A consistency detection result is generated based on the matching result.

[0011] In one embodiment, the materials in the target material procurement data include equipment; the materials in the target material design data include components;

[0012] The matching of the equipment type with the material in the target material design data includes:

[0013] Determine component identifiers corresponding to components constituting the device based on the device type;

[0014] The component identification is matched with the component in the target material design data.

[0015] In one embodiment, generating a consistency detection result based on the matching result includes:

[0016] If the matching result indicates that the device type is consistent with the material in the target material design data, a detection result indicating that the target material procurement data and the target material design data are consistent is generated based on the matching result.

[0017] In one embodiment, the consistency detection result includes a first data comparison table and a second data comparison table, and generating the consistency detection result based on the matching result includes:

[0018] If the matching result indicates that the equipment type is inconsistent with the function location code of the material in the target material design data, generating the first data comparison table and the second data comparison table based on the matching result;

[0019] Wherein, the first data comparison table includes the materials that do not exist in the first database but exist in the second database;

[0020] The second data comparison table includes the materials that do not exist in the second database but exist in the first database.

[0021] In one embodiment, the method further comprises:

[0022] Determining whether the target material design data has been changed according to the second data comparison table;

[0023] If so, generating a modification instruction for the target material procurement data;

[0024] The target material procurement data in the first database is modified based on the modification instruction so that the modified target material procurement data is consistent with the changed target material design data.

[0025] In one embodiment, after comparing the function location code of the material in the material procurement data with the function location code of the material in the material design data, the method further includes:

[0026] If the function position code of the material in the material procurement data is consistent with the function position code of the material in the material design data, it is determined that the material in the material procurement data is consistent with the material in the material design data.

[0027] In a second aspect, the present application further provides a data consistency detection device, the device comprising:

[0028] A data acquisition module, used to obtain material procurement data from the first database and material design data from the second database;

[0029] A first matching module is used to compare the function position code of the material in the material procurement data with the function position code of the material in the material design data, and obtain the target material procurement data and the target material design data whose function position codes of the materials are inconsistent;

[0030] An equipment type determination module, used for determining the equipment type to which the material belongs based on the equipment item and the function location code when the target material procurement data contains both the equipment item and the function location code;

[0031] A second matching module, used for matching the equipment type with the material in the target material design data to obtain a matching result;

[0032] The consistency result generating module is used to generate a consistency detection result based on the matching result.

[0033] In a third aspect, the present application further provides a computer device, wherein the computer device comprises a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the steps of the above-mentioned data consistency detection method are implemented.

[0034] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, which implements the steps of the above-mentioned data consistency detection method when executed by a processor.

[0035] In a fifth aspect, the present application further provides a computer program product, which includes a computer program, and when the computer program is executed by a processor, the steps of the above data consistency detection method are implemented.

[0036] The above-mentioned data consistency detection method, device, computer equipment, storage medium and computer program product will not directly consider that there is a data inconsistency problem when the function position code of the material in the material procurement data is inconsistent with the function position code of the material in the material design data. Instead, it will screen out the target material procurement data and target material design data with inconsistent function position codes of the materials, determine the equipment type to which the material belongs based on the equipment item and function position code in the target material procurement data, and then match the equipment type with the material in the target material design data to obtain a matching result, thereby effectively improving the data consistency detection result. Therefore, when designing or purchasing materials, it is possible to promptly discover whether there is a problem in the design link or the procurement link. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Figure 1 An application environment diagram of a data consistency detection method in one embodiment;

[0038] Figure 2 A schematic diagram of a flow chart of a method for detecting consistency of data in one embodiment;

[0039] Figure 3 is a structural block diagram of a data consistency detection device in one embodiment;

[0040] Figure 4 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0041] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0042] The data consistency detection method provided in the embodiment of the present application can be applied to Figure 1 In the application environment shown. Among them, the terminal 102 communicates with the server 104 through the network. The data storage system can store data that the server 104 needs to process. The data storage system can be integrated on the server 104, or it can be placed on the cloud or other network servers. Obtain material procurement data from the first database, and obtain material design data from the second database; compare the function location code of the material in the material procurement data with the function location code of the material in the material design data to obtain the target material procurement data and target material design data whose function location code is inconsistent; when the target material procurement data contains both equipment items and function location codes, determine the equipment type to which the material belongs based on the equipment items and function location codes; match the equipment type with the material in the target material design data to obtain a matching result; generate a consistency test result based on the matching result.

[0043] The terminal 102 may be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, IoT devices, and portable wearable devices. The IoT devices may be smart speakers, smart TVs, smart air conditioners, smart car-mounted devices, etc. The portable wearable devices may be smart watches, smart bracelets, head-mounted devices, etc. The server 104 may be implemented as an independent server or a server cluster consisting of multiple servers.

[0044] In one embodiment, Figure 2 As shown, a data consistency detection method is provided, which is applied to Figure 1 The server in the example is used to illustrate the following steps:

[0045] Step 202, acquiring material procurement data from the first database, and acquiring material design data from the second database.

[0046] The first database is the database of the purchasing department, which is used to store material purchasing data, including the function location code, responsible person and purchasing package of the material to be purchased; the function location code of the material to be purchased is used to determine the location of the material after purchase and the function of the material. The purchasing package refers to the list of purchased materials, and the purchased materials can be the equipment to be purchased and / or the components of the equipment.

[0047] The second database is the database of the upstream node of the first database, which can be the database of the design department, the database of the planning and construction department, or the database of the construction department. The second database is used to store material design data, which includes the function location code of the material of the design scheme, the material code, the function category and the equipment item to which it belongs; among them, the function location code of the material of the design scheme is used to determine the location of the material in the design scheme and the function played by the material; the material code is used to determine the specific category of the material, and the function category is used to determine the function of the material in the equipment item to which it belongs; the equipment item is the equipment to which the design material belongs. For example: the equipment function location code is used to set up a certain equipment at a certain location in a site, and the material code of the equipment is used to identify the equipment; when the equipment is composed of multiple components, each component has a corresponding function location code and material code, and the function category of the component is used to indicate the function played by the component in the equipment, and the equipment item to which the component belongs is the equipment.

[0048] Step 204, compare the function position code of the material in the material procurement data with the function position code of the material in the material design data to obtain target material procurement data and target material design data whose function position codes are inconsistent.

[0049] By comparing the function position code of the material in the material procurement data with the function position code of the material in the material design data, it can be determined whether there are target material procurement data and target material design data whose function position codes of the materials are inconsistent.

[0050] In one embodiment, after comparing the function location code of the material in the material procurement data with the function location code of the material in the material design data, when the function location code of the material in the material procurement data is consistent with the function location code of the material in the material design data, it is determined that the material in the material procurement data is consistent with the material in the material design data, and the result is relatively accurate.

[0051] After comparing the function position code of the material in the material procurement data with the function position code of the material in the material design data, there are target material procurement data and target material design data with inconsistent function position codes of the materials. There are certain differences between the target material procurement data and the target material design data. The material in the target material procurement data can be a certain equipment or various parts of the equipment, while the material in the target material design data is multiple parts. Therefore, the inconsistent function position code is not used to represent the data inconsistency between the target material procurement data and the target material design data, but to represent that the target material procurement data and the target material design data are screened data, and the screened data needs to be further tested for material data consistency.

[0052] Step 206: When the target material procurement data includes both equipment items and function location codes, the equipment type to which the material belongs is determined based on the equipment items and function location codes.

[0053] In order to obtain more accurate data consistency test results, it is necessary to analyze the target material procurement data. When the target material procurement data contains both equipment items and function location codes, the equipment type to which the material belongs is determined based on the equipment items and function location codes to which the material belongs in the target material procurement data. The equipment items in the target material procurement data are used to characterize the association between a certain material and a certain device. Based on the association, it is determined that the material belongs to a certain device, and the device is the type of equipment to which the material belongs. Since a device can be composed of multiple materials, multiple materials can belong to one equipment type, and in the specific procurement process, multiple materials belonging to the same equipment type may be purchased in assembly. For example: when purchasing the computer, if you purchase a computer assembled by a certain company, there is material procurement data for the computer in the procurement system, but there is no material procurement data for a certain component. The material procurement data of the computer represents the material procurement data of the component.

[0054] Step 208, matching the equipment type with the material in the target material design data to obtain a matching result.

[0055] The equipment type to which the material in the target material procurement data belongs is matched with the material in the target material design data, so as to determine whether there is a corresponding relationship between the components belonging to the same equipment type and the materials in the target material design data. Furthermore, when there are certain differences between the target material procurement data and the target material design data, the matching result between the components of the same equipment type and the materials in the target material design data is obtained, and the matching result can be used for more accurate data consistency detection.

[0056] In one embodiment, the materials in the target material procurement data include equipment; the materials in the target material design data include parts, and the equipment type is matched with the materials in the target material design data. Step 204 includes: determining the part identification corresponding to the parts constituting the equipment based on the equipment type, and matching the part identification with the parts in the target material design data. When the part identification successfully matches the parts in the target material design data, it means that the matching parts in the equipment are consistent with the parts in the target material design data.

[0057] In a specific embodiment, the design department designs a computer and names it "Computer A". Computer A includes three parts: a host, a display, and a keyboard. These three parts are all components of Computer A, and the device type to which they belong (that is, the device to which these three components belong) is Computer A. Therefore, when designing, the names of the components should be entered into the second database, and the name "Computer A" should be filled in the item of the device to which they belong.

[0058] When purchasing the computer, if you purchase a computer assembled by a certain company, there is material procurement data for the computer in the procurement system, but there is no material procurement data for one or more components of the host, display and keyboard. The material procurement data of the computer represents the material procurement data of the component. Therefore, for this kind of assembly procurement, as long as the procurement system has the material procurement data of the computer, it can be shown that there is material procurement data for each component in the computer, which will not affect the specific procurement process. Therefore, the equipment type is successfully matched with the material in the target material design data.

[0059] Step 210: Generate a consistency detection result based on the matching result.

[0060] When the matching result of a material indicates a successful match, the consistency test result indicates that the material is consistent in the target material procurement data and the target material design data; when the matching result of a material indicates a failed match, the consistency test result indicates that the material is inconsistent in the target material procurement data and the target material design data.

[0061] In one embodiment, if the matching result indicates that the equipment type is consistent with the material in the target material design data, a test result is generated based on the matching result to indicate that the target material procurement data is consistent with the target material design data. As a result, no data comparison table is generated, and the material data consistency test is passed. This test result is not only the result of matching based on the function position code, but also determines the equipment type to which the material belongs based on the equipment item and the function position code, and then matches the equipment type with the material in the target material design data to obtain a matching result, thereby improving the accuracy of the test result.

[0062] After a material fails to match, the consistency test result is used to indicate that the material exists in the first database but not in the second database; the consistency test result can be used to indicate that the material exists in the second database but not in the first database. Therefore, through these two consistency matching results, the data consistency test results can be effectively improved, so when designing or purchasing materials, it can be discovered in time whether there is a problem in the design link or the purchasing link.

[0063] In a specific embodiment, the consistency detection result includes a first data comparison table and a second data comparison table, and step 210 specifically includes:

[0064] If the matching result indicates that the equipment type is inconsistent with the function position code of the material in the target material design data, a first data comparison table and a second data comparison table are generated based on the matching result; wherein the first data comparison table includes materials that do not exist in the first database but exist in the second database; wherein the second data comparison table includes materials that do not exist in the second database but exist in the first database. Specifically, after the data in the two databases are compared, if there is a material in the second database and the material does not exist in the first database, a first data comparison table of the dual databases is generated, and the material is recorded in the first data comparison table; when there is a material in the first database and the material does not exist in the second database, a second data comparison table of the dual databases is generated, and the material is recorded in the second data comparison table.

[0065] After obtaining the first data comparison table, the first data comparison table is displayed to the terminal held by the person in charge of the purchasing department to determine whether the material purchase data is missed, or the purchase is missed or the work is not standardized. After obtaining the second data comparison table, the second data comparison table needs to be displayed to the person in charge of the design department to check the design plan.

[0066] In a specific embodiment, in order to more clearly determine the cause of the data inconsistency of the material through the consistency result, the second data comparison table is also used to perform certain data processing.

[0067] Determine whether the target material design data has changed based on the second data comparison table; if so, generate a modification instruction for the target material procurement data; and modify the target material procurement data in the first database based on the modification instruction so that the modified target material procurement data is consistent with the changed target material design data. Specifically, after showing the second data comparison table to the person in charge of the design department, the person in charge of the design department will make a judgment. If the purchase of the material is cancelled due to the change of the target material design data, and the material still exists in the target material procurement data, a prompt message will be sent to the person in charge of the procurement department to prompt the person in charge of the procurement department to cancel the purchase of the material so that the modified target material procurement data is consistent with the changed target material design data.

[0068] If the target material design data has not changed, the person in charge of the design department will determine whether the material design data has not been filled in the second database, but the purchase documents have been sent to the purchasing department. If so, the material design data in the second database will be updated to make the target material purchase data consistent with the changed target material design data.

[0069] In the above data consistency detection method, when the function position code of the material in the material procurement data is inconsistent with the function position code of the material in the material design data, it is not directly considered that there is a data inconsistency problem. Instead, the target material procurement data and target material design data with inconsistent function position codes of the materials are screened out, and the equipment type to which the material belongs is determined based on the equipment item and function position code in the target material procurement data. The equipment type is then matched with the material in the target material design data to obtain a matching result, thereby effectively improving the data consistency detection result. Therefore, when designing or purchasing materials, it is possible to promptly discover whether there is a problem in the design link or the procurement link.

[0070] In a specific embodiment, a data consistency detection process in a nuclear power plant scenario is discussed, and the consistency detection process includes data collection, data matching and data output.

[0071] During the data collection process, the first database is the P source database and the second database is the E source database; material design data containing equipment function location codes are collected from the upstream E source database, and material procurement data containing equipment function location codes are collected from the P source database.

[0072] In the process of data matching, the E source database collected by the data acquisition module is compared with the equipment function position code in the P source database. If the two are inconsistent, the material design data and material procurement data corresponding to the inconsistent equipment function position code are screened out to obtain the target material procurement data and target material design data. If the target material procurement data has the corresponding data filled in the equipment item to which the material belongs, and the material has the equipment function position code, the equipment type to which the material belongs is determined based on the corresponding data filled in the equipment item and the equipment function position code, and the equipment type is compared with the material in the bill of materials, and the inconsistent target material design data and target material procurement data are screened out.

[0073] After data matching, a dual database comparison table is generated based on the inconsistent target material design data and target material procurement data. If there is a material in the E source database, but not in the P source database, a first dual database comparison table is generated; if there is a material in the P source database, but not in the E source database, a second dual database comparison table is generated. Among them, the first dual database comparison table: the material is in the E source database, but not in the P source database. The second dual database comparison table: the material is in the P source database, but not in the E source database.

[0074] After the dual database comparison table is generated, the first dual database comparison table and the second dual database comparison table are sent to corresponding terminals respectively.

[0075] For the person in charge of the purchasing department, after obtaining the first pair of database comparison tables, he will determine whether the material purchase data is missed, or whether the purchase is missed or the work is not standardized.

[0076] For the person in charge of the design department, after obtaining the second double database comparison table, it is determined whether the material is cancelled due to design changes, but the purchasing department has purchased the material; if so, a prompt message is sent to the terminal of the person in charge of the purchasing department to prompt the person in charge to cancel the purchase of the material. If not, it is determined whether the material design data is not filled in the E-source database, but the purchase document is sent to the purchasing department. If so, the E-source database is updated.

[0077] Therefore, when the design method undergoes multiple changes, the consistency of the material design data of the design department and the material procurement data of the procurement department can also be monitored to promptly discover inconsistencies, and promptly inquire about the causes of the problems and solve them.

[0078] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0079] Based on the same inventive concept, the embodiment of the present application also provides a data consistency detection device for implementing the consistency detection method involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in one or more consistency detection device embodiments provided below can refer to the limitations of the data consistency detection method above, and will not be repeated here.

[0080] In one embodiment, Figure 3 As shown, a data consistency detection device is provided, including: a data acquisition module 302, a first matching module 304, a device type determination module 306, a second matching module 308 and a consistency result generation module 310, wherein:

[0081] The data acquisition module 302 is used to obtain material procurement data from the first database and material design data from the second database;

[0082] The first matching module 304 is used to compare the function position code of the material in the material procurement data with the function position code of the material in the material design data, and obtain the target material procurement data and the target material design data whose function position codes of the materials are inconsistent;

[0083] An equipment type determination module 306, configured to determine the equipment type to which the material belongs based on the equipment item and the function location code when the target material procurement data contains both the equipment item and the function location code;

[0084] A second matching module 308, used to match the equipment type with the material in the target material design data to obtain a matching result;

[0085] The consistency result generating module 310 is used to generate a consistency detection result based on the matching result.

[0086] In one embodiment, the materials in the target material procurement data include equipment; the materials in the target material design data include components; the second matching module 308 includes:

[0087] A component determination unit, configured to determine component identifiers corresponding to components constituting the device based on the device type;

[0088] A component matching unit is used to match the component identification with the component in the target material design data.

[0089] In one embodiment, the consistency result generation module 310 is used to generate a detection result indicating that the target material procurement data and the target material design data are consistent based on the matching result if the matching result indicates that the equipment type is consistent with the material in the target material design data.

[0090] In one embodiment, the consistency detection result includes a first data comparison table and a second data comparison table, and the consistency detection result is generated based on the matching result. The consistency result generation module 310 includes:

[0091] a data comparison table generating unit, configured to generate the first data comparison table and the second data comparison table based on the matching result when the matching result indicates that the equipment type is inconsistent with the function position code of the material in the target material design data;

[0092] The first data comparison table includes materials that do not exist in the first database but exist in the second database;

[0093] The second data comparison table includes materials that do not exist in the second database but exist in the first database.

[0094] In one embodiment, the apparatus further comprises:

[0095] a change judgment module, used for judging whether the target material design data has been changed according to the second data comparison table;

[0096] A modification instruction generation module, used to generate a modification instruction for the target material procurement data when the target material design data is changed;

[0097] A data correction module is used to correct the target material procurement data in the first database based on the modification instruction so that the corrected target material procurement data is consistent with the changed target material design data.

[0098] In one embodiment, the device further comprises: a data consistency determination unit;

[0099] The data consistency judgment unit is used to determine that the material in the material procurement data is consistent with the material in the material design data if the function position code of the material in the material procurement data is consistent with the function position code of the material in the material design data.

[0100] Each module in the above data consistency detection device can be implemented in whole or in part by software, hardware and their combination. Each module can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the corresponding operations of each module.

[0101] The above-mentioned data consistency detection device will not directly consider that there is a data inconsistency problem when the function position code of the material in the material procurement data is inconsistent with the function position code of the material in the material design data, but will screen out the target material procurement data and target material design data with inconsistent function position codes of the materials, determine the equipment type to which the material belongs based on the equipment item and function position code in the target material procurement data, and then match the material in the target material design data through the equipment type to obtain a matching result, thereby effectively improving the data consistency detection result. Therefore, when designing or purchasing materials, it is possible to promptly discover whether there is a problem in the design link or the procurement link.

[0102] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 4 As shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. Among them, the processor, the memory and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The first database of the computer device is used to store material procurement data, and the second database is used to store material design data. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a data consistency detection method is implemented.

[0103] Those skilled in the art will understand that Figure 4The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0104] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0105] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0106] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0107] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards of relevant countries and regions.

[0108] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.

[0109] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0110] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A method for detecting consistency of data, characterized in that: The method comprises: Acquiring material procurement data from a first database, and acquiring material design data from a second database; Compare the function position code of the material in the material procurement data with the function position code of the material in the material design data to obtain target material procurement data and target material design data whose function position codes of the materials are inconsistent; When the target material procurement data contains both the equipment item and the function location code, the equipment item represents the association relationship between the material and the equipment; the equipment to which the material belongs is determined according to the association relationship represented by the function location code and the equipment item, and the equipment to which the material belongs is the equipment type; Matching the equipment type with the material in the target material design data to obtain a matching result; A consistency detection result is generated based on the matching result.

2. The method according to claim 1, characterized in that The materials in the target material procurement data include equipment; the materials in the target material design data include components; The matching of the equipment type with the material in the target material design data includes: Determine component identifiers corresponding to components constituting the device based on the device type; The component identification is matched with the component in the target material design data.

3. The method according to claim 1, characterized in that Generating a consistency detection result based on the matching result includes: If the matching result indicates that the device type is consistent with the material in the target material design data, a detection result indicating that the target material procurement data and the target material design data are consistent is generated based on the matching result.

4. The method according to claim 1, characterized in that: The consistency detection result includes a first data comparison table and a second data comparison table, and generating the consistency detection result based on the matching result includes: If the matching result indicates that the equipment type is inconsistent with the function location code of the material in the target material design data, generating the first data comparison table and the second data comparison table based on the matching result; Wherein, the first data comparison table includes the materials that do not exist in the first database but exist in the second database; The second data comparison table includes the materials that do not exist in the second database but exist in the first database.

5. The method according to claim 1, characterized in that The method further comprises: Determining whether the target material design data has been changed according to the second data comparison table; If so, generating a modification instruction for the target material procurement data; The target material procurement data in the first database is modified based on the modification instruction so that the modified target material procurement data is consistent with the changed target material design data.

6. The method according to claim 1, characterized in that After comparing the function position code of the material in the material procurement data with the function position code of the material in the material design data, the method further includes: If the function position code of the material in the material procurement data is consistent with the function position code of the material in the material design data, it is determined that the material in the material procurement data is consistent with the material in the material design data.

7. A data consistency detection device, characterized in that: The device comprises: A data acquisition module, used to obtain material procurement data from the first database and material design data from the second database; A first matching module is used to compare the function position code of the material in the material procurement data with the function position code of the material in the material design data, and obtain the target material procurement data and the target material design data whose function position codes of the materials are inconsistent; An equipment type determination module is used for, when the target material procurement data contains both equipment items and the function location code, the equipment item represents the association relationship between the material and the equipment; determining the equipment to which the material belongs according to the association relationship represented by the function location code and the equipment item, the equipment to which the material belongs is the equipment type; A second matching module, used for matching the equipment type with the material in the target material design data to obtain a matching result; The consistency result generating module is used to generate a consistency detection result based on the matching result.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images