US 11,928,108 B2
Object dependency status tracking in a cloud system
Raja Suresh Krishna Balakrishnan, Fremont, CA (US); Khalid Zaman Bijon, Santa Cruz, CA (US); Subramanian Muralidhar, Mercer Island, WA (US); David Schultz, Piedmont, CA (US); and Jian Xu, San Jose, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Mar. 9, 2023, as Appl. No. 18/181,423.
Application 18/181,423 is a continuation of application No. 17/659,797, filed on Apr. 19, 2022, granted, now 11,645,275.
Application 17/659,797 is a continuation of application No. 17/387,632, filed on Jul. 28, 2021, granted, now 11,347,730.
Prior Publication US 2023/0214383 A1, Jul. 6, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/242 (2019.01); G06F 16/21 (2019.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/2445 (2019.01) [G06F 16/211 (2019.01); G06F 16/2291 (2019.01); G06F 16/2358 (2019.01); G06F 16/2365 (2019.01); G06F 16/2453 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A database system comprising:
at least one hardware processor; and at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
detecting an object dependency created between a referencing object and a referenced object within a database system based on a data definition language (DDL) command received by the database system;
based on detecting the object dependency, generating a dependency record including dependency information describing the object dependency between the referencing object and the referenced object;
storing the dependency record in a database of dependency records;
invalidating the dependency record in response to determining the object dependency is broken, the invalidating of the dependency record comprising updating a validity status in the dependency record to indicate the object dependency is broken, the determining that the object dependency is broken comprising detecting a command that changes the referencing object or the referenced object;
detecting a change to the object dependency that causes the object dependency to become valid; and
revalidating the dependency record based on detecting the change to the object dependency, the revalidating of the dependency record comprising updating the validity status in the dependency record to indicate the object dependency is valid.