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

A method and device for quickly comparing data based on database b-tree

A technology for comparing data and databases, applied in the field of data processing, can solve problems such as low query efficiency and large memory consumption, and achieve the effects of saving memory space, less memory usage, and high speed

Active Publication Date: 2022-05-27
WUHAN DAMENG DATABASE
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Aiming at the above defects or improvement needs of the prior art, the present invention provides a method and device for quickly comparing data based on database B-trees. Compare the problem, thereby improving the query efficiency of the database and reducing memory consumption, thus solving the technical problems of low query efficiency and large memory consumption of traditional comparison tools

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 device for quickly comparing data based on database b-tree
  • A method and device for quickly comparing data based on database b-tree
  • A method and device for quickly comparing data based on database b-tree

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0058] The first embodiment provides a method for quickly comparing data based on a database B-tree, such as figure 1 shown, methods include:

[0059] In step 101, start the comparison database, configure the comparison relationship between the source tables of the comparison data in the comparison database, divide the comparison table into a first table structure and a second table structure according to the data source, in the comparison database A table T with a clustered primary key is created, and the structure of the table T is divided into a first table T and a second table T according to whether there is a primary key in the first table structure and the second table structure.

[0060] A clustered index sorts and stores data in a table based on the key values ​​of data rows. There can only be one clustered index in each table structure, because data rows can only be stored in a unique order. There are many index columns in the index. The clustered primary key select...

Embodiment 2

[0076] The second embodiment of the present invention describes the implementation process of the first embodiment of the present invention from a relatively complete method step process. Compared with the first embodiment, the process performance of the embodiment of the present invention is more complete and more instantiated.

[0077] like figure 2 As shown, in step 101, start the comparison database, configure the comparison relationship between each source table of the comparison data in the comparison database, and divide the comparison table into a first table structure and a second table structure according to the data source, if the first table structure Both the table structure and the second table structure have primary keys, and a first table T with a clustered primary key is created in the comparison database. Combined with the embodiment of the present invention, there is also a preferred implementation scheme. Specifically, the first table T The structure of a ...

Embodiment 3

[0132] Embodiment 3 of the present invention illustrates the implementation process of Embodiment 1 of the present invention from a relatively complete method and step process. Compared with Embodiment 1, the process performance of this embodiment of the present invention is more complete and more instantiated. like image 3 As shown, the third embodiment of the present invention and the second embodiment of the present invention use different comparison schemes.

[0133] In step 101, start the comparison database, configure the comparison relationship between each source table of the comparison data in the comparison database, and divide the comparison table into a first table structure and a second table structure according to the data source. The structure and the second table structure do not have a primary key, and a second table T with a clustered primary key is created in the comparison database. Combined with the embodiment of the present invention, there is also a pre...

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 device for quickly comparing data based on a database B-tree. The method includes: starting the comparison database, configuring the comparison relationship between the source tables of the comparison data in the comparison database, and dividing the comparison table into The first table structure and the second table structure, create a table T in the comparison database; compare the database to extract and traverse each piece of data in the first table structure and the second table structure, and calculate the value of each piece of data when traversing the data; compare the database The first completed data result is directly inserted into table T, and after each calculated data result is compared with the data in table T by the preset comparison method, the corresponding data in the underlying B-tree of database operation table T is compared. The leaf node of T performs data insertion, data deletion, or data update operations on table T according to the comparison rules; query table T to obtain the data comparison result in the data source database.

Description

technical field [0001] The invention belongs to the technical field of data processing, and more particularly, relates to a method and device for rapidly comparing data based on a database B-tree. Background technique [0002] With the development of database technology, more and more databases are used in all walks of life, and applications will use multiple databases at the same time. These databases may be homogeneous or heterogeneous. In many cases, applications need to To compare table data on different databases, an efficient and fast database data comparison solution is required. [0003] When comparing the data with the primary key in the first table structure and the second table structure, the traditional comparison tool needs to sort the data in the first table structure and the second table structure before querying, and process each piece of data queried. First calculate the MD5 value of the primary key column, and then calculate the MD5 value of the remaining ...

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/22G06F16/24
CPCG06F16/2282G06F16/24
Inventor 孙峰谭建强彭青松刘启春余院兰
Owner WUHAN DAMENG DATABASE