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

Database sharding method and apparatus

A database and sub-database technology, applied in the field of database sub-database methods and devices, can solve the problems that it is difficult to accurately analyze the association relationship of a large number of database tables, the sub-database scheme is inaccurate, and the tightness of the association relationship cannot be accurately determined. Avoid error-prone and reduce workload

Active Publication Date: 2018-03-27
HUAWEI TECH CO LTD
View PDF5 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a database sub-database method and device, which is used to solve the problem that in the prior art, it is difficult for a DBA to accurately analyze the relationship between a large number of database tables when manually sub-database, and it is impossible to accurately determine the relationship. The closeness of the relationship leads to inaccurate technical problems in the obtained sub-database plan

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 sharding method and apparatus
  • Database sharding method and apparatus
  • Database sharding method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0106] In order to make the purpose, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings. Obviously, the described embodiments are only some of the embodiments of the present invention, rather than all of them. 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.

[0107] Database sharding includes vertical sharding and horizontal sharding.

[0108] Specifically, vertical database sharding refers to dividing closely related database tables in the source database into a sub-database, which is applicable to scenarios where there are a large number of database tables in the source database. Figure 1a It is a schematic diagram of vertical sub-library. Such as Figure 1a As shown, the source database ...

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

Embodiments of the invention disclose a database sharding method and apparatus. The method comprises the steps of obtaining DDL statements of database tables in a source database, DML statements associated with the database tables and performance index data of the DML statements; according to the DDL statements of the database tables and the DML statements associated with the database tables, determining an associated relationship among the database tables; according to the associated relationship among the database tables and the performance index data of the DML statements, determining a degree value of the associated relationship among the database tables; and according to the degree value of the associated relationship among the database tables, performing sharding on the database tables. Therefore, the problem of inaccurate sharding scheme caused by DBA manual sharding in the prior art is avoided.

Description

technical field [0001] The invention relates to the technical field of communications, in particular to a method and device for database subdivision. Background technique [0002] With the development of society, a large amount of data in the application system needs to be stored in the database. When the amount of data to be stored reaches a certain level (for example: hundreds of millions of levels), using a single database for data storage management will cause problems such as capacity bottlenecks and performance bottlenecks, which will affect the improvement of application system processing capabilities, thereby affecting faster business. development of. In order to solve this problem, the database sub-database method can be adopted, that is, the massive data is split from one database storage management to multiple database storage management. [0003] Database sub-databases in the prior art are usually manually performed by a database administrator (Database Adminis...

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): G06F17/30
CPCG06F16/21G06F16/27
Inventor 王兵兵赵俊
Owner HUAWEI TECH CO LTD