# US 12,001,886 B2 · Allocation of cloud-based resources for backup/recovery services > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,001,886 B2 - Document ID: US12001886B2 - Status: Granted - Kind: B2 - Application number: 17/817,981 - Filed: 2022-08-06 - Published: 2023-01-26 - Granted: 2024-06-04 - Earliest claimed: 2019-09-12 - Assignees: Oracle International Corporation - Applicants: Oracle International Corporation - Inventors: Angelo Rajadurai; Deepika Muthukumar; Sriram V. R Nagaraja Rao - Web page: https://patentgrep.com/patent/US12001886B2 ## CPC - G06F 9/5016: {the resource being the memory} - G06F 11/1448: {Management of the data involved in backup or backup restore} - G06F 11/1451: {by selection of backup contents} - G06F 2201/80: Database-specific techniques - G06F 2201/81: Threshold - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract Disclosed is an improved system, method, and computer program product to allocate backup devices for a database system, where an appropriate appliance can be automatically allocated to accommodate backups. The allocation selects an appliance that effectively balances space allocation needs of the database with overall performance effects on a multi-tenant backup system that handles multiple databases of varying sizes. ## Claims ### Claim 1 A method, comprising: identifying at least a first and second device of a plurality of devices to store backup data for multiple databases, wherein the first device has a greater amount of free space than the second device; and balancing individual performance of a database with overall performance of the multiple databases based at least in part upon a space requirement and a database size threshold to transmit the backup data of the database to a particular device, wherein balancing the individual performance with the overall performance comprises: transmitting, via a network interface for the database in response to the space requirement being larger than the database size threshold, the backup data to the first device, wherein the first device is selected based at least in part upon the first device having the greater amount of free space than the second device; and transmitting, via the network interface for the database in response to the space requirement being smaller than the database size threshold, the backup data to the second device, wherein the second device is selected based at least in part upon the second device having a smaller amount of free space than the first device. ### Claim 2 (depends on 1) The method of claim 1, wherein the space requirement is determined based at least in part upon sizing information of the database. ### Claim 3 (depends on 2) The method of claim 2, wherein the sizing information comprises at least one of a type of backup to be transmitted from the database to the first or the second device, log data, or a catalog of the database, and the type of the backup includes a full backup type and an incremental backup type. ### Claim 4 (depends on 2) The method of claim 2, wherein the space requirement for the database is further determined based at least in part upon recovery window information, the recovery window information pertaining to a service level for the database or an amount of time that the backup data of the database is to be maintained in the first or the second device. ### Claim 5 (depends on 4) The method of claim 4, wherein the recovery window information indicates a reserved amount of space that is reserved on the first or the second device for the database and comprises at least one of a database size of the database, a change rate of the backup data to be backed up for the database, or an archival size pertaining to a statistical size of log data generated by the database within a time period. ### Claim 6 (depends on 1) The method of claim 1, wherein the database size threshold is configurable and is used to determine whether the backup data for the database is to be transmitted to the first device for spreading utilization of the plurality of devices or to the second device to be packed with the backup data of one or more other databases in a cloud system. ### Claim 7 (depends on 1) The method of claim 1, wherein the multiple databases respectively correspond to a plurality of tenants in a multitenant cloud system, a device of the plurality of devices comprises one or more servers each comprising one or more storage devices, the first device has a first utilization level, the second device has a second utilization level, the first utilization level is lower than the second utilization level, and the overall performance of the multiple databases pertains to utilization of the multitenant cloud system. ### Claim 8 (depends on 1) The method of claim 1, further comprising: determining whether the first device has a free space amount that is sufficient for hosting the backup data of the database; and in response to a determination that the free space amount on the first device is insufficient to host the backup data of the database, adding a new device to a cloud system for hosting the backup data of the database. ### Claim 9 A system, comprising: a processor; a memory storing therein a sequence of instructions which, when executed by the processor, causes the processor to perform a set of acts, the set of acts comprising: identifying at least a first and second device of a plurality of devices to store backup data for multiple databases, wherein the first device has a greater amount of free space than the second device; and balancing individual performance of a database with overall performance of the multiple databases based at least in part upon a space requirement and a database size threshold to transmit the backup data of the database to a particular device, wherein balancing the individual performance with the overall performance comprises: transmitting, via a network interface for the database in response to the space requirement being larger than the database size threshold, the backup data to the first device, wherein the first device is selected based at least in part upon the first device having the greater amount of free space than the second device; and transmitting, via the network interface for the database in response to the space requirement being smaller than the database size threshold, the backup data to the second device, wherein the second device is selected based at least in part upon the second device having a smaller amount of free space than the first device. ### Claim 10 (depends on 9) The system of claim 9, wherein the space requirement is determined based at least in part upon sizing information of the database. ### Claim 11 (depends on 10) The system of claim 10, wherein the sizing information comprises at least one of a type of backup to be transmitted from the database to the first or the second device, log data, or a catalog of the database, and the type of the backup includes a full backup type and an incremental backup type. ### Claim 12 (depends on 10) The system of claim 10, wherein the space requirement for the database is further determined based at least in part upon recovery window information, the recovery window information pertaining to a service level for the database or an amount of time that the backup data of the database is to be maintained in the first or the second device, and the recovery window information indicates a reserved amount of space that is reserved on the first or the second device for the database and comprises at least one of a database size of the database, a change rate of the backup data to be backed up for the database, or an archival size pertaining to a statistical size of log data generated by the database within a time period. ### Claim 13 (depends on 9) The system of claim 9, wherein the database size threshold is configurable and is used to determine whether the backup data for the database is to be transmitted to the first device for spreading utilization of the plurality of devices or to the second device to be packed with the backup data of one or more other databases in the cloud system, wherein the multiple databases respectively correspond to a plurality of tenants in a multitenant cloud system, a device of the plurality of devices comprises one or more servers each comprising one or more storage devices, the first device has a first utilization level, the second device has a second utilization level, the first utilization level is lower than the second utilization level, and the overall performance of the multiple databases pertains to utilization of the multitenant cloud system. ### Claim 14 (depends on 9) The system of claim 9, the set of further comprising: determining whether the first device has a free space amount that is sufficient for hosting the backup data of the database; and in response to a determination that the free space amount on the first device is insufficient to host the backup data of the database, adding a new device to a cloud system for hosting the backup data of the database. ### Claim 15 A non-transitory computer readable medium storing thereupon a sequence of instructions which, when executed by the processor, causes the processor to perform a set of acts, the set of acts comprising: identifying at least a first and second device of a plurality of devices to store backup data for multiple databases, wherein the first device has a greater amount of free space than the second device; and balancing individual performance of a database with overall performance of the multiple databases based at least in part upon a space requirement and a database size threshold to transmit the backup data of the database to a particular device, wherein balancing the individual performance with the overall performance comprises: transmitting, via a network interface for the database in response to the space requirement being larger than the database size threshold, the backup data to the first device, wherein the first device is selected based at least in part upon the first device having the greater amount of free space than the second device; and transmitting, via the network interface for the database in response to the space requirement being smaller than the database size threshold, the backup data to the second device, wherein the second device is selected based at least in part upon the second device having a smaller amount of free space than the first device. ### Claim 16 (depends on 15) The non-transitory computer readable medium of claim 15, wherein the space requirement is determined based at least in part upon sizing information of the database. ### Claim 17 (depends on 16) The non-transitory computer readable medium of claim 16, wherein the sizing information comprises at least one of a type of backup to be transmitted from the database to the first or the second device, log data, or a catalog of the database, and the type of the backup includes a full backup type and an incremental backup type. ### Claim 18 (depends on 16) The non-transitory computer readable medium of claim 16, wherein the space requirement for the database is further determined based at least in part upon recovery window information, the recovery window information pertaining to a service level for the database or an amount of time that the backup data of the database is to be maintained in the first or the second device, and the recovery window information indicates a reserved amount of space that is reserved on the first or the second device for the database and comprises at least one of a database size of the database, a change rate of the backup data to be backed up for the database, or an archival size pertaining to a statistical size of log data generated by the database within a time period. ### Claim 19 (depends on 15) The system of claim 15, wherein the database size threshold is configurable and is used to determine whether the backup data for the database is to be transmitted to the first device for spreading utilization of the plurality of devices or to the second device to be packed with the backup data of one or more other databases in a cloud system, the multiple databases respectively correspond to a plurality of tenants in a multitenant cloud system, a device of the plurality of devices comprises one or more servers each comprising one or more storage devices, the first device has a first utilization level, the second device has a second utilization level, the first utilization level is lower than the second utilization level, and the overall performance of the multiple databases pertains to utilization of the multitenant cloud system. ### Claim 20 (depends on 15) The system of claim 15, the set of further comprising: determining whether the first device has a free space amount that is sufficient to hosting the backup data of the database; and in response to a determination that the free space amount on the first device is insufficient to host the backup data of the database, adding a new device to the cloud system for hosting the backup data of the database.