Unlock instant, AI-driven research and patent intelligence for your innovation.

A method and apparatus for identifying database differences

A recognition method and database technology, applied in the computer field, can solve the problems of low efficiency and long time-consuming database difference comparison, and achieve the effects of saving data acquisition time, improving recognition efficiency, and improving difference recognition efficiency

Active Publication Date: 2018-12-14
PING AN TECH (SHENZHEN) CO LTD
View PDF3 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In order to solve the problems of low efficiency and long time-consuming database difference comparison existing in related technologies, the present invention provides a database difference identification method

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
  • A method and apparatus for identifying database differences
  • A method and apparatus for identifying database differences
  • A method and apparatus for identifying database differences

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] The description will now be made in detail of exemplary embodiments, examples of which are illustrated in the accompanying drawings. Where the following description refers to the drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the illustrative examples below are not intended to represent all implementations consistent with the present invention. Rather, they are merely examples of apparatus and methods consistent with some aspects of the invention as recited in the appended claims.

[0046] figure 1 is a schematic diagram of the implementation environment involved in accordance with the present invention. The implementation environment includes: multiple servers 110, and the multiple servers 110 respectively perform database development, testing, production, and pre-release. The server 110 for database development can be considered as a development environment, the se...

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 method and a device for identifying database differences, an electronic device and a computer-readable storage medium. The scheme comprises the following steps: configuring service database information stored in a system library under different environments into independent files; obtaining service database information recorded in the independent files in different environments; using the information digest algorithm to hash each record in the service database information to generate the corresponding information digest value of each record; according to the identification information of each record, comparing the information digest values corresponding to the same identification information in different environments to obtain records with differences. The technical proposal provided by the invention improves the identification efficiency of the database difference.

Description

technical field [0001] The present invention relates to the field of computer technology, and in particular, to a method and device for verifying database differences, an electronic device, and a computer-readable storage medium. Background technique [0002] In order to ensure the consistency of databases in different environments (eg, production environment, test environment, pre-release environment, and development environment), the database structure needs to be compared before release for production. In a cloud environment, database fields are generally compared one by one to find out the differences between databases in different environments. However, this method is inefficient, and requires a polling method. For each field in the database, it is necessary to find the existence of each field in another environmental database, and after all comparisons are completed, it is necessary to judge whether the database table structure is consistent. , the time complexity is ...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/00
Inventor 陈聪陈泽冰
Owner PING AN TECH (SHENZHEN) CO LTD