Systems and methods for executing a database query to perform multi-level deployment

A system of generating an optimized deployment scheme, comprising:

• a memory device having instructions;
• and
• a processor executing the instructions to perform the steps of:
• generating a request identifying a type of resource requested by hierarchically arranged organizational entities including a first organizational entity located at a first level and a second organizational entity at a second level;
• executing a database query to retrieve business data corresponding to the first and second organizational entities;
• determining, based on the business data, a first quantity and a second quantity, the first quantity identifying a quantity of the resource available for deployment to the first organizational entity, and the second quantity identifying a quantity of the resource available for deployment to the second organizational entity;
• modifying the first quantity based on the second quantity;
• and
• generating, by using a processor of the computer system, an optimized deployment scheme based on the first quantity, the modified first quantity, and the second quantity.

A computer-readable storage medium including instructions which, when executed on a processor, cause the processor to perform a method of generating an optimized deployment scheme, the method comprising:

• generating a request identifying a type of resource requested by hierarchically arranged organizational entities including a first organizational entity located at a first level and a second organizational entity at a second level;
• executing a database query to retrieve business data corresponding to the first and second organizational entities;
• determining, based on the business data, a first quantity and a second quantity, the first quantity identifying a quantity of the resource available for deployment to the first organizational entity, and the second quantity identifying a quantity of the resource available for deployment to the second organizational entity;
• modifying the first quantity based on the second quantity;
• and
• generating, by using a processor of the computer system, an optimized deployment scheme based on the first quantity, the modified first quantity, and the second quantity.