Abstract: A method and system for reducing deduplication in database backup are provided. The method includes selecting a first primary key of a database; extracting a plurality of row groups from the database based on the selected first primary key; storing the plurality of row groups arranged according to the first primary key in a file having a column-oriented data storage format as a database backup at a first time; reading at least a portion of the database backup at a second time to detect a plurality of changes; determining a position of each row corresponding to a change of the plurality of changes; selecting a second primary key of the database as a primary key; and generating a database backup of the database at the second time based on the selected second primary key.

Abstract: A method and system for restoring a single file from a backup of a block device storage in a cloud computing environment. The method includes reading a filesystem of a virtualization deployed in the cloud computing environment to detect a plurality of files stored on a block device storage; generating in the cloud computing environment a file-level backup including a plurality of backup objects, each backup object generated to minimize file fragmentation; and generating in the cloud computing environment a block-level backup of the block device storage, wherein the block-level backup is deduplicated based on the file-level backup.

Abstract: A method and system for generating a backup using file-level scanning and block-level scanning is presented. The method includes obtaining a snapshot of a storage volume associated with a virtualization environment; reading a filesystem on the snapshot to identify one or more files; generating a file-level backup of data corresponding to each of the identified files; retrieving one or more block-level addresses corresponding to the file-level data; determining which data blocks were read during the file-level backup based on the one or more block-level addresses; and generating a block-level backup by reading data blocks that were not read during the file-level backup.

Abstract: Systems and methods are disclosed for generating file-level manifest metadata for restoring files stored using filesystem compression. A backup system reads a filesystem on a snapshot to identify files and parses filesystem metadata for a file to determine whether the file data is stored in a compressed format. When compression is indicated, the system identifies physical byte ranges of compressed data and corresponding logical file offset ranges. For each physical byte range, the system determines compression metadata including a compression format identifier and compressed and uncompressed lengths. The system generates and stores a file-level manifest mapping logical file offsets to the physical byte ranges and the compression metadata to enable restoration of the file.

Abstract: A method and system for reducing deduplication in database backup are provided. The method includes selecting a first primary key of a database; extracting a plurality of row groups from the database based on the selected first primary key; storing the plurality of row groups arranged according to the first primary key in a file having a column-oriented data storage format as a database backup at a first time; reading at least a portion of the database backup at a second time to detect a plurality of changes; determining a position of each row corresponding to a change of the plurality of changes; selecting a second primary key of the database as a primary key; and generating a database backup of the database at the second time based on the selected second primary key.

Abstract: A system and method for the device may include reading a plurality of rows of a database. In addition, the device may include generating a secondary hash value for each row of the plurality of rows. The device may include generating a plurality of row groups, each including a group of unique rows of the plurality of rows, based at least on the secondary hash value. Moreover, the device may include generating a primary hash value for each row group of the plurality of row groups. Also, the device may include updating a backup of the database based on a first-row group of the plurality of row groups, in response to determining that a primary hash value of the first-row group does not match any primary hash value associated with the backup of the database.

Abstract: A method and system for restoring a digital backup of a database application hosted on a virtual machine are presented. The method includes generating a bootable volume on a new virtual machine, wherein the new virtual machine is different than the virtual machine hosting the database application; importing data from a plurality of files into the bootable volume, wherein the plurality of files are included in a data backup of the digital backup, and wherein each file of the plurality of files is in a column-oriented storage format; and restoring a virtualization backup included in the digital backup into the bootable volume.

Abstract: A method and system for updating backup data for a database is presented. The method includes initiating a merging operation for a defined time interval; obtaining change data capture (CDC) data generated during the defined time interval; aggregating and ordering the CDC data by a key value; identifying backup data associated with the ordered CDC data; generating a candidate data object that represents data modified during the defined time interval; deduplicating the candidate data object by comparing a hash identifier of the candidate data object with a plurality of hash identifiers stored in a repository; storing the candidate data object when the comparison determines that no matching hash identifier exists in the repository; and updating backup metadata to associate the key value with the candidate data object.

Abstract: A method and system for optimizing backup policies based on backup posture controls are presented. The method includes probing one or more accounts on a cloud infrastructure so as to identify content of cloud resources hosted by the cloud infrastructure in association with the accounts; retrieving a set of backup posture controls, wherein the set of backup controls constrains backup requirements on identified cloud resources; retrieving backup policies defined for the cloud resources; comparing the backup requirements to the retrieve backup policies to detect conflicting backup policies, wherein a conflicting backup policy violates at least one backup posture control of the set of backup posture controls; modifying the detected conflicting backup policies, thereby optimizing the existing backup policies; and assigning the modified backup policy to a backup system to allow backup operations of the cloud resources based on at least one backup policy.

Abstract: A method and system for generating backup policies based on backup posture controls is presented. The method includes probing one or more accounts on a cloud infrastructure so as to identify content of cloud resources hosted by the cloud infrastructure in association with the accounts; retrieving a set of backup posture controls, wherein the set of backup controls defines backup requirements on the identified cloud resources; analyzing the backup requirements to create optimization rules and workload-specific rules; creating at least one backup policy based on the optimization rules and workload-specific rules; and assigning the at least one backup policy to a backup system to allow backup operations of the cloud resources based on the at least one backup policy.

Abstract: A method system for generating a digital backup of database applications to allow join operations. The method includes accessing a plurality of database applications hosted on a plurality of virtual machines; exporting data stored in the database applications to a plurality of files, each file utilizing a column-oriented storage format; generating a joinable backup by at least computing searchable values for each table in the plurality of database applications; searching for joinable database tables in the joinable backup; and generating a digital backup of the database application based on the plurality of files and the joinable backup, wherein the digital backup includes at least a list of joinable database tables.

Abstract: A system and method for the device may include accessing a database application hosted on a virtual machine, the virtual machine deployed in a computing environment. In addition, the device may include exporting data stored in the database application to a plurality of files, each file utilizing a column-oriented storage format; generating a virtualization backup only of the virtual machine; and generating a data backup of the database application based on the plurality of files.

Abstract: A method includes probing one or more accounts on a cloud infrastructure so as to identify content of multiple data resources hosted by the cloud infrastructure in association with the accounts, receiving, from a user of the accounts, a backup policy specifying one or more backup parameters and at least one set of one or more data-resource properties, identifying, based on the identified content, at least some of the data resources that have the data-resource properties, and backing up the identified data resources in accordance with the backup parameters. Other embodiments are also described.

Abstract: A system and method for querying multiple database tables in a database backup are provided. The method includes receiving identification of database tables to query, wherein the database tables in a column-based format, and the database backup includes for each database table classification data for at least classifying its respective column names; generating a prompt for a first language model that provides a set of queries targeting the database tables, wherein the generated prompt is based on at least a received input query and the classification data for the database tables; executing the set of queries on the database tables, wherein each query of the set of queries is executed on a respective database table; and aggregating and displaying results returned in response to the execution of the set of queries.