MASTER SCHEMA SHARED ACROSS MULTIPLE TENANTS WITH DYNAMIC UPDATE

摘要

An enterprise resource planning (ERP) system provides efficient maintenance and upgrade of tenant databases utilizing shared schema. A schema change is propagated from a master to tenants. Support is provided for tenants to be offline. The schema changes are applied at a mount time. Server load associated with the ERP database is distributed when tenant databases are updated with new schema changes. Changes to the application metadata (table schemas) is detected and applied to multiple tenants at a runtime.