Generating query cost data based on power and at least one query function of a query request

Abstract

A database system operates by: determining a query pricing scheme; receiving a query request from a requesting entity that indicates at least one query function for execution against a database system; determining a power consumption value based on the at least one query function; generating query cost data based on the at least one query function by utilizing the query pricing scheme based on the power consumption value; and transmitting the query cost data to the requesting entity.

What is claimed is: 
     
       1. A method for execution by query processing system, the method comprising:
 determining a query pricing scheme via at least one processor configured to perform executable instructions stored in at least one associated memory; 
 receiving at the at least one processor, a query request from a requesting entity that indicates at least one query function for execution against a database system configured to receive, in parallel, a plurality of time data streams of records and to write the records in a plurality of tables stored by a plurality of memory devices; 
 determining, via the at least one processor, a power consumption value based on the at least one query function that indicates a number of the records to be processed; 
 generating, via the at least one processor, query cost data based on the at least one query function by utilizing the query pricing scheme based on the power consumption value; and 
 transmitting, via a network interface, the query cost data to the requesting entity. 
 
     
     
       2. The method of  claim 1 , further comprising:
 determining a plurality of query pricing schemes, wherein each of the plurality of query pricing schemes corresponds to one of a plurality of data providers; and 
 determining the execution of the at least one query function involves access to data supplied by a first one of the plurality of data providers, wherein determining the query pricing scheme includes selecting the query pricing scheme based on determining the query pricing scheme corresponds to the first one of the plurality of data providers based on the at least one query function involving the access to the data supplied by the first one of the plurality of data providers. 
 
     
     
       3. The method of  claim 2 , wherein determining the plurality of query pricing schemes includes receiving the plurality of query pricing schemes from a plurality of provider devices corresponding to the plurality of data providers, wherein each of the plurality of query pricing schemes was generated based on user input in response to a prompt displayed by a corresponding one of the plurality of provider devices via a graphical user interface. 
     
     
       4. The method of  claim 1 , further comprising:
 determining an analytics intensity value for the query request based on the at least one query function, wherein the query cost data is generated by further utilizing the query pricing scheme based on the analytics intensity value. 
 
     
     
       5. The method of  claim 4 , wherein generating the query cost data includes calculating a query price value as an increasing function the analytics intensity value. 
     
     
       6. The method of  claim 5 , wherein generating the query cost data further includes selecting one of a plurality of quantized query price levels based on the query price value. 
     
     
       7. The method of  claim 1 , further comprising:
 determining a result set opacity value for the query request based on the at least one query function, wherein the query cost data is generated by further utilizing the query pricing scheme based on the result set opacity value. 
 
     
     
       8. The method of  claim 7 , further comprising:
 facilitating execution of the at least one query function to generate a result set, wherein the result set opacity value is determined as a decreasing function of a size of the result set. 
 
     
     
       9. The method of  claim 7 , wherein generating the query cost data includes calculating a query price value as an increasing function of the result set opacity value. 
     
     
       10. The method of  claim 1 , wherein generating the query cost data includes calculating a query price value as an increasing function of the power consumption value. 
     
     
       11. The method of  claim 1 , further comprising generating billing data for the requesting entity based on the query cost data. 
     
     
       12. The method of  claim 1 , further comprising facilitating a payment of a query price value of the query cost data by the requesting entity. 
     
     
       13. A query processing system comprises:
 at least one processor; and 
 a memory that stores operational instructions that, when executed by the at least one processor, cause the query processing system to:
 determine a query pricing scheme; 
 receive a query request from a requesting entity that indicates at least one query function for execution against a database system configured to receive, in parallel, a plurality of time data streams of records and to write the records in a plurality of tables stored by a plurality of memory devices; 
 determine an analytics intensity value for the query request based on the at least one query function that indicates a number of the records to be processed; 
 generate query cost data based on the at least one query function by utilizing the query pricing scheme based on the analytics intensity value and a power consumption; and 
 transmit, via a network interface, the query cost data to the requesting entity. 
 
 
     
     
       14. The query processing system of  claim 13 , wherein the operational instructions, when executed by the at least one processor, further cause the query processing system to:
 determine a plurality of query pricing schemes, wherein each of the plurality of query pricing schemes corresponds to one of a plurality of data providers; and 
 determine the execution of the at least one query function involves access to a first one of the plurality of data providers, wherein determining the query pricing scheme includes selecting the query pricing scheme based on determining the query pricing scheme corresponds to the first one of the plurality of data providers. 
 
     
     
       15. The query processing system of  claim 14 , wherein determining the plurality of query pricing schemes includes receiving the plurality of query pricing schemes from a plurality of provider devices corresponding to the plurality of data providers, wherein each of the plurality of query pricing schemes was generated based on user input in response to a prompt displayed by a corresponding one of the plurality of provider devices via a graphical user interface. 
     
     
       16. The query processing system of  claim 13 , wherein the operational instructions, when executed by the at least one processor, further cause the query processing system to:
 determine a result set opacity value for the query request based on the at least one query function, wherein the query cost data is generated by utilizing the query pricing scheme based on the result set opacity value. 
 
     
     
       17. The query processing system of  claim 13 , wherein the operational instructions, when executed by the at least one processor, further cause the query processing system to:
 determine a power consumption value based on the at least one query function, wherein the query cost data is generated by utilizing the query pricing scheme based on the power consumption value. 
 
     
     
       18. The query processing system of  claim 17 , wherein generating the query cost data includes calculating a query price value as an increasing function of the power consumption value. 
     
     
       19. A non-transitory computer readable storage medium comprises:
 at least one memory section that stores operational instructions that, when executed by a processing module that includes a processor and a memory, causes the processing module to:
 determine a query pricing scheme; 
 receive a query request from a requesting entity that indicates at least one query function for execution against a database system configured to receive, in parallel, a plurality of time data streams of records and to write the records in a plurality of tables stored by a plurality of memory devices; 
 determine an analytics intensity value for the query request based on the at least one query function that indicates a number of the records to be processed; 
 generate query cost data based on the at least one query function by utilizing the query pricing scheme based on the analytics intensity value and a power consumption; and 
 transmit, via a network interface, the query cost data to the requesting entity. 
 
 
     
     
       20. The non-transitory computer readable storage medium of  claim 19 , wherein generating the query cost data includes calculating a query price value as an increasing function of the power consumption value.