Method and device for establishing data table, and electronic equipment

A data table and data technology, applied in the database field, can solve problems such as inability to meet data business needs and affect user usage, and achieve the effects of enriching data, improving the sense of use, and flexible partitioning.

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

AI Technical Summary

Problems solved by technology

However, with the development of business, the data that needs to be stored will become more abundant. This splitting method usually cannot meet the business needs of more abundant data, which will affect the user's use.

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 establishing data table, and electronic equipment
  • Method and device for establishing data table, and electronic equipment
  • Method and device for establishing data table, and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to make the objects, technical solutions, and advantages of the present invention, the technical solutions of the present invention will be apparent from the accompanying drawings, which will become apparent from the accompanying drawings. Embodiments. Based on the embodiments of the present invention, those skilled in the art do not have all other embodiments obtained by creative labor, all of which are protected by the present invention.

[0024] At present most of the construction of the table statement distributed database, data tables in the establishment of multi-level split ways, and each split-level fixed dimensions, for example, the same split dimension below a partition to get more two partition, for instance, using a range partitioning way to create a plurality of partitions, split two ways to create a plurality of two partitions using a hash partitioning, for each partition. But with the development of business, the need to store more and more data-rich...

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 provides a method and a device for establishing a data table, and electronic equipment. The method comprises the following steps: creating at least one first-level partition of a target data table according to a preset first-level partition dimension; for each first-level partition, obtaining a preset second-level partition dimension of the first-level partition, and creating at least one second-level partition on the first-level partition based on the second-level partition dimension, wherein if the number of the first-level partitions is multiple, the second-level partition dimensions preset by all the first-level partitions are different; and based on the at least one first-level partition and the second-level partition corresponding to each first-level partition, establishing the target data table. In the mode, when the data table is established, the second-level partition processing of different partition dimensions is performed for each created first-level partition, so that the second-level partition corresponding to each first-level partition can store the data based on different data dimensions, the partition mode of the multi-level partitions is flexible, the business requirements that the data is richer and more complex are met, and the use feeling of the user is improved.

Description

Technical field [0001] Technical Field The present invention relates to databases, in particular, it relates to a method for establishing a data table, device and electronic equipment. Background technique [0002] Distributed Database partition table refers generally, in accordance with certain rules database and a table is split into a plurality of different partitions, each partition physical storage, so that the data table may store more data, It also can improve the efficiency of data queries. In the related art, most of the data table distributed database support fixed dimension split multi-stage resolution, e.g., below a partition using the same split two dimensions to obtain a plurality of partitions, for example, range partitioning mode using creating a plurality of partitions, split two ways to create a plurality of partitions for each of the two partition using a hash partitioning. But with the development of business, data needs to be stored will be more abundant, the...

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/22
CPCG06F16/2282G06F16/2264G06F16/2255
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

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