利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

7 条记录 (耗时 0.035 秒)

    Evaluation strategy for execution of SQL queries involving recursion and table queues
    1.
    发明授权
    Evaluation strategy for execution of SQL queries involving recursion and table queues 失效
    执行涉及递归和表队列的SQL查询的评估策略

    公开(公告)号：US5546570A

    公开(公告)日：1996-08-13

    申请号：US390112

    申请日：1995-02-17

    申请人： John A. McPherson, Jr. ,  Mir H. Pirahesh ,  Tuong C. Truong ,  Daniel J. Coyle, Jr.

    发明人： John A. McPherson, Jr. ,  Mir H. Pirahesh ,  Tuong C. Truong ,  Daniel J. Coyle, Jr.

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30595 ,  Y10S707/954 ,  Y10S707/99932 ,  Y10S707/99934

    摘要： The present invention provides an evaluation strategy for the execution of SQL queries involving recursion and table queues in a relational database management system. The table queue is established for the query in the memory of the computer, and tuples are generated by tuple-producing operators in the query for storage into the table queue. As operators of the query read the stored tuples from the table queue, a first end-of-file condition, termed a Temporary End-Of-File, occurs when all of the tuples currently stored in the table queue have been retrieved and control is returned to the operator reading from the table queue. A retry request for additional tuples is generated by the operator through the table queue to the tuple-producing operators. If the tuple-producing operators can generate additional tuples, then these additional tuples are stored into the table queue and control is returned to the operator reading from the table queue in response to the retry request. If the tuple-producing operators cannot generate the additional tuples, then a second end-of-file condition, termed a Permanent End-Of-File, occurs and control is returned to the operator reading from the table queue.

    摘要翻译： 本发明提供了在关系数据库管理系统中执行涉及递归和表队列的SQL查询的评估策略。 为计算机的存储器中的查询建立表队列，并且元组由查询中的元组生成操作符生成，用于存储到表队列中。 当查询的运算符从表队列中读取存储的元组时，当检索到当前存储在表队列中的所有元组，并且控件为“否”时，会发生称为临时文件结束文件的第一个文件结束条件 返回到操作员从表队列中读取。 对于额外的元组的重试请求由操作员通过表队列生成到元组生成操作符。 如果元组生成操作符可以生成额外的元组，那么这些额外的元组被存储到表队列中，并且响应于重试请求将控制返回给操作员从表队列读取。 如果元组生成运算符不能生成额外的元组，则会发生称为永久文件结束的第二个文件结束条件，并将控制权从表队列返回给操作员进行读取。

    Method and combination for minimizing data conversions when data is transferred between a first database storing data in a first format and a second database storing data in a second format
    4.
    发明授权
    Method and combination for minimizing data conversions when data is transferred between a first database storing data in a first format and a second database storing data in a second format 失效
    当数据以第一格式存储数据的第一数据库和以第二格式存储数据的第二数据库之间传送时，最小化数据转换的方法和组合

    公开(公告)号：US5566332A

    公开(公告)日：1996-10-15

    申请号：US288837

    申请日：1994-08-11

    申请人： John G. Adair ,  Daniel J. Coyle, Jr. ,  Robert J. Grafe ,  Bruce G. Lindsay ,  Roger A. Reinsch ,  Robert P. Resch ,  Patricia G. Selinger ,  Melvin R. Zimowski

    发明人： John G. Adair ,  Daniel J. Coyle, Jr. ,  Robert J. Grafe ,  Bruce G. Lindsay ,  Roger A. Reinsch ,  Robert P. Resch ,  Patricia G. Selinger ,  Melvin R. Zimowski

    IPC分类号： G06F12/00 ,  G06F17/30 ,  G06F15/163

    CPC分类号： G06F17/30569 ,  Y10S707/922 ,  Y10S707/99942 ,  Y10S707/99954

    摘要： The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. Any data conversions that may be necessary are done only by the receiver of the data, and only at the point where it is necessary to have the data represented in the receiver's native format for processing. For sending and receiving systems which match, data conversion is completely avoided, even when the data may have been forwarded through intermediate DBMS systems which do not match. For sending and receiving systems which do not match, data conversion is minimized. The data conversion routines and tables in each system are also minimized by requiring conversion only INTO a system's native format, never FROM its native format into some other format.

    摘要翻译： 本发明建立了可以相互理解和保存不同关系数据库管理系统之间交换的数据的上下文，并且可以最小化数据转换。 本发明通过建立隔离机器特性，支持软件级别和用户数据描述的描述信息层来实现这一点。 通过在开发和执行数据库管理系统的不同时间处理不同的描述符级别来实现优化处理。 在协作的数据库管理系统之间交换最小的描述信息。 可能需要的任何数据转换只能由数据的接收者进行，并且只有在需要以接收方的本机格式表示的数据进行处理的时候才能进行。 对于匹配的发送和接收系统，完全避免数据转换，即使数据可能已经通过不匹配的中间DBMS系统转发。 对于不匹配的发送和接收系统，数据转换最小化。 每个系统中的数据转换例程和表也通过仅将INTO转换为系统的本机格式，从不将其本机格式从其他格式转换为最小化。

    Heterogenous database communication system in which communicating systems identify themselves and convert any requests/responses into their own data format
    6.
    发明授权
    Heterogenous database communication system in which communicating systems identify themselves and convert any requests/responses into their own data format 失效
    异构数据库通信系统，其中通信系统识别自身并将任何请求/响应转换成他们自己的数据格式

    公开(公告)号：US5416917A

    公开(公告)日：1995-05-16

    申请号：US66323

    申请日：1993-05-21

    申请人： John G. Adair ,  Daniel J. Coyle, Jr. ,  Robert J. Grafe ,  Bruce G. Lindsay ,  Roger A. Reinsch ,  Robert P. Resch ,  Patricia G. Selinger ,  Melvin R. Zimowski

    发明人： John G. Adair ,  Daniel J. Coyle, Jr. ,  Robert J. Grafe ,  Bruce G. Lindsay ,  Roger A. Reinsch ,  Robert P. Resch ,  Patricia G. Selinger ,  Melvin R. Zimowski

    IPC分类号： G06F12/00 ,  G06F17/30 ,  G06F3/00 ,  G06F13/00

    CPC分类号： G06F17/30569 ,  Y10S707/922 ,  Y10S707/99942 ,  Y10S707/99954

    摘要： The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. Any data conversions that may be necessary are done only by the receiver of the data, and only at the point where it is necessary to have the data represented in the receiver's native format for processing. For sending and receiving systems which match, data conversion is completely avoided, even when the data may have been forwarded through intermediate DBMS systems which do not match. For sending and receiving systems which do not match, data conversion is minimized. The data conversion routines and tables in each system are also minimized by requiring conversion only INTO a system's native format, never FROM its native format into some other format.

    摘要翻译： 本发明建立了可以相互理解和保存不同关系数据库管理系统之间交换的数据的上下文，并且可以最小化数据转换。 本发明通过建立隔离机器特性，支持软件级别和用户数据描述的描述信息层来实现这一点。 通过在开发和执行数据库管理系统的不同时间处理不同的描述符级别来实现优化处理。 在协作的数据库管理系统之间交换最小的描述信息。 可能需要的任何数据转换只能由数据的接收者进行，并且只有在需要以接收方的本机格式表示的数据进行处理的时候才能进行。 对于匹配的发送和接收系统，完全避免数据转换，即使数据可能已经通过不匹配的中间DBMS系统转发。 对于不匹配的发送和接收系统，数据转换最小化。 每个系统中的数据转换例程和表也通过仅将INTO转换为系统的本机格式，从而将其本机格式从其他格式转换为最小化。

    System and method for intercommunicating between applications and a database manager
    7.
    发明授权
    System and method for intercommunicating between applications and a database manager 失效
    用于应用程序和数据库管理器之间的通信的系统和方法

    公开(公告)号：US5129086A

    公开(公告)日：1992-07-07

    申请号：US277386

    申请日：1988-11-29

    申请人： Daniel J. Coyle, Jr. ,  Dan C. Hargrove ,  John M. McConaughy

    发明人： Daniel J. Coyle, Jr. ,  Dan C. Hargrove ,  John M. McConaughy

    IPC分类号： G06F9/45 ,  G06F9/44 ,  G06F9/46 ,  G06F12/00 ,  G06F17/30

    CPC分类号： G06F17/3041 ,  G06F8/00 ,  Y10S707/99933

    摘要： An interfacing system and method for use in computerized systems for intercommunication between application and database systems. A plurality of generic application program interfaces are employed as an interface for use in precompiler development as a runtime interface target to initialize data structures with data required to perform runtime database query language-related functions. The application program is isolated from the database kernel interface facilitating alteration of the database kernel interface without affecting the application program or user-developed precompilers. Parameters used by the interface are employed by applications written to a plurality of host languages. The applications indirectly use these data structures required by the kernel. The interface system supports serialized multiple thread access to the database kernel facilitating performance/functional benefits of multi-threaded applications.