Cloud distributed database capacity planning and adjustment using time-series data analysis

A computer-implemented method for adjusting distributed cloud database capacity, the method comprising:

• collecting throughput data associated with consumption of provisioned throughput resources of a distributed cloud database over one or more prior periods by an entity;
• preprocessing the collected throughput data to identify and filter out outlier data to generate preprocessed data;
• based on analysis of the preprocessed data, determining a first set of predicted throughput data for the entity over a future period;
• identifying periods of non-use of the distributed cloud database by the entity during at least one 24-hour duration;
• and
• dynamically adjusting provisioned capacity of the distributed cloud database that is assigned to the entity, by dynamically changing the provisioned throughput resources of the distributed cloud database for the entity over the future period, once per day during one of the identified periods of non-use the tributed cloud database based at least in part on the first set of predicted throughput data.

A computer-implemented method for adjusting distributed cloud database capacity, comprising:

• collecting, by a computing system, throughput data associated with consumption of provisioned throughput resources of a distributed cloud database over a prior period by an entity;
• identifying, by the computing system, patterns in the throughput data over the prior period;
• preprocessing, by the computing system, the collected throughput data to identify and filter out outlier data to generate preprocessed data;
• analyzing, by the computing system, the preprocessed data to generate predicted throughput data for the entity over a future period;
• identifying, for each of a plurality of sub-periods in the future period, a maximum throughput consumption in the predicted throughput data;
• identifying periods of non-use of the distributed cloud database by the entity during at least one 24-hour duration;
• and
• dynamically changing, during each of the sub-periods in the future period, provisioned capacity of the distributed cloud database that is assigned to the entity by adjusting the provisioned throughput resources of the distributed cloud database for the entity, during one of the identified periods of non-use of the distributed cloud data based on the identified maximum throughput consumption the particular sub-period for which the provisioned capacity is being changed.