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

1. 发明申请

US20100036805A1 System Maintainable and Reusable I/O Value Caches 审中-公开
标题翻译：系统可维护和可重用的I / O值缓存
公开(公告)号：US20100036805A1
公开(公告)日：2010-02-11
申请号：US12185853
申请日：2008-08-05
申请人： Thomas William Blamer , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Thomas William Blamer , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F17/30
CPC分类号： G06F16/24539
摘要： Embodiments of the invention provide techniques for maintaining I/O value caches for database queries. Each maintained cache may be configured for use with a particular database query. Each cache may be persistently maintained in a system, meaning the cache is not automatically deleted after some period of time, and may thus be used to process subsequent instances of the same query. By use of the maintained cache, executing subsequent instances of the query may be avoided, thus saving time and system resources. Further, the maintained cache may be adapted to process other queries having similar characteristics to the initial query. The data included in each cache may be refreshed as required by changes to the underlying data.
摘要翻译：本发明的实施例提供了用于维护用于数据库查询的I / O值高速缓存的技术。每个维护的缓存可以被配置为与特定数据库查询一起使用。每个高速缓存可以被持续地维护在系统中，这意味着高速缓存在一段时间之后不被自动删除，并且因此可以用于处理同一查询的后续实例。通过使用维护的缓存，可以避免执行后续的查询实例，从而节省时间和系统资源。此外，维护的高速缓存可以适于处理具有与初始查询相似的特征的其他查询。每个缓存中包括的数据可以根据底层数据的更改的要求进行刷新。

2. 发明申请

US20100036804A1 Maintained and Reusable I/O Value Caches 审中-公开
标题翻译：维护和可重用的I / O值缓存
公开(公告)号：US20100036804A1
公开(公告)日：2010-02-11
申请号：US12185844
申请日：2008-08-05
申请人： Thomas William Blamer , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Thomas William Blamer , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F17/30
CPC分类号： G06F16/24552
摘要： Embodiments of the invention provide techniques for maintaining I/O value caches for database queries. Each maintained cache may be configured for use with a particular database query. Each cache may be persistently maintained in a system, meaning the cache is not automatically deleted after some period of time, and may thus be used to process subsequent instances of the same query. By use of the maintained cache, executing subsequent instances of the query may be avoided, thus saving time and system resources. Further, the maintained cache may be adapted to process other queries having similar characteristics to the initial query. The data included in each cache may be refreshed as required by changes to the underlying data.
摘要翻译：本发明的实施例提供了用于维护用于数据库查询的I / O值高速缓存的技术。每个维护的缓存可以被配置为与特定数据库查询一起使用。每个高速缓存可以被持续地维护在系统中，这意味着高速缓存在一段时间之后不被自动删除，并且因此可以用于处理同一查询的后续实例。通过使用维护的缓存，可以避免执行后续的查询实例，从而节省时间和系统资源。此外，维护的高速缓存可以适于处理具有与初始查询相似的特征的其他查询。每个缓存中包括的数据可以根据底层数据的更改的要求进行刷新。

3. 发明授权

US08082265B2 Database query processing with dynamically activated buffers 失效
标题翻译：使用动态激活的缓冲区进行数据库查询处理
公开(公告)号：US08082265B2
公开(公告)日：2011-12-20
申请号：US12056344
申请日：2008-03-27
申请人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F7/00
CPC分类号： G06F17/30474 , G06F17/30445 , G06F17/30457 , G06F17/30466
摘要： A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and activation is based on the monitoring of information associated with the consumption of data by a plurality of threads during execution of an access plan for the database query. By doing so, the selection of a less optimal buffer position during optimization may be replaced with a more optimal buffer position during runtime, often resulting in improved query performance and parallelism.
摘要翻译：方法，装置和程序产品在执行数据库查询期间动态地激活和/或停用缓冲器。动态去激活和激活是基于在用于数据库查询的访问计划的执行期间监视与多个线程的数据消耗相关联的信息。通过这样做，在优化期间选择较不优化的缓冲器位置可以在运行时期间用更优化的缓冲器位置代替，通常导致改进的查询性能和并行性。

4. 发明申请

US20090248618A1 Database Query Processing with Dynamically Activated Buffers 失效
标题翻译：动态激活缓冲区的数据库查询处理
公开(公告)号：US20090248618A1
公开(公告)日：2009-10-01
申请号：US12056344
申请日：2008-03-27
申请人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F7/06
CPC分类号： G06F17/30474 , G06F17/30445 , G06F17/30457 , G06F17/30466
摘要： A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and activation is based on the monitoring of information associated with the consumption of data by a plurality of threads during execution of an access plan for the database query. By doing so, the selection of a less optimal buffer position during optimization may be replaced with a more optimal buffer position during runtime, often resulting in improved query performance and parallelism.
摘要翻译：方法，装置和程序产品在执行数据库查询期间动态地激活和/或停用缓冲器。动态去激活和激活是基于在用于数据库查询的访问计划的执行期间监视与多个线程的数据消耗相关联的信息。通过这样做，在优化期间选择较不优化的缓冲器位置可以在运行时期间用更优化的缓冲器位置代替，通常导致改进的查询性能和并行性。

5. 发明申请

US20090150560A1 REAL-TIME MINING AND REDUCTION OF STREAMED DATA 失效
标题翻译：实时采矿和减少流动数据
公开(公告)号：US20090150560A1
公开(公告)日：2009-06-11
申请号：US12372850
申请日：2009-02-18
申请人： Robert Joseph Bestgen , David Glenn Carlson , Kevin James Kathmann
发明人： Robert Joseph Bestgen , David Glenn Carlson , Kevin James Kathmann
IPC分类号： G06F15/16 , G06K9/36 , G06F17/30
CPC分类号： G06F17/30516
摘要： A stream data node receives real-time streamed data from one or more input devices, dynamically filters the streamed data to reduce the streamed data, and delivers the reduced data when requested. By providing real-time filtering of the data, the amount of data that must be stored in a database may be substantially reduced. The stream data node can perform aggregation functions, group functions, and select functions, thereby also significantly reducing the amount of data that must be stored in a database. The stream data node may also be part of a query execution data structure, where it delivers its data when requested by another node in the query execution data structure.
摘要翻译：流数据节点从一个或多个输入设备接收实时流数据，动态地过滤流数据以减少流数据，并在请求时传送减少的数据。通过提供对数据的实时过滤，可以显着地减少必须存储在数据库中的数据量。流数据节点可以执行聚合功能，组功能和选择功能，从而大大减少必须存储在数据库中的数据量。流数据节点还可以是查询执行数据结构的一部分，其中当查询执行数据结构中的另一节点请求时，该数据结构传递其数据。

6. 发明申请

US20080148103A1 APPARATUS AND METHOD FOR MONITORING AND DEBUGGING QUERY EXECUTION OBJECTS 审中-公开
标题翻译：用于监视和调试查询执行对象的装置和方法
公开(公告)号：US20080148103A1
公开(公告)日：2008-06-19
申请号：US12038446
申请日：2008-02-27
申请人： David Glenn Carlson , Steven Virgil Hoeschen , Kevin James Kathmann
发明人： David Glenn Carlson , Steven Virgil Hoeschen , Kevin James Kathmann
IPC分类号： G06F11/32 , G06F17/30
CPC分类号： G06F17/30289 , G06F3/048 , G06F17/30483
摘要： Nodes in a query execution data structure have monitor and dump methods defined. The monitor method enables the collection of information from the node. The dump method outputs the monitored information from each node. A monitor and debug mechanism of the preferred embodiments includes a graphical user interface that allows a user to graphically examine a query execution tree, to enable monitoring of the nodes on a node-by-node basis, and to view information dumped from the query execution data structure as the query is executed or after the query is executed. The result is a powerful tool that allows efficiently monitoring and debugging a query implemented in an object oriented query execution data structure.
摘要翻译：查询执行数据结构中的节点定义了监视和转储方法。监视器方法可以从节点收集信息。 dump方法从每个节点输出监视的信息。优选实施例的监视器和调试机制包括图形用户界面，其允许用户以图形方式检查查询执行树，以便逐节点地监视节点，以及查看从查询执行转发的信息查询执行时或执行查询后的数据结构。结果是一个强大的工具，可以有效地监视和调试在面向对象的查询执行数据结构中实现的查询。

7. 发明授权

US07089230B2 Method for efficient processing of multi-state attributes 失效
公开(公告)号：US07089230B2
公开(公告)日：2006-08-08
申请号：US10164767
申请日：2002-06-07
申请人： David Glenn Carlson , Kevin James Kathmann
发明人： David Glenn Carlson , Kevin James Kathmann
IPC分类号： G06F17/30
CPC分类号： G06F17/30483 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942 , Y10S707/99943
摘要： Methods, systems and articles of manufacture of processing a multi-state attribute field query. One embodiment provides a method of processing a multi-state attribute field query, comprising instantiating a plurality of live objects; performing, by each live object, an attribute operation, wherein at least one attribute operation is a comparison operation associated with attributes of the query. The plurality of live objects access a global status storage area only when an operand of the comparison operation is null or error. In any case, execution control is passed from each live object to an adjacent live object.

8. 发明授权

US07512700B2 Real-time mining and reduction of streamed data 失效
标题翻译：实时挖掘和减少流数据
公开(公告)号：US07512700B2
公开(公告)日：2009-03-31
申请号：US11241708
申请日：2005-09-30
申请人： Robert Joseph Bestgen , David Glenn Carlson , Kevin James Kathmann
发明人： Robert Joseph Bestgen , David Glenn Carlson , Kevin James Kathmann
IPC分类号： G06K9/36
CPC分类号： G06F17/30516
摘要： A stream data node receives real-time streamed data from one or more input devices, dynamically filters the streamed data to reduce the streamed data, and delivers the reduced data when requested. By providing real-time filtering of the data, the amount of data that must be stored in a database may be substantially reduced. The stream data node can perform aggregation functions, group functions, and select functions, thereby also significantly reducing the amount of data that must be stored in a database. The stream data node may also be part of a query execution data structure, where it delivers its data when requested by another node in the query execution data structure.
摘要翻译：流数据节点从一个或多个输入设备接收实时流数据，动态地过滤流数据以减少流数据，并在请求时传送减少的数据。通过提供对数据的实时过滤，可以显着地减少必须存储在数据库中的数据量。流数据节点可以执行聚合功能，组功能和选择功能，从而大大减少必须存储在数据库中的数据量。流数据节点还可以是查询执行数据结构的一部分，其中当查询执行数据结构中的另一节点请求时，该数据结构传递其数据。

9. 发明授权

US06725223B2 Storage format for encoded vector indexes 失效
标题翻译：编码矢量索引的存储格式
公开(公告)号：US06725223B2
公开(公告)日：2004-04-20
申请号：US09747071
申请日：2000-12-22
申请人： Abdo Esmail Abdo , Kevin James Kathmann , Kurt Walter Pinnow
发明人： Abdo Esmail Abdo , Kevin James Kathmann , Kurt Walter Pinnow
IPC分类号： G06F700
CPC分类号： G06F17/3061
摘要： A storage format and methods for improving the performance of the symbol table of an encoded vector index. The symbol table comprises a hash table, entries of the hash table storing associated key values and codes for the encoded vector index. Hash table entries store an accumulated count of occurrences of prior and the current key values, which improves the efficiency of responding to a request for a key range count. A binary radix tree is used to locate entries, which comprises a plurality of nodes, corresponding to binary digits of a binary representation of a key value. Codes are assigned to key values for the encoded vector index in a distributed fashion, so there are available code values between existing code values in the code ordering, that can be assigned to new key values, alleviating the need to reorganize the code values upon an insertion.
摘要翻译：用于改善编码矢量索引的符号表的性能的存储格式和方法。符号表包括哈希表，存储相关键值的哈希表的条目和编码向量索引的代码。哈希表条目存储先前和当前密钥值的累积计数，这提高了对密钥范围计数的请求的响应效率。使用二进制基数树来定位对应于键值的二进制表示的二进制数字的多个节点的条目。代码以分布式方式分配给编码矢量索引的键值，因此可以将代码排序中的现有代码值之间的可用代码值分配给新的键值，从而减轻了重新组织代码值的需要插入。

10. 发明授权

US06285994B1 Method and system for efficiently searching an encoded vector index 失效
标题翻译：用于有效搜索编码矢量索引的方法和系统
公开(公告)号：US06285994B1
公开(公告)日：2001-09-04
申请号：US09318691
申请日：1999-05-25
申请人： Thuan Quang Bui , Randy Lynn Egan , Kevin James Kathmann
发明人： Thuan Quang Bui , Randy Lynn Egan , Kevin James Kathmann
IPC分类号： G06F1730
CPC分类号： G06F17/30324 , G06F17/30424 , Y10S707/99932 , Y10S707/99934 , Y10S707/99935 , Y10S707/99942
摘要： Method and system aspects for efficiently searching an encoded vector index are provided. The aspects include the translation of a search query into a candidate bitmap, and the mapping of data from the candidate bitmap into a search result bitmap according to entry values in the encoded vector index. Further, the translation includes the setting of a bit in the candidate bitmap for each entry in a symbol table that corresponds to candidate of the search query. Also included in the mapping is the identification of a bit value in the candidate bitmap pointed to by an entry in an encoded vector.
摘要翻译：提供了有效搜索编码矢量索引的方法和系统方面。这些方面包括将搜索查询翻译成候选位图，以及根据编码矢量索引中的条目值将数据从候选位图映射到搜索结果位图。此外，翻译包括对于与搜索查询的候选者相对应的符号表中的每个条目的候选位图中的位的设置。还包括在映射中的是识别由编码向量中的条目指向的候选位图中的位值。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式