Database data comparison method and comparison system

A data comparison and database technology, applied in the computer field, can solve the problems of unintuitive comparison results, high consumption efficiency, and unintuitiveness, and achieve the effects of reducing difficulty, simplifying the comparison process, and improving efficiency

A data comparison and database technology, applied in the computer field, can solve the problems of unintuitive comparison results, high consumption efficiency, and unintuitiveness, and achieve the effects of reducing difficulty, simplifying the comparison process, and improving efficiency

CN111143406APending Publication Date: 2020-05-12BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
2 Cites 2 Cited by

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database data comparison method and comparison system
  • Database data comparison method and comparison system
  • Database data comparison method and comparison system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The present invention is described below based on examples, but the present invention is not limited to these examples. In the following detailed description of the present invention, some specific details are described in detail. Those skilled in the art can fully understand the present invention without the description of these details. In order to avoid obscuring the essence of the present invention, the well-known methods, processes, and procedures are not described in detail. In addition, the drawings are not necessarily drawn to scale.

[0038] figure 1 It shows a flowchart of a method for comparing database data in an embodiment of the present invention, and the specific steps include S101-S104.

[0039] In step S101, the query service is invoked to perform the first query on the specified data of the database, and the first query result is generated.

[0040] In step S102, the first query result is cached.

[0041] In step S103, the same query service is called to pe...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
12 May 2020
Publication
CN111143406A
IPC
G06F16/2455
Inventors
εˆ˜ηˆ±ζ…§