# US 2021/0334174 A1 · Dynamically allocating streams during restoration of data

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

- Number: US 2021/0334174 A1
- Document ID: US20210334174A1
- Status: Published application
- Kind: A1
- Application number: 17/227,118
- Filed: 2021-04-09
- Published: 2021-10-28
- Earliest claimed: 2017-03-31
- Assignees: Commvault Systems, Inc.
- Applicants: Commvault Systems, Inc.
- Inventors: Waqas ASHRAF; Nadejda NEKRASSOVA
- Web page: https://patentgrep.com/patent/US20210334174A1

## CPC

- G06F 11/1469: {Backup restoration techniques}
- G06F 11/1448: {Management of the data involved in backup or backup restore}
- G06F 11/1453: {using de-duplication of the data}
- G06F 11/1464: {for networked environments}
- G06F 11/2056: {by mirroring}
- G06F 16/128: {Details of file system snapshots on the file-level, e.g. snapshot creation, administration, deletion (error detection or correction of the data by redundancy in operations or in hardware G06F11/14, G06F11/16)}
- G06F 16/173: {Customisation support for file systems, e.g. localisation, multi-language support, personalisation}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 11/2048: {where the redundant components share neither address space nor persistent storage}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

The systems and methods described herein dynamically allocate streams when restoring data from databases. In some embodiments, the system and methods restore data from a database by determining a number of streams to allocate to the database for restoring files of data from the database. The determined number of streams may be based on a total amount of data within the database, and/or may be based, at least in part, on the previous number of streams used during backup operations, in order to balance the benefit of allocating streams to a restoration of data with any detriments associated with changing the number of streams from the number used during previous backup operations.

## Claims

### Claim 1

(canceled)

### Claim 2

A system, comprising:
at least one processor;
at least one data storage device coupled to the at least one processor and storing instructions for performing a process of restoring data from a database to a client computing device within an information management system, wherein the process comprises:
determining a number of streams to allocate to the database for restoring database data from the database,
wherein a stream is a data channel that connects a client computing device to a secondary storage device where at least a portion of the database is stored,
wherein the determining the number of streams is based, at least in part, on:
a type of data storage system performing the process of restoring the database data,
one or more characteristics of data storage resources associated with the client computing device, and
available bandwidth of at least one stream available for restoring;
grouping the database data into a number of groups, wherein the number of groups equals the determined number of streams;
allocating a stream of the determined number of streams to database data associated with one of the groups; and
restoring the database data associated with the one of the groups, via the allocated stream, to the client computing device.

### Claim 3 (depends on 2)

The system of claim 2, wherein the determining the number of streams to allocate to the database data is based on a number of streams used during a prior backup operation associated with the client computing device.

### Claim 4 (depends on 2)

The system of claim 2, wherein the determining the number of streams to allocate to the database data an available bandwidth of each available stream.

### Claim 5 (depends on 2)

The system of claim 2, wherein the grouping of the database data results in, a least, a first group and a second group, wherein a total amount of data within the first group substantially matches a total amount of data within the second group.

### Claim 6 (depends on 2)

The system of claim 2, wherein the determined number of streams is different than a total number of streams used to back up the database data.

### Claim 7 (depends on 2)

The system of claim 2, wherein restoring the database data comprises restoring the database data using a media agent associated with the database.

### Claim 8 (depends on 2)

The system of claim 2, the process further comprising identifying characteristics of one or more resources that have changed since the database data was backed up.

### Claim 9 (depends on 2)

The system of claim 2, the process further comprising identifying characteristics of one or more resources that have increased in bandwidth since the database data was backed up.

### Claim 10

A method for restoring data from a database to a client computing device, the method comprising:
receiving a request to restore a copy of database data to a client computing device;
determining a number of streams to allocate to the database for restoring database data from the database,
wherein a stream is a data channel that connects a client computing device to a secondary storage device where at least a portion of the database is stored,
wherein the determining the number of streams is based, at least in part, on:
a type of data storage system performing the method for restoring database data to the client computing device,
one or more characteristics of data storage resources associated with the client computing device, and
available bandwidth of at least one stream available for restoring;
grouping the database data into a number of groups, wherein the number of groups equals the determined number of streams;
allocating a stream of the determined number of streams to database data associated with one of the groups; and
restoring the database data associated with the one of the groups, via the allocated stream, to the client computing device.

### Claim 11 (depends on 10)

The method of claim 10, wherein the determining the number of streams to allocate to the database data is based on a number of streams used during a prior backup operation associated with the client computing device.

### Claim 12 (depends on 10)

The method of claim 10, wherein the determining the number of streams to allocate to the database data an available bandwidth of each available stream.

### Claim 13 (depends on 10)

The method of claim 10, wherein the grouping of the database data results in, a least, a first group and a second group, wherein a total amount of data within the first group substantially matches a total amount of data within the second group.

### Claim 14 (depends on 10)

The method of claim 10, wherein the determined number of streams is different than a total number of streams used to back up the database data.

### Claim 15 (depends on 10)

The method of claim 10, wherein restoring the database data comprises restoring the database data using a media agent associated with the database.

### Claim 16 (depends on 10)

The method of claim 10, the method further comprising identifying characteristics of one or more resources that have changed since the database data was backed up.

### Claim 17 (depends on 10)

The method of claim 10, the method further comprising identifying characteristics of one or more resources that have increased in bandwidth since the database data was backed up.

### Claim 18

A computer-readable medium, excluding transitory propagating signals, storing instructions that, when executed by an information management system, cause the information management system to perform a method for restoring data to a client computing device, the method comprising:
receiving a request to restore a copy of database data to a client computing device;
determining a number of streams to allocate to the database for restoring database data from a secondary copy of the database,
wherein a stream is a data channel that connects a client computing device to a secondary storage device where at least a portion of the database is stored,
wherein the determining the number of streams is based, at least in part, on:
a type of data storage system performing the method for restoring database data to the client computing device,
one or more characteristics of data storage resources associated with the client computing device, and
available bandwidth of at least one stream available for restoring;
grouping the database data into a number of groups, wherein the number of groups equals the determined number of streams;
allocating a stream of the determined number of streams to database data associated with one of the groups; and
restoring the database data associated with the one of the groups, via the allocated stream, to the client computing device.

### Claim 19 (depends on 18)

The computer-readable medium of claim 18, wherein the determining the number of streams to allocate to the database data is based on a number of streams used during a prior backup operation associated with the client computing device.

### Claim 20 (depends on 18)

The computer-readable medium of claim 18, wherein the determining the number of streams to allocate to the database data an available bandwidth of each available stream.

### Claim 21 (depends on 18)

The computer-readable medium of claim 18, wherein the grouping of the database data results in, a least, a first group and a second group, wherein a total amount of data within the first group substantially matches a total amount of data within the second group.

### Claim 22 (depends on 18)

The computer-readable medium of claim 18, wherein the determined number of streams is different than a total number of streams used to back up the database data.

### Claim 23 (depends on 18)

The computer-readable medium of claim 18, wherein restoring the database data comprises restoring the database data using a media agent associated with the database.

### Claim 24 (depends on 18)

The computer-readable medium of claim 18, the method further comprising identifying characteristics of one or more resources that have changed since the database data was backed up.

### Claim 25 (depends on 18)

The computer-readable medium of claim 18, the method further comprising identifying characteristics of one or more resources that have increased in bandwidth since the database data was backed up.
