Unlock instant, AI-driven research and patent intelligence for your innovation.

Service table partitioning method and device

A business table and partition technology, applied in the computer field, can solve problems such as error-prone and heavy workload, and achieve the effect of improving operation, improving efficiency and reducing error rate.

Pending Publication Date: 2020-12-04
BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For a system whose business involves multiple regions and has a large number of database tables that need to be partitioned by region, developers often need to define the partition of each table in each region in the database table creation script, which is a heavy workload and error-prone

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
  • Service table partitioning method and device
  • Service table partitioning method and device
  • Service table partitioning method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below in conjunction with the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention, not all of them. the embodiment. 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.

[0018] At present, the existing solution manually maintains each table through the developer before the partition operation of the business table. If the developer manually maintains the creation script or partition addition script of each table, there are the following disadvantages:

[0019] 1. The script needs to be maintained manually, and the workload is heavy;

[0020] 2. Due ...

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 service table partitioning method and device, and relates to the technical field of computers, and the method comprises the steps: obtaining a configuration file and the partitioning information of a service table; comparing the first target column data of the configuration file with the second target column data of the partitioning information to obtain to-be-added partitioning data; generating a partitioning adding script file according to the to-be-added partitioning data; and partitioning the service table according to the partitioning adding script file. Accordingto the method, partitioning adding can be automatically carried out on the service table, the workload of developers is reduced, the error rate of data adding is reduced, the operation of adding a new partition is more convenient and faster, and the partitioning efficiency of the service table is further improved.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a business table partition method and device. Background technique [0002] The business table in the database includes various fields. For example, for a business table involving multiple regions, the table includes a column of regions for storing the region information to which the business belongs. For a system whose business involves multiple regions and has a large number of database tables that need to be partitioned by region, developers often need to define the partition of each table in each region in the database table creation script, which is a heavy workload and error-prone. Contents of the invention [0003] The invention provides a business table partition method and device, which can automatically identify and create missing column data in a database table, so as to partition according to the column data, and improve the partition efficiency of the bus...

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/23
CPCG06F16/2282G06F16/23Y02D10/00
Inventor 樊世雄钟艳辉黄艺杰
Owner BANK OF CHINA