CN113094338A - Data comparison method, system, device and medium - Google Patents
Data comparison method, system, device and medium Download PDFInfo
- Publication number
- CN113094338A CN113094338A CN202110277107.0A CN202110277107A CN113094338A CN 113094338 A CN113094338 A CN 113094338A CN 202110277107 A CN202110277107 A CN 202110277107A CN 113094338 A CN113094338 A CN 113094338A
- Authority
- CN
- China
- Prior art keywords
- data
- comparison
- file
- data comparison
- search
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/148—File search processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/156—Query results presentation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data comparison method, which comprises the following steps: step S1: receiving a search instruction, calling and running a search and comparison script; step S2: searching the A-type files and the B-type files in the specified database according to preset keywords; step S3: recording a search result to form a data comparison table; step S4: comparing the data according to a preset comparison rule, and displaying a comparison result; the A-type file is a compared target file, and the B-type file is a data comparison tool and a design file. The invention also provides a data comparison system, a data comparison device and a computer readable medium, which can effectively reduce the workload and improve the file analysis comparison efficiency.
Description
Technical Field
The present invention relates to the field of data comparison technologies, and in particular, to a data comparison method, system, device, and medium.
Background
With the increasing heavy task of aerospace model development, the occurrence of product faults becomes an important factor for restricting the smooth progress of model tasks. Analysis of the causes of product failures in recent years has shown that design-induced product failures are largely due to the associated technical and regulatory requirements being unclear or poorly performing. In the existing management system, for the cause analysis of a product fault, multiple related files, technical requirements and management requirements thereof need to be consulted, and technical parameters, technical requirements, management requirements and the like appearing therein are checked one by one, so that the process is complex and is easy to miss.
Through search, patent document CN107346330A discloses a data comparison method and device, including: importing data to be compared; preprocessing the data to be compared based on the full-amount associated information database; setting a data comparison rule; comparing the preprocessed data to be compared according to a data comparison rule; and outputting a comparison result. According to the prior art, after data to be compared is preprocessed by using a full-amount associated information database, the preprocessed data to be compared is compared according to a set data comparison rule, although the efficiency of data set comparison by using fragmented data can be greatly improved, the cause analysis of a product fault still exists, a plurality of files related to the product fault and technical and management requirements of the files need to be compared, the problem that the comparison work can be completed only if the files are searched in all uploaded files, huge workload still exists, time is consumed, and efficiency is low.
Therefore, it is urgently needed to develop a method and a tool for comparing file data in product failure cause analysis and correction, which can effectively reduce workload and improve file analysis and comparison efficiency.
Disclosure of Invention
In view of the defects in the prior art, the present invention is directed to a data comparison method, system, device, and medium.
The data comparison method provided by the invention comprises the following steps:
step S1: receiving a search instruction, calling and running a search and comparison script;
step S2: searching the A-type files and the B-type files in the specified database according to preset keywords;
step S3: recording a search result to form a data comparison table;
step S4: comparing the data according to a preset comparison rule, and displaying a comparison result;
the A-type file is a compared target file, and the B-type file is a data comparison tool and a design file.
Preferably, the method further comprises the following steps:
step S5: after the comparison result is displayed, the user end analyzes the fault cause and provides a fault correction suggestion according to the comparison result;
step S6: the fault cause analysis and correction recommendations are transmitted back to the designated location in the product fault database.
Preferably, step S1 is to fill in the keyword information during the data comparison initiation process.
Preferably, the class A files are established according to professional and position hierarchical levels.
Preferably, in step S2, the a-class file under the specified path is searched according to the preset keyword, the file name and the code number are recorded, the paragraph and the number of times of each keyword appearing in the specified a-class file are recorded, the paragraph and the number of times are added to the data comparison table formed in the background, and the file name and the code number are added to be the new keyword.
Preferably, in step S2, the specified B-type file is searched for, and the paragraphs and the number of times each keyword appears in the specified file are recorded.
Preferably, the preset alignment rule comprises the following steps: comparing paragraphs of each keyword appearing in the A-type file with paragraphs appearing in the B-type file, firstly comparing numbers and letters appearing in the A-type file, if the numbers are consistent, recording the corresponding numbers, and transmitting the corresponding numbers and the result of the numerical conformity back to the designated position in the display of the comparison result; if no consistency data is found, continuing to perform text search, recording characters which appear in the text, such as 'should', 'greater', 'less', 'no less', 'higher', 'no higher', 'lower', 'no lower' and ten characters behind the characters, and transmitting the recorded characters back to the designated position in the comparison result display.
The data comparison system provided by the invention comprises any one or more of the following modules:
a starting module: the system comprises a data processing module, a data processing module and a data processing module, wherein the data processing module is used for receiving a file data searching and comparing instruction initiated in the process of analyzing and correcting a product fault cause;
a search module: searching data of the corresponding file, and adding the data into a data comparison table;
a processing module: comparing the data of the data comparison standard according to a preset comparison rule;
a transmission module: and the system is used for transmitting the comparison result back to the display interface and transmitting the fault cause analysis and correction suggestion back to the specified position.
According to the present invention, a computer-readable storage medium is provided, in which a computer program is stored, which, when being executed by a processor, carries out the steps of the method as described above.
The data comparison device provided by the invention comprises the data comparison system or the computer readable storage medium storing the computer program.
Compared with the prior art, the invention has the following beneficial effects:
1. the invention sets the A-type file database and the B-type file database, searches whether the a-type file has related parameters or not, and if so, then looks at whether the B-type file has related parameters or not, so as to realize the extraction of data between the two files, and solve the technical problems that in the prior art, a plurality of files related to the a-type file and technical and management requirements thereof need to be consulted, the technical parameters, the technical requirements, the management requirements and the like appearing in the files are checked one by one, and the process is complex and is easy to miss.
2. The searching sequence of the invention can not only effectively reduce the workload, but also improve the file analysis and comparison efficiency.
3. According to the invention, data are extracted and compared in a parameter setting mode, so that the method is more efficient and less prone to errors compared with the prior art for extracting and comparing the contents among files.
Drawings
Other features, objects and advantages of the invention will become more apparent upon reading of the detailed description of non-limiting embodiments with reference to the following drawings:
FIG. 1 is a search comparison flowchart of a data comparison method according to the present invention;
FIG. 2 is a layout diagram of a comparison interface of the data comparison method of the present invention;
FIG. 3 is a schematic diagram of a class A file database architecture of the data comparison method of the present invention;
FIG. 4 is a layout diagram of a comparison result interface of the data comparison method of the present invention;
FIG. 5 is a diagram of a data transmission architecture of the data comparison method of the present invention.
Detailed Description
The present invention will be described in detail with reference to specific examples. The following examples will assist those skilled in the art in further understanding the invention, but are not intended to limit the invention in any way. It should be noted that it would be obvious to those skilled in the art that various changes and modifications can be made without departing from the spirit of the invention. All falling within the scope of the present invention.
As shown in fig. 1-5, the present invention provides a data comparison method, comprising the following steps:
step S1: and receiving a search instruction, and calling and running a search and comparison script.
Step S2: and searching the A-type files and the B-type files in the specified database according to preset keywords.
Step S3: and recording the search result to form a data comparison table.
Step S4: and comparing the data according to a preset comparison rule, and displaying a comparison result.
Further, the data comparison method provided by the invention further comprises the following steps:
step S5: and after the comparison result is displayed, the user end analyzes the fault cause according to the comparison result and provides a fault correction suggestion.
Step S6: the fault cause analysis and correction recommendations are transmitted back to the designated location in the product fault database.
More specifically, as shown in fig. 2, before the data comparison method of the present invention is started, a data comparison initiating method, a comparison target file (a-type file) database, a file data searching and comparing tool, and an interface between the data comparison tool and a design file (B-type file) storage system in the product failure cause analysis and correction process need to be established.
Therefore, the keyword information is filled in during the data comparison and initiation process. The A-type file is established hierarchically according to the speciality and the position.
Continuing further, the specific steps mentioned in the above steps include: searching the A-type file under the appointed path according to the preset keywords, recording the file name and the code number, recording the paragraph and the times of each keyword appearing in the appointed A-type file, adding a data comparison table formed in a background, and simultaneously adding the file name and the code number into new keywords. And B-type files are designated for searching, and paragraphs and times of occurrence of each keyword in the designated files are recorded.
The preset comparison rule comprises the following steps: comparing paragraphs of each keyword appearing in the A-type file with paragraphs appearing in the B-type file, firstly comparing numbers and letters appearing in the A-type file, if the numbers are consistent, recording the corresponding numbers, and transmitting the corresponding numbers and the result of the numerical conformity back to the designated position in the display of the comparison result; if no consistency data is found, continuing to perform text search, recording characters which appear in the text, such as 'should', 'greater', 'less', 'no less', 'higher', 'no higher', 'lower', 'no lower' and ten characters behind the characters, and transmitting the recorded characters back to the designated position in the comparison result display.
The invention also provides a data comparison system, which comprises any one or more of the following modules:
a starting module: the system comprises a data processing module, a data processing module and a data processing module, wherein the data processing module is used for receiving a file data searching and comparing instruction initiated in the process of analyzing and correcting a product fault cause;
a search module: searching data of the corresponding file, and adding the data into a data comparison table;
a processing module: comparing the data of the data comparison standard according to a preset comparison rule;
a transmission module: and the system is used for transmitting the comparison result back to the display interface and transmitting the fault cause analysis and correction suggestion back to the specified position.
Next, the operation is performed in a concrete manner, as shown in fig. 2, a "file comparison" operation button is set on the product fault data reporting interface, a button is clicked, a file comparison instruction is initiated, and the comparison interface is entered. As shown in FIG. 3, the A analogy target document database is built according to professional and position levels.
As shown in fig. 1 and 4, the specific process includes inputting keywords in the standard comparison interface, inputting a name of a design file in the column "design file", inputting a name of a professional and a post in the column "standard file", inputting a name of a parameter in the column "design parameter", clicking a "search" button, and initiating a search comparison program. And calling standard data in a standard database, searching all standard file contents under a specific professional and post folder according to the filled key words of the standard files, extracting and recording standard names and codes, and adding new key words. And calling standard data in a standard database, searching all standard contents under a specific specialty and a post folder according to the filled key words of the design parameters, extracting paragraphs containing the key words of the design parameters, and adding the paragraphs into a data comparison table. The background calls file data in a product design file storage system, searches the filled design files, and searches whether related standards are quoted in file contents, if the file contents do not contain the standard name and code number keywords in the comparison result record, the unreferenced related standards are returned to a comparison result interface result 1; if the keywords of the standard name and the code number are found, the result is 'referred relevant standard' and is transmitted back to a comparison result interface 'result 1'.
And continuing to further say, the background calls the file data in the product design file storage system, searches the file content of the filled design file according to the key words of the filled design parameters, extracts the paragraphs containing the key words of the design parameters, and adds the paragraphs into the data comparison table.
Comparing paragraphs of each keyword appearing in the standard file with paragraphs appearing in the design file, firstly comparing numbers and letters appearing in the standard file, if the numbers are consistent, recording the corresponding numbers, and transmitting the corresponding numbers and the result of 'numerical value conformity' back to a comparison interface 'result 2'; if no consistency data is found, the result of 'no check of coincidence value' is returned to the comparison interface 'result 2' in the 6; then, continuing to perform character comparison, extracting characters which appear in the characters, namely 'should', 'greater than', 'no greater than', 'less than', 'no less than' and 10 characters behind the characters, and returning the extracted characters to a comparison interface, namely 'result 3' and 'result 4'. The user terminal can select corresponding characters from the pull-down menus of 'failure cause analysis' and 'improvement suggestion' in the comparison result interface, click the 'completion' button, and upload the conclusion and the suggestion to corresponding positions in the standard database.
As shown in fig. 5, the a-type file is a comparison target file, and the a-type file is stored corresponding to the standard database in fig. 5; the B-type file is a data comparison tool and a design file, and is stored corresponding to the product design file storage system in the figure 5; the standard comparison tool is also a data comparison system; the product failure database is stored in the background, and the position where the task is initiated and the position where the data is backfilled are sent out from the product failure database.
Those skilled in the art will appreciate that, in addition to implementing the system and its various devices, modules, units provided by the present invention as pure computer readable program code, the system and its various devices, modules, units provided by the present invention can be fully implemented by logically programming method steps in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers and the like. Therefore, the system and various devices, modules and units thereof provided by the invention can be regarded as a hardware component, and the devices, modules and units included in the system for realizing various functions can also be regarded as structures in the hardware component; means, modules, units for performing the various functions may also be regarded as structures within both software modules and hardware components for performing the method.
The foregoing description of specific embodiments of the present invention has been presented. It is to be understood that the present invention is not limited to the specific embodiments described above, and that various changes or modifications may be made by one skilled in the art within the scope of the appended claims without departing from the spirit of the invention. The embodiments and features of the embodiments of the present application may be combined with each other arbitrarily without conflict.
Claims (10)
1. A data comparison method is characterized by comprising the following steps:
step S1: receiving a search instruction, calling and running a search and comparison script;
step S2: searching the A-type files and the B-type files in the specified database according to preset keywords;
step S3: recording a search result to form a data comparison table;
step S4: comparing the data according to a preset comparison rule, and displaying a comparison result;
the A-type file is a compared target file, and the B-type file is a data comparison tool and a design file.
2. The data alignment method of claim 1, further comprising the steps of:
step S5: after the comparison result is displayed, the user end analyzes the fault cause and provides a fault correction suggestion according to the comparison result;
step S6: the fault cause analysis and correction recommendations are transmitted back to the designated location in the product fault database.
3. The data comparison method of claim 1, wherein step S1 is to fill in keyword information during the data comparison initiation process.
4. The data comparison method of claim 1, wherein the class A file is established hierarchically according to speciality and position.
5. The data comparison method of claim 1, wherein in step S2, the a-class file under the specified path is searched according to preset keywords, the file name and code number are recorded, the paragraphs and times of each keyword appearing in the specified a-class file are recorded, a data comparison table formed in a background is added, and the file name and code number are added to become new keywords.
6. The data comparison method of claim 1, wherein in step S2, a specified B-type file is searched, and paragraphs and times of occurrence of each keyword in the specified file are recorded.
7. The data alignment method of claim 1, wherein the preset alignment rule comprises the following steps:
comparing paragraphs of each keyword appearing in the A-type file with paragraphs appearing in the B-type file, firstly comparing numbers and letters appearing in the A-type file, if the numbers are consistent, recording the corresponding numbers, and transmitting the corresponding numbers and the result of the numerical conformity back to the designated position in the display of the comparison result; if no consistency data is found, continuing to perform text search, recording characters which appear in the text, such as 'should', 'greater', 'less', 'no less', 'higher', 'no higher', 'lower', 'no lower' and ten characters behind the characters, and transmitting the recorded characters back to the designated position in the comparison result display.
8. A data comparison system, characterized by comprising any one or more of the following modules:
a starting module: the system comprises a data processing module, a data processing module and a data processing module, wherein the data processing module is used for receiving a file data searching and comparing instruction initiated in the process of analyzing and correcting a product fault cause;
a search module: searching data of the corresponding file, and adding the data into a data comparison table;
a processing module: comparing the data of the data comparison standard according to a preset comparison rule;
a transmission module: and the system is used for transmitting the comparison result back to the display interface and transmitting the fault cause analysis and correction suggestion back to the specified position.
9. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.
10. A data alignment apparatus comprising the data alignment system of claim 8 or the computer-readable storage medium of claim 9 in which the computer program is stored.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110277107.0A CN113094338B (en) | 2021-03-15 | 2021-03-15 | Data comparison method, system, device and medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110277107.0A CN113094338B (en) | 2021-03-15 | 2021-03-15 | Data comparison method, system, device and medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113094338A true CN113094338A (en) | 2021-07-09 |
CN113094338B CN113094338B (en) | 2022-12-13 |
Family
ID=76667409
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110277107.0A Active CN113094338B (en) | 2021-03-15 | 2021-03-15 | Data comparison method, system, device and medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113094338B (en) |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1455902A (en) * | 2000-07-17 | 2003-11-12 | 西门子公司 | Method for comparing search profiles |
CN104361001A (en) * | 2014-09-29 | 2015-02-18 | 株洲南车时代电气股份有限公司 | LKJ basic data comparison method and system |
CN105701247A (en) * | 2016-03-03 | 2016-06-22 | 黄川东 | Construction method for engineering-product parameterization application system |
CN110297842A (en) * | 2019-06-25 | 2019-10-01 | 武汉联影医疗科技有限公司 | A kind of data comparison method, device, terminal and storage medium |
CN111985881A (en) * | 2019-05-24 | 2020-11-24 | 上海传时软件技术开发有限公司 | Intelligent contract review system and method |
-
2021
- 2021-03-15 CN CN202110277107.0A patent/CN113094338B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1455902A (en) * | 2000-07-17 | 2003-11-12 | 西门子公司 | Method for comparing search profiles |
CN104361001A (en) * | 2014-09-29 | 2015-02-18 | 株洲南车时代电气股份有限公司 | LKJ basic data comparison method and system |
CN105701247A (en) * | 2016-03-03 | 2016-06-22 | 黄川东 | Construction method for engineering-product parameterization application system |
CN111985881A (en) * | 2019-05-24 | 2020-11-24 | 上海传时软件技术开发有限公司 | Intelligent contract review system and method |
CN110297842A (en) * | 2019-06-25 | 2019-10-01 | 武汉联影医疗科技有限公司 | A kind of data comparison method, device, terminal and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN113094338B (en) | 2022-12-13 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20210318851A1 (en) | Systems and Methods for Dataset Merging using Flow Structures | |
JP6033235B2 (en) | Formatting data by example | |
US9852217B2 (en) | Searching and ranking of code in videos | |
US10210211B2 (en) | Code searching and ranking | |
CN108228861B (en) | Method and system for performing feature engineering for machine learning | |
US7627551B2 (en) | Retrieving case-based reasoning information from archive records | |
CN111667231B (en) | Automatic tax return method, device, system, computer equipment and storage medium | |
CN111931471A (en) | Form collection method and device, electronic equipment and storage medium | |
CN110275938B (en) | Knowledge extraction method and system based on unstructured document | |
JPH09212353A (en) | Method and device for supporting reused design | |
CN109359176A (en) | Data extraction method, device, computer equipment and storage medium | |
CN113312258A (en) | Interface testing method, device, equipment and storage medium | |
CN113094338B (en) | Data comparison method, system, device and medium | |
CN112540925A (en) | New characteristic compatibility detection system and method, electronic device and readable storage medium | |
CN112416329A (en) | Data editing method and device and storage medium | |
CN115098365A (en) | SQL code debugging method and device, electronic equipment and readable storage medium | |
CN114676155A (en) | Code prompt information determining method, data set determining method and electronic equipment | |
CN103488643B (en) | A kind of method and device browsing cloud massive data | |
US20230134989A1 (en) | System and method for building document relationships and aggregates | |
CN114691927A (en) | New energy automobile electric control system signal data management platform and management method | |
CN111611684B (en) | Method, system, device and storage medium for generating interference zone logic block | |
CN117762786A (en) | Method for generating test case, electronic equipment and storage medium | |
CN113191128A (en) | Report form checking tool generation method and device and electronic equipment | |
CN115391629A (en) | Data acquisition method and device, electronic equipment and storage medium | |
CN115964269A (en) | Test processing method and device, electronic equipment and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |