Hierarchical storage management for database systems
    1.
    发明授权
    Hierarchical storage management for database systems 有权
    数据库系统的分层存储管理

    公开(公告)号:US08639880B2

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

    申请号:US13563592

    申请日:2012-07-31

    IPC分类号: G06F12/00

    摘要: Embodiments for managing data in a hierarchical storage server storing data blocks of a database system comprising primary storage devices being in an active mode and secondary storage devices being in one of an active and passive mode are provided. In response to read and write requests for data blocks at logical storage locations, a block mapping device determines physical storage locations on the storage devices. Read requests switch over secondary storage devices to the active mode when they are in the passive mode. Write requests write data blocks only to the primary storage devices. Secondary storage devices that have not been accessed for a minimum activation time may be switched over from the active to the passive mode to save power consumption and cooling. Data migration and data recall policies control moving of data blocks between the primary and secondary storage devices and are primarily based on threshold values.

    摘要翻译: 用于管理存储数据库系统的数据块的分层存储服务器中的数据的实施例包括处于主动模式的主存储装置和处于主动模式和被动模式之一的辅助存储装置。 响应于对逻辑存储位置的数据块的读取和写入请求,块映射设备确定存储设备上的物理存储位置。 读取请求在二级存储设备处于被动模式时切换到活动模式。 写入请求仅将数据块写入主存储设备。 在最小启动时间内未访问的辅助存储设备可能会从主动模式切换到被动模式,以节省功耗和冷却。 数据迁移和数据调用策略控制主存储设备和辅助存储设备之间数据块的移动,主要基于阈值。

    HIERARCHICAL STORAGE MANAGEMENT FOR DATABASE SYSTEMS
    2.
    发明申请
    HIERARCHICAL STORAGE MANAGEMENT FOR DATABASE SYSTEMS 有权
    数据库系统的分层存储管理

    公开(公告)号:US20120297138A1

    公开(公告)日:2012-11-22

    申请号:US13563592

    申请日:2012-07-31

    IPC分类号: G06F12/08

    摘要: Embodiments for managing data in a hierarchical storage server storing data blocks of a database system comprising primary storage devices being in an active mode and secondary storage devices being in one of an active and passive mode are provided. In response to read and write requests for data blocks at logical storage locations, a block mapping device determines physical storage locations on the storage devices. Read requests switch over secondary storage devices to the active mode when they are in the passive mode. Write requests write data blocks only to the primary storage devices. Secondary storage devices that have not been accessed for a minimum activation time may be switched over from the active to the passive mode to save power consumption and cooling. Data migration and data recall policies control moving of data blocks between the primary and secondary storage devices and are primarily based on threshold values.

    摘要翻译: 用于管理存储数据库系统的数据块的分层存储服务器中的数据的实施例包括处于活动模式的主存储设备和处于主动模式和被动模式之一的辅助存储设备。 响应于对逻辑存储位置的数据块的读取和写入请求,块映射设备确定存储设备上的物理存储位置。 读取请求在二级存储设备处于被动模式时切换到活动模式。 写入请求仅将数据块写入主存储设备。 在最小启动时间内未访问的辅助存储设备可能会从主动模式切换到被动模式,以节省功耗和冷却。 数据迁移和数据调用策略控制主存储设备和辅助存储设备之间数据块的移动,主要基于阈值。

    HIERARCHICAL STORAGE MANAGEMENT FOR DATABASE SYSTEMS
    5.
    发明申请
    HIERARCHICAL STORAGE MANAGEMENT FOR DATABASE SYSTEMS 有权
    数据库系统的分层存储管理

    公开(公告)号:US20120221791A1

    公开(公告)日:2012-08-30

    申请号:US13463711

    申请日:2012-05-03

    IPC分类号: G06F12/08 G06F12/16

    摘要: In response to read and write requests for data blocks at logical storage locations, a block mapping device determines physical storage locations on the storage devices. Read requests switch over secondary storage devices to the active mode when they are in the passive mode. Write requests write data blocks only to the primary storage devices. Secondary storage devices that have not been accessed for a minimum activation time may be switched over from the active to the passive mode to save power consumption and cooling. Data migration and data recall policies control moving of data blocks between the primary and secondary storage devices and are primarily based on threshold values.

    摘要翻译: 响应于对逻辑存储位置的数据块的读取和写入请求,块映射设备确定存储设备上的物理存储位置。 读取请求在二级存储设备处于被动模式时切换到活动模式。 写入请求仅将数据块写入主存储设备。 在最小启动时间内未访问的辅助存储设备可能会从主动模式切换到被动模式,以节省功耗和冷却。 数据迁移和数据调用策略控制主存储设备和辅助存储设备之间数据块的移动,主要基于阈值。

    Prevention of redundant indexes in a database management system
    6.
    发明授权
    Prevention of redundant indexes in a database management system 有权
    预防数据库管理系统中的冗余索引

    公开(公告)号:US08055646B2

    公开(公告)日:2011-11-08

    申请号:US12185847

    申请日:2008-08-05

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30336

    摘要: A method and system for preventing redundant indexes in a database management system (DBMS). A received create-index command specifies a new index to be created for retrieving data from a table created by the DBMS and a redundancy check to be performed for the new index in conjunction with an action parameter in the create-index command. If the action parameter includes a REPORT value, each redundant index is stored and/or displayed and the new index is created. If the action parameter includes a PREVENT value and an existing index is redundant in view of the new index and the new index is not redundant in view of the existing index, the existing index is deleted and the new index is created. If the action parameter includes a PREVENT value and the new index is redundant in view of an existing index, the new index is not created.

    摘要翻译: 一种用于防止数据库管理系统(DBMS)中的冗余索引的方法和系统。 接收到的create-index命令指定要创建的新索引,用于从DBMS创建的表中检索数据,并结合create-index命令中的action参数为新索引执行冗余检查。 如果操作参数包含REPORT值,则存储和/或显示每个冗余索引,并创建新的索引。 如果action参数包含PREVENT值,并且现有索引在查看新索引的情况下是冗余的,并且鉴于现有索引,新索引不是冗余的,则现有索引将被删除,并创建新的索引。 如果操作参数包含PREVENT值,并且新索引在现有索引的基础上是冗余的,则不会创建新的索引。

    GENERATING AND INDICATING INCREMENTAL BACKUP COPIES FROM VIRTUAL COPIES OF A DATA SET
    7.
    发明申请
    GENERATING AND INDICATING INCREMENTAL BACKUP COPIES FROM VIRTUAL COPIES OF A DATA SET 有权
    从数据集的虚拟副本生成和指示增量备份副本

    公开(公告)号:US20080243954A1

    公开(公告)日:2008-10-02

    申请号:US11695544

    申请日:2007-04-02

    IPC分类号: G06F12/16

    摘要: Provided are a method, system, and program for generating and indicating incremental backup copies from virtual copies of a data set. A virtual copy operation is initiated to create a virtual copy of a data set, wherein the virtual copy represents the data set at a point-in-time copy, and wherein the virtual copy is completed without transferring the data set to a backup location. An incremental backup operation is initiated with respect to an identified virtual copy, wherein the incremental backup operation copies changes to the data set that occur since a most recent creation of an incremental backup set.

    摘要翻译: 提供了一种用于从数据集的虚拟副本生成和指示增量备份副本的方法,系统和程序。 启动虚拟复制操作以创建数据集的虚拟副本,其中虚拟副本在时间点副本中表示数据集,并且其中完成虚拟副本而不将数据集传送到备份位置。 相对于识别的虚拟副本启动增量备份操作,其中增量备份操作将更改复制到自增量备份集最近创建以来发生的数据集。

    Hierarchical storage management for database systems
    9.
    发明授权
    Hierarchical storage management for database systems 有权
    数据库系统的分层存储管理

    公开(公告)号:US08316182B2

    公开(公告)日:2012-11-20

    申请号:US12797942

    申请日:2010-06-10

    IPC分类号: G06F12/00

    摘要: In response to read and write requests for data blocks at logical storage locations, a block mapping device determines physical storage locations on the storage devices. Read requests switch over secondary storage devices to the active mode when they are in the passive mode. Write requests write data blocks only to the primary storage devices. Secondary storage devices that have not been accessed for a minimum activation time may be switched over from the active to the passive mode to save power consumption and cooling. Data migration and data recall policies control moving of data blocks between the primary and secondary storage devices and are primarily based on threshold values.

    摘要翻译: 响应于对逻辑存储位置的数据块的读取和写入请求,块映射设备确定存储设备上的物理存储位置。 读取请求在二级存储设备处于被动模式时切换到活动模式。 写入请求仅将数据块写入主存储设备。 在最小启动时间内未访问的辅助存储设备可能会从主动模式切换到被动模式,以节省功耗和冷却。 数据迁移和数据调用策略控制主存储设备和辅助存储设备之间数据块的移动,主要基于阈值。

    Hierarchical storage management for database systems
    10.
    发明授权
    Hierarchical storage management for database systems 有权
    数据库系统的分层存储管理

    公开(公告)号:US08380929B2

    公开(公告)日:2013-02-19

    申请号:US13463711

    申请日:2012-05-03

    IPC分类号: G06F12/00

    摘要: In response to read and write requests for data blocks at logical storage locations, a block mapping device determines physical storage locations on the storage devices. Read requests switch over secondary storage devices to the active mode when they are in the passive mode. Write requests write data blocks only to the primary storage devices. Secondary storage devices that have not been accessed for a minimum activation time may be switched over from the active to the passive mode to save power consumption and cooling. Data migration and data recall policies control moving of data blocks between the primary and secondary storage devices and are primarily based on threshold values.

    摘要翻译: 响应于对逻辑存储位置的数据块的读取和写入请求,块映射设备确定存储设备上的物理存储位置。 读取请求在二级存储设备处于被动模式时切换到活动模式。 写入请求仅将数据块写入主存储设备。 在最小启动时间内未访问的辅助存储设备可能会从主动模式切换到被动模式,以节省功耗和冷却。 数据迁移和数据调用策略控制主存储设备和辅助存储设备之间数据块的移动,主要基于阈值。