Cache enumeration and indexing
    3.
    发明授权
    Cache enumeration and indexing 有权
    缓存枚举和索引

    公开(公告)号:US08261020B2

    公开(公告)日:2012-09-04

    申请号:US12469688

    申请日:2009-05-21

    IPC分类号: G06F12/00

    摘要: In response to a request including a state object, which can indicate a state of an enumeration of a cache, the enumeration can be continued by using the state object to identify and send cache data. Also, an enumeration of cache units can be performed by traversing a data structure that includes object nodes, which correspond to cache units, and internal nodes. An enumeration state stack can indicate a current state of the enumeration, and can include state nodes that correspond to internal nodes in the data structure. Additionally, a cache index data structure can include a higher level table and a lower level table. The higher level table can have a leaf node pointing to the lower level table, and the lower level table can have a leaf node pointing to one of the cache units. Moreover, the lower level table can be associated with a tag.

    摘要翻译: 响应于包括可指示高速缓存的枚举状态的状态对象的请求,可以通过使用状态对象来识别和发送高速缓存数据来继续枚举。 此外,可以通过遍历包括对应于高速缓存单元的对象节点和内部节点的数据结构来执行缓存单元的枚举。 枚举状态堆栈可以指示枚举的当前状态,并且可以包括对应于数据结构中的内部节点的状态节点。 此外,缓存索引数据结构可以包括更高级别的表和较低级别的表。 较高级别的表可以具有指向低级表的叶节点,并且下级表可以具有指向其中一个高速缓存单元的叶节点。 此外,较低级别的表可以与标签相关联。

    Storage model for large object columns
    5.
    发明授权
    Storage model for large object columns 有权
    大对象列的存储模型

    公开(公告)号:US07853619B2

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

    申请号:US10949895

    申请日:2004-09-23

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30318 G06F17/30607

    摘要: Methods and apparatus for enabling a plurality of table columns arranged to be associated with large objects (LOBs) to share a single LOB data segment within a database are disclosed. According to one aspect of the present invention, a method for allocating space associated with at least a first column arranged to accommodate LOB data and a second column arranged to accommodate LOB data includes allocating a first LOB data segment. The method also includes associating both the first column and the second column with the first LOB data segment.

    摘要翻译: 公开了一种用于启用被布置为与大对象(LOB)相关联的多个表列以在数据库内共享单个LOB数据段的方法和装置。 根据本发明的一个方面,一种用于分配空间的方法,所述方法用于分配与至少布置成容纳LOB数据的第一列相关联的空间,以及用于容纳LOB数据的第二列,包括分配第一LOB数据段。 该方法还包括将第一列和第二列与第一LOB数据段相关联。

    CACHE ENUMERATION AND INDEXING
    6.
    发明申请
    CACHE ENUMERATION AND INDEXING 有权
    缓存创建和索引

    公开(公告)号:US20100293332A1

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

    申请号:US12469688

    申请日:2009-05-21

    IPC分类号: G06F12/08 G06F17/30 G06F12/00

    摘要: In response to a request including a state object, which can indicate a state of an enumeration of a cache, the enumeration can be continued by using the state object to identify and send cache data. Also, an enumeration of cache units can be performed by traversing a data structure that includes object nodes, which correspond to cache units, and internal nodes. An enumeration state stack can indicate a current state of the enumeration, and can include state nodes that correspond to internal nodes in the data structure. Additionally, a cache index data structure can include a higher level table and a lower level table. The higher level table can have a leaf node pointing to the lower level table, and the lower level table can have a leaf node pointing to one of the cache units. Moreover, the lower level table can be associated with a tag.

    摘要翻译: 响应于包括可指示高速缓存的枚举状态的状态对象的请求,可以通过使用状态对象来识别和发送高速缓存数据来继续枚举。 此外,可以通过遍历包括对应于高速缓存单元的对象节点和内部节点的数据结构来执行缓存单元的枚举。 枚举状态堆栈可以指示枚举的当前状态,并且可以包括对应于数据结构中的内部节点的状态节点。 此外,缓存索引数据结构可以包括更高级别的表和较低级别的表。 较高级别的表可以具有指向低级表的叶节点,并且下级表可以具有指向其中一个高速缓存单元的叶节点。 此外,较低级别的表可以与标签相关联。

    Object-oriented materialized views
    8.
    发明授权
    Object-oriented materialized views 有权
    面向对象的物化视图

    公开(公告)号:US07158994B1

    公开(公告)日:2007-01-02

    申请号:US10006605

    申请日:2001-12-05

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    摘要: Techniques are provided for creating object-oriented materialized views. The object-oriented materialized views may be object materialized views or object-relational materialized views. The base tables may be object tables, object relational tables, or relational tables. The object-oriented materialized views may be refreshed, fully or incrementally. When an object-oriented materialized view is created, refresh code is generated for it. Through the use of object-oriented materialized views, users gain both the efficiency of materialized views and the power of the object-oriented paradigm.

    摘要翻译: 提供了用于创建面向对象的物化视图的技术。 面向对象的物化视图可以是对象物化视图或物体关系物化视图。 基表可以是对象表,对象关系表或关系表。 面向对象的物化视图可以被刷新,完全或递增。 当创建面向对象的物化视图时,会为其生成刷新代码。 通过使用面向对象的物化视图,用户可以获得物化视图的效率和面向对象范式的力量。

    Storage model for large object columns
    9.
    发明申请
    Storage model for large object columns 有权
    大对象列的存储模型

    公开(公告)号:US20060075006A1

    公开(公告)日:2006-04-06

    申请号:US10949895

    申请日:2004-09-23

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30318 G06F17/30607

    摘要: Methods and apparatus for enabling a plurality of table columns arranged to be associated with large objects (LOBs) to share a single LOB data segment within a database are disclosed. According to one aspect of the present invention, a method for allocating space associated with at least a first column arranged to accommodate LOB data and a second column arranged to accommodate LOB data includes allocating a first LOB data segment. The method also includes associating both the first column and the second column with the first LOB data segment.

    摘要翻译: 公开了一种用于启用被布置为与大对象(LOB)相关联的多个表列以共享数据库内的单个LOB数据段的方法和装置。 根据本发明的一个方面,一种用于分配空间的方法,所述方法用于分配与至少布置成容纳LOB数据的第一列相关联的空间,以及用于容纳LOB数据的第二列,包括分配第一LOB数据段。 该方法还包括将第一列和第二列与第一LOB数据段相关联。

    Storage optimization for VARRAY columns
    10.
    发明申请
    Storage optimization for VARRAY columns 有权
    VARRAY列的存储优化

    公开(公告)号:US20060047670A1

    公开(公告)日:2006-03-02

    申请号:US10912426

    申请日:2004-08-05

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30318

    摘要: Methods and apparatus for efficiently storing data in a variable array (VARRAY) of a database system are disclosed. A method for storing data in a VARRAY having an associated large object segment in a system having a memory and a kernel includes determining a size of data to be inserted into the VARRAY. The method also includes determining when the size of the data is less than a threshold value, and storing the data as inline raw data in a column of the VARRAY that is present in the memory when the size of the data is less than the threshold value. When the size of the data is not less than the threshold value, the data is stored in a large object that is associated with the VARRAY. Further, when a VARRAY type is evolved to have a larger maximum size, existing data is not migrated or transformed.

    摘要翻译: 公开了将数据有效地存储在数据库系统的可变数组(VARRAY)中的方法和装置。 在具有存储器和内核的系统中具有相关联的大对象段的VARRAY中存储数据的方法包括确定要插入到VARRAY中的数据的大小。 该方法还包括当数据的大小小于阈值时确定数据的大小是否小于阈值,并且当数据的大小小于阈值时,将数据作为内联原始数据存储在存在于存储器中的VARRAY的列中 。 当数据的大小不小于阈值时,数据存储在与VARRAY相关联的大对象中。 此外,当VARRAY类型演变为具有较大的最大大小时,现有数据不会迁移或转换。