Method and device for data routing based on Java annotations

Abstract

The invention discloses a method and device for data routing based on Java annotations, and relates to the field of data query and operation. The method comprises the following steps of creating a routing annotation on a target object method of a Java class; generating a corresponding Proxy proxy class for the method for creating the target object after the routing annotation; dynamically loadinginto the JVM; generating a Proxy proxy object; intercepting a method calling request by the Proxy proxy object; analyzing routing annotations, obtaining an in-parameter parameter of the request and anel expression carried by the route annotation; according to the data routing method, the input parameter is calculated through the el expression on the routing annotation to obtain the database connection information, the target object method is called, the database connection information is combined, the target database is operated, communication analysis and SQL analysis are not needed, the cost is lower, the speed is higher, and the simpler, lighter and more efficient data routing method is achieved.

Description

technical field [0001] The invention relates to the field of data query and operation, in particular to a method and device for data routing based on Java annotations. Background technique [0002] With the growth of business, the amount of data stored in the tables of relational databases (MySQL / Oracle, etc.) is increasing. When the amount of data reaches a certain level, MySq1 single table is more than 800w, and Oracle single table is more than 3000w-5000w), There will be performance problems with complex queries or change operations. In response to this situation, the general processing method is to split the data into databases. At present, the mainstream solution for sub-database and sub-table is to use database proxy middleware, which will perform data routing by parsing SQL statements. However, powerful database proxy middleware is generally more complex in architecture and requires the team to Its operation and maintenance capabilities also require certain restrict...

AI Technical Summary

Problems solved by technology

At present, the mainstream solution for sub-database and sub-table is to use database proxy middleware, which will perform data routing by parsing SQL statements. However, powerful database proxy middleware is generally more complex in architecture and requires the team to Its operation and maintenance capabilities also require certain restrictions on the SQL written by developers. For some applications that require data fragmentation, but the business / team size is small, it is not friendly. The cost of building a complete set of database proxy middleware Larger, not suitable for small teams

Images