Power based query processing system and methods for use therewith
A database system operates by: determining a query pricing scheme, wherein the query pricing scheme indicates a record valuation scheme; receiving a query request from a requesting entity that indicates access to a subset of a plurality of records in a database system; generating query cost data based on the subset of the plurality of records by utilizing the query pricing scheme and a power consumption, wherein generating the query cost data includes: calculating plurality of record valuations by calculating a record valuation for each of the plurality of records in the subset of the plurality of records, and aggregating over the plurality of record valuations to generate a query price total indicated in the query cost data; and transmitting the query cost data to the requesting entity.
1. A method for execution by a query processing system, the method 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;
receiving a query request from a requesting entity that indicates access to a subset of a plurality of records in a database system;
determining the subset of the plurality of records corresponds to a first one of the plurality of data providers,
determining a query pricing scheme of the plurality of query pricing schemes, wherein the query pricing scheme indicates a record valuation scheme and wherein determining the query pricing scheme includes selecting the query pricing scheme from the plurality of query pricing schemes based on determining the query pricing scheme corresponds to the first one of the plurality of data providers;
generating query cost data based on the subset of the plurality of records by utilizing the query pricing scheme and a power consumption, wherein generating the query cost data includes:
calculating plurality of record valuations by calculating a record valuation for each of the plurality of records in the subset of the plurality of records, and
aggregating over the plurality of record valuations to generate a query price total indicated in the query cost data; and
transmitting the query cost data to the requesting entity.
2. The method of claim 1 , 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.
3. The method of claim 1 , further comprising:
determining a field valuation for each one of a set of fields of the database system; and
determining at least one field included in the subset of the plurality of records;
wherein the query cost data is generated based on the field valuation of the at least one field.
4. The method of claim 1 , further comprising:
determining a field grouping valuation for each of a set of field groupings within a set of fields of the database system; and
determining a field grouping included in the subset of the plurality of records;
wherein the query cost data is generated based on the field grouping valuation of the field grouping.
5. The method of claim 1 , further comprising:
determining a temporal-based valuation of the subset of the plurality of records based on age timestamps of records included in the subset of the plurality of records;
wherein the query cost data is generated based on the temporal-based valuation of the subset of the plurality of records.
6. The method of claim 5 , wherein determining the temporal-based valuation includes calculating a temporal span across all of the plurality of records, wherein the temporal-based valuation is an increasing function of the temporal span.
7. The method of claim 5 , wherein the plurality of records were generated based on being collected by a data collection device.
8. The method of claim 7 , wherein determining the temporal-based valuation includes calculating a shortest temporal span between any pair of records in the plurality of records, and wherein the temporal-based valuation is a decreasing function of the shortest temporal span.
9. The method of claim 1 , wherein the record valuation is based on an age of the each of the plurality of records.
10. The method of claim 1 , wherein the record valuation is based on a level of data transformation utilized to generate the each of the plurality of records.
11. The method of claim 1 , wherein the query pricing scheme indicates a storage location-based valuation scheme, wherein determining the query cost data includes determining at least one location where the subset of the plurality of records is stored, and wherein the query cost data is generated based on the at least one location.
12. The method of claim 11 , wherein determining the query cost data included determining a number of geographic boundaries corresponding to the at least one location, where the query cost data is an increasing function of the number of geographic boundaries.
13. The method of claim 12 , wherein determining the query cost data further includes determining a location of the requesting entity, and where the query cost data is generated based on a difference between the location of the requesting entity and the at least one location.
14. The method of claim 1 , further comprising accessing usage data to determine at least one of: a first subset of records that have already been accessed, or a second subset of records that are new.
15. The method of claim 1 , further comprising generating billing data for the requesting entity based on the query cost data.
16. The method of claim 1 , further comprising facilitating a payment of a query price value of the query cost data by the requesting entity.
17. A query processing system of an analytics system includes:
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 perform operations that include:
receiving a query request from a requesting entity that indicates access to a subset of a plurality of records in a database system;
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;
determining the subset of the plurality of records corresponds to a first one of the plurality of data providers,
determining a query pricing scheme of the plurality of query pricing schemes, wherein the query pricing scheme indicates a record valuation scheme and wherein determining the query pricing scheme includes selecting the query pricing scheme from the plurality of query pricing schemes based on determining the query pricing scheme corresponds to the first one of the plurality of data providers;
determining a temporal-based valuation of the subset of the plurality of records based on age timestamps of records included in the subset of the plurality of records;
generating query cost data based on the subset of the plurality of records by utilizing the query pricing scheme and a power consumption, wherein the query cost data is generated based on the temporal-based valuation of the subset of the plurality of records; and
transmitting the query cost data to the requesting entity.
18. The query processing system of claim 17 , 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.