Multi-tenant data Isolation Mode in eeplat PAAs

eeplat PAAs supports data isolation technology for three tenants: sparce column, tenantid field isolation, each tenant independent database. 1) sparce column, similar to Salesforce appforce, stores all user-defined information through a common table, including tenant fields and many Unified Data columns (such as 500 ). The eeplat PAAs platform uses tenant partitions to query and optimize tenant data. Unlike appforce, The eeplat PAAs platform provides two-layer metadata abstraction. The business metadata in the eeplat PAAs platform is independent of the tenant storage metadata. The eeplat PAAs platform provides a more powerful metadata system. 2) Isolate tenantid fields. Field isolation of tenantid adds the tenantid field to each business table to differentiate tenant data. In this mode, it is generally used for initial business of the system. Instead of the tenant's custom business. 3) tenant independent database. For MySQL databases, the cost of creating a database is relatively small. The tenant independent database provides maximum security and scalability. When a tenant is activated, the eeplat PAAs platform can create its own independent database for each tenant and initialize its own business tables. This project provides an interface for tenants to manage their own data. For MySQL, the tenant independent database is the database isolation method recommended by the eeplat PAAs platform.