Table level database restore in a data storage system

    公开(公告)号:US11023334B2

    公开(公告)日:2021-06-01

    申请号:US16225719

    申请日:2018-12-19

    Abstract: The data storage system according to certain aspects can implement table level database restore. Table level database restore may refer to restoring a database table and its related data without restoring the entire database. The data storage system may use table metadata index to implement table level restore. A table metadata index may be created for each table, e.g., during a backup of the database. The table metadata index for a table can include any type of information for restoring the table and its related data. Some examples of the type of information included in the table metadata index include the following: container for the table, table backup location, system data, table index, table relationships, etc. Table metadata index can make the restoring of tables fast and efficient by packaging information that can be used to restore a table and its related data in an easily accessible manner.

    Single snapshot for multiple agents

    公开(公告)号:US10853176B2

    公开(公告)日:2020-12-01

    申请号:US15888592

    申请日:2018-02-05

    Abstract: A data storage system according to certain aspects can share a single snapshot for multiple applications and/or agents. For example, the data storage system can receive snapshot commands from multiple applications and/or agents, and can group them for a single snapshot (e.g., based on time of receipt of the snapshot commands). Data associated with the multiple applications and/or agents may reside on a single LUN or volume. The data storage system can take a single snapshot of the LUN or volume, and generate metadata regarding which portion of the snapshot is related to which application. The single snapshot can be stored in one or more secondary storage devices. The single snapshot may be partitioned into portions relating to different applications and stored separately.

    Opportunistic execution of secondary copy operations

    公开(公告)号:US10474538B2

    公开(公告)日:2019-11-12

    申请号:US15474077

    申请日:2017-03-30

    Abstract: Rather than relying on pre-defined scheduling of secondary copy operations such as backup jobs, the illustrative opportunistic approach initiates secondary copy operations based on changing operational conditions in a storage management system. An adaptive backup readiness score is based on a number of backup-readiness operational factors. An illustrative enhanced data agent which is associated with the target database application (or other executable component) may monitor the operational factors and determine the backup readiness score based on weights assigned to the respective operational factors. The enhanced data agent may evaluate recent backup jobs to determine which of the operational factors that contributed to the backup readiness score may have been most relevant. Based on the most-relevant analysis, the enhanced data agent may adapt the weights assigned to the monitored operational factors, so that the backup readiness score may be more suitable and responsive to ongoing operational conditions in the system.

    Object-level database restore
    25.
    发明授权

    公开(公告)号:US10223211B2

    公开(公告)日:2019-03-05

    申请号:US14717816

    申请日:2015-05-20

    Abstract: According to certain aspects, a system may include a computing device configured to: intercept a request from a database application to read a portion of a database file, where a secondary copy of the database file resides on a secondary storage device(s) and is organized as a plurality of first blocks, wherein the request includes a database file offset(s) corresponding to the requested portion; and map the database file offset(s) to a subset of the first blocks that correspond to requested database object(s). The system may include a secondary storage controller computer(s) configured to: access a table that maps the plurality of first blocks to storage locations on the secondary storage device(s); using the table, locate and retrieve the subset of the first blocks on the secondary storage device(s); and forward the retrieved first blocks for storage in a primary storage device(s).

    Table level database restore in a data storage system

    公开(公告)号:US09766987B2

    公开(公告)日:2017-09-19

    申请号:US14041771

    申请日:2013-09-30

    CPC classification number: G06F11/1469 G06F11/1448 G06F2201/80

    Abstract: The data storage system according to certain aspects can implement table level database restore. Table level database restore may refer to restoring a database table and its related data without restoring the entire database. The data storage system may use table metadata index to implement table level restore. A table metadata index may be created for each table, e.g., during a backup of the database. The table metadata index for a table can include any type of information for restoring the table and its related data. Some examples of the type of information included in the table metadata index include the following: container for the table, table backup location, system data, table index, table relationships, etc. Table metadata index can make the restoring of tables fast and efficient by packaging information that can be used to restore a table and its related data in an easily accessible manner.

    UTILIZING SNAPSHOTS FOR ACCESS TO DATABASES AND OTHER APPLICATIONS
    27.
    发明申请
    UTILIZING SNAPSHOTS FOR ACCESS TO DATABASES AND OTHER APPLICATIONS 有权
    使用数据库和其他应用程序的快照

    公开(公告)号:US20140222759A9

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

    申请号:US13792104

    申请日:2013-03-10

    CPC classification number: G06F17/30581 G06F11/3664 G06F17/303

    Abstract: A method and system for utilizing snapshots to provide copies of a database or other application or large data structure to computing devices receives a request for access to a copy of a database, and performs a snapshot of a storage volume containing the requested database. The system then clones the snapshot and mounts the snapshot to a computing device, thus enabling the computing device to access a copy of the database. In some examples, the system automatically updates copies of a database on a scheduled basis (e.g., daily or weekly basis) to refresh a database regularly.

    Abstract translation: 利用快照向计算设备提供数据库或其他应用或大数据结构的副本的方法和系统接收访问数据库副本的请求,并执行包含所请求的数据库的存储卷的快照。 系统然后克隆快照并将快照安装到计算设备,从而使计算设备能够访问数据库的副本。 在一些示例中,系统以计划的方式自动更新数据库的副本(例如,每天或每周),以定期刷新数据库。

    TABLE LEVEL DATABASE RESTORE IN A DATA STORAGE SYSTEM

    公开(公告)号:US20140201161A1

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

    申请号:US14041817

    申请日:2013-09-30

    CPC classification number: G06F11/1469 G06F11/1448 G06F2201/80

    Abstract: The data storage system according to certain aspects can implement table level database restore. Table level database restore may refer to restoring a database table and its related data without restoring the entire database. The data storage system may use table metadata index to implement table level restore. A table metadata index may be created for each table, e.g., during a backup of the database. The table metadata index for a table can include any type of information for restoring the table and its related data. Some examples of the type of information included in the table metadata index include the following: container for the table, table backup location, system data, table index, table relationships, etc. Table metadata index can make the restoring of tables fast and efficient by packaging information that can be used to restore a table and its related data in an easily accessible manner.

Patent Agency Ranking