利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

28 条记录 (耗时 0.038 秒)

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

    公开(公告)号：US07694102B2

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

    申请号：US11278130

    申请日：2006-03-30

    申请人： Christian Marcelo Garcia-Arellano ,  Sam Sampson Lightstone ,  Adam J. Storm ,  Wojciech Kuczynski ,  Matthew Albert Huras ,  Xun Xue ,  Matthew James Carroll

    发明人： Christian Marcelo Garcia-Arellano ,  Sam Sampson Lightstone ,  Adam J. Storm ,  Wojciech Kuczynski ,  Matthew Albert Huras ,  Xun Xue ,  Matthew James Carroll

    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, system and article of manufacture for improving execution efficiency of a database workload
    13.
    发明授权
    Method, system and article of manufacture for improving execution efficiency of a database workload 失效
    用于提高数据库工作负载的执行效率的方法，系统和制造

    公开(公告)号：US07483873B2

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

    申请号：US11038513

    申请日：2005-01-18

    申请人： Bishwaranjan Bhattacharjee ,  Sam Sampson Lightstone ,  Timothy Ray Malkemus ,  Sriram K. Padmanabhan ,  Adam J. Storm ,  Daniele Costante Zilio

    发明人： Bishwaranjan Bhattacharjee ,  Sam Sampson Lightstone ,  Timothy Ray Malkemus ,  Sriram K. Padmanabhan ,  Adam J. Storm ,  Daniele Costante Zilio

    IPC分类号： G06F7/00 ,  G06F17/30

    CPC分类号： G06F17/30592 ,  G06F17/30306 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

    摘要： 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.

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

    Providing cost model data for tuning of query cache memory in databases
    14.
    发明授权
    Providing cost model data for tuning of query cache memory in databases 失效
    提供用于调整数据库中查询缓存的成本模型数据

    公开(公告)号：US07502775B2

    公开(公告)日：2009-03-10

    申请号：US11278373

    申请日：2006-03-31

    申请人： Matthew James Carroll ,  Christian Marcelo Garcia-Arellano ,  Sam Sampson Lightstone ,  Michael Joshua Snowbell ,  Adam J. Storm

    发明人： Matthew James Carroll ,  Christian Marcelo Garcia-Arellano ,  Sam Sampson Lightstone ,  Michael Joshua Snowbell ,  Adam J. Storm

    IPC分类号： G06F17/30 ,  G06F12/00

    CPC分类号： G06F17/30587 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99953

    摘要： Providing cost model data for tuning query cache memory size in database systems. In one aspect, a query is received, and a query cache is checked for a stored query matching the received query. In response to a cache miss occurring, a token representing the received query is generated and checked for matching a token stored in a simulation area, each stored token representing a query object previously evicted from the query cache. A processing time saved by an avoidance of the cache miss is determined, and a cache size needed to avoid the cache miss is determined only when the generated token matches a stored token, by summing sizes of all query objects represented by the stored tokens. Each stored token is included in a stub that also includes the size of the represented query object and an identification number indicating a stored order.

    摘要翻译： 提供用于在数据库系统中调优查询缓存内存大小的成本模型数据。 在一个方面，接收到查询，并且检查与所接收的查询匹配的存储的查询的查询高速缓存。 响应于发生的高速缓存未命中，生成表示所接收的查询的令牌并检查其匹配存储在模拟区域中的令牌，每个存储的令牌表示先前从查询缓存中逐出的查询对象。 确定避免高速缓存未命中所节省的处理时间，并且仅当所生成的令牌与所存储的令牌相匹配时才通过对所存储的令牌表示的所有查询对象的大小相加来确定避免高速缓存未命中所需的高速缓存大小。 每个存储的令牌都包含在存根中，该存根还包括所表示的查询对象的大小和指示存储顺序的标识号。

    Method and apparatus for automatic recommendation and selection of clustering indexes
    16.
    发明授权
    Method and apparatus for automatic recommendation and selection of clustering indexes 失效
    自动推荐和选择聚类指标的方法和装置

    公开(公告)号：US07548903B2

    公开(公告)日：2009-06-16

    申请号：US11033327

    申请日：2005-01-11

    申请人： Fei Yen Chiang ,  Leslie Anne Cranston ,  Sam Sampson Lightstone ,  Daniele Costante Zilio

    发明人： Fei Yen Chiang ,  Leslie Anne Cranston ,  Sam Sampson Lightstone ,  Daniele Costante Zilio

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30312 ,  Y10S707/99932 ,  Y10S707/99933

    摘要： A method, apparatus, and computer instructions for selecting and recommending of clustering indexes are provided. Baseline run time cost estimates are calculated based on database designs. Workload benefit of a candidate clustering design is calculated and compared to the baseline costs. If the workload benefit outweighs the baseline costs, clustering dimension solutions originated from the record identifier (RID) based index are identified. A clustering design is selected based on the identified clustering dimension solutions and the total number of recommended clustering dimensions for a given table. Based on the number of dimensions observed, either a multidimensional clustering solution or a RID based clustering index is recommended.

    摘要翻译： 提供了一种用于选择和推荐聚类索引的方法，装置和计算机指令。 基线运行时间成本估算是基于数据库设计计算的。 计算候选聚类设计的工作量优势，并与基准成本进行比较。 如果工作负载的利益超过基准成本，则识别出基于记录标识符（RID）的索引的聚类维度解。 基于识别的聚类维度解决方案和给定表格的推荐聚类维数的总数，选择聚类设计。 基于所观察的维数，推荐使用多维聚类解决方案或基于RID的聚类索引。