US 12,066,998 B2
Online updates to schema information in multi-tenant database system
Helen Kwong, Palo Alto, CA (US); and Benjamin Busjaeger, San Carlos, CA (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by salesforce.com, inc., San Francisco, CA (US)
Filed on Dec. 1, 2021, as Appl. No. 17/457,247.
Prior Publication US 2023/0169067 A1, Jun. 1, 2023
Int. Cl. G06F 16/21 (2019.01); G06F 16/23 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2379 (2019.01) [G06F 16/211 (2019.01); G06F 16/2358 (2019.01); G06F 16/256 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method, comprising:
storing, by a multi-tenant database system, a standard schema for a database object, wherein the standard schema is shared by multiple tenants;
storing, by the multi-tenant database system, a tenant-specific schema for the database object, wherein the tenant-specific schema includes one or more tenant-specific custom elements for the database object; and
checking, by the multi-tenant database system, tenant-specific custom elements for a predetermined pattern to enforce a naming scheme;
automatically adding, by the multi-tenant database system, the predetermined pattern in response to the check determining that a tenant-specific custom element does not include the predetermined pattern, wherein the predetermined pattern is not included in object elements of the standard schema;
detecting, by the multi-tenant database system, an update of the standard schema; and
in response to the detecting, the multi-tenant database system automatically propagating the update to the tenant-specific schema, while the database remains available to accept tenant queries of a tenant corresponding to the tenant-specific schema, without taking the database offline for the update.