利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

122 条记录 (耗时 0.047 秒)

    In-memory space management for database systems
    1.
    发明授权
    In-memory space management for database systems 有权
    数据库系统的内存空间管理

    公开(公告)号：US07664799B2

    公开(公告)日：2010-02-16

    申请号：US11830568

    申请日：2007-07-30

    申请人： Niloy Mukherjee ,  Amit Ganesh ,  Sujatha Muthulingam ,  Wei Zhang

    发明人： Niloy Mukherjee ,  Amit Ganesh ,  Sujatha Muthulingam ,  Wei Zhang

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30595 ,  G06F9/5005 ,  G06F9/5016 ,  G06F9/526 ,  Y10S707/99956

    摘要： A framework for in-memory space management for content management database systems is provided. A per-instance in-memory dispenser is partitioned. An incoming transaction takes a latch on a partition and obtains sufficient block usage to perform and complete the transaction. Generating redo information is decoupled from transaction level processing and, instead, is performed when block requests are loaded into the in-memory dispenser or synced therefrom to a per-instance on-disk structure.

    摘要翻译： 提供了内容管理数据库系统的内存空间管理框架。 每个实例的内存分配器被分区。 传入的事务在分区上占用一个锁存器，并获得足够的块使用来执行和完成事务。 生成重做信息与事务级别处理分离，而是将块请求加载到内存分配器中或从其同步到每个实例磁盘结构时执行。

    Proactive space allocation in a database system
    3.
    发明授权
    Proactive space allocation in a database system 有权
    在数据库系统中主动分配空间

    公开(公告)号：US07716177B2

    公开(公告)日：2010-05-11

    申请号：US11880917

    申请日：2007-07-24

    申请人： Wei Zhang ,  Amit Ganesh ,  Sujatha Muthulingam ,  Niloy Mukherjee

    发明人： Wei Zhang ,  Amit Ganesh ,  Sujatha Muthulingam ,  Niloy Mukherjee

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30595 ,  G06F12/0223

    摘要： A method and apparatus for proactively allocating space to a logical layer of a database is provided. Allocation of space to a logical layer of a database is an expensive operation that should be minimized. The allocation of space includes discovering free space in all the higher layers in the logical storage hierarchy. It also includes cross-domain system calls and cleansing disk-write operations. In prior approaches, the allocation processes were triggered on-demand, only a certain logical layer was discovered to be at full capacity when an insert-row operation was attempted. In one embodiment of the invention, space needs are statistically predicted based on prior rates of space consumption. The database server pre-allocates space as needed, based on the statistical predictions. Rates of consumption are examined periodically. Space is pre-allocated before any logical layer reaches full capacity by a combination of proactive background processes; foreground-triggered, background processes; and classic foreground allocation.

    摘要翻译： 提供了一种用于主动地将空间分配给数据库的逻辑层的方法和装置。 将空间分配到数据库的逻辑层是一个应该最小化的昂贵的操作。 空间分配包括发现逻辑存储层次结构中所有较高层的可用空间。 它还包括跨域系统调用和清理磁盘写入操作。 在先前的方法中，分配过程是按需触发的，当尝试插入行操作时，只发现某个逻辑层处于满载状态。 在本发明的一个实施例中，基于先前的空间消耗率来统计地预测空间需求。 数据库服务器根据统计预测，根据需要预分配空间。 定期检查消费量。 在任何逻辑层通过主动后台进程的组合达到满容量之前，预先分配空间; 前台触发，后台进程; 和经典的前景分配。

    Proactive space allocation in a database system
    5.
    发明申请
    Proactive space allocation in a database system 有权
    在数据库系统中主动分配空间

    公开(公告)号：US20090030956A1

    公开(公告)日：2009-01-29

    申请号：US11880917

    申请日：2007-07-24

    申请人： Wei Zhang ,  Amit Ganesh ,  Sujatha Muthulingam ,  Niloy Mukherjee

    发明人： Wei Zhang ,  Amit Ganesh ,  Sujatha Muthulingam ,  Niloy Mukherjee

    IPC分类号： G06F12/00

    CPC分类号： G06F17/30595 ,  G06F12/0223

    摘要： A method and apparatus for proactively allocating space to a logical layer of a database is provided. Allocation of space to a logical layer of a database is an expensive operation that should be minimized. The allocation of space includes discovering free space in all the higher layers in the logical storage hierarchy. It also includes cross-domain system calls and cleansing disk-write operations. In prior approaches, the allocation processes were triggered on-demand, only a certain logical layer was discovered to be at full capacity when an insert-row operation was attempted. In one embodiment of the invention, space needs are statistically predicted based on prior rates of space consumption. The database server pre-allocates space as needed, based on the statistical predictions. Rates of consumption are examined periodically. Space is pre-allocated before any logical layer reaches full capacity by a combination of proactive background processes; foreground-triggered, background processes; and classic foreground allocation.

    摘要翻译： 提供了一种用于主动地将空间分配给数据库的逻辑层的方法和装置。 将空间分配到数据库的逻辑层是一个应该最小化的昂贵的操作。 空间分配包括发现逻辑存储层次结构中所有较高层的可用空间。 它还包括跨域系统调用和清理磁盘写入操作。 在先前的方法中，分配过程是按需触发的，当尝试插入行操作时，只发现某个逻辑层处于满载状态。 在本发明的一个实施例中，基于先前的空间消耗率来统计地预测空间需求。 数据库服务器根据统计预测，根据需要预分配空间。 定期检查消费量。 在任何逻辑层通过主动后台进程的组合达到满容量之前预先分配空间; 前台触发，后台进程; 和经典的前景分配。

    IN-MEMORY SPACE MANAGEMENT FOR DATABASE SYSTEMS
    6.
    发明申请
    IN-MEMORY SPACE MANAGEMENT FOR DATABASE SYSTEMS 有权
    数据库系统的内存空间管理

    公开(公告)号：US20090037498A1

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

    申请号：US11830568

    申请日：2007-07-30

    申请人： Niloy Mukherjee ,  Amit Ganesh ,  Sujatha Muthulingam ,  Wei Zhang

    发明人： Niloy Mukherjee ,  Amit Ganesh ,  Sujatha Muthulingam ,  Wei Zhang

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30595 ,  G06F9/5005 ,  G06F9/5016 ,  G06F9/526 ,  Y10S707/99956

    摘要： A framework for in-memory space management for content management database systems is provided. A per-instance in-memory dispenser is partitioned. An incoming transaction takes a latch on a partition and obtains sufficient block usage to perform and complete the transaction. Generating redo information is decoupled from transaction level processing and, instead, is performed when block requests are loaded into the in-memory dispenser or synced therefrom to a per-instance on-disk structure.

    摘要翻译： 提供了内容管理数据库系统的内存空间管理框架。 每个实例的内存分配器被分区。 传入的事务在分区上占用一个锁存器，并获得足够的块使用来执行和完成事务。 生成重做信息与事务级别处理分离，而是将块请求加载到内存分配器中或从其同步到每个实例磁盘结构时执行。

    Framework to optimize delete all rows operations on database objects
    7.
    发明申请
    Framework to optimize delete all rows operations on database objects 有权
    优化框架来删除数据库对象上的所有行操作

    公开(公告)号：US20070288529A1

    公开(公告)日：2007-12-13

    申请号：US11450092

    申请日：2006-06-09

    申请人： Amit Ganesh ,  Niloy Mukherjee ,  Manosiz Bhattacharyya ,  Bipul Sinha

    发明人： Amit Ganesh ,  Niloy Mukherjee ,  Manosiz Bhattacharyya ,  Bipul Sinha

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30442

    摘要： A bulk delete operation with reduced latency allows for retrieval of deleted data. Each database object holds a Delete SCN indicating when a bulk delete operation was last performed. Each row in the database object holds a Row Modification SCN indicating when the row was last updated. A bulk delete is performed by writing the old value of the Delete SCN to the undo tablespace and updating the Delete SCN. No undo information is stored for the rows. A write is performed by finding a deleted row, storing undo information for the deleted row and writing over the deleted row. To read from the database object, a rollback operation is performed, if necessary. Those rows are then retrieved for which the Row Modification SCN is higher than the Delete SCN and is less than or equal to the timestamp for the requested data.

    摘要翻译： 减少延迟的批量删除操作允许检索已删除的数据。 每个数据库对象保存一个删除SCN，指示上次执行批量删除操作的时间。 数据库对象中的每一行都保存一行行修改SCN，指示行何时上次更新。 通过将删除SCN的旧值写入undo表空间并更新删除SCN来执行批量删除。 没有为行存储撤消信息。 通过查找删除的行，存储删除的行的撤消信息并写入被删除的行来执行写入。 要从数据库对象读取，必要时执行回滚操作。 然后检索行修改SCN高于删除SCN并且小于或等于所请求数据的时间戳的那些行。

    Framework to optimize delete all row operations on database objects to improve throughput, query ability and flashback
    8.
    发明授权
    Framework to optimize delete all row operations on database objects to improve throughput, query ability and flashback 有权
    优化框架来删除数据库对象上的所有行操作，以提高吞吐量，查询能力和回发

    公开(公告)号：US08856083B2

    公开(公告)日：2014-10-07

    申请号：US11450092

    申请日：2006-06-09

    申请人： Amit Ganesh ,  Niloy Mukherjee ,  Manosiz Bhattacharyya ,  Bipul Sinha

    发明人： Amit Ganesh ,  Niloy Mukherjee ,  Manosiz Bhattacharyya ,  Bipul Sinha

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

    CPC分类号： G06F17/30442

    摘要： A bulk delete operation with reduced latency allows for retrieval of deleted data. Each database object holds a Delete SCN indicating when a bulk delete operation was last performed. Each row in the database object holds a Row Modification SCN indicating when the row was last updated. A bulk delete is performed by writing the old value of the Delete SCN to the undo tablespace and updating the Delete SCN. No undo information is stored for the rows. A write is performed by finding a deleted row, storing undo information for the deleted row and writing over the deleted row. To read from the database object, a rollback operation is performed, if necessary. Those rows are then retrieved for which the Row Modification SCN is higher than the Delete SCN and is less than or equal to the timestamp for the requested data.

    摘要翻译： 减少延迟的批量删除操作允许检索已删除的数据。 每个数据库对象保存一个删除SCN，指示上次执行批量删除操作的时间。 数据库对象中的每一行都保存一行行修改SCN，指示行何时上次更新。 通过将删除SCN的旧值写入undo表空间并更新删除SCN来执行批量删除。 没有为行存储撤消信息。 通过查找删除的行，存储删除的行的撤消信息并写入被删除的行来执行写入。 要从数据库对象读取，必要时执行回滚操作。 然后检索行修改SCN高于删除SCN并且小于或等于所请求数据的时间戳的那些行。