Getting dependency metadata using statement execution plans
AssigneeMicrosoft Corporation
InventorsKaarthik Sivashanmugam, David I. Noor
Life of this patent
Estimating the term…
Abstract
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.
Claims20
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;
- and
- including the metadata in a data structure.
A computer-implemented method 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;
- and
- 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, and the assembling of the metadata comprising including the metadata in a data structure.
One or more computer-readable storage media having computer-executable instructions embodied thereon that, when executed by 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;
- and
- 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, and the assembling of the metadata comprising including the metadata in a data structure.
Dependencies are inferred from the claim text.