专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20090216709A1 OPTIMIZED COLLECTION OF JUST-IN-TIME STATISTICS FOR DATABASE QUERY OPTIMIZATION 失效
标题翻译：优化收集用于数据库查询优化的即时统计
公开(公告)号：US20090216709A1
公开(公告)日：2009-08-27
申请号：US12038054
申请日：2008-02-27
申请人： Qi Cheng , John Frederick Hornibrook , Wing Yan Lau , Ivan Popivanov , Xiaoyan Qian , Michael Joshua Snowbell , Michael Arthur Franciscus Stuy , Calisto Paul Zuzarte
发明人： Qi Cheng , John Frederick Hornibrook , Wing Yan Lau , Ivan Popivanov , Xiaoyan Qian , Michael Joshua Snowbell , Michael Arthur Franciscus Stuy , Calisto Paul Zuzarte
IPC分类号： G06F7/06
CPC分类号： G06F17/30442
摘要： A system and method are provided for updating database statistics for use in generating query execution plans. A first query for a database is received, for example by a compiler, and the compiler accesses statistics associated with the first query for optimizing a query execution plan for the first query. The statistics may be accessed from a first cache. If the statistics retrieved from the first cache are determined to be stale, the system obtains updated statistics and may store them in a temporary cache. The stale statistics in the first cache are marked as invalid. Existing queries using the first cache may continue to use the first cache, while new queries may be provided with updated statistics.
摘要翻译：提供了一种用于更新数据库统计信息以用于生成查询执行计划的系统和方法。例如由编译器接收对数据库的第一个查询，并且编译器访问与第一个查询关联的统计信息，以优化第一个查询的查询执行计划。可以从第一缓存访问统计信息。如果从第一个缓存检索到的统计信息被确定为陈旧，系统将获得更新的统计信息，并将其存储在临时缓存中。第一个缓存中的陈旧统计信息被标记为无效。使用第一缓存的现有查询可以继续使用第一高速缓存，而可以向更新的统计信息提供新的查询。

2. 发明授权

US07917502B2 Optimized collection of just-in-time statistics for database query optimization 失效
标题翻译：优化数据库查询优化的即时统计数据收集
公开(公告)号：US07917502B2
公开(公告)日：2011-03-29
申请号：US12038054
申请日：2008-02-27
申请人： Qi Cheng , John Frederick Hornibrook , Wing Yan Lau , Ivan Popivanov , Xiaoyan Qian , Michael Joshua Snowbell , Michael Arthur Franciscus Stuy , Calisto Paul Zuzarte
发明人： Qi Cheng , John Frederick Hornibrook , Wing Yan Lau , Ivan Popivanov , Xiaoyan Qian , Michael Joshua Snowbell , Michael Arthur Franciscus Stuy , Calisto Paul Zuzarte
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30442
摘要： A system and method are provided for updating database statistics for use in generating query execution plans. A first query for a database is received, for example by a compiler, and the compiler accesses statistics associated with the first query for optimizing a query execution plan for the first query. The statistics may be accessed from a first cache. If the statistics retrieved from the first cache are determined to be stale, the system obtains updated statistics and may store them in a temporary cache. The stale statistics in the first cache are marked as invalid. Existing queries using the first cache may continue to use the first cache, while new queries may be provided with updated statistics.
摘要翻译：提供了一种用于更新数据库统计信息以用于生成查询执行计划的系统和方法。例如由编译器接收对数据库的第一个查询，并且编译器访问与第一个查询关联的统计信息，以优化第一个查询的查询执行计划。可以从第一缓存访问统计信息。如果从第一个缓存检索到的统计信息被确定为陈旧，系统将获得更新的统计信息，并将其存储在临时缓存中。第一个缓存中的陈旧统计信息被标记为无效。使用第一缓存的现有查询可以继续使用第一高速缓存，而可以向更新的统计信息提供新的查询。

3. 发明授权

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

4. 发明授权

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

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式