Retrieving point-in-time copies of a source database for creating virtual databases

    公开(公告)号:US10067952B2

    公开(公告)日:2018-09-04

    申请号:US14052580

    申请日:2013-10-11

    Abstract: A storage system maintains copies of a source database to allow virtual databases to be provisioned. Transaction logs received from the source database are applied to database blocks stored in the storage system to update the database blocks. The storage system checks if there are defect in the transaction logs of the source database. If a defect in transaction logs is detected, the storage system obtains a latest copy of the source database. The storage system matches database blocks of the received copy with database blocks already available in the storage system to determine whether a corresponding database block is already available in the storage system. If a received database block is different from database blocks already available at the storage system, the received database block is stored in the storage system. The database blocks may be matched using a hash value of the database blocks.

    MANAGING TRANSFORMED SNAPSHOTS IN A STORAGE SYSTEM

    公开(公告)号:US20170206016A1

    公开(公告)日:2017-07-20

    申请号:US15411471

    申请日:2017-01-20

    CPC classification number: G06F16/258 G06F3/0607 G06F3/0661 G06F3/067

    Abstract: A storage system performs transformations of data stored as source snapshots to obtain transformed snapshots. The storage system stores relations between source snapshots, for example, parent child relationships. The storage system analyzes relationships between source snapshots to determine relationships between transformed snapshots. The storage system creates a transformed snapshot based on a source snapshot. The storage system traverses the graph representing source snapshots to identify ancestor or descendants of the source snapshots that were previously transformed. The storage system determines the transformed snapshots corresponding to the ancestor and descendant source snapshots and relates them to the newly created transformed snapshot.

    Creating Secure Virtual Databases Storing Masked Data
    3.
    发明申请
    Creating Secure Virtual Databases Storing Masked Data 审中-公开
    创建安全虚拟数据库存储屏蔽数据

    公开(公告)号:US20160224797A1

    公开(公告)日:2016-08-04

    申请号:US15013147

    申请日:2016-02-02

    CPC classification number: G06F17/30342 G06F17/30368 G06F21/6227

    Abstract: A database storage system creates secure snapshots or virtual databases based on a source database that stores sensitive information. The database storage system applies a masking function to the sensitive data and stores the masked data in the secure snapshot. The database storage system creates secure snapshots that share masked database blocks with other secure snapshots. The database storage system shares masked database blocks by storing information identifying a previously created masked database block for a new secure snapshot. If a masked database block for the new secure snapshot is different from the previously created masked database block, the database storage system stores metadata including the difference between the two masked database blocks. The database storage system allows sharing any transformed database blocks across snapshot, if the transformed database blocks are obtained by applying a transformation function to data of the source database.

    Abstract translation: 数据库存储系统基于存储敏感信息的源数据库创建安全快照或虚拟数据库。 数据库存储系统对敏感数据应用掩蔽功能,并将掩蔽的数据存储在安全快照中。 数据库存储系统创建与其他安全快照共享蒙版数据库块的安全快照。 数据库存储系统通过存储识别先前创建的用于新的安全快照的被屏蔽的数据库块的信息来共享屏蔽的数据库块。 如果新的安全快照的掩码数据库块与先前创建的掩蔽数据库块不同,则数据库存储系统存储包含两个屏蔽的数据库块之间的差异的元数据。 数据库存储系统允许跨快照共享任何变换的数据库块,如果通过将转换函数应用于源数据库的数据获得转换后的数据库块。

    De-Duplication Based Backup Of File Systems
    4.
    发明申请
    De-Duplication Based Backup Of File Systems 有权
    基于复制的文件系统备份

    公开(公告)号:US20140025637A1

    公开(公告)日:2014-01-23

    申请号:US14040459

    申请日:2013-09-27

    Inventor: Jedidiah Yueh

    Abstract: File system backups are performed by copying information describing changes in the file system since a previous point in time. To restore data, a virtual restored file system (VRFS) structure is created corresponding to a snapshot of data copied from the file system that is stored in the backup file system. A client can read the data stored in the backup file system pointed at by the VRFS structure as well as write to the backup file system. Multiple clients can share blocks of data stored on the backup file system via the same VRFS structure or via multiple VRFS structures. If a client writes to a data block pointed at by a VRFS, a copy of the data block is made to which the client makes changes so that the data in the original data blocks is saved for other clients.

    Abstract translation: 文件系统备份是通过复制描述自上一个时间点以来文件系统中的更改的信息来执行的。 要恢复数据,将创建与从备份文件系统中存储的文件系统复制的数据快照相对应的虚拟还原文件系统(VRFS)结构。 客户端可以读取存储在VRFS结构指向的备份文件系统中的数据,并写入备份文件系统。 多个客户端可以通过相同的VRFS结构或通过多个VRFS结构共享存储在备份文件系统上的数据块。 如果客户端写入由VRFS指向的数据块,则会向客户端进行更改的数据块副本,以便为其他客户端保存原始数据块中的数据。

    INTERFACING WITH A VIRTUAL DATABASE SYSTEM
    5.
    发明申请

    公开(公告)号:US20180181469A1

    公开(公告)日:2018-06-28

    申请号:US15722825

    申请日:2017-10-02

    Abstract: User interactions with a database storage system allow creation of virtual databases based on point-in-time copies associated with a source database. Multiple point-in-time copies are obtained for each source database. A point-in-time copy retrieves data changed in the source database since the retrieval of a previous point-in-time copy. A virtual database (VDB) is created by creating a set of files in the data storage system and mounting the files on a database server allowing the database server to access the files. User interactions allow the user to specify the source database, a point in time associated with the source database and a destination server to create the virtual database. User input can specify other attributes associated with the virtual database including the file paths, database parameters etc. The user can specify schedules of various actions, including making and retention of point-in-time copies.

    MANAGING TRANSFORMATIONS OF SNAPSHOTS IN A STORAGE SYSTEM

    公开(公告)号:US20170206017A1

    公开(公告)日:2017-07-20

    申请号:US15411476

    申请日:2017-01-20

    Abstract: A storage system executes transform scripts to transform data stored in a source snapshot to obtain transformed snapshot. A transform script may be used to upgrade data stored in a snapshot from a version of an application to a newer version of the application. The storage system stores intermediate snapshots during execution of a transform scripts. The storage system reuses data stored during execution of transform scripts to optimize execution of newer transform scripts. For example, the storage system identifies a previously executed transform script having a matching prefix of transform operations and reuses an intermediate snapshot obtained by executing the matching prefix. The storage system processes the intermediate snapshot by executing the remaining transform operations of the new transform script.

    Virtual Partitions in Virtual Databases
    7.
    发明申请
    Virtual Partitions in Virtual Databases 有权
    虚拟数据库中的虚拟分区

    公开(公告)号:US20160267105A1

    公开(公告)日:2016-09-15

    申请号:US14657708

    申请日:2015-03-13

    Abstract: Information from source databases is retrieved and stored on a database storage system. Multiple point-in-time copies are obtained for each database. A source database may contain partitions comprising sets of database tables. A partition is imported into a virtual database created. The database storage system validates the partition before importing, by checking whether the partition includes database tables that refer to database tables outside the partition. A partition imported in a virtual database may be rewinded to an older state or refreshed to a more recent state. Multiple partitions may be included in a virtual database and the state of each partition modified independent of the state of the remaining virtual database including the other partitions. Multiple versions of the same partition corresponding to different points in time are incorporated in the same virtual database, thereby allowing a query to process different versions of the same database table.

    Abstract translation: 来自源数据库的信息被检索并存储在数据库存储系统上。 为每个数据库获取多个时间点副本。 源数据库可以包含包含数据库表的集合的分区。 将分区导入到创建的虚拟数据库中。 数据库存储系统通过检查分区是否包含引用分区外的数据库表的数据库表来验证导入之前的分区。 在虚拟数据库中导入的分区可能会被还原到较旧的状态或刷新到更新的状态。 可以在虚拟数据库中包括多个分区,并且每个分区的状态被修改,独立于包括其他分区的剩余虚拟数据库的状态。 对应于不同时间点的相同分区的多个版本被并入相同的虚拟数据库中,从而允许查询处理相同数据库表的不同版本。

    Creating validated database snapshots for provisioning virtual databases
    8.
    发明授权
    Creating validated database snapshots for provisioning virtual databases 有权
    为配置虚拟数据库创建经过验证的数据库快照

    公开(公告)号:US08788461B2

    公开(公告)日:2014-07-22

    申请号:US13645409

    申请日:2012-10-04

    Abstract: Virtual databases are provisioned using point-in-time copies of a source database. Transaction logs received from the source database are applied to a point-in-time copy of the source database to create recovery milestones comprising database blocks that can be used to provision virtual databases. The recovery milestones are created in advance of receiving a request to provision a virtual database. Each recovery milestone is validated to determine that a consistent database snapshot can be created using the recovery milestone. If a problem is identified that prevents creation of a consistent database snapshot, the problem is fixed before creating the next recovery milestone. In response to receiving a request to provision a virtual database corresponding to a point in time, a recovery milestone is identified and transaction logs applied to the recovery milestone to create a database snapshot corresponding to the requested point in time.

    Abstract translation: 使用源数据库的时间点副本来提供虚拟数据库。 从源数据库接收的事务日志应用于源数据库的时间点副本,以创建包含可用于配置虚拟数据库的数据库块的恢复里程碑。 恢复里程碑是在接收到提供虚拟数据库的请求之前创建的。 验证每个恢复里程碑以确定可以使用恢复里程碑创建一致的数据库快照。 如果确定了阻止创建一致的数据库快照的问题,则在创建下一个恢复里程碑之前,问题已解决。 响应于接收到对与时间点相对应的虚拟数据库的请求,识别恢复里程碑,并将事务日志应用于恢复里程碑以创建与所请求的时间点对应的数据库快照。

    Virtual partitions in virtual databases

    公开(公告)号:US10831707B2

    公开(公告)日:2020-11-10

    申请号:US15972359

    申请日:2018-05-07

    Abstract: Information from source databases is retrieved and stored on a database storage system. Multiple point-in-time copies are obtained for each database. A source database may contain partitions comprising sets of database tables. A partition is imported into a virtual database created. The database storage system validates the partition before importing, by checking whether the partition includes database tables that refer to database tables outside the partition. A partition imported in a virtual database may be rewinded to an older state or refreshed to a more recent state. Multiple partitions may be included in a virtual database and the state of each partition modified independent of the state of the remaining virtual database including the other partitions. Multiple versions of the same partition corresponding to different points in time are incorporated in the same virtual database, thereby allowing a query to process different versions of the same database table.

    Interfacing with a virtual database system

    公开(公告)号:US10678649B2

    公开(公告)日:2020-06-09

    申请号:US15722825

    申请日:2017-10-02

    Abstract: User interactions with a database storage system allow creation of virtual databases based on point-in-time copies associated with a source database. Multiple point-in-time copies are obtained for each source database. A point-in-time copy retrieves data changed in the source database since the retrieval of a previous point-in-time copy. A virtual database (VDB) is created by creating a set of files in the data storage system and mounting the files on a database server allowing the database server to access the files. User interactions allow the user to specify the source database, a point in time associated with the source database and a destination server to create the virtual database. User input can specify other attributes associated with the virtual database including the file paths, database parameters etc. The user can specify schedules of various actions, including making and retention of point-in-time copies.

Patent Agency Ranking