Granted Patent B2

US 12,259,886 · App. 18/532,294 · Granted Mar 25, 2025

Inventors: S. Christopher Gladwin (Chicago, IL); Andrew D. Baptist (Mt. Pleasant, WI); George Kondiles (Chicago, IL); Jason Arnold (Chicago, IL)

Assignee: Ocient Holdings LLC

G06F16/24545

Abstract

Claims (83)

1. A method for execution by an analytics system, the method comprising:

receiving a query request from a user device;

determining query cost data based on the query request by utilizing a query pricing scheme, wherein the query cost data indicates a total query cost computed as a function of at least one of:

a plurality of provider costs for each of a plurality of data providers that supplied data accessed in the query request;

a plurality of query function costs for each of a plurality of query functions indicated in the query request;

a plurality of field costs for each of a plurality of fields accessed in the query request; or

a plurality of record type costs for each of a plurality of record types accessed in the query request:

transmitting the query cost data to the user device;

receiving query approval data from the user device, wherein the query approval data is generated by the user device based on user input to a graphical user interface;

when the query approval data indicates approval of query request:

transmitting a query response to the user device based on facilitation of execution of the query request against a database system; and

generating billing data for based on the query cost data; and

when the query approval data does not indicate approval to transmit the query request:

foregoing transmission of the query response to the user device; and

foregoing generation of the billing data.

2. The method of claim 1 , wherein determining the query cost data includes facilitating the execution of at least one query function of the query request against the database system, wherein the query cost data is based on a query result generated based on the execution of the at least one query function of the query request against the database system, and wherein the query response is based on the query result.

3. A method for execution by a user device, the method comprising:

determining a query request based on first user input to a graphical user interface displayed by the user device;

determining query cost data based on the query request, wherein determining the query cost data is based on:

transmitting the query request to an analytics system for execution against a database system; and

receiving query cost data from the analytics system, wherein a query result is generated by the analytics system based on facilitating execution of at least one query function against the database system, and wherein the query cost data is generated by the analytics system by utilizing a query pricing scheme based on the execution of the at least one query function;

displaying a prompt via the graphical user interface that indicates the query cost data;

determining query approval data based on second user input to the graphical user interface in response to the prompt;

when the query approval data indicates approval to receive the query results:

transmitting a request for the query results to the analytics system for execution against the database system; and

receiving the query results in a transmission from the analytics system; and

when the query approval data does not indicate approval to receive the query results:

foregoing transmission of the request for the query results to the analytics system.

4. The method of claim 3 , wherein the analytics system caches the query result in a query result cache in response to generating the query result further comprising:

when the query approval data does not indicate approval to transmit the query request:

transmitting a message to the analytics system indicating the query approval data does not indicate approval to transmit the query request;

wherein the analytics system removes the query result from the query result cache based on receiving the message.

5. The method of claim 3 , wherein a result set is generated based on the execution of the at least one query function against the database system, and wherein the query cost data is generated based on a size of the result set.

6. A method for execution by a user device, the method comprising:

determining a query request based on first user input to a graphical user interface displayed by the user device;

determining query cost data based on the query request, wherein the query cost data indicates estimated query cost data generated based on the query request;

displaying a prompt via the graphical user interface that indicates the query cost data;

determining query approval data based on second user input to the graphical user interface in response to the prompt;

when the query approval data indicates approval to transmit the query request for execution:

transmitting the query request to an analytics system for execution against a database system; and

when the query approval data does not indicate approval to transmit the query request for execution:

foregoing transmission of the query request to the analytics system.

7. The method of claim 6 , further comprising:

receiving user application data from the analytics system; and

executing the user application data, wherein displaying the graphical user interface, determining the query request, determining the query cost data is determined, and determining the query approval data is based on the execution of the user application data.

8. The method of claim 6 , further comprising:

when the query approval data does not indicate approval to transmit the query request for execution:

determining an amended query request based on third user input to the graphical user interface displayed by the user device in response to a prompt to amend the query request displayed by the graphical user interface;

determining second query cost data based on the amended query request;

displaying a second prompt via the graphical user interface that indicates the second query cost data;

determining second query approval data based on fourth user input to the graphical user interface in response to the second prompt;

when the second query approval data indicates approval to transmit the amended query request for execution:

transmitting the amended query request to the analytics system for execution against the database system; and

when the second query approval data does not indicate approval to transmit the amended query request for execution:

foregoing transmission of the amended query request to the analytics system.

9. The method of claim 6 , further comprising:

receiving query pricing scheme data from the analytics system;

wherein determining the query cost data includes calculating the query cost data by utilizing the query pricing scheme data.

10. The method of claim 6 , wherein determining the query cost data includes:

transmitting the query request to the analytics system, wherein the analytics system generates the query cost data based on the query request by utilizing a query pricing scheme, and wherein the analytics system transmits the query cost data to the user device; and

receiving the query cost data from the analytics system.

11. The method of claim 10 , wherein the analytics system generates the query cost data based on executing at least one query function of the query request.

12. The method of claim 6 , wherein the query cost data indicates a plurality of provider costs for each of a plurality of data providers that supplied data accessed in the query request, and wherein a total query cost indicated in the query cost data is computed as a function of the plurality of provider costs.

13. The method of claim 6 , wherein the query cost data indicates a plurality of query function costs for each of a plurality of query functions indicated in the query request, and wherein a total query cost indicated in the query cost data is computed as a function of the plurality of query function costs.

14. The method of claim 6 , wherein the query cost data indicates a plurality of field costs for each of a plurality of fields accessed in the query request, and wherein a total query cost indicated in the query cost data is computed as a function of the plurality of field costs.

15. The method of claim 6 , wherein the query cost data indicates a plurality of record type costs for each of a plurality of record types accessed in the query request, and wherein a total query cost indicated in the query cost data is computed as a function of the plurality of record type costs.

16. The method of claim 6 , wherein at least one of:

the query cost data indicates a plurality of provider cost ratios for each of a plurality of data providers that supplied data accessed in the query request;

the query cost data indicates a plurality of query function cost ratios for each of a plurality of query functions indicated in the query request;

the query cost data indicates a plurality of field cost ratios for each of a plurality of fields accessed in the query request; or

the query cost data indicates a plurality of record type cost ratios for each of a plurality of record types accessed in the query request.

17. The method of claim 6 , wherein the estimated query cost data is based on an estimated result set size generated based on at least one of:

a current size of a table indicated in the query request for access;

a recent size of the table indicated in the query request for access;

a current total number of records supplied by a provider supplying data indicated in the query request for access;

a recent total number of records supplied by the provider supplying data indicated in the query request for access;

result set size of a result set generated via execution of at least one previous query queries based on filtering via same filtering parameters indicated in the query request;

a known number of records meeting filtering parameters indicated in the query request; or

an estimate number of records meeting filtering parameters indicated in the query request.

18. The method of claim 6 , wherein the estimated query cost data indicates at least one of: an estimated minimum query cost, or an estimated maximum query cost.

19. The method of claim 6 , wherein the query approval data indicates approval to transmit the query request for execution, further comprising:

receiving a query response from the analytics system based on the execution of the query request against the database system; and

displaying the query response via the graphical user interface.

Assignments (1)

Continuity (4)

References Cited (61)