会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 1. 发明授权
    • 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 SinghJignesh M. PatelNavin Kabra
    • Ashutosh SinghJignesh M. PatelNavin Kabra
    • G06F1730
    • G06F17/30342Y10S707/99933Y10S707/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虚拟机。
    • 3. 发明授权
    • Method and apparatus for parallel execution of SQL-from within user defined functions
    • 用于从用户定义的函数中并行执行SQL的方法和装置
    • US06594651B2
    • 2003-07-15
    • US09470215
    • 1999-12-22
    • Navin KabraJignesh M. PatelJie-Bing YuBiswadeep NagJian-Jun Chen
    • Navin KabraJignesh M. PatelJie-Bing YuBiswadeep NagJian-Jun Chen
    • G06F1730
    • G06F17/30445G06F17/30463Y10S707/99932Y10S707/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. 发明授权
    • 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. PatelNavin Kabra
    • Jignesh M. PatelNavin Kabra
    • G06F700
    • 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.
    • 一种方法,装置,制品和存储器结构,用于使用提供元组的索引提供对抽象数据类型的访问。 该方法包括接受数据库查询的步骤; 从数据库查询生成索引谓词; 并使用索引谓词从索引中确定元组。 该元组与响应于数据库查询的抽象或复杂数据类型相关联。 数据流用索引谓词初始化; 并且元数据在数据流中返回。 该装置包括用于执行上述方法步骤的装置,并且该制品包括有形地体现用于执行这些方法步骤的计算机指令的介质。
    • 5. 发明授权
    • Method and apparatus for parallel execution of SQL from stored procedures
    • 从存储过程并行执行SQL的方法和装置
    • US06507834B1
    • 2003-01-14
    • US09470927
    • 1999-12-22
    • Navin KabraJignesh M. PatelJie-Bing YuBiswadeep NagJian-Jun Chen
    • Navin KabraJignesh M. PatelJie-Bing YuBiswadeep NagJian-Jun Chen
    • G06F1730
    • G06F17/30415G06F17/30445Y10S707/99932Y10S707/99933Y10S707/99934Y10S707/99943Y10S707/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执行结果的类。