Data table horizontal splitting method and device

A technology of horizontal splitting and data tables, applied in the database field, can solve problems such as high time cost of splitting, complex splitting of data tables and databases, increased cost of data tables, etc., and achieve the effect of automatic splitting

Inactive Publication Date: 2019-11-05
GUIZHOU BAISHANCLOUD TECH CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] 1. The structure of the data table and its splitting modes are diverse, and there is no unified specification, which makes the splitting of the data table and database complicated, and the time cost of splitting is high
[0004] 2. Irregular splitting mode will add additional cost to splitting the data table again later
[0005] 3. Problems such as cumbersome and irregular splitting process are also likely to cause problems such as wrong splitting and loss of data records

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 table horizontal splitting method and device
  • Data table horizontal splitting method and device
  • Data table horizontal splitting method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention. 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.

[0038] figure 1 It exemplarily shows a schematic flow chart of the data table horizontal splitting method according to the present invention.

[0039] Such as figur...

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 table horizontal splitting method and device. The method disclosed by the invention comprises the following steps: comparing distribution conditions of all records in adata table respectively corresponding to various field combinations in the data table; selecting a field combination which enables all records in the data table to be uniformly distributed or approximately uniformly distributed in the N sets as a split field combination; and splitting the data table automatically and horizontally into N split tables based on the split field combination, wherein Nis larger than or equal to 2 and far smaller than the total record number. According to the technical scheme, automatic splitting of the data table can be realized.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data table horizontal split method and device. Background technique [0002] The database is used to save relevant data records of users or devices, and the same type of data records are usually stored in a data table of the database. With the continuous growth of data volume, the form of single database and single table will cause the IO bottleneck of database reading and writing. At this time, it is necessary to split the single data table in the database. The existing sub-table (that is, data table splitting) technology mainly has three shortcomings: [0003] 1. The structure of the data table and its splitting modes are diverse, and there is no unified specification, which makes the splitting of the data table and database complicated, and the time cost of splitting is high. [0004] 2. Irregular splitting mode will add extra cost for splitting the data table again later. [000...

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/22G06F16/27
Inventor 李文博张炎泼
Owner GUIZHOU BAISHANCLOUD 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