Method and device for realizing database partition and distributed database management system

A database and distributed technology, applied in the field of cloud computing, can solve problems such as database bottlenecks, and achieve the effect of reducing operation and maintenance costs

Pending Publication Date: 2021-08-24
ALIBABA GRP HLDG LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, with the complexity of big data scenarios and the increasingly complex analysis requirements, some hot partitions will be caused when the data of some hash keys themselves is unbalanced, thus causing the bottleneck of the database

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
  • Method and device for realizing database partition and distributed database management system
  • Method and device for realizing database partition and distributed database management system
  • Method and device for realizing database partition and distributed database management system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] In order to make the purpose, technical solution and advantages of the application clearer, the embodiments of the application will be described in detail below in conjunction with the accompanying drawings. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

[0051] In a typical configuration of the present application, a computing device includes one or more processors (CPUs), input / output interfaces, network interfaces, and memory.

[0052]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.

[0053] 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 info...

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 realizing database partition and a distributed database management system, and the invention well evaluates the effect advantages and disadvantages of the partition by collecting the operation state information of database partitions (including partitions and computing nodes). According to the invention, the dynamic partitioning is realized, and the partitioning is further automatically adjusted according to the data condition of the database, so that the real dynamic partitioning is realized, and the operation and maintenance cost in the cloud computing era is greatly reduced.

Description

technical field [0001] This application relates to but not limited to cloud computer technology, especially a method and device for realizing database partitioning and a distributed database management system. Background technique [0002] As the amount of data in the database increases, database partitioning emerges as the times require. Database partitioning is mainly used to solve the problem of low query efficiency and performance degradation caused by large data volume. Use the database partition function to further divide tables, indexes, etc. into segments, and these database objects are partitions. These partitions can be managed individually or collectively. [0003] In the traditional database partitioning technology, the hash algorithm is mostly used to evenly hash the data in different partitions, and each partition is only responsible for its own data. However, with the complexity of big data scenarios and the increasingly complex analysis requirements, in th...

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/27G06F16/22
CPCG06F16/2255G06F16/27
Inventor 梁卜元酆晓杰
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap