Multi-tenant oriented database engine and its data access method

Abstract

A database engine facing multiple tenancies and data accessing method thereof are provided. The method of the invention includes: receiving a data access request of tenancy; determining the tenancy entity corresponding to the tenancy, wherein multiple tenancy entities share one logic table in the database; processing the data access request of the tenancy according to the configuration information of the tenancy entity. The invention introduces the concept of tenancy entity to the database: a plurality of tenancy entities shares one logic table such that the development and management costs are reduced; meanwhile, every tenancy entity has independent database access account number such that the security problem of the database access is solved; when the tenancy request comes, the data access request of the tenancy is processed according to the authority of the account number of the tenancy. Due to the introduced concept of the tenancy entity in the invention, the data of the tenancy is physically separated from each other and thus it is possible to improve performance, excellent isolation and expandability; and it is possible to realize the service quality management for the tenancy at the same time.

Description

technical field [0001] The invention relates to multi-tenant database sharing, in particular to a multi-tenant-oriented database engine and a data access method thereof. Background technique [0002] In a multi-tenant system, a database service provider leases one database instance to multiple small and medium-sized (SMB) tenants, so that a large number of small and medium-sized tenants share the same database instance. To construct a reasonable multi-tenant architecture, the following technical issues should be considered: [0003] Security issues: Since multiple tenants share the same database instance, it is necessary to prevent one tenant from accessing data placed in the database by other tenants; [0004] Application development cost: the developer's development complexity must be considered when deploying such a multi-tenant application; [0005] Management cost: The management complexity of the operating platform must be considered, such as tenant login, backup and...

AI Technical Summary

Problems solved by technology

[0003] Security issues: Since multiple tenants share the same database instance, it is necessary to prevent one tenant from accessing data placed in the database by other tenants;

However, since a separate table is prepared for each tenant in the database, it is very difficult to manage when there are many tenants, which greatly increases the cost of management

Images