Method and system for extending database table under multi-tenant environment

Abstract

The invention relates to the technology of databases, and particularly relates to a technology of extending a database table in a multi-tenant environment. The invention provides a method for extending the database table, which comprises the following steps: receiving a request of a tenant about database table extension; and generating a description document corresponding to the tenant according to the received request, wherein the description document describes extended fields defined by the database table into at least one extension column.

Description

Technical field [0001] The present invention relates to database technology, in particular to a technology for expanding database tables in a multi-tenant environment. Background technique [0002] Due to the emergence of SaaS (Software as a Service, software as a service), the software industry is undergoing a profound transformation. SaaS has become popular in many countries and has entered the popularization stage. The security technology of SaaS changes with each passing day, and more and more companies are beginning to recognize the security and reliability of SaaS. Based on the characteristics of the Internet, SaaS software has many unique features that are different from the previous generation of software. Many new technologies have emerged from server-side software and databases, data transmission, to client browsers. [0003] When developing SaaS software systems, they are all built on the basis of Multi-Tenant, also known as “multi-tenant”, which is a set of software a...

AI Technical Summary

Problems solved by technology

The obvious disadvantage of this solution is that if the developer only provides fewer expandable empty table columns when designing the system, then the needs of a large number of tenants to expand the database table may not be met

And if the developer provides a large number of expandable empty table columns when designing the system, the database table will occupy and waste a lot of space, because there are many expandable table columns that may only be required by very few tenants

In some cases, the above two disadvantages may occur at the same time: there are some tenants whose needs cannot be met, and there are a large number of scalable table columns with extremely low usage, resulting in a lot of space being wasted

Another disadvantage of this solution is: since the pre-defined expandable empty table columns do not contain relevant information such as data type (such as numeric type, date type, string type), these information must be defined by the tenant itself, so it must be passed Joint operation (JointOperation) can correctly interpret the data, which will consume a lot of computing resources and affect system performance and user experience

The obvious disadvantages of this solution are: first, a large number of private tables need to be created in a multi-tenant system to meet the needs of a large number of unknown tenants, and the number of private tables that can be created is limited by the database management system DBMS; second, When tenants operate the private data created by them (data in extended table columns), they must go through the joint operation (Join Operation) between the private table and the public table, which will consume a lot of computing resources and affect system performance and users. to experience

Images