US 11,940,963 B2
Mechanisms for handling schema changes
Michael Sgroi, San Francisco, CA (US); Helen Kwong, Palo Alto, CA (US); Benjamin Busjaeger, San Carlos, CA (US); and Igor Fedorenko, Toronto (CA)
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,244.
Prior Publication US 2023/0169049 A1, Jun. 1, 2023
Int. Cl. G06F 16/21 (2019.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/213 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2358 (2019.01); G06F 16/24552 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A method, comprising:
receiving, by a computer system, a metadata document describing an updated schema for a database that stores a plurality of records, wherein the updated schema describes a set of database entities and a corresponding set of statuses, and wherein a status of the set of statuses indicates whether a corresponding database entity can be used to process requests;
instantiating, by the computer system, a set of processes to perform an upgrade routine to upgrade the plurality of records to comply with the updated schema;
while the set of processes are upgrading the plurality of records, the computer system:
receiving, from a client, a request to perform an operation on one of the plurality of records;
detecting that the record corresponds to an earlier schema version than a version of the updated schema of the metadata document;
upgrading the record to comply with the updated schema; and
after upgrading the record, performing the requested operation on the record; and
in response to receiving a status request from the client for a status of a particular one of the set of database entities, the computer system returning a response indicating the status of the particular database entity that causes the client to determine that the particular database entity is usable to process requests from the client.