US 11,599,542 B2 · End user configuration of cost thresholds in a database system and methods for use therewith

Abstract

A method for execution by a query processing system includes receiving a query request from a requesting entity. Query cost data is generated based on the query request by utilizing a query pricing scheme. Minimum query cost compliance data is generated for the query request based on determining whether the minimum query cost data complies with a minimum query cost rule. When the minimum query cost compliance data indicates the minimum query cost data complies with the minimum query cost rule a query result is generated based on facilitating execution of the query by executing at least one query function of the query against a database system, and the query result is transmitted to the requesting entity. When the minimum query cost compliance data indicates the query cost data does not comply with the minimum query cost rule, the query result is not transmitted to the requesting entity.

Drawings

Drawings are temporarily unavailable. Open the PDF at USPTO

Drawings

Claims18

Dependent claims

A method for execution by a query processing system, the method comprising:

determining a query pricing scheme;
determining a plurality of maximum query cost rulesets for a corresponding plurality of end users;
receiving a query request from a requesting entity;
determining the maximum query cost ruleset for the requesting entity by identifying one of the plurality of maximum query cost rulesets that corresponds to one of the corresponding plurality of end users associated with the requesting entity, wherein the maximum query cost ruleset for the requesting entity indicates a set of query function-based query cost rules corresponding to each of a set of query function types;
generating query cost data by utilizing the query pricing scheme based on the query request;
generating maximum query cost compliance data based on determining whether the query cost data complies with the maximum query cost ruleset, wherein generating the maximum query cost compliance data includes:
identifying at least one of the set of query function types corresponding to at least one query function of the query request;
identifying at least one of the set of query function-based query cost rules corresponding to the at least one of the set of query function types;
and
determining whether the query cost data complies with the at least one of the set of query function-based query cost rules;
when the maximum query cost compliance data indicates the query cost data complies with the maximum query cost ruleset:
generating a query result based on facilitating execution of the query request by executing at least one query function of the query request against a database system;
and
transmitting the query result to the requesting entity;
when the maximum query cost compliance data indicates the query cost data does not comply with the maximum query cost ruleset:
foregoing transmission of the query result to the requesting entity.

13 more elements

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;
determine a plurality of maximum query cost rulesets for a corresponding plurality of end users;
receive a query request from a requesting entity;
determine the maximum query cost ruleset for the requesting entity by identifying one of the plurality of maximum query cost rulesets that corresponds to one of the corresponding plurality of end users associated with the requesting entity, wherein the maximum query cost ruleset indicates a temporal-based maximum cost and a corresponding time window;
generate query cost data by utilizing the query pricing scheme based on the query request;
generate maximum query cost compliance data based on determining whether the query cost data complies with the maximum query cost ruleset, wherein generating the maximum query cost compliance data includes:
determining running query cost data for at least one previous query request received from the requesting entity within the corresponding time window;
and
calculating potential query cost data based on a summation of the running query cost data and the query cost data generated for the query request, wherein the generating the maximum cost compliance data is based on determining whether a potential price total indicated by the potential query cost data exceeds the temporal-based maximum cost;
when the maximum query cost compliance data indicates the query cost data complies with the maximum query cost ruleset:
generate a query result based on facilitating execution of the query request by executing at least one query function of the query request against a database system;
and
transmit the query result to the requesting entity;
when the maximum query cost compliance data indicates the query cost data does not comply with the maximum query cost ruleset:
forego transmission of the query result to the requesting entity.

15 more elements

A 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, cause the processing module to:
determine a query pricing scheme;
determine a plurality of maximum query cost rulesets for a corresponding plurality of end users;
receive a query request from a requesting entity;
determine the maximum query cost ruleset for the requesting entity by identifying one of the plurality of maximum query cost rulesets that corresponds to one of the corresponding plurality of end users associated with the requesting entity, wherein the maximum query cost ruleset for the requesting entity indicates a set of query function-based query cost rules corresponding to each of a set of query function types;
generate query cost data by utilizing the query pricing scheme based on the query request;
generate maximum query cost compliance data based on determining whether the query cost data complies with the maximum query cost ruleset, wherein generating the maximum query cost compliance data includes:
identifying at least one of the set of query function types corresponding to at least one query function of the query request;
identifying at least one of the set of query function-based query cost rules corresponding to the at least one of the set of query function types;
and
determining whether the query cost data complies with the at least one of the set of query function-based query cost rules;
when the maximum query cost compliance data indicates the query cost data complies with the maximum query cost ruleset:
generate a query result based on facilitating execution of the query request by executing at least one query function of the query request against a database system;
and
transmit the query result to the requesting entity;
when the maximum query cost compliance data indicates the query cost data does not comply with the maximum query cost ruleset:
forego transmission of the query result to the requesting entity.

14 more elements

Dependencies are inferred from the claim text.

Description80,499 words

Summary17 words

#Not applicable.

#This invention relates generally to computer networks and more particularly to database systems.

Brief description of the drawings68 figures

#FIG. 1 is a schematic block diagram of an embodiment of an analytics system in accordance with various embodiments of the present invention;

#FIG. 2A is a schematic block diagram of an embodiment of a data provider in accordance with various embodiments of the present invention;

#FIG. 2B is a schematic block diagram of an embodiment of a provider device in accordance with various embodiments of the present invention;

Detailed description78,752 words

#FIG. 1 illustrates an embodiment of an analytics system 110. The analytics system 110 can be operable to store data received from multiple data providers 130 in at least one database system 112. The data can be received as data streams from each data provider, and can correspond to raw or processed data collected by the data provider, such as a stream of time-series data. One or more communication interfaces 122 of the analytics system 110 can be operable to receive the data streams via a network 150. The received data streams 1-N can be optionally cleaned and/or standardized by the analytics system 110 to generate multiple entries that populate the database system 112.

#This data can be utilized by one or more end users via one or more user devices 140 corresponding to various end users of the analytics system 110. Each user device can transmit query requests to the analytics system 110 via the same or different network 150. The same or different communication interface 122 can receive these query requests, and the analytics system 110 can utilize a query processing module to execute queries of the query requests against the database system 112. The result sets generated in executing these queries can be utilized to generate a query response for transmission back to the corresponding user device 140. This enables end users to perform various analytics on data collected from multiple data providers via queries to the database system.

#FIG. 2A illustrates an embodiment of a data provider 130. Data provider 130 can be implemented utilizing at least one processing module 210 at least one memory module 220, at least one communication interface 215, and/or at least one collection interface 217, all connected via bus 290. The bus 290 can be implemented via a wired and/or wireless connection, where the processing module 210, at least one memory module 220, and/or at least one communication interface 215 are coupled to a single device via short range connections and/or are dispersed across multiple devices within a same system via a wired and/or wireless network. The memory module 220 can store operational instructions that, when executed by the processing module 210, cause the processing module 210 to execute the functionality of a data provider 130 as discussed herein.

Facts

Application

17/150,415Filed 15 Jan 2021 · continuation

Priority

28 Oct 2019

Published

US 2021/0124744 A113 May 2021

Granted

7 Mar 2023

Term ends

10 Nov 2039

Estimated · how

20 years from earliest known nonprovisional domestic filing plus recorded patent term adjustment, including 13 days of adjustment. Maintenance-fee lapses, terminal disclaimers and statutory extensions have not been checked. The continuity chain may be incomplete; this is not an enforceability determination.

Classification3 codes

G06F 16/24545
Plan optimisation: selectivity estimation or determination
G06F 16/24552
Query execution: database cache management
G06F
Computing and data processing

Family

Application16/665,571Parent of this continuation · filed 28 Oct 2019

US 2021/0141795 A1Pre-grant publication · published 13 May 2021

US 11,093,500 B2Parent of this continuation

US 2021/0124744 A1Published application

US 11,599,542 B2This patent

From the US filing history. Foreign family members aren’t listed.

Timeline

28 Oct 2019Priority claimedParent application 16/665,571
15 Jan 2021Application filedUS 17/150,415
19 Jan 2021Assigned to Ocient Holdings LLCassignment of assignor's interest
13 May 2021PublishedUS 2021/0124744 A1
7 Mar 2023GrantedUS 11,599,542 B2
12 Oct 2026TodayWithin its term
10 Nov 2039Term endsEstimated, includes 13 days of adjustment

End user configuration of cost thresholds in a database system and methods for use therewith

Life of this patent

End user configuration of cost thresholds in a database system and methods for use therewith

Life of this patent

Life of this patent

Abstract

Drawings

Drawings

Claims18

Description80,499 words

Drawings

Classification3 codes

Life of this patent

Description80,499 words