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

Method for isolating SaaS software tenant data

A data isolation and tenant technology, applied in the computer field, can solve the problems of mutual data leakage, high requirements for application developers, code logic problems, etc., to achieve the effect of improving data security, high data processing efficiency, and meeting business needs

Pending Publication Date: 2019-08-23
上海有谱网络科技有限公司
View PDF8 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The data is not physically isolated, but only logically distinguished, and the business processing is a little more rigorous. The data between tenants may leak each other, and the data security is relatively low.
[0005] When the tenant no longer renews the lease, it needs to back up the tenant's data or clean up the data. It will be very difficult to separate the data of a tenant separately, resulting in incomplete data and garbage data
[0006] A database to store the data of many tenants will inevitably lead to a huge amount of data, and a huge amount of data will inevitably lead to low data processing efficiency
[0007] Application development must consider the issues of "tenant id" and "tenant data distinction" when implementing each requirement. The requirements for application developers are relatively high, and code logic problems are prone to occur.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0022] Embodiment 1: The SaaS software tenant data isolation method of this embodiment is based on windows or linux operating system, mysql database, and SaaS software developed based on java. In the database, a basic database needs to be preset for the SaaS software as a benchmark template for tenant information replication, and the SaaS software is connected by configuring the user name and password of the basic database. And supporting a platform database as unified data management.

[0023] 1. After receiving the creation request of a new tenant, the SaaS software registration unit generates a unique random number for the tenant as the tenant's namespace. The registration unit calls the database creation script to create a new database and name it "basic database_namespace". When the tenant database is created, the corresponding database user will not be created, but the permissions of the tenant database will be given to the application basic database user;

[0024] 2. T...

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 isolating SaaS software tenant data. The method is characterized in that each tenant has a unique naming space, different tenants achieve physical isolation of data by creating different database instances and label databases with the naming spaces of the tenants for distinguishing, and tenant information and the naming spaces can be maintained in a unified mode through a platform database. According to the method, physical isolation between tenant data is realized, and the data security is improved substantially; backup and clearing of tenant data are convenient, the integrity of the data is guaranteed, and no junk data exists; data of all tenants are separated, and the data processing efficiency is high.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method for isolating SaaS software tenant data. Background technique [0002] SaaS is the abbreviation of Software-as-a-Service. With the development of Internet technology and the maturity of application software, a completely innovative software application model began to emerge in the 21st century. It is a mode of providing software through the Internet. The manufacturer uniformly deploys the application software on its own server. Customers can order the required application software services from the manufacturer through the Internet according to their actual needs, according to the number of services ordered and the length of time. Pay the manufacturer and obtain the service provided by the manufacturer through the Internet. For many small businesses, SaaS is the best way to adopt advanced technology, eliminating the need for businesses to buy, build and maintain infra...

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): G06F21/62G06F16/22G06F16/23
CPCG06F21/6245G06F16/23G06F16/22Y02D10/00
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