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

1. 发明授权

US08825616B2 Execution of database queries including filtering 有权
标题翻译：执行数据库查询，包括过滤
公开(公告)号：US08825616B2
公开(公告)日：2014-09-02
申请号：US11780777
申请日：2007-07-20
申请人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
发明人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
IPC分类号： G06F17/30
CPC分类号： G06F17/30486 , G06F17/30492 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99943 , Y10S707/99945
摘要： A query processing system has a query processor and a data manager. The query processor calls the data manager to carry out data access for a query including a filtering operation. The data manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.
摘要翻译：查询处理系统具有查询处理器和数据管理器。查询处理器调用数据管理器对包括过滤操作的查询执行数据访问。数据管理器访问一组数据中的数据，并在返回数据之前，向查询处理器发起回调，以确定所查找的数据是否满足过滤条件。在数据不满足过滤标准的情况下，数据管理器在数据集中寻求附加数据，而不必将第一定位数据返回给查询处理器。

2. 发明授权

US06230206B1 System for internode deadlock avoidance in parallel database system using as overflow buffer a temporary table storage allocated to the parallel database application program being executed 失效
标题翻译：在并行数据库系统中使用节点死锁避免系统作为溢出缓冲区分配给执行的并行数据库应用程序的临时表存储
公开(公告)号：US06230206B1
公开(公告)日：2001-05-08
申请号：US09185257
申请日：1998-11-02
申请人： Douglas J. Doole , Paul C. Huffman , John E. Lumby
发明人： Douglas J. Doole , Paul C. Huffman , John E. Lumby
IPC分类号： G06F1516
CPC分类号： G06F9/524
摘要： The invention provides a method and apparatus including a programming product for a parallel data processing system having a plurality of nodes interconnected by communication paths, in which one or more sets of data present at one or more source nodes of the system is required to be sent on a plurality of communication paths having communication buffers to selected nodes of the database system for processing, a system of communicating the data over the paths between the nodes to avoid deadlocking the processing system, including: accessing data from the one or more source nodes in subsets of the data; sending the subsets of data on a plurality of paths to the selected nodes of the processing system; if a path of the paths intended for the sending of one or more of the subsets of data becomes blocked, suspending the sending of subsets of the data on the path for a predetermined time period; if the blocked path becomes capable of accepting additional data before the predetermined time period has expired, resuming the sending of subsets of data on the path; however, if the predetermined time period expires without the path becoming available, placing one or more subsequent subsets of data intended for the path into an overflow buffer; when the blocked path again becomes free, sending the subsets of data from the overflow buffer on the path to the intended recipient node for processing.
摘要翻译：本发明提供了一种方法和装置，包括用于并行数据处理系统的编程产品，该系统具有通过通信路径互连的多个节点，其中需要发送系统的一个或多个源节点处存在的一组或多组数据在具有到所述数据库系统的选定节点的通信缓冲器的多个通信路径上进行处理的系统，通过所述节点之间的路径传送所述数据的系统，以避免所述处理系统死锁，包括：从所述一个或多个源节点访问数据数据子集; 将多个路径上的数据子集发送到处理系统的所选节点; 如果旨在发送数据子集中的一个或多个的路径的路径被阻塞，则暂停在路径上发送数据子集达预定时间段; 如果阻塞路径能够在预定时间段到期之前接受附加数据，则恢复在该路径上发送数据子集; 然而，如果预定时间段在路径变得可用的情况下到期，则将用于路径的一个或多个后续的数据子集放置到溢出缓冲器中; 当阻塞路径再次变为空闲时，将数据子集从路径上的溢出缓冲区发送到预期的接收方节点进行处理。

3. 发明申请

US20080256053A1 EXECUTION OF DATABASE QUERIES INCLUDING FILTERING 有权
标题翻译：数据库查询的执行，包括过滤
公开(公告)号：US20080256053A1
公开(公告)日：2008-10-16
申请号：US11780777
申请日：2007-07-20
申请人： Paul C. HUFFMAN , Kathy A. MCKNIGHT , David C. SHARPE , Daniel C. ZILIO
发明人： Paul C. HUFFMAN , Kathy A. MCKNIGHT , David C. SHARPE , Daniel C. ZILIO
IPC分类号： G06F17/30
CPC分类号： G06F17/30486 , G06F17/30492 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99943 , Y10S707/99945
摘要： A query processing system has a query processor and a data manager. The query processor calls the data manager to carry out data access for a query including a filtering operation. The data manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.
摘要翻译：查询处理系统具有查询处理器和数据管理器。查询处理器调用数据管理器对包括过滤操作的查询执行数据访问。数据管理器访问一组数据中的数据，并在返回数据之前，向查询处理器发起回调，以确定所查找的数据是否满足过滤条件。在数据不满足过滤标准的情况下，数据管理器在数据集中寻求附加数据，而不必将第一定位数据返回给查询处理器。

4. 发明授权

US06879977B2 Execution of database queries including filtering 有权
公开(公告)号：US06879977B2
公开(公告)日：2005-04-12
申请号：US09757428
申请日：2001-01-10
申请人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
发明人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30486 , G06F17/30492 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99943 , Y10S707/99945
摘要： A query processing system has a query processor and a data manager. The query processor calls the data manager to carry out data access for a query including a filtering operation. The data manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式