会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 5. 发明申请
    • PREVENTION OF REDUNDANT INDEXES IN A DATABASE MANAGEMENT SYSTEM
    • 防止数据库管理系统中的冗余索引
    • US20100036864A1
    • 2010-02-11
    • US12185847
    • 2008-08-05
    • Oliver AugensteinNamik HrleThomas RitterAndreas Uhl
    • Oliver AugensteinNamik HrleThomas RitterAndreas Uhl
    • G06F17/30
    • 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值,并且新索引在现有索引的基础上是冗余的,则不会创建新的索引。
    • 6. 发明授权
    • Hierarchical storage management for database systems
    • 数据库系统的分层存储管理
    • US08639880B2
    • 2014-01-28
    • US13563592
    • 2012-07-31
    • Oliver AugensteinStefan BenderKarl FleckensteinAndreas Uhl
    • Oliver AugensteinStefan BenderKarl FleckensteinAndreas Uhl
    • G06F12/00
    • G06F17/30221G06F1/3203G06F1/3268G06F1/3287G06F3/0625G06F3/0634G06F3/0665G06F3/068Y02D10/154Y02D10/171Y02D10/45
    • 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.
    • 用于管理存储数据库系统的数据块的分层存储服务器中的数据的实施例包括处于主动模式的主存储装置和处于主动模式和被动模式之一的辅助存储装置。 响应于对逻辑存储位置的数据块的读取和写入请求,块映射设备确定存储设备上的物理存储位置。 读取请求在二级存储设备处于被动模式时切换到活动模式。 写入请求仅将数据块写入主存储设备。 在最小启动时间内未访问的辅助存储设备可能会从主动模式切换到被动模式,以节省功耗和冷却。 数据迁移和数据调用策略控制主存储设备和辅助存储设备之间数据块的移动,主要基于阈值。
    • 7. 发明授权
    • Prevention of redundant indexes in a database management system
    • 预防数据库管理系统中的冗余索引
    • US08055646B2
    • 2011-11-08
    • US12185847
    • 2008-08-05
    • Oliver AugensteinNamik HrleThomas RitterAndreas Uhl
    • Oliver AugensteinNamik HrleThomas RitterAndreas Uhl
    • G06F7/00G06F17/30
    • 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值,并且新索引在现有索引的基础上是冗余的,则不会创建新的索引。