Abstract: A system and method for resizing cloud volumes on a backup restore are presented. The method includes receiving a command to restore a cloud volume, the command is being received during a restore of the backup volume, wherein backup volume provides a backup of the cloud volume; computing a target volume size for a restored cloud volume, wherein the target volume size is computed based on sizing information gathered over time during the backup of the cloud volume; determining a structure type of the cloud volume; and restoring the backup volume to the restored cloud volume based on the target volume size and the determined structure type, wherein the restored cloud volume contains same files and structure as the cloud volume, and wherein a size of the cloud restored volume is different than a size of the cloud volume as originally created.

Abstract: A method and system for generating a deduplicated database backup are presented. The method includes generating, at a first time, a first backup of a database, the first backup including a plurality of backup objects comprising a first backup object and a second backup object, each backup object being a column-oriented file; assigning rows in the plurality of backup objects to row groups; generating a first temporal table including identifiers of row groups that are part of the first backup; generating, a second backup of the database; generating a third backup object storing changes detected between the first time and the second time; generating a second temporal table for the second backup; and generating a relevance table including, for a row group, a start point and an end point.

Abstract: A method and system for reducing deduplication in database backup are presented. The method includes selecting a first primary key; extracting row groups from a database based on the first primary key; storing the row groups arranged according to the first primary key; reading a portion of the database backup to detect a changes in the database; selecting a second primary key as a primary key, when utilizing the second primary key generates a smaller number of row groups than utilizing the first primary key; and generating a database backup based on the selected second primary key, wherein prior to generating the database backup at the second time, the one or more files of the database backup at the first time are rearranged based on the second primary key.

Abstract: A system and method for identifying and managing related storage volumes is provided. The method includes scanning a plurality of cloud computing environments to identify a plurality of storage volumes; obtaining volume data for each of the plurality of storage volumes, wherein the volume data includes a plurality of metadata identifiers; analyzing the plurality of metadata identifiers to determine one or more lineage identifiers indicating a common lineage among the plurality of storage volumes; determining associations among the plurality of storage volumes based on a comparison of the one or more lineage identifiers; and generating and outputting one or more data structures based on the determined associations, wherein the one or more data structures represent the common lineage among the plurality of storage volumes.

Abstract: A system and method for generating a backup of a file system are provided. The method includes capturing a plurality of snapshots of the file system at predetermined time intervals and in sequence without freezing operation of the file system, wherein the file system supports a workload that is deployed in a cloud environment; verifying each of the plurality of snapshots to determine whether the snapshot is valid or corrupted; selecting a valid snapshot for backup of the file system in response to determining that at least one snapshot is valid; initiating a repair process for snapshots determined to be corrupted in response to determining that no snapshot is valid; and designating the repaired snapshot as valid in response to successfully repairing at least one corrupted snapshot.

Abstract: A method and system for generating a temporal, query-ready database backup. The method includes generating a plurality of backups of a database, each of the backups including a plurality of backup data objects, each of the backup data objects including a plurality of rows stored in a file having a column-oriented format, and each backup corresponding to a unique point in time; assigning each row in a file to a row group, the row group having a unique identifier; generating a temporal table including a column of row group identifiers for each backup of the plurality of backups; receiving a query for a backup of the plurality of backups created at different point in times; and generating a query result based on the temporal table and at least the respective backup data object, wherein results are from backups of the plurality of backups related to different point in time.

Abstract: A method and system for generating a queryable backup of database applications to allow database operations are presented. The method includes accessing a plurality of database applications; exporting data stored in the database applications to a plurality of files, each file utilizing a column-oriented storage format; generating metadata based on the plurality of exported files, wherein the metadata includes a hash map of related-columns and a list of related-tables, wherein generating the metadata comprises normalizing column values of tables in the database applications and identifying related-columns based on at least the normalized column values by computing hash-based signatures for two columns in the normalized column values and designating the columns as having similar values upon determining that the columns share a threshold overlap in their computed hash-based signatures; and generating a queryable backup based on the plurality of exported files and the metadata.

Abstract: A system and method for generating a quarriable backup of database applications to allow database operations is provided. The method includes accessing a plurality of database applications deployed in a cloud environment; exporting data stored in the database applications to a plurality of files, each file utilizing a column-oriented storage format; generating metadata based on the plurality of exported files, where the metadata includes at least a hash map of related-columns and a list of related-tables; and generating a quarriable backup based on a plurality of exported files and the metadata.

Abstract: A method and system for identifying relevant database tables in a database backup are provided. The method includes receiving an input query, wherein the input query is a free text query; generating a prompt for a first language model that, when executed by a generative AI system, provides a set of column names most relevant to answering the input query; embedding a search vector for the set of relevant column names; and identifying relevant database tables by performing a similarity search between the search vector and vectors in a vector database, wherein the vectors in a vector database represent at least a portion of contents of database tables in the database backup.

Abstract: A method and system for querying multiple database tables in a database backup is presented. The method includes receiving identification of database tables to query, wherein the database tables to query are database tables of different database applications; receiving an input query in a free text format; retrieving classification data for each of the identified database tables; and generating a prompt for a first language model that, when executed by a generative AI system, provides a set of queries targeting the database tables, wherein the generated prompt is based on the input query and the classification data for the database tables.

Abstract: A method and system for searching joinable tables in digital backups of database applications for performing join operations. The method includes receiving a database table to perform a join operation on, wherein the received database table is included in the digital backups; searching for joinable columns across at least a set of tables included in the digital backups, wherein a joinable column shares at least a set of column values with a column in the received database table; and joining, upon a user selection, a joinable database table having a joinable column with the received database table.

Abstract: A method and system for constructing a join graph from normalized data are provided. The method includes receiving normalized data derived from a plurality of database tables, wherein the normalized data corresponds to columns that have been standardized to a format across the plurality of database tables; identifying one or more unique identifier columns among the plurality of database tables in the normalized data, wherein each unique identifier column includes values that enable matching of data across the plurality of database tables; generating a plurality of graph nodes, each node corresponding to at least one of the plurality of database tables; mapping joinable relationships between the graph nodes based on the unique identifier columns; and generating a join graph based on the mapped joinable relationships.

Abstract: A method and system for generating a temporal, query-ready database backup. The method includes generating a plurality of backups of a database, each of the backups including a plurality of backup data objects, each of the backup data objects including a plurality of rows stored in a file having a column-oriented format, and each backup corresponding to a unique point in time; assigning each row in a file to a row group, the row group having a unique identifier; generating a temporal table including a column of row group identifiers for each backup of the plurality of backups; receiving a query for a backup of the plurality of backups created at different point in times; and generating a query result based on the temporal table and at least the respective backup data object, wherein results are from backups of the plurality of backups related to different point in time.

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.