Database data management method and device and electronic equipment

A technology of data management and database, applied in the field of cloud storage

Pending Publication Date: 2021-06-04
BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to provide a database data management method, device, elec...

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 data management method and device and electronic equipment
  • Database data management method and device and electronic equipment
  • Database data management method and device and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058]Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that the relative arrangements of components and steps, numerical expressions and numerical values ​​set forth in these embodiments do not limit the scope of the present invention unless specifically stated otherwise.

[0059] The following description of at least one exemplary embodiment is merely illustrative in nature and in no way taken as limiting the invention, its application or uses.

[0060] Techniques, methods and devices known to those of ordinary skill in the relevant art may not be discussed in detail, but where appropriate, such techniques, methods and devices should be considered part of the description.

[0061] In all examples shown and discussed herein, any specific values ​​should be construed as exemplary only, and not as limitations. Therefore, other instances of the exemplary embodiment may have diff...

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 database data management method and device, electronic equipment and a computer readable storage medium. A database is provided with more than two tables with the same format, all rows of each table are provided with row primary key values, each table comprises at least one corresponding partition, and each partition is provided with a specific partition server, and the method comprises the following steps: determining object attributes of data to be written as the row primary key values in a table to be stored, wherein the to-be-stored table is a table used for storing the to-be-written data in the more than two tables with the same format; determining table serial numbers of the to-be-stored tables according to the row primary key values and the number of the tables; determining a to-be-stored partition based on the table serial number of the to-be-stored table and the row primary key value, wherein the to-be-stored partition is a partition where the row primary key value is located in the to-be-stored table; and writing the to-be-written data into a partition server corresponding to the to-be-stored partition.

Description

technical field [0001] The present invention relates to the technical field of cloud storage, in particular to a database data management method, device, electronic equipment and computer storage medium. Background technique [0002] Non-relational databases (NoSql) with partially distributed storage, such as HBase and HyperTable, when writing and reading data, divide the data into different rows according to the row key (Rowkey) of each row of data in lexicographical order. Each region is assigned to a different region server in the cluster. When a large number of rows with the same prefix of the primary key are written, it will cause excessive traffic on the partition server, resulting in performance degradation or even unavailability of hot spots. In related technologies, one way is to use hash hash to rehash the row primary key value to distribute the data to different partitions; the other way is to reduce the regularity of the row primary key value by randomly prefixi...

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/22G06F16/25
CPCG06F16/2255G06F16/25
Inventor 陈骋
Owner BEIJING KINGSOFT CLOUD NETWORK TECH CO 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