Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data inspection method and device, terminal and storage medium

A data inspection and data technology, applied in the computer field, can solve problems such as database data inconsistency

Pending Publication Date: 2022-02-22
BEIJING JINTI TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of this disclosure is to provide a data inspection method, device, equipment and storage medium to solve the technical problem of data inconsistency between databases

Method used

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
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data inspection method and device, terminal and storage medium
  • Data inspection method and device, terminal and storage medium
  • Data inspection method and device, terminal and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0051] see figure 1 , the data verification method provided by the present disclosure may include the following steps S101 to S106:

[0052] In step S101, within a set acquisition period, continuously acquire unmarked data that meets preset conditions from the first data space and form a first data set;

[0053] In some implementations, the data may include data identification and data content.

[0054]Specifically, data identification can have multiple levels. Several lower-level data identifiers can be included under the high-level data identifiers.

[0055] For example, referring to Table 1, the company name of the company may be the primary data identifier. The business dimension of the company may be several secondary data identifiers under the primary data identifier.

[0056]

[0057] Table 1

[0058] Take Table 2 as a specific example: the company name "QianX Technology" is a primary data identifier, and several business dimensions of the company, "number of em...

Embodiment 2

[0088] see figure 2 , the data verification method provided by the present disclosure may include the following steps S201 to S206:

[0089] In step S201, within a set acquisition period, continuously acquire data that meets preset conditions from the first data space and form a first data set;

[0090] In step S202, within the set acquisition period, periodically acquire data corresponding to the data in the first data set from the second data space to form a second data set;

[0091] In step S203, the data in the first data set and the data in the second data set are written into the comparison table, and for one row of the comparison table, the first comparison column and the second comparison column are respectively written into the corresponding data in the first data set and the second data set;

[0092] In step S204, the data of each row in the first comparison column and the second comparison column are compared, and a comparison result column is generated in the co...

Embodiment 3

[0099] see image 3 , the data verification method provided by the present disclosure may include the following steps S301 to S306:

[0100] In step S301, within a set acquisition period, continuously acquire data that meets preset conditions from the first data space and form a first data set;

[0101] In step S302, within the set acquisition period, periodically acquire data corresponding to the data in the first data set from the second data space to form a second data set;

[0102] In step S303, the data in the first data set and the data in the second data set are written into the comparison table, and for one row of the comparison table, the first comparison column and the second comparison column are respectively written into the corresponding data in the first data set and the second data set;

[0103] In step S304, the data of each row in the first comparison column and the second comparison column are compared, and a comparison result column is generated in the com...

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 invention relates to a data inspection method and device, a terminal and a storage medium. The method comprises: in a set acquisition period, continuously acquiring unmarked data meeting a preset condition from the first data space and forming a first data set; and regularly acquiring data corresponding to the data in the first data set from a second data space to form a second data set, then writing the data in the first data set and the data in the second data set into a comparison table for comparison, and generating a comparison result column in the comparison table. And finally, processing the comparison result column according to a set instruction to generate a comparison result for display. According to the invention, a quantitative test result of data consistency can be obtained.

Description

technical field [0001] The present disclosure relates to the field of computers, and in particular, to a data verification method, device, terminal and storage medium. Background technique [0002] Homologous databases refer to two or more databases with the same source of data. For example, if both database 1 and database 2 obtain data from the source database S, then database 1 and database 2 may be called homologous databases. [0003] In some application scenarios, the data stored in the same-origin database needs to be consistent, but in practice, due to possible system and network freezes, failures, etc., the data in the same-origin database may be different, that is, the same-origin database. There is data inconsistency between databases. For example: Homologous database 1 and database 2 also store the data "number of employees" of company A, but the number of employees stored by them is not the same. A corresponding solution is currently missing. SUMMARY OF THE ...

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
no application Login to View More
IPC IPC(8): G06F40/194G06F16/27
CPCG06F40/194G06F16/27
Inventor 张阳
Owner BEIJING JINTI TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products