On-line dynamic file shrink facility
    11.
    发明授权
    On-line dynamic file shrink facility 有权
    在线动态文件收缩设备

    公开(公告)号:US06249792B1

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

    申请号:US09212661

    申请日:1998-12-16

    IPC分类号: G06F1200

    摘要: An on-line dynamic shrink facility sets an allocation fence in a file and moves data from above the fence to below the fence. The fence is based on a target size for the file. When all the data above the fence is moved below the fence, the space above the fence is freed. The target size can be a specified size, an original size for the file when it was created, or a size calculated by examining the amount of space used and adding in an amount of desired free space. Resources that are required to move the data, such as old and new allocation units for the data, or that will be impacted by movement of the data, such as index entries, are locked or latched to prevent corruption of the data while it is being moved. The operations are performed in discreet transactions which are immediately committed to minimize the impact on other users of the file.

    摘要翻译: 在线动态收缩设备在文件中设置分配围栏,并将数据从栅栏上方移动到围栏下方。 围栏基于文件的目标大小。 当栅栏上方的所有数据移动到栅栏下方时,围栏上方的空间将被释放。 目标大小可以是指定的大小,创建文件时的原始大小,或通过检查所使用的空间量和添加所需可用空间的数量计算的大小。 移动数据所需的资源(例如数据的旧的和新的分配单元)或将被数据移动(例如索引条目)影响的资源被锁定或锁定,以防止数据被破坏 移动了 这些操作是在谨慎的交易中执行的,这些交易立即被承诺最小化对文件的其他用户的影响。

    CACHE-FRIENDLY B-TREE ACCELERATOR
    12.
    发明申请
    CACHE-FRIENDLY B-TREE ACCELERATOR 有权
    快速访问B-TREE加速器

    公开(公告)号:US20100306222A1

    公开(公告)日:2010-12-02

    申请号:US12474278

    申请日:2009-05-29

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30961 G06F17/30949

    摘要: A system and method for accelerating searches of B-trees. An auxiliary index that is optimized for use with a cache is used in conjunction with a B-tree. A hash type of auxiliary index maintains pointers to key entries in the B-tree leaf nodes. The hash type of index may be searched, and a resulting pointer is used to locate records of the B-tree, bypassing a search of the B-tree. A top level type of auxiliary index maintains pointers to leaf nodes or internal nodes of the B-tree. A top level index may be searched, and a search of the B-tree is performed beginning with the node found by using the top level index. A monitoring mechanism may automatically start, change, or discard the auxiliary index based on an amount of cache memory, types of searches, or other factors. The auxiliary index may be optimized for high performance in read only searches, while the B-tree provides transaction durability.

    摘要翻译: 一种用于加速搜索B树的系统和方法。 与缓存一起使用的辅助索引与B树结合使用。 辅助索引的哈希类型维护指向B树叶节点中的密钥条目的指针。 可以搜索索引的哈希类型,并且生成的指针用于定位B树的记录,绕过B树的搜索。 辅助索引的顶级类型维护指向叶节点或B树内部节点的指针。 可以搜索顶级索引,并且通过使用顶级索引找到的节点开始执行B树的搜索。 监视机制可以根据高速缓冲存储器的数量,搜索类型或其他因素自动地启动,改变或丢弃辅助索引。 辅助索引可以针对只读搜索中的高性能进行优化,而B树可提供事务持久性。

    SYSTEMS AND METHODS FOR VERSIONING BASED TRIGGERS
    13.
    发明申请
    SYSTEMS AND METHODS FOR VERSIONING BASED TRIGGERS 有权
    用于基于变换的触发器的系统和方法

    公开(公告)号:US20070174358A1

    公开(公告)日:2007-07-26

    申请号:US11696166

    申请日:2007-04-03

    IPC分类号: G06F17/30

    摘要: A system and/or methodology to track and organize database application data in response to a delete, insert or update procedure. More specifically, a system and/or methodology that employs a version-based retention and linkage approach with respect to triggering implementations is provided.

    摘要翻译: 响应于删除,插入或更新过程来跟踪和组织数据库应用程序数据的系统和/或方法。 更具体地,提供了一种采用基于版本的保持和链接方法相对于触发实现的系统和/或方法。