US 12,405,927 B2
Database object lifecycle states
David Gershuni, Carmel, IN (US); Punit B. Shah, Castro Valley, CA (US); Mikhail Lychagin, San Francisco, CA (US); Rama K. Korlapati, El Segundo, CA (US); and Rui Zhang, Fremont, CA (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by Salesforce, Inc., San Francisco, CA (US)
Filed on Jan. 12, 2024, as Appl. No. 18/411,638.
Prior Publication US 2025/0231921 A1, Jul. 17, 2025
Int. Cl. G06F 16/21 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/213 (2019.01) [G06F 16/219 (2019.01); G06F 16/24552 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method, comprising:
storing, by a computer system, a plurality of database schema versions associated with a database schema, wherein a given database schema version has one of a plurality of states and defines a plurality of database objects, wherein a first one of the plurality of database schema versions is in an active state in which the first database schema version is used to process database traffic and remaining ones of the plurality of database schema versions are in one of at least two other states in which the remaining database schema versions are not used to process the database traffic, wherein the other states include:
a dormant state that does not permit structural or content updates to a database schema version; and
a load state that permits structural and content updates to a database schema version in preparation to transition to the active state, wherein the active state, the dormant state, and the load state form a cycle;
receiving, by the computer system, one or more updates to apply to the database schema;
transitioning, by the computer system, a second one of the plurality of database schema versions from the dormant state to the load state;
applying, by the computer system, the one or more updates to the second database schema version; and
transitioning, by the computer system, the second database schema version into the active state and the first database schema version into the dormant state.