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

1. 发明授权

US06732084B1 Method and apparatus for parallel execution of trigger actions 有权
标题翻译：用于并行执行触发动作的方法和装置
公开(公告)号：US06732084B1
公开(公告)日：2004-05-04
申请号：US09470227
申请日：1999-12-22
申请人： Navin Kabra , Jignesh M. Patel , Jie-Bing Yu , Biswadeep Nag , Jian-Jun Chen
发明人： Navin Kabra , Jignesh M. Patel , Jie-Bing Yu , Biswadeep Nag , Jian-Jun Chen
IPC分类号： G06F1730
CPC分类号： G06F17/3051 , Y10S707/99932 , Y10S707/99933
摘要： A method and apparatus for parallel execution of trigger actions. One or more embodiments of the invention comprise providing a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query or trigger action and start parallel execution of the trigger action. The trigger action is optimized and parallelized. The dispatcher executes the trigger action, sets up the communication links between the various operators in the trigger action, and ensures that all the results are sent back to the trigger.
摘要翻译：一种用于并行执行触发动作的方法和装置。本发明的一个或多个实施例包括提供可以采取SQL查询或触发动作并开始并行执行触发动作的C ++类（以下称为“调度器”）。触发动作被优化和并行化。调度程序执行触发动作，在触发动作中设置各种运算符之间的通信链路，并确保所有结果都发送回触发器。

2. 发明授权

US06507834B1 Method and apparatus for parallel execution of SQL from stored procedures 有权
标题翻译：从存储过程并行执行SQL的方法和装置
公开(公告)号：US06507834B1
公开(公告)日：2003-01-14
申请号：US09470927
申请日：1999-12-22
申请人： Navin Kabra , Jignesh M. Patel , Jie-Bing Yu , Biswadeep Nag , Jian-Jun Chen
发明人： Navin Kabra , Jignesh M. Patel , Jie-Bing Yu , Biswadeep Nag , Jian-Jun Chen
IPC分类号： G06F1730
CPC分类号： G06F17/30415 , G06F17/30445 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943 , Y10S707/99945
摘要： A method, apparatus, and an article of manufacture for parallel execution of SQL operations from stored procedures. One or more embodiments of the invention provide the stored procedure (stored procedure) with a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling stored procedure. To provide the single stream to the calling stored procedure, one or more embodiments of the invention utilize a class that provides the stored procedure with a simple and easy-to-use interface to access the results of the nested SQL execution.
摘要翻译：用于从存储过程并行执行SQL操作的方法，装置和制品。本发明的一个或多个实施例提供具有可以进行SQL查询并开始并行执行查询的C ++类（以下称为“调度程序”）的存储过程（存储过程）。查询优化并并行化。调度程序执行查询，设置查询中各种运算符之间的通信链路，并确保将所有结果发送回发起查询请求的数据服务器。此外，调度程序合并并行执行的结果，并产生单个流的元组，该元组被提供给调用存储过程。为了向调用存储过程提供单个流，本发明的一个或多个实施例利用向存储过程提供简单且易于使用的界面来访问嵌套SQL执行结果的类。

3. 发明授权

US06594651B2 Method and apparatus for parallel execution of SQL-from within user defined functions 有权
标题翻译：用于从用户定义的函数中并行执行SQL的方法和装置
公开(公告)号：US06594651B2
公开(公告)日：2003-07-15
申请号：US09470215
申请日：1999-12-22
申请人： Navin Kabra , Jignesh M. Patel , Jie-Bing Yu , Biswadeep Nag , Jian-Jun Chen
发明人： Navin Kabra , Jignesh M. Patel , Jie-Bing Yu , Biswadeep Nag , Jian-Jun Chen
IPC分类号： G06F1730
CPC分类号： G06F17/30445 , G06F17/30463 , Y10S707/99932 , Y10S707/99933
摘要： A method, apparatus, and an article of manufacture for parallel execution of SQL operations from within user defined functions. One or more embodiments of the invention provide the user defined function (UDF) with a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling UDF. To provide the single stream to the calling UDF, one or more embodiments of the invention utilize a class that provides the UDF with a simple and easy-to-use interface to access the results of the nested SQL execution.
摘要翻译：用于从用户定义的功能中并行执行SQL操作的方法，装置和制造。本发明的一个或多个实施例提供具有可以进行SQL查询并开始并行执行查询的C ++类（以下称为“调度程序”）的用户定义函数（UDF）。查询优化并并行化。调度程序执行查询，设置查询中各种运算符之间的通信链路，并确保将所有结果发送回发起查询请求的数据服务器。此外，调度程序合并并行执行的结果，并产生单个流的元组，该元组被馈送到调用UDF。为了向调用的UDF提供单个流，本发明的一个或多个实施例利用为UDF提供简单且易于使用的界面来访问嵌套SQL执行结果的类。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式