Abstract: A method, including accessing a source database including records stored in tables, which are organized in a hierarchy defining respective parents and dependents of the tables, containing respective parent and dependent records, the records including attribute values. Upon presenting a first list of the tables, an input is received selecting a first table. Upon presenting a second list of the tables related to the first table, an input is received selecting a second table in the second list. Upon presenting filtering criteria for the selected tables, a filtering request is received for a given selected table. The request is applied to the given selected table to select a subset of the records in the given selected table and to generate a target database including the subset of the records and the records in the set that are the respective directly related records of the records in the subset.

Abstract: Methods, apparatuses and computer program products implement embodiments of the present invention that include capturing a series of point-in-time images of a database including one or more tables, each of the tables including one or more fields. Upon receiving, from a user, a query with respect to a variation of a given field over a specified period of time, the point-in-time images are analyzed in order to extract the variation; and the extracted variation is presented to the user.

Abstract: An information management system creates a modified representation of backup files in a backup copy on restore to overcome the difficulties and challenges imposed by the legal and administrative requirements on the handling of personally information without making changes to the backup copy. In an example, a restore modification component searches backup data files as they are restored from a backup copy but before the restored data files are written into the primary storage system. When the restore modification component identifies a backup data file with a record that matches search criteria defined in the modification repository, the restore modification component replaces one or more of the restored data field values in the record with replacement data values obtained from the modification repository according to respective replacement rules. In this way, the information management system can create a modified representation of the backup copy data without modifying the backup copy.

Abstract: An embodiment features a method of generating test data. An application-level schema corresponding to a source relational database is received. The schema defines constraints comprising one or more of inter-field, inter-record, and inter-object constraints between related data in the source relational database. A random walk is performed on a graph of nodes representing data in the source relational database. At respective ones of the nodes, corresponding ones of the data in the source relational database are selected along a path ordered in accordance with the constraints defined in the schema. Synthetic test data is generated based on one or more statistical models of the data selected from the source relational database. Data values are generated for respective fields of an object defined in the schema, and data values are generated for records related to the object based on one or more of the constraints defined in the schema.

Abstract: Embodiments of the present invention include generating, at a first time, a first copy of a database including multiple tables, the first copy including a set of first structured text files. During a time period subsequent to the first time, queries that request updates to the tables during the time period are periodically generated and conveyed to a system managing the database. Responsively to the periodic queries, any updates to the tables and their respective update times are received and stored to a journal including one or more second structured text files. At a subsequent time, a request to generate a second copy of the database is received, the second copy including a state of the database at a specified time during the time period. The first copy of the database is updated with the updates whose update times are prior to the specified time, thereby generating the second copy.

Abstract: The present disclosure relates to software development and, more specifically, to continuous integration (CI) based software development systems, methods, and computer program products in which a system-under-test (SUT) is populated with production data that has been filtered or transformed, or both. In accordance with this approach, the filtered or transformed production test data can be automatically generated and seamlessly integrated into a continuous integration process. In some examples, the resulting filtered or transformed test data closely reflects real production data while, at the same time, consuming less data storage space and protecting an individual's sensitive information.

Abstract: An embodiment features a method of generating test data. An application-level schema corresponding to a source relational database is received. The schema defines constraints comprising one or more of inter-field, inter-record, and inter-object constraints between related data in the source relational database. A random walk is performed on a graph of nodes representing data in the source relational database. At respective ones of the nodes, corresponding ones of the data in the source relational database are selected along a path ordered in accordance with the constraints defined in the schema. Synthetic test data is generated based on one or more statistical models of the data selected from the source relational database. Data values are generated for respective fields of an object defined in the schema, and data values are generated for records related to the object based on one or more of the constraints defined in the schema.

Abstract: An embodiment features a method of generating test data. An application-level schema corresponding to a source relational database is received. The schema defines constraints comprising one or more of inter-field, inter-record, and inter-object constraints between related data in the source relational database. A random walk is performed on a graph of nodes representing data in the source relational database. At respective ones of the nodes, corresponding ones of the data in the source relational database are selected along a path ordered in accordance with the constraints defined in the schema. Synthetic test data is generated based on one or more statistical models of the data selected from the source relational database. Data values are generated for respective fields of an object defined in the schema, and data values are generated for records related to the object based on one or more of the constraints defined in the schema.

Abstract: The present disclosure relates to software development and, more specifically, to continuous integration (CI) based software development systems, methods, and computer program products in which a system-under-test (SUT) is populated with production data that has been filtered or transformed, or both. In accordance with this approach, the filtered or transformed production test data can be automatically generated and seamlessly integrated into a continuous integration process. In some examples, the resulting filtered or transformed test data closely reflects real production data while, at the same time, consuming less data storage space and protecting an individual's sensitive information.

Abstract: Information management systems and methods archive and back up data from one or more primary storage devices to one or more secondary storage devices are described. More specifically, systems, methods, and computer program instructions are provided for efficiently transferring relational database data from one or more primary storage devices to one or more secondary storage devices for archival and backup purposes.

Abstract: The present disclosure relates to software development and, more specifically, to continuous integration (CI) based software development systems, methods, and computer program products in which a system-under-test (SUT) is populated with production data that has been filtered or transformed, or both. In accordance with this approach, the filtered or transformed production test data can be automatically generated and seamlessly integrated into a continuous integration process. In some examples, the resulting filtered or transformed test data closely reflects real production data while, at the same time, consuming less data storage space and protecting an individual's sensitive information.

Abstract: Information management systems and methods archive and back up data from one or more primary storage devices to one or more secondary storage devices are described. More specifically, systems, methods, and computer program instructions are provided for efficiently transferring relational database data from one or more primary storage devices to one or more secondary storage devices for archival and backup purposes.

Abstract: An information management system creates a modified representation of backup files in a backup copy on restore to overcome the difficulties and challenges imposed by the legal and administrative requirements on the handling of personally information without making changes to the backup copy. In an example, a restore modification component searches backup data files as they are restored from a backup copy but before the restored data files are written into the primary storage system. When the restore modification component identifies a backup data file with a record that matches search criteria defined in the modification repository, the restore modification component replaces one or more of the restored data field values in the record with replacement data values obtained from the modification repository according to respective replacement rules. In this way, the information management system can create a modified representation of the backup copy data without modifying the backup copy.