Limiting execution of database operations based on power usage policy data

A parallelized database system comprises:

• a data input sub-system including a first plurality of computing device clusters, wherein the first plurality of computing device clusters includes first pluralities of computing devices, wherein the first pluralities of computing devices includes pluralities of loader computing nodes, wherein a first computing device of the first pluralities of computing devices incudes a first plurality of loader computing nodes of the pluralities of loader computing nodes;
• a query and response sub-system including a second plurality of computing device clusters, wherein the second plurality of computing device clusters includes second pluralities of computing devices, wherein the second pluralities of computing devices includes pluralities of query and response computing nodes, wherein a first computing device of the second pluralities of computing devices incudes a first plurality of query and response computing nodes of the pluralities of query and response computing nodes;
• a store and compute sub-system including a third plurality of computing device clusters, wherein the third plurality of computing device clusters includes third pluralities of computing devices, wherein the third pluralities of computing devices includes pluralities of store and compute computing nodes, wherein a first computing device of the third pluralities of computing devices includes a first plurality of store and compute computing nodes of the pluralities of store and compute computing nodes;
• and
• an energy utilization processing sub-system operable to:
• monitor the data input sub-system for data input operations;
• monitor the query and response sub-system for incoming queries;
• monitor the store and compute sub-system for store and compute operations;
• and
• based on the monitoring:
• determine a database operation for execution;
• determine power usage policy data for the database system regarding the database operation;
• generate operation requirement data based on the power usage policy data;
• perform an energy utilization-based operation limitation enforcement function upon energy utilization-based operation restriction enforcement input data to generate energy utilization-based operation restriction enforcement data for the database operation based on applying the operation requirement data;
• execute the database operation when the energy utilization-based operation restriction enforcement data indicates execution of the operation is allowed based on execution of the database operation adhering to the operation requirement data;
• and
• forego execution of the database operation when the energy utilization-based operation restriction enforcement data indicates execution of the operation is disallowed based on execution of the database operation not adhering to the operation requirement data.

A non-transitory computer readable storage medium comprises:

• a first memory section that stores operational instructions that, when executed by an energy utilization processing sub-system of a parallelized database system, cause the energy utilization processing sub-system to:
• monitor a first plurality of computing device clusters of a data input sub-system of the parallelized database system for data input operations, wherein the first plurality of computing device clusters includes first pluralities of computing devices, wherein the first pluralities of computing devices includes pluralities of loader computing nodes, wherein a first computing device of the first pluralities of computing devices incudes a first plurality of loader computing nodes of the pluralities of loader computing nodes;
• monitor a second plurality of computing device clusters of a query and response sub-system of the parallelized database system for incoming queries, wherein the second plurality of computing device clusters includes second pluralities of computing devices, wherein the second pluralities of computing devices includes pluralities of query and response computing nodes, wherein a first computing device of the second pluralities of computing devices incudes a first plurality of query and response computing nodes of the pluralities of query and response computing nodes;
• monitor a third plurality of computing device clusters of a store and compute sub-system of the parallelized database system for store and compute operations, wherein the third pluralities of computing devices includes pluralities of store and compute computing nodes, wherein a first computing device of the third pluralities of computing devices incudes a first plurality of store and compute computing nodes of the pluralities of store and compute computing nodes;
• and
• based on the monitoring:
• determine a database operation for execution;
• determine power usage policy data for the database system regarding the database operation;
• generate operation requirement data based on the power usage policy data;
• perform an energy utilization-based operation limitation enforcement function upon energy utilization-based operation restriction enforcement input data to generate energy utilization-based operation restriction enforcement data for the database operation based on applying the operation requirement data;
• execute the database operation when the energy utilization-based operation restriction enforcement data indicates execution of the operation is allowed based on execution of the database operation adhering to the operation requirement data;
• and
• forego execution of the database operation when the energy utilization-based operation restriction enforcement data indicates execution of the operation is disallowed based on execution of the database operation not adhering to the operation requirement data.