利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

16 条记录 (耗时 0.036 秒)

    System and method for executing a large object fetch query against a database
    1.
    发明授权
    System and method for executing a large object fetch query against a database 有权
    用于针对数据库执行大型对象提取查询的系统和方法

    公开(公告)号：US07039651B2

    公开(公告)日：2006-05-02

    申请号：US10425851

    申请日：2003-04-29

    申请人： Curt L. Cotner ,  Robert A. Begg ,  Brent P. Gross ,  Paul A. Ostler ,  Timothy J. Vincent

    发明人： Curt L. Cotner ,  Robert A. Begg ,  Brent P. Gross ,  Paul A. Ostler ,  Timothy J. Vincent

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30318 ,  Y10S707/99944 ,  Y10S707/99946

    摘要： A database server helps to streamline the retrieval of LOB values by deciding to send a locator in replacement of the LOB value, or the LOB value itself, depending upon the specific LOB value being retrieved. A threshold value is determined in a fetch query, and the LOB sizes below that threshold are sent as values in a corresponding fetch response, and the lengths above are sent as locators in the fetch response. Indicators are inserted in a fetch parameter of the response to inform the receiving client the form of retrieval that was used for each requested LOB value being returned.

    摘要翻译： 数据库服务器有助于通过根据正在检索的特定LOB值决定发送定位器替换LOB值或LOB值本身来简化LOB值的检索。 在获取查询中确定阈值，并且低于该阈值的LOB大小作为相应获取响应中的值发送，并且上述长度作为定位器发送在获取响应中。 指示符插入到响应的提取参数中，以通知接收客户端返回的每个请求的LOB值所使用的检索形式。

    Unique identification of SQL cursor occurrences in a repetitive, nested environment
    3.
    发明授权
    Unique identification of SQL cursor occurrences in a repetitive, nested environment 失效
    重复嵌套环境中SQL游标出现的唯一标识

    公开(公告)号：US06959305B2

    公开(公告)日：2005-10-25

    申请号：US10317234

    申请日：2002-12-10

    申请人： Paul M. Bird ,  Timothy J. Vincent ,  Curt L. Cotner

    发明人： Paul M. Bird ,  Timothy J. Vincent ,  Curt L. Cotner

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30286 ,  Y10S707/954 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99945

    摘要： A cursor query identifier is defined to uniquely identify cursors in a relational database system that supports nested routine invocation. The identifier includes a cursor nesting level value that corresponds to the nested level at which the cursor is opened. The identifier also includes a invocation identifier that corresponds to the routine within which a cursor is opened. The third part of the identifier is a unique cursor counter. The definition of the cursor query identifier permits cursors to be opened within nested levels of the same relational database context and to be uniquely identified for reference by database system and by applications accessing the system.

    摘要翻译： 定义游标查询标识符以唯一标识支持嵌套例程调用的关系数据库系统中的游标。 标识符包括与光标所在的嵌套级别相对应的游标嵌套级别值。 标识符还包括对应于光标被打开的例程的调用标识符。 标识符的第三部分是唯一的光标计数器。 游标查询标识符的定义允许在相同关系数据库上下文的嵌套级别中打开游标，并且被唯一标识以供数据库系统和访问系统的应用程序引用。

    System and method for providing multiple virtual database connections in a relational database system
    8.
    发明授权
    System and method for providing multiple virtual database connections in a relational database system 失效
    在关系数据库系统中提供多个虚拟数据库连接的系统和方法

    公开(公告)号：US06850942B2

    公开(公告)日：2005-02-01

    申请号：US10133162

    申请日：2002-04-26

    申请人： Curt L. Cotner ,  Paul M. Bird ,  Timothy J. Vincent

    发明人： Curt L. Cotner ,  Paul M. Bird ,  Timothy J. Vincent

    IPC分类号： G06F7/00 ,  G06F17/30

    CPC分类号： G06F17/30595 ,  Y10S707/959 ,  Y10S707/99931

    摘要： A method for providing database connections in a network includes: (a) mapping a first plurality of logical connections for a transaction at the application server to a physical connection between the application server and the database server; (b) sending a request of the transaction to the database server utilizing one of the first plurality of logical connections, where the request is sent utilizing the physical connection; and (c) processing the request by a logical agent on the database server, where the logical agent is associated with the transaction, where the request is maintained in one of a second plurality of logical connections within the logical agent. In this manner, connections are logically separated from one another with minimal storage implications. Conflicts and unpredictable behavior can also be avoided.

    摘要翻译： 一种用于在网络中提供数据库连接的方法包括：（a）将应用服务器处的事务的第一多个逻辑连接映射到应用服务器与数据库服务器之间的物理连接; （b）使用所述第一多个逻辑连接中的一个将所述交易的请求发送到所述数据库服务器，其中使用所述物理连接发送所述请求; 以及（c）由数据库服务器上的逻辑代理处理该请求，其中逻辑代理与事务相关联，其中请求被维护在逻辑代理中的第二多个逻辑连接之一中。 以这种方式，连接在逻辑上彼此分离，具有最小的存储影响。 也可以避免冲突和不可预知的行为。

    Substituting parameter markers for literals in database query language statement to promote reuse of previously generated access plans
    9.
    发明授权
    Substituting parameter markers for literals in database query language statement to promote reuse of previously generated access plans 失效
    在数据库查询语言语句中替换文字的参数标记，以促进先前生成的访问计划的重用

    公开(公告)号：US07289978B2

    公开(公告)日：2007-10-30

    申请号：US10389315

    申请日：2003-03-13

    申请人： Joseph Serge Limoges ,  Robert A. Begg ,  Dominique J. Evans ,  William T. O'Connell ,  Klaus Bernhard Schiefer ,  Timothy J. Vincent

    发明人： Joseph Serge Limoges ,  Robert A. Begg ,  Dominique J. Evans ,  William T. O'Connell ,  Klaus Bernhard Schiefer ,  Timothy J. Vincent

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30404 ,  Y10S707/99932

    摘要： A method, computer program product and computing device for promoting reuse of previously generated access plans are disclosed. SQL statements containing literals are amended so as to substitute a parameter marker for each literal. Amended statements are provided to the DBMS along with parameters including the substituted literals and a substitution indicator indicating that the substitution has been performed. The DBMS assesses the soundness of the substitutions that are performed. Soundness may be measured in terms of the semantic correctness of the amended statement and the likelihood that the literal substitution will improve DBMS efficiency. If a substitution is unsound, the DBMS may obtain and optimize the original version of the amended SQL statement. Otherwise, the amended statement is optimized. Advantageously, SQL statements originally differing only in the value of one or more literals may become functionally equivalent, and the reuse of cached, previously generated access plans is thus promoted.

    摘要翻译： 公开了一种用于促进先前生成的访问计划的重用的方法，计算机程序产品和计算设备。 修改包含文字的SQL语句，以替换每个文字的参数标记。 将修改后的语句与包括替代文字的参数以及指示已执行替换的替换指示符一起提供给DBMS。 DBMS评估所进行替换的健全性。 可以根据经修改的语句的语义正确性以及字面替代可以提高DBMS效率的可能性来衡量声音。 如果替换不正确，DBMS可能会获得并优化修改后的SQL语句的原始版本。 否则，修改后的声明进行了优化。 有利地，最初仅在一个或多个文字的值上不同的SQL语句可能在功能上是等效的，因此促进了先前生成的缓存的访问计划的重用。

    System and method for enabling efficient multi-protocol database transaction processing
    10.
    发明授权
    System and method for enabling efficient multi-protocol database transaction processing 有权
    用于实现高效多协议数据库事务处理的系统和方法

    公开(公告)号：US07076489B2

    公开(公告)日：2006-07-11

    申请号：US10390062

    申请日：2003-03-14

    申请人： Robert A. Begg ,  Jo-Anne M. Kirton ,  Timothy J. Vincent

    发明人： Robert A. Begg ,  Jo-Anne M. Kirton ,  Timothy J. Vincent

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30557

    摘要： A system provides efficient multi-protocol database transaction processing in a multi-communications protocol and multi-programming model computing environment. The system separates the source and the target functionalities, and uses generic function names linked to function pointers, in order to permit the source layer to call embedded functions in the target layer. As an example, the system provides a source layer code path that includes embedded call-back functions and embedded generic function names. A target layer code path is set to include embedded functions and generic call-back function names. A function pointer array permits the source layer code path to call functions embedded in the target layer code path using the generic function names. A call-back function pointer array permits the target layer code path to call the call-back functions embedded in the source layer code path using the generic call-back function names.

    摘要翻译： 系统在多通信协议和多编程模型计算环境中提供有效的多协议数据库事务处理。 系统分离源和目标功能，并使用链接到函数指针的通用函数名，以便允许源层调用目标层中的嵌入式函数。 作为示例，系统提供包括嵌入式回调函数和嵌入式通用函数名称的源层代码路径。 目标层代码路径被设置为包括嵌入式函数和通用回调函数名称。 函数指针数组允许源层代码路径使用通用函数名调用嵌入在目标层代码路径中的函数。 回调函数指针数组允许目标层代码路径使用通用回调函数名称来调用嵌入在源层代码路径中的回调函数。