# US 2025/0086012 A1 · Resource allocation using proactive pause

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

- Number: US 2025/0086012 A1
- Document ID: US20250086012A1
- Status: Published application
- Kind: A1
- Application number: 18/484,861
- Filed: 2023-10-11
- Published: 2025-03-13
- Earliest claimed: 2023-09-08
- Assignees: Microsoft Technology Licensing, LLC
- Applicants: Microsoft Technology Licensing, LLC
- Inventors: Olga POPPE; Qun GUO; Willis LANG; Pankaj ARORA; Ajay KALHAN
- Web page: https://patentgrep.com/patent/US20250086012A1

## CPC

- G06F 11/3423: {where the assessed time is active or idle time}
- G06F 11/3438: {monitoring of user actions (tracking the activity of the user H04L67/535)}
- G06F 9/5005: {to service a request}
- G06F 9/5022: {Mechanisms to release resources}
- G06F 9/5072: {Grid computing}
- G06F 9/5077: {Logical partitioning of resources; Management or configuration of virtualized resources (specific details on emulation or internal functioning of virtual machines G06F9/455)}
- G06F 11/3442: {for planning or managing the needed capacity}
- G06N 7/01: Probabilistic graphical models, e.g. probabilistic networks
- G06N 20/00: Machine learning
- G06F 2201/80: Database-specific techniques
- G06F 2209/5011: Pool
- G06F 2209/5019: Workload prediction
- G06F 2209/508: Monitor
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS

## Abstract

A proactive resource allocator in a database management system is configured to make database resource allocation decisions for users accessing a database, including proactively pausing resources allocated to a user for accessing a database. To determine whether to proactively pause resources that are allocated to a user who has logged out, the proactive resource allocator accesses historical data to predict a next time the user with log back in. If the predicted next time of user login is relatively soon, the proactive resource allocator maintains the allocation of the resources to the user. If the predicted next time of user login is relatively far away, the proactive resource allocator pauses the resources. The proactive resource allocator may logically pause the resources or may physically pause the resources.

## Claims

### Claim 1

A system, comprising:
a processor; and
a memory device that stores program code structured to cause the processor to:
allocate resources to a user in response to the user logging into a database;
determine the user logged out of the database subsequent to the user logging in;
determine a plurality of login patterns for the user from historical data of user interactions with the database, each login pattern of the login patterns corresponding to a respective time window of a plurality of time windows having a same start of predicted activity;
calculate a plurality of probabilities corresponding to the determined login patterns for the time windows, each calculated probability indicative of a likelihood that the user will log into the database during the corresponding time window of the time windows;
in response to a set of the calculated probabilities being determined to have a predetermined relationship with a confidence threshold:
select from the set the probability having a greatest likelihood; and
determine whether a time of predicted activity in the time window associated with the selected probability is within an upcoming predetermined length of time; and
in response to the time of predicted activity being determined to be within the upcoming predetermined length of time, maintain the allocation of the resources to the user.

### Claim 2 (depends on 1)

The system of claim 1, wherein to calculate the plurality of probabilities, the program code is further structured to cause the processor to:
calculate the probability for a login pattern corresponding to a time window as a ratio of:
a number of days the user was logged into the database during the time window over a historical time period in the historical data; to
a number of days of the historical time period.

### Claim 3 (depends on 1)

The system of claim 1, wherein to maintain the allocation of the resources to the user, the program code is further structured to cause the processor to:
predict a time period of user activity based on an earliest time and a latest time of log in by the user to the database indicated in the historical data for the time window associated with the selected probability; and
maintain the allocation of the resources to the user during the predicted time period.

### Claim 4 (depends on 1)

The system of claim 1, wherein the program code is further structured to cause the processor to:
in response to the time of predicted activity being determined to not be within the upcoming predetermined length of time, reclaim the resources.

### Claim 5 (depends on 1)

The system of claim 1, wherein to determine the plurality of login patterns, the program code is further structured to cause the processor to:
in response to no calculated probabilities being determined to have the predetermined relationship with the confidence threshold, sliding through the historical data by a predetermined time increment according to a sliding window algorithm to determine a next time window.

### Claim 6 (depends on 5)

The system of claim 5, wherein the program code is further structured to cause the processor to:
in response to no calculated probabilities being determined to have the predetermined relationship with the confidence threshold for all time windows determined from the historical data:
determine whether the historical data covers a predetermined historical time period;
in response to the historical data being determined to cover the predetermined historical time period, reclaim the resources, the database being considered idle; and
in response to the historical data being determined to not cover the predetermined historical time period, logically pause the resources.

### Claim 7

A method, comprising:
allocating resources to a user in response to the user logging into a database;
determining the user logged out of the database subsequent to the user logging in;
determining a plurality of login patterns for the user from historical data of user interactions with the database, each login pattern of the login patterns corresponding to a respective time window of a plurality of time windows having a same start of predicted activity;
calculating a plurality of probabilities corresponding to the determined login patterns for the time windows, each calculated probability indicative of a likelihood that the user will log into the database during the corresponding time window of the time windows;
in response to a set of the calculated probabilities being determined to have a predetermined relationship with a confidence threshold:
selecting from the set the probability having a greatest likelihood; and
determining whether a time of predicted activity in the time window associated with the selected probability is within an upcoming predetermined length of time; and
in response to determining the time of predicted activity to be within the upcoming predetermined length of time, maintaining the allocation of the resources to the user.

### Claim 8 (depends on 7)

The method of claim 7, wherein said calculating comprises:
calculating the probability for a login pattern corresponding to a time window as a ratio of:
a number of days the user was logged into the database during the time window over a historical time period in the historical data; to
a number of days of the historical time period.

### Claim 9 (depends on 7)

The method of claim 7, wherein said maintaining the allocation of the resources to the user comprises:
predicting a time period of user activity based on an earliest time and a latest time of log in by the user to the database indicated in the historical data for the time window associated with the selected probability; and
maintaining the allocation of the resources to the user during the predicted time period.

### Claim 10 (depends on 7)

The method of claim 7, further comprising:
in response to determining the time of predicted activity to not be within the upcoming predetermined length of time, reclaiming the resources.

### Claim 11 (depends on 7)

The method of claim 7, wherein said determining a plurality of login patterns comprises:
in response to no calculated probabilities being determined to have the predetermined relationship with the confidence threshold, sliding through the historical data by a predetermined time increment according to a sliding window algorithm to determine a next time window.

### Claim 12 (depends on 11)

The method of claim 11, further comprising:
in response to no calculated probabilities being determined to have the predetermined relationship with the confidence threshold for all time windows determined from the historical data:
determining whether the historical data covers a predetermined historical time period; and
in response to the historical data being determined to cover the predetermined historical time period, reclaiming the resources, the database being considered idle.

### Claim 13 (depends on 12)

The method of claim 12, further comprising:
in response to the historical data being determined to not cover the predetermined historical time period, logically pausing the resources.

### Claim 14

A computer-readable storage device encoded with program instructions that, when executed by a processor circuit, perform a method comprising:
allocating resources to a user in response to the user logging into a database;
determining the user logged out of the database subsequent to the user logging in;
determining a plurality of login patterns for the user from historical data of user interactions with the database, each login pattern of the login patterns corresponding to a respective time window of a plurality of time windows having a same start of predicted activity;
calculating a plurality of probabilities corresponding to the determined login patterns for the time windows, each calculated probability indicative of a likelihood that the user will log into the database during the corresponding time window of the time windows;
in response to a set of the calculated probabilities being determined to have a predetermined relationship with a confidence threshold:
selecting from the set the probability having a greatest likelihood; and
determining whether a time of predicted activity in the time window associated with the selected probability is within an upcoming predetermined length of time; and
in response to determining the time of predicted activity to be within the upcoming predetermined length of time, maintaining the allocation of the resources to the user.

### Claim 15 (depends on 14)

The computer-readable storage device of claim 14, wherein said calculating comprises:
calculating the probability for a login pattern corresponding to a time window as a ratio of:
a number of days the user was logged into the database during the time window over a historical time period in the historical data; to
a number of days of the historical time period.

### Claim 16 (depends on 14)

The computer-readable storage device of claim 14, wherein said maintaining the allocation of the resources to the user comprises:
predicting a time period of user activity based on an earliest time and a latest time of log in by the user to the database indicated in the historical data for the time window associated with the selected probability; and
maintaining the allocation of the resources to the user during the predicted time period.

### Claim 17 (depends on 14)

The computer-readable storage device of claim 14, wherein the method further comprises:
in response to determining the time of predicted activity to not be within the upcoming predetermined length of time, reclaiming the resources.

### Claim 18 (depends on 14)

The computer-readable storage device of claim 14, wherein said determining a plurality of login patterns comprises:
in response to no calculated probabilities being determined to have the predetermined relationship with the confidence threshold, sliding through the historical data by a predetermined time increment according to a sliding window algorithm to determine a next time window.

### Claim 19 (depends on 18)

The computer-readable storage device of claim 18, wherein the method further comprises:
in response to no calculated probabilities being determined to have the predetermined relationship with the confidence threshold for all time windows determined from the historical data:
determining whether the historical data covers a predetermined historical time period; and
in response to the historical data being determined to cover the predetermined historical time period, reclaiming the resources, the database being considered idle.

### Claim 20 (depends on 19)

The computer-readable storage device of claim 19, wherein the method further comprises:
in response to the historical data being determined to not cover the predetermined historical time period, logically pausing the resources.
