Global session identifiers in a multi-node system
    7.
    发明申请
    Global session identifiers in a multi-node system 审中-公开
    多节点系统中的全局会话标识符

    公开(公告)号:US20060200469A1

    公开(公告)日:2006-09-07

    申请号:US11071275

    申请日:2005-03-02

    IPC分类号: G06F17/30 G06F7/00

    摘要: A method and apparatus for managing sessions across the nodes of a multi-node system is provided. When a session is first initiated on any node of a multi-node system, a global session identifier is assigned to the session. The global session identifier uniquely identifies the session relative to all other sessions managed by the multi-node system. A session monitor may use the global session identifier to collect and store cumulative statistics about the activity of the session, regardless of which node of the multi-node system is currently managing the session, since the global session identifier uniquely identifies the session relative to all other sessions managed by the multi-node system. As a session may be uniquely identified across the lifetime of the session, the session state may be cleaned-up when the session ceases to be maintained, and the activity of the session during its lifetime may be analyzed.

    摘要翻译: 提供了一种用于在多节点系统的节点上管理会话的方法和装置。 当会话首次在多节点系统的任何节点上启动时,全局会话标识符被分配给该会话。 全局会话标识符唯一地标识相对于由多节点系统管理的所有其他会话的会话。 会话监视器可以使用全局会话标识符来收集和存储关于会话的活动的累积统计信息,而不管多节点系统当前正在管理该会话的哪个节点,因为全局会话标识符唯一地标识相对于所有会话的会话 由多节点系统管理的其他会话。 由于可以在会话的整个生命周期中唯一地识别会话,所以可以在会话停止维持时清除会话状态,并且可以分析会话在其生命期内的活动。

    Method and system for scrollable cursors
    8.
    发明授权
    Method and system for scrollable cursors 有权
    可滚动光标的方法和系统

    公开(公告)号:US06973457B1

    公开(公告)日:2005-12-06

    申请号:US10144665

    申请日:2002-05-10

    IPC分类号: G06F17/30

    摘要: A method and system for implementing scrollable cursors is described. A multi-tier caching structure is maintained, in which a partial result set is cached at the client computer and a more-complete result set is cached at the server computer. If the cursor is scrolled in either the forward or backward directions, the partial result set cached at the client computer is first checked to see if requested data is present. If so, then the requested data is fetched from the client cache and the current position of the cursor is moved to the appropriate position in the result set. If the requested data is not present in the client cache, then those data items are fetched from the cache at the server computer.

    摘要翻译: 描述用于实现可滚动光标的方法和系统。 维护多层缓存结构,其中部分结果集在客户端计算机缓存,并且更完整的结果集在服务器计算机上缓存。 如果光标向前或向后滚动,则首先检查客户端计算机缓存的部分结果集,以查看是否存在请求的数据。 如果是这样,则从客户端缓存中取出所请求的数据,并将光标的当前位置移动到结果集中的适当位置。 如果请求的数据不存在于客户机高速缓存中,则从服务器计算机的缓存中取出那些数据项。

    System and method for auto-evolvable remote procedure call structures
    9.
    发明授权
    System and method for auto-evolvable remote procedure call structures 有权
    用于自动演进的远程过程调用结构的系统和方法

    公开(公告)号:US07100171B1

    公开(公告)日:2006-08-29

    申请号:US10144563

    申请日:2002-05-10

    IPC分类号: G06F9/46

    CPC分类号: G06F9/547

    摘要: A system and method for facilitating a remote procedure call (RPC) using an auto-evolvable RPC interface or record type (an “RPC structure”). Each field of an auto-evolvable RPC structure includes a version number and a default value. During a negotiation process, a client and a server exchange their highest version numbers, thereby indicating their RPC capabilities to each other. A higher or more recent version number may indicate a more recent release of the application comprising the RPC. During an RPC, when the client sends a structure to the server, or vice versa, and it has a more recent version, it may omit one or more fields that are not in the recipient's version. When the server receives a structure from the client, or vice versa, and it has a more recent version, it may populate an extra field (not in the sender's version) with its default value.

    摘要翻译: 一种使用自动演进的RPC接口或记录类型(“RPC结构”)促进远程过程调用(RPC)的系统和方法。 自动演进的RPC结构的每个字段包括版本号和默认值。 在协商过程中,客户端和服务器交换其最高版本号,从而向对方显示其RPC功能。 更高或更新的版本号可以指示包括RPC的应用的更新版本。 在RPC期间,当客户端向服务器发送结构,反之亦然,并且具有更新版本时,可能会省略一个或多个不在收件人版本中的字段。 当服务器从客户端收到结构,反之亦然,并且它具有更新版本时,它可能会使用其默认值填充一个额外的字段(不在发件人的版本中)。

    Method and apparatus for efficient SQL processing in an n-tier architecture
    10.
    发明授权
    Method and apparatus for efficient SQL processing in an n-tier architecture 有权
    用于在n层体系结构中进行有效的SQL处理的方法和装置

    公开(公告)号:US07580971B1

    公开(公告)日:2009-08-25

    申请号:US09953490

    申请日:2001-09-10

    IPC分类号: G06F15/16

    摘要: A method and apparatus for efficiently processing data requests in a network oriented n-tier database environment is presented. According to one embodiment of the invention, certain or all data from the tables of a database server device can be maintained in tables on the client device in a client side database cache server system. This local cache allows the network oriented n-tier database system to eliminate the expense of repetitive network transmissions to respond to duplicate queries for the same information. Additionally, the local client device may also keep track of what data is cached on peer network nodes. This allows the client to request that data from a peer database cache server and off load that burden from the database server device. Moreover, the local client may also keep statistics regarding the frequency of requested data in order to optimize the data set maintained in the local database cache server.

    摘要翻译: 提出了一种在面向网络的n层数据库环境中有效处理数据请求的方法和装置。 根据本发明的一个实施例,来自数据库服务器设备的表的某些或所有数据可以在客户机侧数据库高速缓存服务器系统中的客户端设备的表中维护。 该本地缓存允许面向网络的n层数据库系统消除重复网络传输的费用,以响应相同信息的重复查询。 此外,本地客户端设备还可以跟踪在对等网络节点上高速缓存哪些数据。 这允许客户端从对等数据库缓存服务器请求数据,并从数据库服务器设备卸载负担。 此外,本地客户端还可以保持关于所请求数据的频率的统计信息,以便优化本地数据库缓存服务器中维护的数据集。