# US 2023/0273907 A1 · Managing time series databases using workload models

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2023/0273907 A1
- Document ID: US20230273907A1
- Status: Published application
- Kind: A1
- Application number: 17/586,897
- Filed: 2022-01-28
- Published: 2023-08-31
- Earliest claimed: 2022-01-28
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Peng Hui Jiang; Sheng Yan Sun; Meng Wan; Hong Mei Zhang
- Web page: https://patentgrep.com/patent/US20230273907A1

## CPC

- G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)}
- G06F 16/285: {Clustering or classification}
- G06F 9/4881: {Scheduling strategies for dispatcher, e.g. round robin, multi-level priority queues}
- G06F 9/5027: {the resource being a machine, e.g. CPUs, Servers, Terminals}
- G06F 2209/501: Performance criteria
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method of managing time series data workload requests includes receiving a workload job request from a user in a multi-tenant network, the request specifying a plurality of workloads, each workload including time series data configured to be stored in a time series database (TSDB), inputting workload information to a workload model that is specific to the user, and classifying each workload according to the workload model, the workload model configured to classify each workload based on a plurality of parameters, the plurality of parameters including at least a workload type and an amount of storage associated with each workload. The method also includes assigning each workload of the plurality of workloads into one or more workload groups based on the classifying, and executing each workload according to the workload type and the storage size.

## Claims

### Claim 1

A method of managing time series data workload requests, the method comprising:
receiving a workload job request from a user in a multi-tenant network, the request specifying a plurality of workloads, each workload including time series data configured to be stored in a time series database (TSDB);
inputting workload information to a workload model that is specific to the user, and classifying each workload according to the workload model, the workload model configured to classify each workload based on a plurality of parameters, the plurality of parameters including at least a workload type and an amount of storage associated with each workload;
assigning each workload of the plurality of workloads into one or more workload groups based on the classifying; and
executing each workload according to the workload type and the storage size.

### Claim 2 (depends on 1)

The method of claim 1, wherein the workload model is further configured to classify each workload based on a charge amount associated with each workload.

### Claim 3 (depends on 1)

The method of claim 1, wherein the workload model is further configured to classify each workload by defining a vector space, constructing a workload type vector and a storage size vector, and calculating a vector angle.

### Claim 4 (depends on 1)

The method of claim 1, further comprising monitoring stored time series data during execution of each workload, calculating a delta value based on changes in the stored time series data, and predicting time series data values for a future time window.

### Claim 5 (depends on 4)

The method of claim 4, further comprising automatically adjusting the future time window based on the predicting.

### Claim 6 (depends on 5)

The method of claim 5, further comprising inputting the predicted data values to a revision model, the revision model configured to calculate a variance between one or more parameters of the stored time series data and one or more parameters of the predicted data values.

### Claim 7 (depends on 6)

The method of claim 6, further comprising adjusting the workload model based on the variance.

### Claim 8 (depends on 1)

The method of claim 1, further comprising incorporating the workload groups into a federated model associated with a plurality of tenants in the multi-tenant network.

### Claim 9

An apparatus for managing time series data workload requests, comprising one or more computer processors that comprise:
a processing unit including a processor configured to receive a workload job request from a user in a multi-tenant network, the request specifying a plurality of workloads, each workload including time series data configured to be stored in a time series database (TSDB),
a workload model that is specific to the user and is configured to receive workload information, classify each workload based on a plurality of parameters, the plurality of parameters including at least a workload type and an amount of storage associated with each workload, and assign each workload of the plurality of workloads into one or more workload groups based on the classifying, wherein the processor is configured to execute each workload according to the workload type and the storage size.

### Claim 10 (depends on 9)

The apparatus of claim 9, wherein the workload model is configured to classify each workload based on a charge amount associated with each workload.

### Claim 11 (depends on 9)

The apparatus of claim 9, wherein the workload model is configured to classify each workload by defining a vector space, constructing a workload type vector and a storage size vector, and calculating a vector angle.

### Claim 12 (depends on 9)

The apparatus of claim 9, wherein the processor is configured to monitor stored time series data during execution of each workload, calculate a delta value based on changes in the stored time series data, and predict time series data values for a future time window.

### Claim 13 (depends on 12)

The apparatus of claim 12, wherein the processor is configured automatically adjust the time window based on the predicting.

### Claim 14 (depends on 13)

The apparatus of claim 13, wherein the processor is configured to input the predicted data values to a revision model, the revision model configured to calculate a variance between one or more parameters of the stored time series data and one or more parameters of the predicted data values.

### Claim 15 (depends on 14)

The apparatus of claim 14, wherein the processor is configured to adjust the workload model based on the variance.

### Claim 16 (depends on 9)

The apparatus of claim 9, wherein the processor is configured to incorporate the workload groups into a federated model associated with a plurality of tenants in the multi-tenant network.

### Claim 17

A computer program product comprising a storage medium readable by one or more processing circuits, the storage medium storing instructions executable by the one or more processing circuits to perform a method comprising:
receiving a workload job request from a user in a multi-tenant network, the request specifying a plurality of workloads, each workload including time series data configured to be stored in a time series database (TSDB);
inputting workload information to a workload model that is specific to the user, and classifying each workload according to the workload model, the workload model configured to classify each workload based on a plurality of parameters, the plurality of parameters including at least a workload type and an amount of storage associated with each workload;
assigning each workload of the plurality of workloads into one or more workload groups based on the classifying; and
executing each workload according to the workload type and the storage size.

### Claim 18 (depends on 17)

The computer program product of claim 17, wherein the workload model is configured to classify each workload based on a charge amount associated with each workload.

### Claim 19 (depends on 17)

The computer program product of claim 17, wherein the workload model is configured to classify each workload by defining a vector space, constructing a workload type vector and a storage size vector, and calculating a vector angle.

### Claim 20 (depends on 17)

The computer program product of claim 17, wherein the method further comprises monitoring stored time series data during execution of each workload, calculating a delta value based on changes in the stored time series data, predicting time series data values for a future time window, and automatically adjusting the time window based on the predicting.
