US 12,314,256 B2
Management of object dependency records 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 Jan. 31, 2024, as Appl. No. 18/428,371.
Application 18/428,371 is a continuation of application No. 18/181,423, filed on Mar. 9, 2023, granted, now 11,928,108.
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 2024/0168946 A1, May 23, 2024
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)] 20 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 a first 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 first object dependency, generating a first dependency record including first dependency information describing the first object dependency between the referencing object and the referenced object;
detecting a change to the first object dependency;
based on the change to the first object dependency, generating a second dependency record including second dependency information describing a second object dependency associated with the referencing object or the referenced object; and
in response to determining that the change results in the first object being broken, invalidating the first dependency record, the invalidating of the first dependency record comprising updating a validity status in the first dependency record to indicate the first object dependency is broken.