WO2018227880A1 - Data comparison method, apparatus and device, and readable storage medium - Google Patents

Abstract

A data comparison method, comprising the following steps: displaying a data comparison window when a data comparison request is detected, thereby prompting a user to input data comparison information (S10); based on the data comparison information input by the user, determining a data comparison range, and comparing data information contained in the corresponding range (S20); and when it is detected that the data information comparison is finished, outputting a data information comparison result (S30). A data comparison apparatus and device, and a readable storage medium are also correspondingly provided. The data comparison among different databases is realized by means of a program, and the data comparison result is quickly and accurately obtained.

Description

 Data comparison method, device, device and readable storage medium

The present application claims priority to Chinese Patent Application No. JP-A No. No. No. No. No. No. No. No. No. No. No. No. No. In the application.

Technical field

The present invention relates to the field of computer technologies, and in particular, to a data comparison method, apparatus, device, and readable storage medium.

Background technique

As the amount of data stored in the database is larger and larger, different databases store different types of data, and each data type is associated with each other, and each database is independent of each other.

There is data information import between each database, and after the database data information is imported, it is related to confirming whether the imported data information is correct. Now, it is usually confirmed by screening method whether the imported data is correct, and the human eye is compared and identified after the screening. Such data screening is less efficient and less accurate, and the data rate is more complicated for different database data comparisons. Users need to log in different databases to compare and match data, and at the same time, such screening methods It is not possible to perform verification or logical comparison of data for data of different data interfaces.

The above content is only used to assist in understanding the technical solutions of the present invention, and does not constitute an admission that the above is prior art.

Summary of the invention

The main object of the present invention is to provide a data comparison method, apparatus, device and readable storage medium, aiming at improving the efficiency and accuracy of data comparison.

To achieve the above object, the present invention provides a data comparison method, and the data comparison method includes the following steps:

When the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information;

Determining a data comparison range based on the user input data comparison information, and comparing the data information included in the corresponding range;

When the comparison of the data information is detected, the result of the comparison of the data information is output.

To achieve the above object, the present invention also provides a data comparison device;

a detection prompting module, configured to display a data comparison window when the data comparison request is detected, to prompt the user to input the data comparison information;

Determining a comparison module, configured to determine a data comparison range based on the user input data comparison information, and compare the data information included in the corresponding range;

The detection output module is configured to output the result of the comparison of the data information when the comparison of the data information is detected.

To achieve the above object, the present invention also provides a data comparison device, the data comparison device comprising: a memory, a processor, and a data comparison program stored on the memory and operable on the processor, The data comparison program implements any of the steps of the data comparison method described above when executed by the processor.

In addition, in order to achieve the above object, the present invention also provides a readable storage medium, on which the data comparison program is stored, and the data comparison program implements the data ratio described above when executed by the processor. Any step of the method.

The invention realizes data comparison through a program. Since the program supports data comparison between the same library and the cross-database, it is not necessary to log in to different databases, and the custom database can be supported, and the data source is filled in the corresponding position of the data comparison window, according to the comparison program. The comparison statement realizes the comparison of large-volume data tables, which effectively improves the data comparison efficiency. The data is manually compared and filtered repeatedly, and is converted into a program to automatically process the data information of the same or different databases for data comparison, thereby saving Larger manpower time, and reduced errors in manual processing results in inaccurate comparison results, and can quickly and accurately obtain data comparison results.

DRAWINGS

1 is a schematic structural diagram of a device in a hardware operating environment according to an embodiment of the present invention;

2 is a schematic flow chart of a first embodiment of a data comparison method according to the present invention;

3 is a schematic flow chart of a second embodiment of a data comparison method according to the present invention;

4 is a schematic flow chart of a third embodiment of a data comparison method according to the present invention;

FIG. 5 is a schematic flowchart of the refinement of step S20 of the data comparison method in FIG. 2;

6 is a schematic diagram of a refinement process of step S30 of the data comparison method in FIG. 2;

FIG. 7 is a schematic flowchart diagram of a fourth embodiment of a data comparison method according to the present invention; FIG.

FIG. 8 is a schematic diagram of a scenario in which the data comparison method of the present invention is combined;

9 is a schematic diagram of a data comparison setting setting scenario of a data comparison method according to the present invention;

FIG. 10 is a schematic diagram of functional modules of an embodiment of a data comparison device according to the present invention.

The implementation, functional features, and advantages of the present invention will be further described in conjunction with the embodiments.

detailed description

It is understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

As shown in FIG. 1 , FIG. 1 is a schematic structural diagram of a terminal (also referred to as a data comparison device) in a hardware operating environment according to an embodiment of the present invention.

In the embodiment of the present invention, the terminal may be a PC, or may be a portable terminal device having a display function, such as a smart phone, a tablet computer, or a portable computer.

As shown in FIG. 1, the terminal may include a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, and a communication bus 1002. Among them, the communication bus 1002 is used to implement connection communication between these components. The user interface 1003 can include a display, an input unit such as a keyboard, and the optional user interface 1003 can also include a standard wired interface, a wireless interface. The network interface 1004 can optionally include a standard wired interface, a wireless interface (such as a WI-FI interface). The memory 1005 may be a high speed RAM memory or a stable memory (non-volatile) Memory), such as disk storage. The memory 1005 can also optionally be a storage device independent of the aforementioned processor 1001.

Optionally, the terminal may further include a camera, RF (Radio) Frequency, RF) circuits, sensors, audio circuits, WiFi modules, and more. Among them, sensors such as light sensors, motion sensors, and other sensors. Specifically, the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor may adjust the brightness of the display according to the brightness of the ambient light, and the proximity sensor may turn off the display and/or when the mobile terminal moves to the ear. Backlighting. As a kind of motion sensor, the gravity acceleration sensor can detect the magnitude of acceleration in each direction (usually three axes), and can detect the magnitude and direction of gravity when stationary, and can be used to identify the posture of the mobile terminal (such as horizontal and vertical screen switching, Related games, magnetometer attitude calibration), vibration recognition related functions (such as pedometer, tapping), etc.; of course, the mobile terminal can also be equipped with other sensors such as gyroscope, barometer, hygrometer, thermometer, infrared sensor, etc. No longer.

It will be understood by those skilled in the art that the terminal structure shown in FIG. 1 does not constitute a limitation to the terminal, and may include more or less components than those illustrated, or a combination of certain components, or different component arrangements.

As shown in FIG. 1, an operating system, a network communication module, a user interface module, and a data comparison application may be included in the memory 1005 as a computer storage medium.

In the terminal shown in FIG. 1, the network interface 1004 is mainly used to connect to the background server and perform data communication with the background server; the user interface 1003 is mainly used to connect the client (user end), and perform data communication with the client; and the processor 1001 can be used to call the data comparison application stored in the memory 1005 and perform the following operations:

The data comparison method includes the following steps:

When the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information;

Determining a data comparison range based on the user input data comparison information, and comparing the data information included in the corresponding range;

When the comparison of the data information is detected, the result of the comparison of the data information is output.

Further, the processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:

The data comparison window is used to display a data comparison file and a configuration file, and the data comparison file is formed by setting a data comparison function in an Excel table.

The step of displaying the data comparison window to prompt the user to input the data comparison information before detecting the data comparison request includes:

Obtaining preset database information, and generating a configuration file according to the database address in the preset database information, so that the user forms a configuration file according to the data comparison requirement setting profile;

Establish a response relationship between the comparison function of the data comparison file and the specified configuration file.

Further, the processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:

The data comparison information includes a data source, a data comparison logic, and a data output format. The step of determining the data comparison range based on the user input data comparison information and comparing the data information included in the corresponding range includes:

Obtaining data comparison information and comparing the data entered in the file, and determining whether the data comparison information includes data comparison logic;

If the data comparison information includes data comparison logic, the data information is compared according to the data comparison logic;

If the data comparison information does not include the data comparison logic, the data information of the data comparison range is determined as the full data comparison.

Further, the processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:

The step of determining the data comparison range based on the user input data comparison information and comparing the data information included in the corresponding range includes:

Determining a source database of the data information according to the data source in the data comparison information, extracting the data source from the source database, and determining whether there is data comparison logic;

If there is data comparison logic, the data information is combined according to the data comparison logic to form a data information comparison group, and the data information in the corresponding data comparison group is compared.

Further, the processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:

According to the data source in the data comparison information, in the response association relationship, determining the source database of the data information and extracting the data information from the source database, and determining whether there is a data comparison logic step further includes:

If there is no data comparison logic, the full data field in the source database is used as the data comparison logic, and the data information in the database is compared with the full data.

Further, the processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:

When it is detected that the data information comparison is completed, the steps of outputting the result of the data information comparison include:

When it is detected that the data information comparison is completed, it is determined whether the data amount of the data information is greater than a threshold;

If the data amount of the data information is not greater than the threshold, the data comparison result is output according to the data output format;

If the data amount of the data information is greater than the threshold, the data comparison result is output according to a preset default format.

Further, the processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:

After detecting that the data information comparison is completed, the step of outputting the result of the data information comparison includes:

Based on the output data information comparison result, the data comparison function in the data comparison file is adjusted to optimize the data comparison file.

Further, the processor 1001 can call the data comparison application stored in the memory 1005, and also performs the following operations:

When the data information comparison is completed, the output of the data information comparison step further includes:

If the data comparison result is abnormal, the data comparison data is compared according to the data comparison process to prompt the user to modify the data input information.

Referring to FIG. 2, in the first embodiment of the data comparison method of the present invention, the data comparison method includes:

Step S10: When the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information.

When the terminal detects the data comparison request, the display screen of the terminal displays a data comparison window (specifically, when the terminal detects the data comparison request, the execution of the application of the data comparison on the terminal may be triggered, and the terminal may call the data. Comparing the underlying interface, so that the data comparison window is displayed on the display interface of the terminal, and the data comparison window displays the data comparison file and the data is compared with the configuration file required by the user when the program is running, in the data ratio Data matching information required for users in files and configuration files (data comparison information: data sources including data comparison, database information (database name, database network address, database interface, and data document information in the corresponding database) Data comparison logic (the data comparison logic includes logical primary keys of data comparisons and logical combination keys of data comparisons. Specifically, the data comparison primary key can be understood as a reference quantity of data comparison, a reference of data comparison, Logical primary key, that is, a reference quantity of a data comparison, a logical combination key, that is, a reference of two data comparisons ) And the comparison result data corresponding to the output format (output format data alignment: that is, comparison result output data, the name of the document xxx)) xxx type in the document.

Step S20: Determine a data comparison range based on the user input data comparison information, and compare the data information included in the corresponding range.

Obtaining data comparison information input by the user, determining a database according to the data comparison information (the data information comparison of the same or different databases can be implemented in the present invention), determining the database of the compared data information, and further determining the network address according to the database , query data interface, data information called from the data interface, that is, determine the scope of the data information (from the xxx database call xxx data interface to the data information in the xxx data interface), the data corresponding to the range of the database, according to the data ratio Compare the data in the program with the sql statement (sql statement: set in the data comparison file, run in Excel, developed by the program developer according to the user's usage, specifically JAVA, python, VBA or other programming Language) for data comparison.

Step S30, when it is detected that the data information comparison is completed, the result of the comparison of the data information is output.

The user can set the data output document format of the data output and the name of the corresponding document. The data comparison program stores the data comparison on the device, and can compare the data in the data comparison range, and the data ratio in the data comparison range When the completion is completed, the data comparison program stops executing, and the data comparison statement is jumped out. When the data comparison statement is detected, that is, when the data comparison is completed, the data output format of the data comparison result set by the user is obtained, and The output of the data comparison shows that the user can visually and accurately see the results of the data comparison.

In the embodiment, when the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information, and the data comparison range is determined based on the user input data comparison information, and the data included in the corresponding range is compared. Information, when the comparison of the data information is completed, the result of the comparison of the data information is output, and the data comparison is realized by the program. Since the program supports the comparison of the data in the same library and the cross-database, it is not necessary to log in to different databases, and the customization can be supported. Database, fill the data source to the corresponding position of the data comparison window, compare the large number of data tables according to the comparison statement of the comparison program, effectively improve the data comparison efficiency, compare the data manually by repeated filtering and filtering, and convert For the program to automatically process the data information of the same or different databases for data comparison, it can save a lot of manpower time, and reduce the inaccurate comparison result caused by errors in the manual processing process, and can quickly and accurately obtain the data comparison result.

Referring to FIG. 3, in a second embodiment of the data comparison method of the present invention, the data comparison window is configured to display a data comparison file and a configuration file, and the data comparison file is formed by setting a data comparison function in an Excel table. The data comparison methods include:

Step S40: Acquire preset database information, and generate a configuration file according to the database address in the preset database information, so that the user forms a specified configuration file according to the data comparison requirement setting configuration file.

The data comparison is mainly used in the comparison of different or the same database data information (that is, the invention is mainly applied to two upstream and downstream databases, and the data information of the downstream database is imported by the upstream database, and the existing methods are mainly In the process of data import, the data is compared and verified, or after the data is imported, the database is compared for manual data comparison, or the similarity of data information of different data ports is compared, etc., in the embodiment, when the program is developed Obtaining preset database information (preset database information, that is, existing different database names, database network addresses, database interfaces, and corresponding data document information in the database), generating a configuration file for the user to use according to the data Comparing the requirement setting configuration file to form a specified configuration file, specifically, generating a data comparison configuration file during software development, and correspondingly inputting information in the configuration file according to the data comparison situation when the user compares the data, forming a specified configuration file, and the user according to the Data comparison requirements The information entered in the configuration file can contain Username, password, and database network address information.

Step S50, establishing a response association relationship between the comparison function of the data comparison file and the specified configuration file.

The user inputs information according to the data comparison requirement, and the obtained data is associated with the specified configuration file and the data comparison file, and the data comparison function is associated with the response between the file and the specified configuration file, that is, the user is in the data ratio. The data trigger comparison data in the data comparison comparison file in the data comparison function can call the configuration information in the configuration file to perform the data comparison program operation.

In this embodiment, the preset database information is acquired, and a configuration file is generated according to the database address in the preset database information, so that the user can form a configuration file according to the data setting requirement configuration file, and establish a comparison function of the data comparison file and Specifies the response association between profiles. In this embodiment, the information of the preset database is acquired, and a data comparison configuration file is generated to prompt the user to obtain a specified configuration file according to the data matching requirement setting file, and associate the specified configuration file with the data comparison file, and the user triggers the data. When comparing instructions, according to the database information in the specified configuration file, the data comparison program in the data comparison file can realize the comparison of the batch data information in different or the same database, and the user does not need to log in to import different database information data. Export, manual data comparison, speed up the efficiency of data comparison.

Referring to FIG. 4, in a third embodiment of the data comparison method of the present invention, the data comparison information includes a data source, a data comparison logic, and a data output format, and the data comparison method includes:

Step S60: Acquire data comparison information input in the data comparison file, and determine whether the data comparison information includes data comparison logic.

In the data comparison file, the user needs to input data comparison information. In combination with FIG. 8, the data comparison information includes a data source (data source: including source database, database name, etc.), and data comparison logic (data comparison logic: data) Comparing the logical primary key and logical combination key of the logic and the data output format, obtaining the data comparison information input in the data comparison file, further determining whether the user inputs the data comparison logic, that is, determining whether the data comparison information contains data Compare logic. As shown in Table 1, "t3eginv" "t0egidw" is the database name database information, "select Securon, start_date, end_date, dividend_rate, data_state, isused from Preferred_stock_float_rate where data_state = '2'" is the data comparison range that needs to be called in the database. "PK_A" is the setting of the output format of the data comparison table output information. In Table 1, the user does not include the data comparison logic. The data is set as shown in Figure 8. Compare logic.

T3eginv	T0egidw	PK_A	PK_B	FILE_NAME
Select securno, start_date, end_date, Dividend_rate, data_state, isused from preferred_stock_float_rate where Data_state = '2'	Select securno, start_date, end_date, Dividend_rate, data_state, isused from IPAP_PREFERRED_FLOAT_RATE	SECURNO	SECURNO
T3eginv	T0egidw	PK_A	PK_B	FILE_NAME
Select marketno, securno, publishdate, Updatedate, curno, per_int_cash, per_int_cash_tx, Consideration_rights_reg_date, ex_dividend_date, share_due_date, data_state, Isused from preferred_share_rec where data_state = '2'	Select SECURITY_MARKET_NO, securno, Publishdate, updatedate, curno, per_int_cash, per_int_cash_tx, Consideration_rights_reg_date, ex_dividend_date, share_due_date, data_state, Isused from ipap_preferred_share_rec	SECURNO	SECURNO
		MARKETNO	SECURITY_MARKET_NO
		EX_DIVIDEND_DATE	EX_DIVIDEND_DATE

Step S70: If the data comparison information includes data comparison logic, the data information is compared according to the data comparison logic.

If the user inputs the data comparison logic, after determining the data comparison range, the data can be compared according to the data comparison logic (data comparison logic: logical primary key and logical combination key of the data comparison logic) input by the user, specifically Ground, obtain the logical primary key of the data information comparison or the logical combination key of the data comparison (that is, the two databases contain the resident user information of a certain community, and compare the data based on the user ID number when the data is compared, Then, the user ID number is used as the logical primary key of the data comparison, and the logical combination key of the data matching the user name and the user gender in the two databases is the same. The present invention can also implement different data comparison. The key, used to determine the order of the data comparisons, compares the data information in the data source (same or different database) according to the data comparison logic.

Step S80: If the data comparison information does not include the data comparison logic, the data information of the data comparison range is determined as the full data comparison.

In the data comparison file, the user does not input the data comparison logic, and compares all the numbers in the data information in the data comparison range as the data comparison logic, that is, the database contains the name, age, ID number, telephone number, gender. The home address and other information, when the user does not enter the data comparison logic, the age, ID number, phone number and the number as the data comparison logic, the full amount of data comparison.

In this embodiment, the data comparison information is obtained in the data comparison file, and the data comparison information is included in the data comparison logic. If the data comparison information includes the data comparison logic, the data is compared according to the data comparison logic. Information, if the data comparison information does not contain data comparison logic, the data information of the data comparison range is determined as a full data comparison. Determining the data comparison logic of the data comparison to obtain the data comparison result required by the user, and eliminating the need for artificial macroscopic data comparison, thereby improving the efficiency of the data comparison, and at the same time, the user can independently set the data comparison. The logical primary key, to obtain the required data comparison results, makes the data comparison more efficient and convenient.

Referring to FIG. 5, in the data comparison method in this embodiment, step S20 includes:

Step S21: Determine, according to the data source in the data comparison information, the source database of the data information in the response association relationship, and extract the data information from the source database, and determine whether there is data comparison logic.

According to the data input data of the user (data source: database name, database network address, database interface information), according to the specified configuration file and the data comparison file, the corresponding data information is obtained in the specified configuration file, and the data is determined. The database of information extracts data information from the database, and extracts data information that needs to be compared in the database (that is, when the data of the present invention is compared, the user does not need to log in to the database, and according to information such as the name of the database input by the user, the database corresponds to the corresponding data. Data information of the interface (data information: including data document information, character information in the document)).

Step S22, if there is data comparison logic, the data information comparison group is formed according to the data comparison logic, and the data information in the corresponding data comparison group is compared.

The data information in the database is logically combined according to the data comparison to form a data comparison group (data comparison group: can be understood as a data combination formed by the same digital primary key in different source databases, for example, a group of students' information is stored separately In the teaching system A of the Education Bureau and the teaching system B of the school, the student information of the Education Bureau's teaching system A and the school's teaching system B are compared, and the student's student number is used as the logical primary key of the data comparison. The information of the same student number in the teaching system A of the Education Bureau and the teaching system B of the school will be combined, and the relevant information of the students of the same student number in the two teaching systems will appear, and the relevant information of the students of the same student number will be used as the data information. The comparison group compares the other student information in the corresponding data comparison group, that is, whether the contact information of the students in the two systems with the same student number, the parent name, and the like are the same, for example, the data information in the downstream database. As with the data information in the upstream database, it is necessary to determine whether the data information imported into the downstream database from the upstream database is consistent. Then, a data amount in the database is used as a logical primary key of the data comparison. Specifically, the database of the commodity sales system includes different subsystems, and each subsystem contains different commodity sales data, and the same commodity number is used as a reference. (commodity number: logical primary key of data comparison), combining product information of the same product number in different databases, comparing whether the retail price of the same product is the same, (it can be understood that the data comparison described in the present invention is not only Limited to two databases, you can implement multiple databases, two-two comparisons, multiple loop comparisons, etc.).

In this embodiment, according to the data source in the data comparison information, in the response association relationship, the source database of the data information is determined and the data information is extracted from the source database, and it is determined whether there is data comparison logic; if there is data comparison logic Then, according to the data comparison logic, the data information is combined to form a data information comparison group, and the data information in the corresponding data comparison group is compared. According to the data set by the user, the data is compared with the logic, which can ensure the optimization of the data comparison program quickly. According to the user setting, the data information is compared, and the data information is logically combined according to the data comparison logic. The data comparison program can be optimized to improve the efficiency of data comparison.

Referring to FIG. 5, in the data comparison method in this embodiment, after step S21, the method further includes:

Step S23, if there is data comparison logic, the data information comparison group is formed according to the data comparison logic, and the data information in the corresponding data comparison group is compared.

The data comparison file does not contain the data comparison logic (that is, the user does not input the data to compare the logical primary key). Considering the situation of different databases, the data information is compared with the full amount of data, that is, the entire database will be Data field (full data field: all the numbers in the data information, ie, the identity number, phone number and age, a data comparison logic) as the data comparison logic, the data information in the database is compared with the full amount of data, The difference in other data information in the database information.

In the embodiment, if there is data comparison logic, the data information is compared according to the data comparison data to form a data information comparison group, and the data information in the corresponding data comparison group is compared, and when the data is compared, if the user does not set The data comparison logic identifies the data comparison as a full-scale data comparison, which ensures the comprehensiveness of the data comparison and compares the data information on a unified basis.

Referring to FIG. 6, in the data comparison method in this embodiment, step S30 includes:

Step S31, when it is detected that the data information comparison is completed, it is determined whether the data amount of the data information is greater than a threshold.

After the terminal detects that the data information is compared, the output of the data comparison needs to be compared. The output of the data comparison result can be output according to the user setting, but there may be a large amount of data comparison, and a specific document is required for data output. 9. Determine whether the output of the data comparison is greater than the maximum data amount. In the present invention, the data is output by using xls, xlsx, and csv formats, because the data capacity of the xls and xlsx tables is limited (xls, xlsx tables are suitable for storing data amount is less than 65525, if the comparison result exceeds 65525 can be output in csv format), it will be necessary to determine whether the data amount of the comparison data information is greater than a threshold (threshold value is 65525).

In step S32, if the data amount of the data information is not greater than the threshold, the data comparison result is output according to the data output format.

If the amount of data information is not greater than the threshold, the result of the data comparison may be output according to the user's setting (the user may set the name of the data output when the data is compared, the data comparison process, or the data comparison result is output. Information such as the output format, the user-set data output format can contain all data formats, ie xls, xlsx or csv).

Step S33: If the data amount of the data information is greater than the threshold, the data comparison result is output according to a preset default format.

If the data amount of the data information is greater than the threshold, the data comparison result needs to be output in the csv format document, and the data comparison result is according to a preset format (preset default format: when the data volume is greater than 65525, the csv format is adopted. Document) output, the user can customize the naming of documents in csv format.

In this embodiment, by comparing the confirmation of the data amount, the output of the data comparison result is limited, so that the result of the data comparison is output according to the user definition, and when the data amount exceeds the preset value, the preset format is adopted. The output reduces the user's operation and improves the efficiency of data comparison.

Referring to FIG. 7, in the fourth embodiment of the data comparison method of the present invention, the data comparison method further includes:

Step S90: Adjust the data comparison function in the data comparison file based on the output data information comparison result to optimize the data comparison file.

Based on the result output of the data comparison, the user can customize the setting SQL statement on the terminal, so that the data information of different databases is compared according to the user-defined sql statement. It is necessary to add that the server of the data comparison can be based on Based on the output data information comparison result, the program function corresponding to the adjustment data comparison data comparison data makes the data comparison result display easier to view.

In this embodiment, based on the output data information comparison result, the data comparison function in the data comparison file is adjusted to optimize the data comparison file, and the user can customize the sql statement to satisfy the user's data comparison requirement, or data. The comparison background automatically adjusts the setting data comparison program according to the output data comparison result, so that the data comparison program is more optimized.

Further, in the embodiment, the data comparison method further includes:

If the data comparison result is abnormal, the data comparison data is compared according to the data comparison process to prompt the user to modify the data input information.

After the data comparison program is used for a period of time, the required data comparison result is not obtained, that is, the data comparison is abnormal, and the data comparison abnormality processing scheme: when the entered query content does not conform to the format, the output 'Data Incorrect, please check the Document' (for example: the database name does not exist in the configuration document, the SQL statement has a syntax error, the number of logical primary keys is inconsistent, etc.), or other exception handling: when there are other exceptions in the query, the result will not be output. That is, when the result document is found to be missing, please check whether the entered query condition has content that does not meet the requirements (for example: whether the number of table fields is inconsistent, lack of SQL statement, etc.). According to the data comparison process, the data is compared with the abnormal factor to prompt The user modifies the data input information.

In the embodiment, if the data comparison result is abnormal, the data comparison data is compared according to the data comparison process to prompt the user to modify the data input information, and the execution of the data comparison result is abnormal. The factor allows the user to prompt the user to check the data according to the data comparison logic to correct the input of the information.

Further, in conjunction with FIG. 10, the present invention also provides a data comparison device.

The detection prompting module 10 is configured to display a data comparison window when the data comparison request is detected, to prompt the user to input the data comparison information;

Determining the comparison module 20, for determining a data comparison range based on the user input data comparison information, and comparing the data information included in the corresponding range;

The detection output module 30 is configured to output the result of the comparison of the data information when the comparison of the data information is detected.

For the steps of the data comparison device, the data comparison method may refer to various embodiments of the data comparison method of the present invention, and details are not described herein again.

The present invention also provides a readable storage medium.

The readable storage medium of the present invention stores a data comparison program that implements any of the steps of the data comparison method described above when the program is executed by the processor.

For the method implemented by the smart data comparison program, refer to various embodiments of the data comparison method of the present invention, and details are not described herein again.

It is to be understood that the term "comprises", "comprising", or any other variants thereof, is intended to encompass a non-exclusive inclusion, such that a process, method, article, or It also includes other elements that are not explicitly listed, or elements that are inherent to such a process, method, item, or system. An element defined by the phrase "comprising a ..." does not exclude the presence of additional equivalent elements in a process, method, article, or system that includes the element, without further limitation.

The serial numbers of the embodiments of the present invention are merely for the description, and do not represent the advantages and disadvantages of the embodiments.

Through the description of the above embodiments, those skilled in the art can clearly understand that the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but in many cases, the former is better. Implementation. Based on such understanding, portions of the technical solution of the present invention that contribute substantially or to the prior art may be embodied in the form of a software product stored in a storage medium (such as a ROM/RAM as described above). , a disk, an optical disk, including a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present invention.

The above are only the preferred embodiments of the present invention, and are not intended to limit the scope of the invention, and the equivalent structure or equivalent process transformations made by the description of the present invention and the drawings are directly or indirectly applied to other related technical fields. The same is included in the scope of patent protection of the present invention.

Claims (20)

1.  A data comparison method, characterized in that the data comparison method comprises the following steps:

   When the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information;

   Determining a data comparison range based on the user input data comparison information, and comparing the data information included in the corresponding range;

   When the comparison of the data information is detected, the result of the comparison of the data information is output.
2. The data comparison method according to claim 1, wherein said data comparison window is used to display a data comparison file and a configuration file, and said data comparison file is formed by setting a data comparison function in an Excel table;

   The step of displaying the data comparison window to prompt the user to input the data comparison information before detecting the data comparison request includes:

   Obtaining preset database information, and generating a configuration file according to the database address in the preset database information, so that the user can form a specified configuration file according to the data setting configuration file according to the requirement;

   Establish a response relationship between the comparison function of the data comparison file and the specified configuration file.
3. The data comparison method according to claim 2, wherein the data comparison information comprises a data source, a data comparison logic, and a data output format, and the data comparison range is determined based on the user input data comparison information. And before comparing the steps of the data information contained in the corresponding range, include:

   Obtaining data comparison information and comparing the data entered in the file, and determining whether the data comparison information includes data comparison logic;

   If the data comparison information includes data comparison logic, the data information is compared according to the data comparison logic;

   If the data comparison information does not include the data comparison logic, the data information of the data comparison range is determined as the full data comparison.
4. The data comparison method according to claim 3, wherein the step of determining a data comparison range based on the user input data comparison information and comparing the data information included in the corresponding range comprises:

   Determining a source database of the data information according to the data source in the data comparison information, extracting the data source from the source database, and determining whether there is data comparison logic;

   If there is data comparison logic, the data information is combined according to the data comparison logic to form a data information comparison group, and the data information in the corresponding data comparison group is compared.
5. The data comparison method according to claim 1, wherein in the response association relationship according to the data source in the data comparison information, the source database of the data information is determined and the data information is extracted from the source database, and the data is determined. Whether there are steps to compare data logic, including:

   If there is no data comparison logic, the full data field in the source database is used as the data comparison logic, and the data information in the database is compared with the full data.
6. The data comparison method according to claim 1, wherein the step of outputting the result of comparing the data information when the data information comparison is completed is completed:

   When it is detected that the data information comparison is completed, it is determined whether the data amount of the data information is greater than a threshold;

   If the data amount of the data information is not greater than the threshold, the data comparison result is output according to the data output format;

   If the data amount of the data information is greater than the threshold, the data comparison result is output according to a preset default format.
7. The data comparison method according to claim 6, wherein the step of outputting the result of comparing the data information when the data information comparison is completed is completed:

   Based on the output data information comparison result, the data comparison function in the data comparison file is adjusted to optimize the data comparison file.
8. The data comparison method according to claim 1, wherein when the data information comparison is completed, the step of outputting the data information after the step of outputting the method further comprises:

   If the data comparison result is abnormal, the data comparison data is compared according to the data comparison process to prompt the user to modify the data input information.
9. A data comparison device, characterized in that the data comparison device comprises:

   a detection prompting module, configured to display a data comparison window when the data comparison request is detected, to prompt the user to input the data comparison information;

   Determining a comparison module, configured to determine a data comparison range based on the user input data comparison information, and compare the data information included in the corresponding range;

   The detection output module is configured to output the result of the comparison of the data information when the comparison of the data information is detected.
10. A data comparison device, characterized in that: the data comparison device comprises: a memory, a processor, and a data comparison program stored on the memory and operable on the processor, the data comparison The following steps are implemented when the program is executed by the processor:

    When the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information;

    Determining a data comparison range based on the user input data comparison information, and comparing the data information included in the corresponding range;

    When the comparison of the data information is detected, the result of the comparison of the data information is output.
11. The data comparison device according to claim 10, wherein said data comparison window is for displaying a data comparison file and a configuration file, said data comparison file being formed by setting a data comparison function in an Excel table;

    The step of: when the data comparison request is detected, displaying the data comparison window to prompt the user to input the data comparison information, the data comparison program is executed by the processor to implement the following steps:

    Obtaining preset database information, and generating a configuration file according to the database address in the preset database information, so that the user can form a specified configuration file according to the data setting configuration file according to the requirement;

    Establish a response relationship between the comparison function of the data comparison file and the specified configuration file.
12. The data comparison device according to claim 11, wherein the data comparison information comprises a data source, a data comparison logic, and a data output format, and the data comparison range is determined based on the user input data comparison information. And prior to the step of comparing the data information contained in the corresponding range, the data comparison program implements the following steps when executed by the processor:

    Obtaining data comparison information and comparing the data entered in the file, and determining whether the data comparison information includes data comparison logic;

    If the data comparison information includes data comparison logic, the data information is compared according to the data comparison logic;

    If the data comparison information does not include the data comparison logic, the data information of the data comparison range is determined as the full data comparison.
13. The data comparison device according to claim 12, wherein said data comparison program is implemented by said processor, said data comparison range is determined based on user input data comparison information, and the correspondence is compared The steps for the data information contained in the scope include:

    Determining a source database of the data information according to the data source in the data comparison information, extracting the data source from the source database, and determining whether there is data comparison logic;

    If there is data comparison logic, the data information is combined according to the data comparison logic to form a data information comparison group, and the data information in the corresponding data comparison group is compared.
14. The data comparison device according to claim 10, wherein said determining a source database of the data information in the response association relationship according to the data source in the data comparison information and extracting the data information from the source database, and determining Whether there is a step of comparing data logic;

    The data synchronization comparison program implements the following steps when executed by the processor:

    If there is no data comparison logic, the full data field in the source database is used as the data comparison logic, and the data information in the database is compared with the full data.
15. The data comparison device according to claim 10, wherein said data comparison program is implemented when said program is executed by said processor, said result of comparing said data information when said comparison of said data information is completed The steps of the output include:

    When it is detected that the data information comparison is completed, it is determined whether the data amount of the data information is greater than a threshold;

    If the data amount of the data information is not greater than the threshold, the data comparison result is output according to the data output format;

    If the data amount of the data information is greater than the threshold, the data comparison result is output according to a preset default format.
16. A readable storage medium, characterized in that the readable storage medium stores a data comparison program, and the data comparison program implements the following steps when executed by the processor:

    When the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information;

    Determining a data comparison range based on the user input data comparison information, and comparing the data information included in the corresponding range;

    When the comparison of the data information is detected, the result of the comparison of the data information is output.
17. The readable storage medium of claim 16 wherein said data comparison program is executed by a processor to implement the following steps:

    When the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information;

    Determining a data comparison range based on the user input data comparison information, and comparing the data information included in the corresponding range;

    When the comparison of the data information is detected, the result of the comparison of the data information is output.
18. The readable storage medium according to claim 17, wherein said data comparison window is for displaying a data comparison file and a configuration file, said data comparison file being formed by setting a data comparison function in an Excel table;

    When the data comparison request is detected, the data comparison window is displayed to prompt the user to input the data comparison information, and the data comparison program is executed by the processor to implement the following steps:

    Obtaining preset database information, and generating a configuration file according to the database address in the preset database information, so that the user can form a specified configuration file according to the data setting configuration file according to the requirement;

    Establish a response relationship between the comparison function of the data comparison file and the specified configuration file.
19. The readable storage medium of claim 18, wherein the data comparison information comprises a data source, a data comparison logic, and a data output format, wherein the user input data comparison information determines a data comparison range, And before the step of comparing the data information contained in the corresponding range, the data comparison program is executed by the processor to implement the following steps:

    Obtaining data comparison information and comparing the data entered in the file, and determining whether the data comparison information includes data comparison logic;

    If the data comparison information includes data comparison logic, the data information is compared according to the data comparison logic;

    If the data comparison information does not include the data comparison logic, the data information of the data comparison range is determined as the full data comparison.
20. The readable storage medium according to claim 16, wherein said data comparison program is executed by a processor, said user input data comparison information determining a data comparison range, and comparing the corresponding range includes The steps of the data information include:

    Determining a source database of the data information according to the data source in the data comparison information, extracting the data source from the source database, and determining whether there is data comparison logic;

    If there is data comparison logic, the data information is combined according to the data comparison logic to form a data information comparison group, and the data information in the corresponding data comparison group is compared.