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

Database table data comparison method and device based on MD5

A database and MD5 technology, applied in the computer field, can solve cumbersome and prone to comparison problems, achieve fast data comparison, and solve complex and inaccurate effects

Pending Publication Date: 2021-06-11
SUNINFO INFORMATION TECH
View PDF7 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the process of using database data, the data in the table will be continuously added, deleted, and updated, and users often need to know which data in the current database table is added, deleted, or modified with the data at a certain point in time before. The traditional comparison method Manual participation is often required, and at the same time it is necessary to compare the data information of the two tables of the version database. The entire data comparison process is cumbersome and prone to comparison errors

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 table data comparison method and device based on MD5
  • Database table data comparison method and device based on MD5

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0030] In a typical configuration of the present application, the terminal, the device serving the network and the trusted party all include one or more processors (CPUs), input / output interfaces, network interfaces and memory.

[0031] Memory may include non-permanent storage in computer readable media, in the form of random access memory (RAM) and / or nonvolatile memory such as read only memory (ROM) or flash RAM. Memory is an example of computer readable media.

[0032] Computer-readable media, including both permanent and non-permanent, removable and non-removable media, can be implemented by any method or technology for storage of information. Information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static rando...

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 aims to provide an database table data comparison method and device based on MD5. An MD5 encryption result is generated for each piece of data and a primary key (or a unique index) in a database table, and a comparison function of the data in the database table is realized through comparison of the MD5 results. When a user wants to compare the record in the current database table with the record at any previous historical time point, the comparison of the record in the current database table and the record in the database table at any previous time point can be realized only by selecting the comparison MD5 value copy at the corresponding historical time point and the record MD5 value in the database table at the current time point. According to the database table data comparison function based on MD5, database table data comparison can be rapidly carried out, meanwhile, the addition, deletion, modification and record functions of data in the table can be listed, and the problems of complexity and inaccuracy of database table comparison can be solved.

Description

technical field [0001] The invention relates to the field of computers, in particular to an MD5-based database table data comparison method and equipment. Background technique [0002] At present, with the widespread use of database technology, database data is also being used more and more. In the process of using database data, the data in the table will be continuously added, deleted, and updated, and users often need to know which data in the current database table is added, deleted, or modified with the data at a certain point in time before. The traditional comparison method Manual participation is often required, and at the same time, the data information of the two tables of the version database needs to be compared. The entire data comparison process is cumbersome and prone to comparison errors. Contents of the invention [0003] An object of the present invention is to provide an MD5-based database table data comparison method and device. [0004] According to ...

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): G06F16/22
CPCG06F16/2282G06F16/2228Y02D10/00
Inventor 任养超马佩王倪彬
Owner SUNINFO INFORMATION TECH