Querying a database

A non-transitory, computer-readable medium storing one or more instructions executable by a computer system to perform operations comprising:

• receiving, as a received query, a query from a user;
• determining a query event type and a query time range associated with the query;
• determining an estimated amount of data to be queried associated with the query time range based on at least a historical number of the query event type of the user, wherein the historical number comprises a quantity of events of the query event type that occurred in a past time period, and wherein determining the estimated amount of data to be queried comprises:
• dividing the historical number by the past time period to determine an average number of the query event type of the user;
• and
• multiplying the average number of the query event type of the user and the query time range to determine the estimated amount of data to be queried;
• determining an allowable amount of data to be queried supported by a database for a single query;
• determining, based on the estimated amount of data to be queried and the allowable amount of data to be queried, a quantity N of one or more sub-queries to be generated;
• dividing the query time range into N time periods, wherein N−1 time periods of the N time periods have equal lengths of time;
• generating, as generated one or more sub-queries, the quantity N of one or more sub-queries for the received query, wherein each sub-query is used to query data in a different time period of the N time periods, and wherein a corresponding amount of data to be queried associated with each time period is less than, or equal to, the allowable amount of data to be queried;
• and
• querying the database with the generated one or more sub-queries.

A computer-implemented system, comprising:

• one or more computers;
• and
• one or more computer memory devices interoperably coupled with the one or more computers and having tangible, non-transitory, machine-readable media storing one or more instructions that, when executed by the one or more computers, perform one or more operations comprising:
• receiving, as a received query, a query from a user;
• determining a query event type and a query time range associated with the query;
• determining an estimated amount of data to be queried associated with the query time range based on at least a historical number of the query event type of the user, wherein the historical number comprises a quantity of events of the query event type that occurred in a past time period, and wherein determining the estimated amount of data to be queried comprises:
• dividing the historical number by the past time period to determine an average number of the query event type of the user;
• and
• multiplying the average number of the query event type of the user and the query time range to determine the estimated amount of data to be queried;
• determining an allowable amount of data to be queried supported by a database for a single query;
• determining, based on the estimated amount of data to be queried and the allowable amount of data to be queried, a quantity N of one or more sub-queries to be generated;
• dividing the query time range into N time periods, wherein N−1 time periods of the N time periods have equal lengths of time;
• generating, as generated one or more sub-queries, the quantity N of one or more sub-queries for the received query, wherein each sub-query is used to query data in a different time period of the N time periods, and wherein a corresponding amount of data to be queried associated with each time period is less than, or equal to, the allowable amount of data to be queried;
• and
• querying the database with the generated one or more sub-queries.