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

1. 发明授权

US07945581B2 Global-results processing matrix for processing queries 有权
标题翻译：用于处理查询的全局结果处理矩阵
公开(公告)号：US07945581B2
公开(公告)日：2011-05-17
申请号：US10293482
申请日：2002-11-14
申请人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
发明人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
IPC分类号： G06F17/30
CPC分类号： G06F17/30445
摘要： A system and methods for parallel processing of queries to one or more databases are described herein. One or more databases may be distributed among a subset of slave nodes of a global-results processing matrix. A query to the database may be generated using a query-based high-level programming language. The query-based source code then may be converted to intermediary source code in a common programming language and then compiled into a dynamic link library (DLL) or other type of executable. The DLL is then distributed among the slave nodes of the processing matrix, whereupon the slave nodes execute related portions of the DLL substantially in parallel to generate initial query results. The initial query results may then be provided to a master node of the global-results processing matrix for additional processing, whereby the master node is adapted to execute one or more associated portions of the DLL on the initial query results.
摘要翻译：这里描述了用于将并行处理对一个或多个数据库的查询的系统和方法。一个或多个数据库可以分布在全局结果处理矩阵的从节点的子集中。可以使用基于查询的高级编程语言来生成对数据库的查询。然后，基于查询的源代码可以以通用编程语言转换为中间源代码，然后被编译成动态链接库（DLL）或其他类型的可执行文件。然后将DLL分布在处理矩阵的从节点之间，随后从节点基本并行地执行DLL的相关部分以产生初始查询结果。然后可以将初始查询结果提供给全局结果处理矩阵的主节点用于附加处理，由此主节点适于在初始查询结果上执行DLL的一个或多个关联部分。

2. 发明申请

US20080010296A1 SYSTEM AND METHOD FOR CONFIGURING A PARALLEL-PROCESSING DATABASE SYSTEM 有权
标题翻译：用于配置并行处理数据库系统的系统和方法
公开(公告)号：US20080010296A1
公开(公告)日：2008-01-10
申请号：US11772634
申请日：2007-07-02
申请人： David BAYLISS , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
发明人： David BAYLISS , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
IPC分类号： G06F17/30
CPC分类号： G06F17/30545 , G06F17/30445
摘要： A system and method for configuring a plurality of processing nodes into a parallel-processing database system are described herein. Each of a plurality of processing nodes connected by a network receive software and one or more configuration files related to the intended function of the processing node. The software may include homogeneous agent software, one or more library dynamic-link libraries (DLL), and the like. The configuration file is used to configure the homogeneous agent to operate as the intended node in a global-results processing matrix, a general-purpose query processing matrix, or a index-base query processing matrix. Another node or nodes may be configured to convert query-based programming code to intermediary source code in a common programming language and then compile the intermediary source code into a dynamic link library (DLL) or other type of executable. The DLL is then distributed among the processing nodes of the processing matrix, whereupon various subsets of the processing nodes execute related portions of the DLL substantially in parallel to generate query results.
摘要翻译：这里描述了用于将多个处理节点配置到并行处理数据库系统中的系统和方法。通过网络连接的多个处理节点中的每一个接收软件和与处理节点的预期功能相关的一个或多个配置文件。该软件可以包括均质代理软件，一个或多个库动态链接库（DLL）等。配置文件用于将均匀代理配置为全局结果处理矩阵，通用查询处理矩阵或索引基查询处理矩阵中的预期节点。可以将另一个节点或节点配置为将基于查询的编程代码以通用编程语言转换为中间源代码，然后将中间源代码编译成动态链接库（DLL）或其他类型的可执行文件。然后将DLL分配在处理矩阵的处理节点之间，由此处理节点的各种子集大致并行地执行DLL的相关部分以产生查询结果。

3. 发明授权

US07668840B2 System and method for configuring a parallel-processing database system 有权
标题翻译：用于配置并行处理数据库系统的系统和方法
公开(公告)号：US07668840B2
公开(公告)日：2010-02-23
申请号：US11772634
申请日：2007-07-02
申请人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
发明人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
IPC分类号： G06F17/30
CPC分类号： G06F17/30545 , G06F17/30445
摘要： A system and method for configuring a plurality of processing nodes into a parallel-processing database system are described herein. Each of a plurality of processing nodes connected by a network receive software and one or more configuration files related to the intended function of the processing node. The software may include homogeneous agent software, one or more library dynamic-link libraries (DLL), and the like. The configuration file is used to configure the homogeneous agent to operate as the intended node in a global-results processing matrix, a general-purpose query processing matrix, or a index-base query processing matrix. Another node or nodes may be configured to convert query-based programming code to intermediary source code in a common programming language and then compile the intermediary source code into a dynamic link library (DLL) or other type of executable. The DLL is then distributed among the processing nodes of the processing matrix, whereupon various subsets of the processing nodes execute related portions of the DLL substantially in parallel to generate query results.
摘要翻译：这里描述了用于将多个处理节点配置到并行处理数据库系统中的系统和方法。通过网络连接的多个处理节点中的每一个接收软件和与处理节点的预期功能相关的一个或多个配置文件。该软件可以包括均质代理软件，一个或多个库动态链接库（DLL）等。配置文件用于将均匀代理配置为全局结果处理矩阵，通用查询处理矩阵或索引基查询处理矩阵中的预期节点。可以将另一个节点或节点配置为将基于查询的编程代码以通用编程语言转换为中间源代码，然后将中间源代码编译成动态链接库（DLL）或其他类型的可执行文件。然后将DLL分配在处理矩阵的处理节点之间，由此处理节点的各种子集大致并行地执行DLL的相关部分以产生查询结果。

4. 发明授权

US07293024B2 Method for sorting and distributing data among a plurality of nodes 有权
标题翻译：用于在多个节点之间排序和分发数据的方法
公开(公告)号：US07293024B2
公开(公告)日：2007-11-06
申请号：US10293485
申请日：2002-11-14
申请人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
发明人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
IPC分类号： G06F17/30
CPC分类号： G06F17/30575 , G06F7/32 , Y10S707/99937
摘要： A method for distributing and sorting data among a plurality of nodes is described herein. After receiving a portion of a data set (e.g., a database), each node sorts its portion and estimates a partitioning of the sorted dataset among the nodes based in part on its own sorted data portion. Each node then provides a representation of its estimated partition to a master node. The master node, using the provided estimated partitions, determines a tentative partitioning and submits the tentative partitioning to each node. Each node then determines the effect the tentative partitioning using its data portion. If the effect is acceptable for each node, the tentative partitioning plan is used to partition the data. Otherwise, the tentative partitioning plan is repeatedly revised by the master node and considered by the nodes having data portions until an acceptable or optimum partitioning is determined. Each node then distributes data from its data portion that falls outside the partition assigned to the node to the appropriate node. Upon receipt of this data, each node can perform a merge sort to add the received data to the previously sorted data portion at the node.
摘要翻译：这里描述了在多个节点之间分配和分类数据的方法。在接收到数据集（例如，数据库）的一部分之后，每个节点分别对其部分进行排序，并且部分地基于其自己的排序数据部分来估计节点之间的分类数据集的分区。然后，每个节点向主节点提供其估计分区的表示。使用提供的估计分区的主节点确定临时分区，并将暂定分区提交给每个节点。然后每个节点使用其数据部分确定临时分区的效果。如果每个节点的效果是可接受的，则使用暂时分区计划来分割数据。否则，暂时分区计划由主节点反复修改，并由具有数据部分的节点考虑，直到确定可接受或最佳分区。然后，每个节点将数据从分配给该节点的分区之外的数据部分分发到适当的节点。在接收到该数据时，每个节点可以执行合并排序以将接收的数据添加到节点处的先前排序的数据部分。

5. 发明授权

US07185003B2 Query scheduling in a parallel-processing database system 有权
标题翻译：并行处理数据库系统中的查询调度
公开(公告)号：US07185003B2
公开(公告)日：2007-02-27
申请号：US10293489
申请日：2002-11-14
申请人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
发明人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
IPC分类号： G06F17/30 , G06F15/16 , G06F9/46
CPC分类号： G06F17/30545 , G06F17/30463 , Y10S707/99933
摘要： A system and method for scheduling database operations to one or more databases in a parallel-processing database system are described herein. After a query server generates a dynamic-link library (DLL) or other executable representative of one or more database operations to a database, the query server notifies a scheduling services module of the generation of the DLL and submits the DLL to a query agent. The query agent notifies the scheduling services module of its receipt of the DLL. Based on any of a variety of considerations, the scheduling services module schedules a time of execution for the DLL by one or more processing matrices that store the database. At the scheduled time, the scheduling services module directs the query agent to submit the DLL to the indicated processing matrices. The scheduling services module also can be adapted to monitor the execution of previously submitted DLLs by one or more processing matrices and adjust the scheduled times of execution for subsequent DLLs accordingly.
摘要翻译：这里描述了一种用于将数据库操作调度到并行处理数据库系统中的一个或多个数据库的系统和方法。在查询服务器生成动态链接库（DLL）或代表数据库的一个或多个数据库操作的其他可执行代码之后，查询服务器通知调度服务模块生成DLL，并将该DLL提交给查询代理。查询代理通知调度服务模块收到该DLL。基于各种考虑因素，调度服务模块通过存储数据库的一个或多个处理矩阵为DLL执行执行时间。在预定的时间，调度服务模块指示查询代理将DLL提交到指定的处理矩阵。调度服务模块还可以适于通过一个或多个处理矩阵监视先前提交的DLL的执行，并相应地调整后续DLL的执行的调度时间。

6. 发明授权

US08676843B2 Failure recovery in a parallel-processing database system 有权
标题翻译：并行处理数据库系统中的故障恢复
公开(公告)号：US08676843B2
公开(公告)日：2014-03-18
申请号：US10293475
申请日：2002-11-14
申请人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
发明人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30545 , G06F11/203 , G06F11/2035 , G06F11/2038 , G06F2201/80
摘要： A system and method for failure recovery in a multiple processing node system are described herein. Each node can be adapted to store a backup copy of its database portion and/or results to disk storage or memory of at least one other node. In the event of a failure of a node, the replacement node can be adapted to transfer or copy the backup copy of the database portion of the failed node from the failed node's neighbors to the replacement node's disk storage or memory in between database operations. Before the transfer or copy of the backup copy is completed, the replacement node can be adapted to perform database operations in part on the portion of the backup copy the replacement node has already received and in part on the backup copy stored at the neighboring node(s).
摘要翻译：本文描述了用于多处理节点系统中的故障恢复的系统和方法。每个节点可以适于将其数据库部分的备份副本和/或结果存储到至少一个其他节点的磁盘存储器或存储器。在节点发生故障的情况下，替换节点可以适于在故障数据库操作之间将故障节点的数据库部分的备份副本从故障节点的邻居传输或复制到替换节点的磁盘存储器或存储器。在备份副本的传送或复制完成之前，替换节点可以适于部分地在替换节点已经接收到的备份副本的部分上执行数据库操作，并且部分地在存储在相邻节点的备份副本上 s）。

7. 发明申请

US20070208694A1 QUERY SCHEDULING IN A PARALLEL-PROCESSING DATABASE SYSTEM 审中-公开
标题翻译：在并行处理数据库系统中的查询调度
公开(公告)号：US20070208694A1
公开(公告)日：2007-09-06
申请号：US11671090
申请日：2007-02-05
申请人： David BAYLISS , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
发明人： David BAYLISS , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
IPC分类号： G06F17/30
CPC分类号： G06F16/2471 , G06F16/24542 , Y10S707/99933
摘要： A system and method for scheduling database operations to one or more databases in a parallel-processing database system are described herein. After a query server generates a dynamic-link library (DLL) or other executable representative of one or more database operations to a database, the query server notifies a scheduling services module of the generation of the DLL and submits the DLL to a query agent. The query agent notifies the scheduling services module of its receipt of the DLL. Based on any of a variety of considerations, the scheduling services module schedules a time of execution for the DLL by one or more processing matrices that store the database. At the scheduled time, the scheduling services module directs the query agent to submit the DLL to the indicated processing matrices. The scheduling services module also can be adapted to monitor the execution of previously submitted DLLs by one or more processing matrices and adjust the scheduled times of execution for subsequent DLLs accordingly.
摘要翻译：这里描述了一种用于将数据库操作调度到并行处理数据库系统中的一个或多个数据库的系统和方法。在查询服务器生成动态链接库（DLL）或代表数据库的一个或多个数据库操作的其他可执行代码之后，查询服务器通知调度服务模块生成DLL，并将该DLL提交给查询代理。查询代理通知调度服务模块收到该DLL。基于各种考虑因素，调度服务模块通过存储数据库的一个或多个处理矩阵为DLL执行执行时间。在预定的时间，调度服务模块指示查询代理将DLL提交到指定的处理矩阵。调度服务模块还可以适于通过一个或多个处理矩阵监视先前提交的DLL的执行，并相应地调整后续DLL的执行的调度时间。

8. 发明授权

US07240059B2 System and method for configuring a parallel-processing database system 有权
标题翻译：用于配置并行处理数据库系统的系统和方法
公开(公告)号：US07240059B2
公开(公告)日：2007-07-03
申请号：US10293483
申请日：2002-11-14
申请人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
发明人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
IPC分类号： G06F17/30
CPC分类号： G06F17/30545 , G06F17/30445
摘要： A system and method for configuring a plurality of processing nodes into a parallel-processing database system are described herein. Each of a plurality of processing nodes connected by a network receive software and one or more configuration files related to the intended function of the processing node. The software may include homogeneous agent software, one or more library dynamic-link libraries (DLL), and the like. The configuration file is used to configure the homogeneous agent to operate as the intended node in a global-results processing matrix, a general-purpose query processing matrix, or a index-base query processing matrix. Another node or nodes may be configured to convert query-based programming code to intermediary source code in a common programming language and then compile the intermediary source code into a dynamic link library (DLL) or other type of executable. The DLL is then distributed among the processing nodes of the processing matrix, whereupon various subsets of the processing nodes execute related portions of the DLL substantially in parallel to generate query results.
摘要翻译：这里描述了用于将多个处理节点配置到并行处理数据库系统中的系统和方法。通过网络连接的多个处理节点中的每一个接收软件和与处理节点的预期功能相关的一个或多个配置文件。该软件可以包括均质代理软件，一个或多个库动态链接库（DLL）等。配置文件用于将均匀代理配置为全局结果处理矩阵，通用查询处理矩阵或索引基查询处理矩阵中的预期节点。可以将另一个节点或节点配置为将基于查询的编程代码以通用编程语言转换为中间源代码，然后将中间源代码编译成动态链接库（DLL）或其他类型的可执行文件。然后将DLL分配在处理矩阵的处理节点之间，由此处理节点的各种子集大致并行地执行DLL的相关部分以产生查询结果。

9. 发明授权

US06968335B2 Method and system for parallel processing of database queries 有权
标题翻译：用于并行处理数据库查询的方法和系统
公开(公告)号：US06968335B2
公开(公告)日：2005-11-22
申请号：US10293490
申请日：2002-11-14
申请人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
发明人： David Bayliss , Richard Chapman , Jake Smith , Ole Poulsen , Gavin Halliday , Nigel Hicks
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30545 , G06F17/30445 , Y10S707/99933 , Y10S707/99942 , Y10S707/99952
摘要： A system and methods for parallel processing of queries to one or more databases are described herein. One or more databases may be distributed among a subset of slave nodes of a global-results processing matrix. A query to the database may be generated using a query-based high-level programming language. The query-based source code then may be converted to intermediary source code in a common programming language and then compiled into a dynamic link library (DLL) or other type of executable. The DLL is then distributed among the slave nodes of the processing matrix, whereupon the slave nodes execute related portions of the DLL substantially in parallel to generate initial query results. The initial query results may then be provided to master node of the global-results processing matrix for additional processing, whereby the master node is adapted to execute one or more associated portions of the DLL on the initial query results.
摘要翻译：这里描述了用于将并行处理对一个或多个数据库的查询的系统和方法。一个或多个数据库可以分布在全局结果处理矩阵的从节点的子集中。可以使用基于查询的高级编程语言来生成对数据库的查询。然后，基于查询的源代码可以以通用编程语言转换为中间源代码，然后被编译成动态链接库（DLL）或其他类型的可执行文件。然后将DLL分布在处理矩阵的从节点之间，随后从节点基本并行地执行DLL的相关部分以产生初始查询结果。然后可以将初始查询结果提供给全局结果处理矩阵的主节点用于附加处理，由此主节点适于在初始查询结果上执行DLL的一个或多个相关联部分。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式