Database sharding method and device, middleware, storage medium and electronic equipment
A database and sub-database technology, applied in the computer field, can solve the problems of high maintenance cost, unfavorable post-maintenance, high code complexity, etc., and achieve the effect of reducing post-maintenance cost, reducing development complexity, and low code complexity
Active Publication Date: 2018-11-23
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF6 Cites 6 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
However, there are still some problems in related technologies, such as strong code intrusion, complex development, and not conducive to later maintenance; when querying multiple data or evaluating functions such as sum and count, it is necessary to traverse all databases and add the query results , the code complexity is high, which is not conducive to beginners to use, and the later maintenance cost is high; the method of transmitting database information is single, only through ThreadLocal, and it is easy to make mistakes when switching between multiple databases; when using database transactions (non-distributed transactions), regardless of using declarative Both transactions and programmatic transactions need to specify or write transactions for each database separately, and the development is more complicated
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0059] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
[0060] Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus repeated descriptions thereof will be omitted. Some of the block diagrams shown in the drawings are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities ...
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
Login to View More Abstract
The invention relates to a database sharding method and device, middleware, a storage medium and electronic equipment. The method comprises the steps of receiving a database operation request, and analyzing the database operation request to call a preset database method; when the preset database method is called, enabling the preset database method to access a preset proxy class; obtaining a method name of the preset database method by the preset proxy class, and judging the type of the method to which the method name belongs; and accessing a database according to the method type obtained by judgment through the preset proxy class so as to operate the database. The method disclosed by the invention has the advantages that the code invasiveness of realizing sharding operation can be reduced, the development amount is reduced, and the development complexity is lowered.
Description
technical field [0001] The present disclosure relates to the field of computer technology, and in particular, to a database sub-database method, a database sub-library device, a database access middleware including the database sub-database device, and a computer-readable storage medium and electronic equipment for implementing the database sub-database method . Background technique [0002] At present, among Java open source projects, there are many projects for accessing databases, among which the more famous ones are the Hibernate and Mybatis projects which are currently used more. Among them, Hibernate is generally used in large or very large projects because it is relatively heavyweight. Mybatis is used by a large number of small and medium-sized projects because of its lightweight and simple and efficient development methods. Even some large projects currently use Mybatis as a database access component. However, Mybatis currently does not support sub-database operat...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 张志维
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD