CN113094338B - Data comparison method, system, device and medium - Google Patents
Data comparison method, system, device and medium Download PDFInfo
- Publication number
- CN113094338B CN113094338B CN202110277107.0A CN202110277107A CN113094338B CN 113094338 B CN113094338 B CN 113094338B CN 202110277107 A CN202110277107 A CN 202110277107A CN 113094338 B CN113094338 B CN 113094338B
- Authority
- CN
- China
- Prior art keywords
- file
- data
- comparison
- standard
- result
- 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.)
- Active
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 file and the B-type file in the specified database according to the preset keywords; and step S3: recording a search result to form a data comparison table; and 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 failure in recent years has shown that product failure caused by design is largely due to the unclear or poorly-executed technical and regulatory requirements associated with it. 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 apparatus, including: importing data to be compared; preprocessing the data to be compared based on the full-quantity correlation 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;
and step S3: recording a search result to form a data comparison table;
and 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, a data comparison table formed in the background is added, and the file name and the code number are added to form a new keyword.
Preferably, in step S2, the specified B-type file is searched, 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 invention provides a data comparison system, which comprises any one or more of the following modules:
a starting module: the file data searching and comparing instruction is used for receiving a file data searching and comparing instruction initiated in the process of analyzing and correcting the 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 aid those skilled in the art in further understanding the present invention, but are not intended to limit the invention in any manner. 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 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.
And step S3: and recording the search result to form a data comparison table.
And 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 'number coincidence' result back to a specified position in the comparison result display; if no consistency data is found, continuing to carry out text search, recording the characters which appear in the text, such as 'should', 'greater', 'not greater', 'less', 'not less', 'higher', 'lower', 'not less' and the following ten characters, and transmitting the recorded characters back to the specified 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 'design parameter' key words, extracting paragraphs containing the 'design parameter' key words, and adding 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 carry out character comparison, extracting characters which appear in the characters and 10 characters behind the characters which are 'should', 'greater than', 'no greater than', 'less than', 'no less than', 'higher', 'no higher', 'lower', 'no lower' and 'no lower', back to the alignment interface "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; a standard comparison tool, namely 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.
It is well within the knowledge of a person skilled in the art to implement the system and its various devices, modules, units provided by the present invention in a purely computer readable program code means that the same functionality can be 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 has described specific embodiments of the present invention. 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 (6)
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 file and the B-type file in the specified database according to the preset keywords;
and step S3: recording the search result to form a data comparison table;
and step S4: comparing the data according to a preset comparison rule, and displaying a comparison result;
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: transmitting the fault cause and the correction suggestion back to the specified position in the product fault database;
the A-type file is a compared target file, the A-type file is stored corresponding to a standard database, the B-type file is a design file, and the B-type file is stored corresponding to a product design file storage system;
the specific process comprises the following steps:
inputting keywords in a standard comparison interface, inputting a design file name in a 'design file' column, inputting a professional and a position name in a 'standard file' column, inputting a parameter name in a 'design parameter' column, clicking a 'search' button, initiating a search comparison program, calling standard data in a standard database, searching all standard file contents under a specific professional and a position folder according to the filled in 'standard file' keywords, extracting and recording the standard file name and the code number, adding new keywords, calling the standard data in the standard database, searching all standard contents under the specific professional and the position folder according to the filled in 'design parameter' keywords, extracting paragraphs containing the 'design parameter' keywords, recording paragraphs and times of the keywords appearing in a specified A-class file, adding a data comparison table, calling file data in a background product design file storage system, searching the filled 'design file', searching whether related standards are quoted in the file contents, and if the file contents do not contain the standard file name and the code number of the comparison result record, returning 'non-quoted related standards' to a comparison result interface '1'; if the standard file name and the code number key words are found, the result that the related standard is quoted is transmitted back to a comparison result interface, namely result 1;
the background calls file data in a product design file storage system, searches file contents of the filled design files according to the filled key words of the design parameters, extracts paragraphs containing the key words of the design parameters, records paragraphs and times of the key words appearing in the specified B-type files, and adds the paragraphs and times into a 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 result interface 'result 2'; if no consistency data is found, the result of 'no check of coincidence numerical value' is transmitted back to the comparison result interface 'result 2', then character comparison is continued, the characters appearing in the characters are extracted, and the characters appearing in the characters are transmitted back to the comparison result interface 'result 3' and 'result 4', wherein the characters appear 'should', 'larger', 'not larger', 'smaller', 'not smaller', 'higher', 'not higher', 'lower' or 'not lower'.
2. The data comparison method of claim 1, wherein step S1 is to fill in keyword information during the process of initiating data comparison.
3. The data comparison method of claim 1, wherein the class A files are established hierarchically according to specialties and positions.
4. A data comparison system based on the data comparison method of claim 1, 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 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 and the correction suggestion back to the specified position.
5. 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 3.
6. A data alignment apparatus comprising the data alignment system of claim 4 or the computer-readable storage medium of claim 5 having a computer program stored thereon.
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 CN113094338A (en) | 2021-07-09 |
| CN113094338B true 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 |
|---|---|
| CN113094338A (en) | 2021-07-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6033235B2 (en) | Formatting data by example | |
| US10997184B2 (en) | System and method for ranking search results | |
| US10210211B2 (en) | Code searching and ranking | |
| CN108228861B (en) | Method and system for performing feature engineering for machine learning | |
| US20160063102A1 (en) | Searching and ranking of code in videos | |
| US7627551B2 (en) | Retrieving case-based reasoning information from archive records | |
| CN110348020A (en) | A kind of English- word spelling error correction method, device, equipment and readable storage medium storing program for executing | |
| CN107301130A (en) | A kind of VR all-in-ones testing tool and its method | |
| CN108959067A (en) | Test method, device and the computer readable storage medium of search engine | |
| CN111931471A (en) | Form collection method and device, electronic equipment and storage medium | |
| US20230134989A1 (en) | System and method for building document relationships and aggregates | |
| CN107256266A (en) | Query content display method and system | |
| CN110275938B (en) | Knowledge extraction method and system based on unstructured document | |
| JPH09212353A (en) | Method and device for supporting reused design | |
| CN113094338B (en) | Data comparison method, system, device and medium | |
| CN109359176A (en) | Data extraction method, device, computer equipment and storage medium | |
| CN112540925A (en) | New characteristic compatibility detection system and method, electronic device and readable storage medium | |
| CN111984673A (en) | Fuzzy retrieval method and device for tree structure of power grid electric energy metering system | |
| CN112416329A (en) | Data editing method and device and storage medium | |
| CN115098365A (en) | SQL code debugging method and device, electronic equipment and readable storage medium | |
| JP7181043B2 (en) | Fault diagnosis device, fault diagnosis method, and fault diagnosis program | |
| KR20220034907A (en) | information retrieval system | |
| CN103488643B (en) | A kind of method and device browsing cloud massive data | |
| CN114969131B (en) | Information query method, device and equipment | |
| JP7450570B2 (en) | Information processing device, information processing method, and information processing program |
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 |