Data index comparison method for data issued by third party

Abstract

The invention relates to a data index comparison method for third-party issued data, which comprises the following steps of: acquiring a data index of the third-party issued data, decrypting the data index into a file in a preset format, and sending the file to a front-end processor; downloading a file of a to-be-compared data index from the front-end processor; exporting a data index in the to-be-compared file; comparing new and old changes of the data indexes according to the exported data indexes of the files to be compared, and obtaining a comparison result; and outputting a comparison result of the new and old changes of the data indexes in a preset mode. According to the invention, accuracy, portability and high efficiency of a comparison result of new and old data of the issued index can be maintained, and acquisition index data can be provided for a third-party system more quickly.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a method for comparing data indicators of data sent by a third party. Background Art

[0002] As more and more paperless interactions occur between departments or between enterprises, the scenarios of computer data interaction between departments or between enterprises are becoming more and more extensive. For example, Department A or Enterprise A proposes data indicators to be collected, and correspondingly, Department B or Enterprise B collects corresponding data based on the received data indicators.

[0003] The inventors of this application discovered during their research that if Department A or Company A undergoes system transformation, migration or upgrade, the data indicators that need to be collected will change, which will result in Department B or Company B being able to find new data indicators only based on manual comparison, resulting in slow progress in data collection and extended working hours.

[0004] Therefore, departments or enterprises need to have a comparative method that can quickly obtain the data indicators that third parties need to collect. Summary of the invention

[0005] In view of the above problems, the purpose of the present invention is to provide a data indicator comparison method and system for data sent by a third party, which can maintain the accuracy, portability and efficiency of the comparison results of new and old data of the sent indicators, and provide collection indicator data for third-party systems more quickly.

[0006] To achieve the above object, the present invention adopts the following technical solutions:

[0007] In a first aspect, the present application provides a data indicator comparison method for data sent by a third party, the method comprising:

[0008] Obtain data indicators from third-party data, decrypt them into files in a preset format and send them to the front-end;

[0009] Downloading a file of the data index to be compared from the front-end processor;

[0010] Export the data indicators in the files to be compared;

[0011] According to the data indicators of the exported files to be compared, compare the new and old changes of the data indicators and obtain the comparison results;

[0012] Output the comparison results of the new and old changes of data indicators in a preset way.

[0013] In one implementation of the present application, the step of obtaining data indicators of data sent by a third party and decrypting the data into a file in a preset format and sending the file to the front-end processor includes:

[0014] The data sent by the third party is obtained, and the data indicators therein are decrypted into a database table file, and stored in the front-end machine.

[0015] In one implementation of the present application, the decrypted database table file is named and stored according to the third-party system code and the data version number of the issued data.

[0016] In one implementation of the present application, the downloading of the file of the data indicator to be compared from the front-end processor includes:

[0017] Download the database table file with the same system code but different data version number from the front-end machine.

[0018] In one implementation of the present application, the exporting of data indicators in the files to be compared includes:

[0019] A lightweight embedded database is used to read data indicators from the database table file downloaded from the front-end processor.

[0020] In one implementation of the present application, the lightweight embedded database is SQLite, and the SQLite reads all data indicators in the database table file, and the return value is a LinkedHashMap collection.

[0021] In one implementation of the present application, the comparison result of the new and old changes of the data indicator includes four types: addition, modification, deletion and no change of the data indicator.

[0022] In one implementation of the present application, the comparison result of the new and old changes of the data indicator is output in a preset manner, including:

[0023] The comparison results are displayed in a table format on the interface of the preset terminal.

[0024] In one implementation of the present application, the method further includes: generating corresponding results in text form based on the table of comparison results.

[0025] In one implementation of the present application, the text-based results are sent to an email address of a preset administrator account.

[0026] The present invention can maintain the accuracy, portability and high efficiency of the comparison results of the new and old data of the issued indicators, and provide the collection indicator data for the third-party system more quickly. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] Figure 1 A business flow chart for comparing new and old data based on indicators sent by a third-party system implemented in the present invention;

[0028] Figure 2 This is a schematic diagram of the deployment of comparing new and old data based on indicators issued by a third-party system implemented in the present invention. DETAILED DESCRIPTION

[0029] In order to make the purpose, technical solution and advantages of the embodiment of the present invention clearer, the technical solution of the embodiment of the present invention will be clearly and completely described below in conjunction with the drawings of the embodiment of the present invention. Obviously, the described embodiment is a part of the embodiment of the present invention, not all of the embodiments. Based on the described embodiment of the present invention, all other embodiments obtained by ordinary technicians in this field belong to the scope of protection of the present invention.

[0030] In response to the existing technology, there is a need for a comparative method that can quickly obtain the data indicators that a third party needs to collect. question The present application provides a data indicator comparison method for data sent by a third party, including: obtaining data indicators of data sent by a third party, decrypting it into a file in a preset format and sending it to a front-end; downloading a file of data indicators to be compared from the front-end; exporting data indicators in the file to be compared; comparing the new and old changes of data indicators according to the exported data indicators of the file to be compared, and obtaining a comparison result; outputting the comparison result of the new and old changes of data indicators in a preset manner. The present invention can maintain the accuracy, portability and high efficiency of the comparison result of the new and old data of the sent indicators, and provide the collection indicator data for the third-party system more quickly.

[0031] like Figure 1 FIG. 1 is a flow chart of a method according to an embodiment of the present invention. Figure 2 A schematic diagram of the system architecture is shown.

[0032] Specifically, the present invention realizes the comparison between new and old data by sending indicators through a third-party system. The core is JS component, Bootstrap Table component, JAVA-IO, FastDFS, SQLite, LinkedHashMap and JAVA-Mail. The indicators sent by the third-party system are compared before and after through system functions.

[0033] The method in this embodiment comprises the steps of:

[0034] S1. The third-party system sends the data indicators to the front-end in the form of DB (decrypted file type);

[0035] S2. Call the DB download function to download the DB to the system and import the data indicators into the system. The DB name format is 1000 (system code)-0001 (version number) to distinguish different systems and different versions of the same system due to upgrades and other issues;

[0036] S3. Use Bootstrap Table to render the DB management list, and select two DBs with the same system code in the list for version comparison;

[0037] S4. Use SQLite to read all data indicators in the new and old DBs, and the return value is a LinkedHashMap collection

[0038] S5. Distinguish whether the new and old LinkedHashMap collections are unified indicators according to the indicator identifier, compare the indicators and record the indicator changes and indicator comparison types. The indicator comparison types include: new, modified, deleted and no change.

[0039] S6. Return to the data comparison page. The page arranges the old and new LinkedHashMap sets with the old set on the left and the new set on the right. If the indicator comparison type is any of the three types except no change, they are displayed in red in the left and right distribution lists respectively.

[0040] S7. Click the data comparison result above to display the text version of the comparison result (for example, indicator A before modification=>1, after modification=>2);

[0041] S8. Send the text version of the comparison result to the administrator's mailbox in the form of a JAVA-Mail email.

[0042] In the several embodiments provided by the present invention, it should be understood that the disclosed method can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the above units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0043] The above-mentioned integrated unit implemented in the form of a software functional unit can be stored in a computer-readable storage medium. The above-mentioned software functional unit is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) or a processor (Processor) to perform some steps of the above-mentioned method of each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), disk or optical disk and other media that can store program codes.

[0044] The above are only preferred embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A data indicator comparison method for data sent by a third party, characterized in that: The method comprises: Obtain data indicators from third-party data, decrypt them into files in a preset format and send them to the front-end; Downloading a file of the data index to be compared from the front-end processor; Export the data indicators in the files to be compared; According to the data indicators of the exported files to be compared, compare the new and old changes of the data indicators and obtain the comparison results; Output the comparison results of the new and old changes of data indicators in a preset way.

2. The data indicator comparison method of data sent by a third party according to claim 1 is characterized in that: The step of obtaining data indicators of data sent by a third party and decrypting the data into a file in a preset format and sending the file to the front-end processor includes: The data sent by the third party is obtained, and the data indicators therein are decrypted into a database table file, and stored in the front-end machine.

3. The data indicator comparison method of data sent by a third party according to claim 2 is characterized in that: The decrypted database table file is named and stored according to the third-party system code and the data version number of the issued data.

4. The data indicator comparison method of data sent by a third party according to claim 3 is characterized in that: The downloading of the file of the data indicator to be compared from the front-end processor includes: Download the database table file with the same system code but different data version number from the front-end machine.

5. The data indicator comparison method of data sent by a third party according to claim 4 is characterized in that: The data indicators in the exported files to be compared include: A lightweight embedded database is used to read data indicators from the database table file downloaded from the front-end processor.

6. The data indicator comparison method of data sent by a third party according to claim 3 is characterized in that: The lightweight embedded database used is SQLite, and the SQLite reads all data indicators in the database table file, and the return value is a LinkedHashMap collection.

7. The data indicator comparison method of data sent by a third party according to claim 5 is characterized in that: The comparison results of the new and old changes of the data indicators include four types: addition, modification, deletion and no change of data indicators.

8. The data indicator comparison method of data sent by a third party according to claim 7, characterized in that: Output the comparison results of the new and old changes of data indicators in a preset way, including: The comparison results are displayed in a table format on the interface of the preset terminal.

9. The data indicator comparison method of data sent by a third party according to claim 8, characterized in that: The method further includes: generating corresponding text-based results based on the comparison result table.

10. The data indicator comparison method of data sent by a third party according to claim 9, characterized in that: The text results are sent to the email address of the preset administrator account.

Images