Database data verification method and device

A verification method and database technology, applied in database management systems, database design/maintenance, structured data retrieval, etc., can solve the problems of not verifying the data, unable to judge the consistency of the data, etc., and achieve the realization of data verification. Effect

Active Publication Date: 2019-10-29
ALIBABA GRP HLDG LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The main purpose of this application is to provide a method and device for verifying database data, so as to overcome the problems in the prior art that there is no data verification before and after database data migration, and it is impossible to judge whether the data is consistent

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
  • Database data verification method and device
  • Database data verification method and device
  • Database data verification method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The main idea of ​​the present application is to realize the relational database ( Including data verification between heterogeneous databases), it can compare and verify the consistency of data from the application point of view after data migration.

[0038] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in conjunction with specific embodiments of the present application and corresponding drawings. Apparently, the described embodiments are only some of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0039] According to an embodiment of the present application, a method for verifying databa...

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 discloses a database data verification method and device. The method comprises the following steps of: respectively setting a data type mapping rule corresponding to each database according to data types supported by a first database and a second database; and respectively converting data in the first database and the second database into intermediate data according to the data type mapping rules corresponding to the databases, and judging whether the converted intermediate data are the same. Through the database data verification method and device, effective verification can be carried out on the consistency of the data after data migration.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a method and device for verifying database data. Background technique [0002] With the application of open source databases and the development of cloud computing, there is an increasing demand for data migration across databases. The so-called data migration refers to exporting the data of a database (source database) according to the provided data migration tools according to the specified steps and rules, and loading it into the target database in the form of other statements or data files. [0003] However, after data is migrated between databases, the following needs will also arise: [0004] (1) After the database is migrated between heterogeneous relational databases, data verification is required; [0005] (2) After data migration, there is no type corresponding to the data before migration. For example, if a field is TIMESTAMP WITH TIME ZONE in Oracle, tw...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21G06F16/25
Inventor 孙明善王小勇
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products