GETTING DEPENDENCY METADATA USING STATEMENT EXECUTION PLANS

摘要

A database statement can be identified in a software artifact that is configured to issue the database statement. At least one execution plan for the database statement can be retrieved, and reference(s) to database object(s) can be identified in the execution plan(s). Metadata from the reference(s) can be assembled, where the metadata can reflect one or more dependencies of the software artifact on the object(s). The metadata can be included in a data structure.

主权项

1. A computer system comprising:
at least one processor; and a memory comprising instructions stored thereon that when executed by the at least one processor cause the at least one processor to perform acts comprising:
identifying a database statement in a software artifact that is configured to issue the database statement, the database statement being a request to perform an operation on a database or a reference to the request;retrieving at least one execution plan for the database statement, the at least one execution plan identifying sub-operations to be performed in accomplishing an overall operation according to the database statement;identifying in the at least one execution plan one or more references to one or more database objects;assembling metadata from the one or more references, the metadata reflecting one or more dependencies of the software artifact on the one or more database objects; andincluding the metadata in a data structure.