利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

4 条记录 (耗时 0.038 秒)

    Providing cost model data for tuning of query cache memory in databases
    3.
    发明授权
    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 cross-node sharing of cached dynamic SQL in a multiple relational database management system environment
    4.
    发明授权
    Method and apparatus for cross-node sharing of cached dynamic SQL in a multiple relational database management system environment 失效
    在多个关系数据库管理系统环境中缓存动态SQL的跨节点共享的方法和装置

    公开(公告)号：US06598058B2

    公开(公告)日：2003-07-22

    申请号：US09404438

    申请日：1999-09-22

    申请人： Paul Miller Bird ,  Michael Joshua Snowbell

    发明人： Paul Miller Bird ,  Michael Joshua Snowbell

    IPC分类号： G06F1730

    CPC分类号： G06F17/30595 ,  Y10S707/99931 ,  Y10S707/99952 ,  Y10S707/99953

    摘要： The invention provides a data processing system, a method, computer program product and software for operating it where the data processing system includes a number of interconnected nodes. At least one data partition resides on one of the nodes, and one or more tables reside in a data partition. One of the nodes has a catalogue containing metadata describing tables and other objects and relationships therebetween in the data processing system. There is a global instruction cache at each node having a statement portion storing instruction statements and associated executables; each of the executable is designed for a particular environment; the instruction cache includes a dependency portion which lists objects and links them to the corresponding executable entries that depend on the objects; the instruction cache includes a shipped variation portion, each entry of the shipped variation portion refers to one executable entry and identifies the node from which the statement associated with the executable was originally shipped and the identification of such executable in the node from which it was originally shipped. The cache includes an invalidations in progress portion, each entry of the invalidations in progress portion refers to an object entry in the dependency portion.

    摘要翻译： 本发明提供一种数据处理系统，方法，计算机程序产品和用于操作其的软件，其中数据处理系统包括多个互连节点。 至少一个数据分区位于其中一个节点上，一个或多个表驻留在数据分区中。 其中一个节点具有包含在数据处理系统中描述表和其它对象之间的元数据的目录。 每个节点都有一个全局指令缓存，其中有一个存储指令语句和关联的可执行文件的语句部分; 每个可执行文件是针对特定环境而设计的; 指令高速缓存包括依赖部分，其列出对象并将它们链接到依赖于对象的相应可执行条目; 指令高速缓存包括运送的变化部分，所运送的变化部分的每个条目涉及一个可执行条目，并且识别与该可执行文件相关联的语句最初出货的节点以及从其原始的节点中的这种可执行文件的标识 发货。 高速缓存包括在进行中的无效部分，正在进行的部分中的无效的每个条目是指依赖关系部分中的对象条目。