Multi-tenant data source switching system based on method parameter aspect
A technology for switching systems and data sources, applied in the field of multi-tenant data source switching systems based on method parameter aspects, can solve the problems of low isolation level, increased security development volume, low security, etc. effect on stability
Active Publication Date: 2021-11-19
舟谱数据技术南京有限公司
View PDF13 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
If the price is low and the product takes a low-priced route, this solution is generally unaffordable for operators
[0007] Share the database and isolate the data structure. If there is a failure, data recovery is difficult, because restoring the database will involve the data of other tenants; if you need cross-tenant statistics, there are certain difficulties
[0008] Shared database and shared data structure, that is, tenants share the same Database and the same Schema, but distinguish the data of tenants by TenantID in the table; the isolation level is the lowest, and the security is the lowest, so it is necessary to increase the amount of security development during design and development; Data backup and recovery are the most difficult, and need to be backed up and restored table by table
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
[0025] The present invention will be further described below in conjunction with the accompanying drawings.
[0026] see as figure 1 As shown, the specific implementation method includes the following steps:
[0027] 1. The user logs in, and the unified authentication returns which library the current user belongs to, and the identifier is cid, which is the sub-database key; each user carries the cid after logging in.
[0028] 2. Before intercepting the method, in the system execution context SysContext, bind ThreadLocal to each request, ThreadLocal saves the current cid, and releases it when it is used up.
[0029] 3. After intercepting the method, find the data source corresponding to the cid from the memory, and switch the current data source. The data source is also a bound thread, and the end of a thread request will also release the current data source.
[0030] 4. The connection pool cannot be shared between applications. Each application in the cluster maintains the...
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 multi-tenant data source switching system based on method parameters, and belongs to the technical field of multi-tenant data sources. The user logs in, and the unified authentication returns which library the current user belongs to, identified as cid, which is the sub-library key; each user carries the cid after logging in; before intercepting the method, in the system execution context SysContext, bind ThreadLocal to each request , ThreadLocal saves the current cid and releases it when it is used up; it unifies the API standard, does not need to pay attention to who calls it, and does not need to make judgments and settings in each business code. Of course, the data source makes the code more concise and more maintainable .
Description
technical field [0001] The invention relates to a multi-tenant data source switching system based on method parameters, and belongs to the technical field of multi-tenant data sources. Background technique [0002] Multi-tenancy technology (English: multi-tenancy technology), or multi-tenancy technology, is a software architecture technology that discusses and implements how to share the same system or program components in a multi-user environment and still ensure that each Data isolation between users. [0003] Due to the fever of cloud computing issues, how to use a single system architecture and services in a shared data center to provide the same or even customizable services for most clients, and still ensure the isolation of customer data, so that multi-tenant technology has become a cloud computing technology. of learning. [0004] In multi-tenant technology, a tenant refers to a customer who uses the system or computer computing resources, but in multi-tenant tech...
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 Patents(China)
IPC IPC(8): G06F16/25G06F16/2455
Inventor 苗江波汤定一张旭荣王宏祥
Owner 舟谱数据技术南京有限公司