Patent ID: 11928108
Assignee: SNOWFLAKE INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 8:
9. A method comprising:
detecting, within a database system, an object dependency created between a referencing object and a referenced object based on a data definition language (DDL) command received by the database system;
based on detecting the object dependency, generating, by one or more hardware processors, a dependency record including dependency information describing the object dependency between the referencing object and the referenced object;
storing, by the one or more hardware processors, 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.