Database data comparison method and comparison system

Abstract

The embodiment of the invention provides a database data comparison method and comparison system, and the method comprises the steps: calling a query service to carry out the first query of specifieddata of a database, and generating a first query result; caching the result of the first query; calling the same query service to query the specified data for the second time, and generating a secondquery result; and comparing the first query result with the second query result to analyze difference data. According to the method, the specified data of the database is queried for multiple times through the query service, and the multiple query results are cached and compared, so that the comparison workload is reduced, the comparison steps are simplified, difference data analysis is provided,and the change of the data table is visually displayed.

Description

Technical field [0001] The invention relates to the field of computer technology, in particular to a database data comparison method and a comparison system. Background technique [0002] At present, in the process of development, debugging or testing, it is often necessary to compare the data of the database before and after, to check what changes have occurred in the data during the running of the code / program. This requires field comparisons. There are currently two common ways to compare databases. One is that the user records the value of each field in the data table before and after the operation, and then manually compares it word by word to find out the impact of this operation on the data. This kind of comparison is common in tables that have fewer fields to modify or to query. In rare cases, if there are too many data fields, it is not suitable for manual comparison; the other is to read the canal log message. When the system is configured with the canal message to obt...

AI Technical Summary

Problems solved by technology

For existing comparison technologies, when the target comparison is a relatively complex database or a large number of data tables, in addition to extracting the data into a set and then comparing them, the rest of the technology is still essentially a comparison of data table operations. It still requires human participation and is not intuitive, and it is relatively more complicated for making set comparisons or formulating rules. For commonly used simple database comparisons, the cost efficiency may be higher

[0003] Therefore, the inventor believes that the above-mentioned data comparison method has great limitations, and to a certain extent, it can solve the problem of changing the query database fields before and after, but whether it is technology or tools, human participation accounts for a very large proportion. When the amount of data is small and there are not many fields to be compared, the above methods will not have too much burden. However, if the amount of data is large or there are many fields, or the database needs to be compared frequently during work, manual comparison or Querying canal logs will be a very large workload, and there may be omissions, and the comparison results may not be intuitive enough; for the comparison of a single piece of data, the comparison of the existing massive data is not the most efficient processing method

Images