Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Multi-tenant data source switching system based on method parameter section

A technology for switching systems and data sources, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as difficult data recovery, increased security development, and low security

Active Publication Date: 2018-09-11
舟谱数据技术南京有限公司
View PDF13 Cites 7 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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Multi-tenant data source switching system based on method parameter section

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

No PUM Login to View More

Abstract

The invention relates to a multi-tenant data source switching system based on a method parameter section and belongs to the technical field of multi-tenant data sources. User login is conducted, unified authentication is conducted to return to a library to which a current user belongs, and cid serving as a library distinguishing key is an identifier; each user carries the cid after login; before methods are intercepted, the system binds ThreadLocal to each request during execution of context SysContext, and the current cid is saved in the ThreadLocal and released when being used. API standardsare unified, there is no need to pay attention to the information about who conducts calling, judgment and setting of current data sources are not required to be conducted in each business code, andcodes are more concise and higher in maintainability.

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
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 苗江波汤定一张旭荣王宏祥
Owner 舟谱数据技术南京有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com