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: In one embodiment, a method comprises receiving, from a plurality of large language models, a first plurality of application detectors for a plurality of applications, wherein an application detector comprises executable code to detect whether an application is installed on a computing system; executing the first plurality of application detectors to determine whether the first plurality of application detectors accurately detect applications installed on a plurality of computing systems; and selecting, based on detection accuracy of the first plurality of application detectors, a second plurality of application detectors to deploy for use in detecting the plurality of applications.

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: In one embodiment, a method comprises receiving a request to view a portion of a file system; identifying a first file of the portion of the file system that is not likely to be corrupt, a second file of the portion of the file system that is likely to be corrupt, and a backup of the second file that is not likely to be corrupt; and generating a representation of the portion of the file system, the representation displayable in a file system explorer, wherein the representation includes an identifier of the first file, an identifier of the second file, and a point in time of the backup of the second file that is not likely to be corrupt.

Abstract: In one embodiment, a method comprises responsive to a request, accessing a storage backup log, the storage backup log comprising indications of changes to files of a plurality of storage backups relative to previous storage backups, wherein each storage backup of the plurality of storage backups is associated with a different point-in-time; and responsive to the request, utilizing the storage backup log to generate a representation of at least a portion of a file system at multiple points in time, wherein the representation includes indications of a first file in existence at a point-in-time, a second file deleted prior to the point-in-time, and a third file created after the point-in-time.

Abstract: In one embodiment, a method comprises receiving a request to view a portion of a first file system and a second file system; and generating a representation of a portion of a first file system and a second file system, the representation displayable in a file system explorer, wherein the representation includes a file at a file path, a first indication of one or more backups of the file for the first file system, and a second indication of one or more backups of the file for the second file system.

Abstract: In one embodiment, a method comprises generating a backup of a table of a relational database by partitioning a plurality of records of the table among a plurality of Parquet files; and extracting metadata of the table into one or more metadata files; and requesting access of at least one of the plurality of Parquet files of the backup of the relational database responsive to an SQL query entered by a user into a user interface.

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.