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

Middleware-based database sharding method and apparatus

A technology of sub-database, sub-table, and middleware, which is applied in the field of database applications, can solve problems such as unavailability of business systems and violation of the opening and closing principles of software design, and achieve the effect of ensuring stability and scalability

Inactive Publication Date: 2017-12-01
BEIJING VRV SOFTWARE CO LTD
View PDF3 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Such intrusive modification of the code may lead to the unavailability of the original business system, and violates the open-close principle of software design

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
  • Middleware-based database sharding method and apparatus
  • Middleware-based database sharding method and apparatus
  • Middleware-based database sharding method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] Certain terms are used, for example, in the description and claims to refer to particular components. Those skilled in the art should understand that hardware manufacturers may use different terms to refer to the same component. The specification and claims do not use the difference in name as a way to distinguish components, but use the difference in function of components as a criterion for distinguishing. As mentioned throughout the specification and claims, "comprising" is an open term, so it should be interpreted as "including but not limited to". The following descriptions in the specification are preferred implementation modes for implementing the present invention, but the descriptions are for the purpose of illustrating the general principles of the present invention, and are not intended to limit the scope of the present invention. The scope of protection of the present invention should be defined by the appended claims.

[0031] In one embodiment of the pre...

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 middleware-based database sharding method. The method comprises the following steps of constructing a standard JAVA service as middleware, which is required to be independently started; defining a database sharding algorithm; by adopting the database sharding algorithm, configuring a database sharding rule according to a business demand; intercepting an SQL statement sent by an application, and according to the database sharding rule, analyzing the SQL statement; sending the analyzed SQL statement to a real database of a back end; and processing a result returned by the back end and returning the result to a user. The middleware-based database sharding method provided by the invention has the following advantages: database sharding can be finished without changing original business logic and modifying original business codes, so that the stability and expandability of a business system are ensured. The invention furthermore provides a middleware-based database sharding apparatus.

Description

technical field [0001] The invention relates to the technical field of database application, in particular to a method and device for sub-database and sub-table based on middleware. Background technique [0002] With the continuous growth of business system data, the amount of data in a single table becomes larger and larger. A single table and a single database cannot meet the requirements of business and data volume. At this time, you need to modify the code to complete the operation of sub-database and sub-table. Such intrusive modification of the code may lead to the unavailability of the original business system, and violates the open-close principle of software design. [0003] Therefore, there is a need for a middleware-based method and device for sub-database and table sub-database, which can complete the sub-database and table sub-database without changing the original business logic or modifying the original business code, ensuring the stability and scalability o...

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): G06F17/30
Inventor 梁宝珠高林武毕永东
Owner BEIJING VRV SOFTWARE CO LTD