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

Method for realizing multi-tenant data isolation of industrial software

A technology of data isolation and implementation method, applied in the field of data processing, can solve the problems of consumption, omission, large labor cost, etc.

Pending Publication Date: 2021-04-02
山东恒远智能科技有限公司
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the actual development process, manually adding TenantId for each database access requires a lot of labor costs, and there are potential risks of omissions or addition errors

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
  • Method for realizing multi-tenant data isolation of industrial software
  • Method for realizing multi-tenant data isolation of industrial software

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0038] Please refer to figure 1 As shown in FIG. 2 , it is a structural schematic diagram of the method for implementing industrial software multi-tenant data isolation of the present invention. The implementation method of the industrial software multi-tenant data isolation includes:

[0039] S1. Initialize, specify the name of the database table that requires data isolation, and obtain the target database table vector T[i]; set the schema, and set a field tenant_id corresponding to TenantId in the database table contained in T[i]; obtain The TenantId corresponding to the login user; loading the TenantId and T[i] of the login user into the system cache can improve the access speed and reduce the access load to 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 discloses a method for realizing multi-tenant data isolation of industrial software. The method comprises the steps of acquiring an original SQL (Structured Query Language) statement ofuser access data by using a filter technology, judging whether the original SQL statement is a database table to be isolated or not, if so, modifying the SQL statement through a self-defined rule andexecuting the modified SQL statement. Therefore, the purpose of automatically adding a label to multi-tenant data is achieved, the efficiency of labeling the data is greatly improved, and the accuracyis ensured. The method is flexible and efficient, the tenant label can be automatically added to the SQL script only through a small amount of configuration work, and efficient isolation of industrial software multi-tenant data is achieved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a method for realizing multi-tenant data isolation of industrial software. Background technique [0002] Multi-tenancy technology (multi-tenancy technology) or multi-tenancy technology is used more and more widely in today's era. In some industrial scenarios, multi-tenancy technology must be used. Multi-tenant technology is a software architecture technology, which is to explore and realize how to share the same system or program components in a multi-user environment, and still ensure the isolation of data between users. Simply put, multiple tenants (users who are not related to each other) use the same system, each implements its own operations and does not affect each other. [0003] In the process of implementing multi-tenant technology, data storage is the top priority. There are three main solutions: [0004] (1) Separate databases [0005] The solution is to assign a sepa...

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): G06F16/22G06F16/242G06F16/2455
CPCG06F16/2282G06F16/2433G06F16/2455
Inventor 张永文杨磊季东滨李红勇
Owner 山东恒远智能科技有限公司