专利快速检索-快速检索全球专利，免费商用专利数据库-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执行结果的类。

4. 发明授权

US06601064B1 Method and apparatus for fetching array based objects by direct delivery and batching 有权
标题翻译：通过直接递送和批量获取基于数组的对象的方法和装置
公开(公告)号：US06601064B1
公开(公告)日：2003-07-29
申请号：US09449704
申请日：1999-11-24
申请人： Biswadeep Nag , Jie-Bing Yu , Jignesh M. Patel , Zhe Wang
发明人： Biswadeep Nag , Jie-Bing Yu , Jignesh M. Patel , Zhe Wang
IPC分类号： G06F1730
CPC分类号： G06F17/30067 , Y10S707/99932 , Y10S707/99934
摘要： A method, apparatus, article of manufacture, and a memory structure for providing access to an array-based data object to a client is disclosed. The method comprises the steps of receiving a database query from a client; generating a first execution plan from the database query; transmitting at least a portion of the first execution plan to a data server; compiling a query result from the execution of the first execution plan; and transmitting the query result to the client on a first communication path wherein the query result comprises an identification for a master data object responsive to the database query and the master data object comprises an identification for a plurality of array-based objects associated with the master data object. Further, the method comprises the establishment of a second communication path between the data server and the client and the transmission of the master data object to the client via this second communication path. This is followed by a third request by the client for the required array-based objects. This results in the generation of a third execution plan which is executed by the appropriate data server. The resultant array-based objects are then tagged with the corresponding object identification and sent in batched fashion directly to the client via the second communication path.
摘要翻译：公开了一种用于向客户机提供对基于阵列的数据对象的访问的方法，装置，制品和存储器结构。该方法包括从客户端接收数据库查询的步骤; 从数据库查询生成第一个执行计划; 将所述第一执行计划的至少一部分发送到数据服务器; 从执行第一个执行计划编译查询结果; 以及在所述第一通信路径上将所述查询结果发送给所述客户端，其中所述查询结果包括响应于所述数据库查询的主数据对象的标识，并且所述主数据对象包括与所述主机相关联的多个基于阵列的对象的标识数据对象。此外，该方法包括在数据服务器和客户端之间建立第二通信路径，以及通过该第二通信路径向客户端发送主数据对象。之后是客户端针对所需的基于数组的对象的第三个请求。这导致产生由适当的数据服务器执行的第三执行计划。然后将所得到的基于阵列的对象用相应的对象标识标记，并通过第二通信路径直接发送给客户端。

5. 发明授权

US06477540B1 Method and apparatus for using Java as a stored procedure language and as an embedded language on a client 有权
标题翻译：在客户机上使用Java作为存储过程语言和嵌入式语言的方法和装置
公开(公告)号：US06477540B1
公开(公告)日：2002-11-05
申请号：US09470228
申请日：1999-12-22
申请人： Ashutosh Singh , Jignesh M. Patel , Navin Kabra
发明人： Ashutosh Singh , Jignesh M. Patel , Navin Kabra
IPC分类号： G06F1730
CPC分类号： G06F17/30342 , Y10S707/99933 , Y10S707/99944
摘要： One or more embodiments of the invention provide the ability to utilize the Java programming language as a stored procedure language. One or more embodiments of the invention provide for Java abstract data types (ADT) that map to ADT attributes from a database. The Java ADT can then be manipulated in an application written in the Java programming language such as a stored procedure. Each ADT attribute from a database is mapped to a Java class by wrapping the ADT definition (which is commonly written in C ++) in a Java wrapper. The wrapping process enables a user to write any client side Java application. Once the ADTs are wrapped and a stored procedure is created, the stored procedure must be able to execute. Enhancements permit a stored procedure written in the Java programming language to execute. Such enhancements include a server side cursor that the stored procedure can use to run SQL queries. Additionally, the server has been enhanced to link to a Java virtual machine that can be used to execute the bytecodes of the stored procedure written in the Java programming language.
摘要翻译：本发明的一个或多个实施例提供了利用Java编程语言作为存储过程语言的能力。本发明的一个或多个实施例提供从数据库映射到ADT属性的Java抽象数据类型（ADT）。然后可以在使用Java编程语言编写的应用程序（如存储过程）中对Java ADT进行操作。通过将ADT定义（通常用C ++编写）定义在Java包装器中，将数据库中的每个ADT属性映射到Java类。封装过程使用户能够编写任何客户端Java应用程序。一旦ADT被包装并且存储过程被创建，存储过程必须能够执行。增强功能允许以Java编程语言编写的存储过程执行。此类增强功能包括存储过程可用于运行SQL查询的服务器端游标。此外，服务器已经被增强以链接到可以用于执行以Java编程语言编写的存储过程的字节码的Java虚拟机。

6. 发明授权

US06678686B1 Method and apparatus for evaluating index predicates on complex data types using virtual indexed streams 有权
标题翻译：使用虚拟索引流对复杂数据类型的索引谓词进行评估的方法和装置
公开(公告)号：US06678686B1
公开(公告)日：2004-01-13
申请号：US09474040
申请日：1999-12-28
申请人： Jignesh M. Patel , Navin Kabra
发明人： Jignesh M. Patel , Navin Kabra
IPC分类号： G06F700
CPC分类号： G06F17/30477
摘要： A method, apparatus, article of manufacture, and a memory structure for providing access to abstract data types using an index providing a tuple. The method comprises the steps of accepting a database query; generating an index predicate from the database query; and determining a tuple from an index using the index predicate. The tuple is associated with an abstract or complex data type responsive to the database query. A data stream is initialized with the index predicate; and the tuple is returned in the data stream. The apparatus comprises means for performing the above method steps, and the article of manufacture comprises a medium tangibly embodying computer instructions for performing these method steps.
摘要翻译：一种方法，装置，制品和存储器结构，用于使用提供元组的索引提供对抽象数据类型的访问。该方法包括接受数据库查询的步骤; 从数据库查询生成索引谓词; 并使用索引谓词从索引中确定元组。该元组与响应于数据库查询的抽象或复杂数据类型相关联。数据流用索引谓词初始化; 并且元数据在数据流中返回。该装置包括用于执行上述方法步骤的装置，并且该制品包括有形地体现用于执行这些方法步骤的计算机指令的介质。

7. 发明授权

US08117190B2 Method of pattern searching 失效
标题翻译：模式搜索方法
公开(公告)号：US08117190B2
公开(公告)日：2012-02-14
申请号：US12268944
申请日：2008-11-11
申请人： Nikolaos Koudas , Divesh Srivastava , Jignesh M. Patel , Shurug Ali Al-Khalifa , Hosagrahar V. Jagadish , Yuqing Wu
发明人： Nikolaos Koudas , Divesh Srivastava , Jignesh M. Patel , Shurug Ali Al-Khalifa , Hosagrahar V. Jagadish , Yuqing Wu
IPC分类号： G06F7/00
CPC分类号： G06F17/30923 , Y10S707/99932 , Y10S707/99936
摘要： Structural join mechanisms provide efficient query pattern matching. In one embodiment, tree-merge mechanisms are provided. In another embodiment, stack-tree mechanisms are provided.
摘要翻译：结构连接机制提供有效的查询模式匹配。在一个实施例中，提供了树合并机制。在另一个实施例中，提供堆栈树机制。

8. 发明授权

US08015179B2 Method of pattern searching 有权
标题翻译：模式搜索方法
公开(公告)号：US08015179B2
公开(公告)日：2011-09-06
申请号：US12268444
申请日：2008-11-10
申请人： Nikolaos Koudas , Divesh Srivastava , Jignesh M. Patel , Shurug Ali Al-Khalifa , Hosagrahar V. Jagadish , Yuqing Wu
发明人： Nikolaos Koudas , Divesh Srivastava , Jignesh M. Patel , Shurug Ali Al-Khalifa , Hosagrahar V. Jagadish , Yuqing Wu
IPC分类号： G06F7/00
CPC分类号： G06F17/30923 , Y10S707/99932 , Y10S707/99936
摘要： Structural join mechanisms provide efficient query pattern matching. In one embodiment, tree-merge mechanisms are provided. In another embodiment, stack-tree mechanisms are provided.
摘要翻译：结构连接机制提供有效的查询模式匹配。在一个实施例中，提供了树合并机制。在另一个实施例中，提供堆栈树机制。

9. 发明申请

US20090282122A1 Location tracking optimizations 失效
标题翻译：位置跟踪优化
公开(公告)号：US20090282122A1
公开(公告)日：2009-11-12
申请号：US12151799
申请日：2008-05-09
申请人： Jignesh M. Patel , Yun Chen , Karthikeyan Ramasamy
发明人： Jignesh M. Patel , Yun Chen , Karthikeyan Ramasamy
IPC分类号： G06F15/16 , G01C21/00
CPC分类号： G06F17/30241 , H04L67/18 , H04W4/02
摘要： A computer-implemented method includes probing a first band along a centerline dimension for a distribution of Location Based Notifications (LBNs), the distribution including a majority of LBNs clustered along and overlapping with the centerline.
摘要翻译：计算机实现的方法包括沿着中心线维度探测用于分布基于位置的通知（LBN）的第一频带，该分布包括沿着中心线聚集并与其重叠的多数LBN。

10. 发明申请

US20090138470A1 METHOD OF PATTERN SEARCHING 失效
标题翻译：图案搜索方法
公开(公告)号：US20090138470A1
公开(公告)日：2009-05-28
申请号：US12268944
申请日：2008-11-11
申请人： Nikolaos Koudas , Divesh Srivastava , Jignesh M. Patel , Shurug Ali Al-Khalifa , Hosagrahar V. Jagadish , Yuqing Wu
发明人： Nikolaos Koudas , Divesh Srivastava , Jignesh M. Patel , Shurug Ali Al-Khalifa , Hosagrahar V. Jagadish , Yuqing Wu
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30923 , Y10S707/99932 , Y10S707/99936
摘要： Structural join mechanisms provide efficient query pattern matching. In one embodiment, tree-merge mechanisms are provided. In another embodiment, stack-tree mechanisms are provided.
摘要翻译：结构连接机制提供有效的查询模式匹配。在一个实施例中，提供了树合并机制。在另一个实施例中，提供堆栈树机制。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式