Multi-Part Aggregated Variable in Structured External Storage
    1.
    发明申请
    Multi-Part Aggregated Variable in Structured External Storage 有权
    结构化外部存储中的多部分聚合变量

    公开(公告)号:US20110302375A1

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

    申请号:US12795205

    申请日:2010-06-07

    IPC分类号: G06F12/00

    CPC分类号: G06F17/30348

    摘要: A mechanism is provided for multi-part aggregated variables in structured external storage. The shared external storage provides a serialized, aggregated structure update capability. The shared external storage identifies each local value for which a group value is needed by name. Each time a member writes out its value, the member specifies the name of the object, the member's current value, and the type of aggregate function to apply (e.g., minimum, maximum, etc.). The structured external storage in one atomic operation updates the member's value, recalculates the aggregate of all of the individual values, and returns the aggregate to the member. The advantage of this approach is that it requires only one write operation to the structured external storage. The update operation does not require locking, because the operation is atomic.

    摘要翻译: 为结构化外部存储中的多部分聚合变量提供了一种机制。 共享外部存储提供了一个序列化的聚合结构更新功能。 共享的外部存储器通过名称标识需要组值的每个本地值。 每次成员写出其值时,成员将指定对象的名称,成员的当前值以及要应用的聚合函数的类型(例如最小值,最大值等)。 一个原子操作中的结构化外部存储更新成员的值,重新计算所有单个值的聚合,并将聚合返回给成员。 这种方法的优点是只需要对结构化外部存储器进行一次写操作。 更新操作不需要锁定,因为操作是原子的。

    Multi-part aggregated variable in structured external storage
    2.
    发明授权
    Multi-part aggregated variable in structured external storage 有权
    结构化外部存储中的多部分聚合变量

    公开(公告)号:US08838910B2

    公开(公告)日:2014-09-16

    申请号:US12795205

    申请日:2010-06-07

    IPC分类号: G06F12/00 G06F17/30

    CPC分类号: G06F17/30348

    摘要: A mechanism is provided for multi-part aggregated variables in structured external storage. The shared external storage provides a serialized, aggregated structure update capability. The shared external storage identifies each local value for which a group value is needed by name. Each time a member writes out its value, the member specifies the name of the object, the member's current value, and the type of aggregate function to apply (e.g., minimum, maximum, etc.). The structured external storage in one atomic operation updates the member's value, recalculates the aggregate of all of the individual values, and returns the aggregate to the member. The advantage of this approach is that it requires only one write operation to the structured external storage. The update operation does not require locking, because the operation is atomic.

    摘要翻译: 为结构化外部存储中的多部分聚合变量提供了一种机制。 共享外部存储提供了一个序列化的聚合结构更新功能。 共享的外部存储器通过名称标识需要组值的每个本地值。 每次成员写出其值时,成员将指定对象的名称,成员的当前值以及要应用的聚合函数的类型(例如最小值,最大值等)。 一个原子操作中的结构化外部存储更新成员的值,重新计算所有单个值的聚合,并将聚合返回给成员。 这种方法的优点是只需要对结构化外部存储器进行一次写操作。 更新操作不需要锁定,因为操作是原子的。

    Method, system and article of manufacture for improving execution efficiency of a database workload
    5.
    发明授权
    Method, system and article of manufacture for improving execution efficiency of a database workload 失效
    用于提高数据库工作负载的执行效率的方法,系统和制造

    公开(公告)号:US07483873B2

    公开(公告)日:2009-01-27

    申请号:US11038513

    申请日:2005-01-18

    IPC分类号: G06F7/00 G06F17/30

    摘要: Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for improving execution efficiency of a database workload to be executed against a database. The database includes database tables, and the database workload identifies at least one of the database tables. The data processing system includes an identification module for identifying candidate database tables being identifiable in the database workload, the identified candidate database tables being eligible for organization under a clustering schema, a selection module for selecting the identified candidate tables according to whether execution of the database workload is improved if the selected identified candidate table is organized according to the clustering scheme, and an organization module for organizing the clustering schema of the selected organized identified candidate tables prior to the database workload being execution against the database.

    摘要翻译: 公开了一种数据处理系统实现的方法,数据处理系统和制品,用于提高要对数据库执行的数据库工作负荷的执行效率。 数据库包括数据库表,数据库工作负载标识至少一个数据库表。 数据处理系统包括识别模块,用于识别在数据库工作负载中可识别的候选数据库表,所识别的候选数据库表有资格在聚类模式下组织;选择模块,用于根据数据库的执行来选择所识别的候选表 如果所选择的识别的候选表根据聚类方案进行组织,则工作量得到改善;以及组织模块,用于在数据库工作负载正在针对数据库执行之前组织所选择的组织识别的候选表的聚类模式。

    Systems and methods for self-tuning memory
    8.
    发明授权
    Systems and methods for self-tuning memory 有权
    自调整内存的系统和方法

    公开(公告)号:US07694102B2

    公开(公告)日:2010-04-06

    申请号:US11278130

    申请日:2006-03-30

    IPC分类号: G06F12/02 G06F12/16 G06F13/24

    CPC分类号: G06F12/0646 G06F12/0223

    摘要: There are disclosed systems, computer program products, and methods for self-tuning memory. In an embodiment, a method for self-tuning memory comprises setting a tuning interval and a target range for free memory for a memory pool. If memory consumption falls outside of the set target range for free memory during a tuning interval, a new target size for the memory pool is set based on the target range for free memory. Memory allocation for the memory pool is increased or decreased for the next tuning interval, such that the new target size for the memory pool is reached. A decrement rate may be used to provide a controlled decrease of the memory pool over a plurality of tuning intervals if necessary, until the new target size for the memory pool is reached.

    摘要翻译: 已经公开了系统,计算机程序产品和用于自调整存储器的方法。 在一个实施例中,一种用于自调整存储器的方法包括设置用于存储器池的空闲存储器的调谐间隔和目标范围。 如果内存消耗在调整间隔期间超出了可用内存的设置目标范围,则基于可用内存的目标范围设置内存池的新目标大小。 内存池的内存分配在下一个调整间隔内增加或减少,从而达到内存池的新目标大小。 如果需要,减量率可以用于在多个调谐间隔中提供存储池的受控减少,直到达到存储器池的新目标大小。

    METHOD AND APPARATUS FOR ONLINE SAMPLE INTERVAL DETERMINATION
    9.
    发明申请
    METHOD AND APPARATUS FOR ONLINE SAMPLE INTERVAL DETERMINATION 失效
    在线样品间隔测定的方法和装置

    公开(公告)号:US20080263563A1

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

    申请号:US12165009

    申请日:2008-06-30

    IPC分类号: G06F9/50

    摘要: In one embodiment, functional system elements are added to an autonomic manager to enable automatic online sample interval selection. In another embodiment, a method for determining the sample interval by continually characterizing the system workload behavior includes monitoring the system data and analyzing the degree to which the workload is stationary. This makes the online optimization method less sensitive to system noise and capable of being adapted to handle different workloads. The effectiveness of the autonomic optimizer is thereby improved, making it easier to manage a wide range of systems.

    摘要翻译: 在一个实施例中,将功能系统元件添加到自主管理器以启用自动在线采样间隔选择。 在另一个实施例中,用于通过连续地表征系统工作负载行为来确定采样间隔的方法包括监视系统数据并分析工作负载静止的程度。 这使得在线优化方法对系统噪声不太敏感,并且能够适应于处理不同的工作负载。 从而改进了自主优化器的有效性,从而更容易地管理广泛的系统。

    System and method for autonomically reallocating memory among buffer pools
    10.
    发明授权
    System and method for autonomically reallocating memory among buffer pools 失效
    在缓冲池中自动重新分配内存的系统和方法

    公开(公告)号:US06961835B2

    公开(公告)日:2005-11-01

    申请号:US10391686

    申请日:2003-03-19

    摘要: A system and method autonomically reallocate memory among buffer pools to permit quick access to data. A simulated buffer pool extension (SBPX) is created for each buffer pool in a set of buffer pools. Data victimized from a buffer pool is represented in the associated SBPX. Requests for data that is not resident in a buffer pool but is represented in the associated SBPX are tallied. Periodically, an expected efficiency benefit of increasing the capacity of each buffer pool is determined from the tallies. Memory is reallocated from the buffer pool with the lowest expected efficiency benefit having remaining reallocatable memory to the buffer pool with the highest expected efficiency benefit having remaining reallocatable memory, until either one or both of the buffer pools exhausts its reallocatable memory. This process is repeated until all reallocatable memory has been reallocated, until only one buffer pool with reallocatable memory remains, or until all buffer pools with remaining reallocatable memory have substantially the same expected efficiency benefit.

    摘要翻译: 系统和方法在缓冲池中自动重新分配内存,以便快速访问数据。 为一组缓冲池中的每个缓冲池创建模拟缓冲池扩展(SBPX)。 从缓冲池中受害的数据在关联的SBPX中表示。 对不驻留在缓冲池中但在关联的SBPX中表示的数据的请求进行计数。 定期地,从提示中确定增加每个缓冲池容量的预期效率效益。 从缓冲池中重新分配内存,将预留效率最低的优点在于具有剩余可重新分配内存到具有剩余可重新分配内存的最高预期效率优势的缓冲池,直到缓冲池中的一个或两者都耗尽其可重新分配的内存。 重复此过程,直到所有可重新分配的内存已重新分配,直到只有一个具有可重新分配内存的缓冲池保留,或者直到具有剩余可重新分配内存的所有缓冲池具有基本相同的预期效率优势。