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

Data redistribution method and device, equipment and storage medium

A redistribution and data technology, applied in the database field, can solve the problems affecting the overall efficiency, time-consuming, complicated process, etc., and achieve the effect of simple and efficient technical effect

Pending Publication Date: 2022-07-05
SHANGHAI DAMENG DATABASE
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the existing data redistribution process, the data in the table to be migrated is scanned and the target node of each row of data in the table is recalculated, and then distributed. The process is complicated and time-consuming, which affects the overall efficiency

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 redistribution method and device, equipment and storage medium
  • Data redistribution method and device, equipment and storage medium
  • Data redistribution method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0081] figure 1 A flowchart of a data redistribution method is provided for Embodiment 1 of the present invention. This embodiment can be applied to the situation where two or more sensors are used for target tracking. The method can be executed by a data redistribution device. The data redistribution apparatus can be implemented in the form of hardware and / or software, and the data redistribution apparatus can be configured in an electronic device. like figure 1 As shown, the method includes:

[0082] S110. Determine the tablespace to be migrated, the source node where the tablespace to be migrated is located, and the target node to be migrated.

[0083] In a database, a table space (Table Space, TS) consists of one or more data files. All objects in the database are logically stored in the table space, and physically stored in the data files of the table space to which they belong. A tablespace can be used as a movable unit of data to quickly migrate subtables between dat...

Embodiment 2

[0106] figure 2 This is a flowchart of a data redistribution method provided in Embodiment 2 of the present invention, and this embodiment is a refinement of the foregoing embodiment S130. like figure 2 As shown, the method includes:

[0107] S210. Determine the tablespace to be migrated, the source node where the tablespace to be migrated is located, and the target node to be migrated.

[0108] In this embodiment, when the number of data storage nodes changes, node data in the distributed system needs to be migrated, that is, redistributed.

[0109] Optionally, according to the executed SQL statement, the tablespace to be migrated, the source node where the tablespace to be migrated is located, and the target node to be migrated can be determined.

[0110] S220. Copy the data files in the tablespace to be migrated to the target node.

[0111] In this embodiment, according to the known tablespace to be migrated and the corresponding target node, the tablespace to be migr...

Embodiment 3

[0128] image 3 This is a schematic structural diagram of a data redistribution apparatus provided in Embodiment 3 of the present invention. like image 3 As shown, the apparatus includes: a tablespace to be migrated and a source node and target node determination module 310 , a data file copying module 320 and a log file sending and replaying module 330 .

[0129] The tablespace to be migrated and the source node and target node determination module 310 is configured to determine the tablespace to be migrated, the source node where the tablespace to be migrated is located, and the target node to be migrated.

[0130] The data file copying module 320 is configured to copy the data files in the tablespace to be migrated to the target node.

[0131] Optionally, the data file copying module 320 is also used for:

[0132] Block the tablespace to be migrated and each table in the tablespace to be migrated; obtain the definition of the tablespace to be migrated on the source node...

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 data redistribution method and device, equipment and a storage medium. The method comprises the steps that a to-be-migrated table space, a source node where the to-be-migrated table space is located and a to-be-migrated target node are determined; copying the data file in the to-be-migrated table space into the target node; and sending the log file corresponding to the to-be-migrated table space to the target node and replaying the log file. The invention provides a simple and efficient data redistribution method, by means of online migration, online copying of table space data files and replaying of log files generated by a user in the migration process, the user can still continue to access and modify table data in the table space in the migration process, and the influence caused by table space migration is almost avoided.

Description

technical field [0001] The present invention relates to the technical field of databases, and in particular, to a data redistribution method, apparatus, device and storage medium. Background technique [0002] Usually, when the number of nodes in a distributed database system changes, in order to make full use of the node resources in the system, achieve a balance of data storage, and improve resource utilization and overall performance, it is necessary to analyze the original data according to the distribution attributes of the data table. data for data redistribution. [0003] In the prior art, data redistribution is usually performed according to a certain algorithm, such as a hash consistency algorithm. In the existing data redistribution process, the data in the table to be migrated is scanned, the target node of each row of data in the table is recalculated, and then the data is distributed. The process is complicated and time-consuming, which affects the overall effi...

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): G06F16/18G06F16/11G06F16/182
CPCG06F16/184G06F16/119G06F16/1815
Inventor 韩朱忠郭振岗
Owner SHANGHAI DAMENG DATABASE