Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Partition splitting method and device, electronic equipment and readable storage medium

A partitioning and source partitioning technology, applied in the database field, can solve problems such as large resource consumption and excessively large single partitions, and achieve the effect of improving splitting performance

Active Publication Date: 2019-07-19
BEIJING OCEANBASE TECH CO LTD
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, because a single partition in some databases is too large, there will be a problem that a large amount of resources such as CPU, IO, and disk space will be consumed when partitioning it.

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
  • Partition splitting method and device, electronic equipment and readable storage medium
  • Partition splitting method and device, electronic equipment and readable storage medium
  • Partition splitting method and device, electronic equipment and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to better understand the above technical solutions, the technical solutions of the embodiments of this specification will be described in detail below through the drawings and specific examples. It should be understood that the embodiments of this specification and the specific features in the embodiments are the technical solutions of the embodiments of this specification. It is a detailed description, rather than a limitation to the technical solutions of this specification. In the case of no conflict, the embodiments of this specification and the technical features in the embodiments can be combined with each other. It should be noted that, in the embodiments of this specification, the term "more than two" includes two or more than two situations; the term "and / or" is only a description of the relationship between associated objects, indicating that there may be three A relation, for example, M and / or N, may mean: M exists alone, M and N exist simultaneously,...

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 embodiment of the invention provides a partition splitting method. A data file in a target source partition is divided into more than two data groups; one data group is taken as a target split data group; the target split data group is split according to a preset splitting rule and then assigned to a corresponding new partition; after splitting of the target split data set is completed, one data set is selected from the remaining data sets again to serve as the target split data set, splitting of all the data sets is completed through multiple rounds, consumption of resources caused by partition splitting is dispersed to multiple time periods, and resources such as CPU, IO and disk space occupied in the splitting process are saved.

Description

technical field [0001] The embodiment of this specification relates to the technical field of databases, and in particular to a partition splitting method, device, electronic equipment, and readable storage medium. Background technique [0002] Database partitioning is a physical database design technique. When the data volume of a single partition is too large, the partition needs to be split. Partition splitting is a service that splits a partition into multiple partitions, offline the original partition, and bring the split new partition online, so that the writing and reading pressure of the original partition is distributed to different partitions, breaking through single partition processing the limit of ability. However, because a single partition in some databases is too large, there will be a problem of consuming a large amount of resources such as CPU, IO, and disk space when partitioning it. Contents of the invention [0003] The embodiment of this specificati...

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/21G06F16/22G06F16/18
CPCG06F16/21G06F16/2255G06F16/2246G06F16/1815G06F16/278G06F16/322G06F3/0614G06F3/064G06F3/0644G06F3/0659G06F3/0673
Inventor 李晨曦赵裕众徐虎
Owner BEIJING OCEANBASE TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products