Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data division processing method, system andapparatus and storage medium

A processing method and database technology, applied in the field of data processing, can solve problems such as poor consistency of transaction data, and achieve the effect of facilitating rapid migration and rapid horizontal expansion

Inactive Publication Date: 2019-02-22
CHINA CONSTRUCTION BANK
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In order to solve the above technical problems, the present invention provides a data sub-database processing method, system, device and storage medium to solve the problem of poor consistency of current transaction data

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 division processing method, system andapparatus and storage medium
  • Data division processing method, system andapparatus and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0023] figure 1 It is a flowchart of a data sub-database processing method according to an embodiment of the present invention, see figure 1 , the method includes:

[0024] Step S1, according to the data business type in the database, perform vertical segmentation processing on the database to obtain multiple segmentation databases;

[0025] Step S2, performing data analysis on the data volume and growth rate of the tables in the plurality of partitioned databases, and judging whether horizontal partitioning is required;

[0026] Step S3, if the horizontal segmentation is required, perform horizontal segmentation on the plurality of segmentation libraries.

[0027] In an embodiment of the present invention, in step S2, the judging whether h...

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

A Data division processing method, system and apparatus and a storage medium are disclosed. That method comprises the following steps: according to the data service type in the database, the databaseis vertically split to obtain a plurality of sub-libraries; data analysis is performed on the data amount and growth rate of the tables in the plurality of slitting warehouses, and judging whether horizontal slitting is required; If the horizontal segmentation is required, the plurality of segmentation libraries are horizontally segmented. The invention can effectively isolate faults, can construct more scientific data structure, and is convenient for rapid data migration and rapid lateral expansion.

Description

technical field [0001] The present invention relates to the field of data processing, in particular, to a data sub-database processing method, system, device and storage medium. Background technique [0002] The Internet era is also an era in which relational databases dominate. From Oracle's dominance in the early days to MySQL's flourishing, relational databases are the "lifeblood" of most Internet applications in terms of reliable data storage. [0003] As Internet products expand in size and scale, both Oracle and MySQL will immediately face stand-alone bottlenecks such as disk, CPU, and memory. , but also face continuous iterative online data migration. In this case, whether it is massive structured data or rapidly growing business scale, there is an urgent need for a horizontal expansion method to allocate storage costs to cost-controllable commercial servers. At the same time, we also hope to reduce the impact of full data migration on online services through linear...

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/22
Inventor 范雄健程明远苏贤杰陈大平黄瑾范玄周小聪
Owner CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products