A multi-tenant data storage pattern suitable for cross-tenant data sharing
With the development of the centralization of SaaS.(Software-as-a-Service)software and the scope of business service,cross-tenant business collaboration and data sharing requirements have become more and more prominent,which has posed new challenges to the traditional multi-tenant data storage model with tenant data isolation as the main content.How to support cross-tenant data sharing and on-demand customization on the basis of the existing multi-tenant data pattern has become a new problem in the design of multi-tenant data storage patterns.To this end,this paper proposes a multi-tenant data storage mode that supports customizable sharing,that is,sharing wide tables.This mode extends the logical tables used to store relationships between tenants under the traditional wide tables,and adds a mapping mechanism for heterogeneous data,which can be applied to flexible customization of data sharing between tenants while ensuring their requirements for data isolation.Experiments show that compared with the traditional wide-table data schema,it is easier for the storage mode proposed in this paper to support cross-tenant data sharing definitions with better efficiency of sharing query.