System and method for pre-compiling a source cursor into a target library cache
    33.
    发明授权
    System and method for pre-compiling a source cursor into a target library cache 有权
    将源光标预编译为目标库缓存的系统和方法

    公开(公告)号:US06892205B1

    公开(公告)日:2005-05-10

    申请号:US10086842

    申请日:2002-02-28

    IPC分类号: G06F17/00 G06F17/30

    摘要: A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.

    摘要翻译: 描述了使得第二数据库实例能够更快速地处理执行先前由第一数据库实例执行的数据库语句的请求的系统和方法。 在一个实施例中,该方法涉及将数据库语句从第一数据库实例发送到第二数据库实例,并且由第二数据库实例生成准备执行语句所需的一个或多个结构,诸如解析树和执行计划 为声明。 如果在将来的某个时刻,第二个数据库实例接收到执行相同语句的请求,上述结构可以用于执行,从而不需要一个或多个潜在的耗时的操作,比如生成解析 树或执行计划。

    Automatic failover for clients accessing a resource through a server
    34.
    发明授权
    Automatic failover for clients accessing a resource through a server 失效
    客户端通过服务器访问资源的自动故障切换

    公开(公告)号:US06490610B1

    公开(公告)日:2002-12-03

    申请号:US08866842

    申请日:1997-05-30

    IPC分类号: G06F900

    摘要: A method and system for recovering after failure of a first server to which a client was connected for accessing a resource is provided. When it is detected that a connection between the first server and the client has failed, the client is automatically connected with a second server that has access to the resource. After automatically connecting the client, the client accesses the resource through the second server. The client stores information about the state of the session with the first server so that processing can continue where it left off after the client connects with the second server. The client may be pre-connected to the second server prior to the failure of the first server to reduce the latency caused by switching in response to a failure. The second server may be configured to pre-parse the commands that the client issues to the first server to further reduce the latency associated with switching to the second server.

    摘要翻译: 提供了一种用于在连接了客户机以访问资源的第一服务器故障之后恢复的方法和系统。 当检测到第一服务器和客户端之间的连接发生故障时,客户机将自动连接到可访问该资源的第二个服务器。 客户端自动连接后,客户端通过第二台服务器访问资源。 客户端存储有关第一台服务器的会话状态的信息,以便在客户端与第二台服务器连接后,处理可以继续停止。 在第一服务器发生故障之前,客户端可能被预连接到第二服务器,以减少由于故障而导致的切换所引起的等待时间。 第二服务器可以被配置为预先解析客户端向第一服务器发出的命令,以进一步减少与切换到第二服务器相关联的延迟。

    Method and system for maintaining checkpoint values
    35.
    发明授权
    Method and system for maintaining checkpoint values 失效
    维护检查点值的方法和系统

    公开(公告)号:US06253212B1

    公开(公告)日:2001-06-26

    申请号:US09103627

    申请日:1998-06-23

    IPC分类号: G06F1730

    摘要: A method and system are provided for maintaining a checkpoint value that indicates which records of a plurality of records associated with updates made before a failure have to be processed after the failure. According to one aspect of the invention, an ordered list of buffers is maintained in volatile memory. The ordered list of buffers has a head and a tail. The ordered list of buffers is maintained by writing a record that indicates the update to nonvolatile memory and adding the buffer to the tail of the ordered list whenever an update is made to a data item within a buffer in volatile memory. When a data item contained in a buffer within the ordered list is stored in nonvolatile memory, the buffer can be removed from the ordered list. A checkpoint value that identifies a record associated with a buffer located at the head of the ordered list is written to nonvolatile memory. According to another aspect, after a failure, the record associated with the checkpoint value is identified. If a particular record was stored to nonvolatile memory before the record associated with the checkpoint value, the particular record is not processed. If the particular record was not stored to nonvolatile memory before the record associated with the checkpoint value, the particular record is processed.

    摘要翻译: 提供了一种方法和系统,用于维护检查点值,该检查点值指示在故障之后必须处理故障之前所做出的与更新相关联的多个记录的哪些记录。 根据本发明的一个方面,缓存器的有序列表被保存在易失性存储器中。 缓冲区的有序列表有一个头和尾。 通过写入一个指示更新到非易失性存储器的记录来维护缓冲区的有序列表,并且每当对易失性存储器中的缓冲器内的数据项进行更新时,将该缓冲区添加到有序列表的尾部。 当包含在有序列表中的缓冲器中的数据项存储在非易失性存储器中时,可以从有序列表中移除缓冲区。 标识与位于有序列表头部的缓冲区关联的记录的检查点值被写入非易失性存储器。 根据另一方面,在故障之后,识别与检查点值相关联的记录。 如果在与检查点值相关联的记录之前将特定记录存储到非易失性存储器中,则不处理特定记录。 如果在与检查点值相关联的记录之前没有将特定记录存储到非易失性存储器中,则处理特定记录。

    Method and apparatus for performing selective encryption/decryption in a data storage system
    36.
    发明授权
    Method and apparatus for performing selective encryption/decryption in a data storage system 有权
    用于在数据存储系统中执行选择性加密/解密的方法和装置

    公开(公告)号:US08892905B2

    公开(公告)日:2014-11-18

    申请号:US11726428

    申请日:2007-03-21

    IPC分类号: G06Q30/02 H04L9/08

    CPC分类号: H04L9/0894

    摘要: One embodiment of the present invention provides a system for performing selective encryption/decryption in a data storage system. During operation, the system receives a data block from a storage medium at an input/output layer, wherein the input/output layer serves as an interface between the storage medium and a buffer cache. Next, the system determines whether the data block is an encrypted data block. If not, the system stores the data block in the buffer cache. Otherwise, if the data block is an encrypted data block, the system retrieves a storage-key, wherein the storage-key is associated with a subset of storage, which is associated with the encrypted data block. Using the storage-key, the system then decrypts the encrypted data block to produce a decrypted data block. Finally, the system stores the decrypted data block in the buffer cache, wherein the data block remains encrypted in the storage medium.

    摘要翻译: 本发明的一个实施例提供一种用于在数据存储系统中执行选择性加密/解密的系统。 在操作期间,系统在输入/输出层从存储介质接收数据块,其中输入/输出层用作存储介质和缓冲器高速缓存之间的接口。 接下来,系统确定数据块是否是加密数据块。 如果没有,系统将数据块存储在缓冲区高速缓存中。 否则,如果数据块是加密数据块,则系统检索存储密钥,其中存储密钥与与加密数据块相关联的存储子集相关联。 使用存储密钥,系统然后解密加密的数据块以产生解密的数据块。 最后,系统将解密的数据块存储在缓冲器高速缓存中,其中数据块在存储介质中保持加密。

    CASCADING INDEX COMPRESSION
    40.
    发明申请

    公开(公告)号:US20090292947A1

    公开(公告)日:2009-11-26

    申请号:US12469637

    申请日:2009-05-20

    IPC分类号: G06F11/07 G06F17/30

    CPC分类号: G06F11/1474 G06F17/30

    摘要: Techniques for maintaining a cascading index are provided. In one approach, one or more branch node compression techniques are applied to the main index of a cascading index. In an approach, a Bloom filter is generated and associated with, e.g., a branch node in the main index. The Bloom filter is used to determine whether, without accessing any leaf blocks, a particular key value exists, e.g., in leaf blocks associated with the branch node. In an approach, a new redo record is generated in response to a merge operation between two levels of the cascading index. The new redo record comprises (a) one or more addresses of blocks that are affected by the merge operation, (b) data is that being “pushed down” to a lower level of the cascading index, and (c) one or more addresses of blocks that are written to disk storage as a result of the merge operation.

    摘要翻译: 提供了维护级联索引的技术。 在一种方法中,一个或多个分支节点压缩技术被应用于级联索引的主索引。 在一种方法中,生成Bloom过滤器并与例如主索引中的分支节点相关联。 Bloom过滤器用于确定在不访问任何叶片块的情况下是否存在特定的键值,例如在与分支节点相关联的叶片块中。 在一种方法中,响应于级联索引的两个级别之间的合并操作,生成新的重做记录。 新的重做记录包括(a)受合并操作影响的块的一个或多个地址,(b)数据被“下推”到级联索引的较低级,以及(c)一个或多个地址 作为合并操作的结果写入磁盘存储的块。