Fact table storage in a decision support system environment
    4.
    发明授权
    Fact table storage in a decision support system environment 有权
    事实表存储在决策支持系统环境中

    公开(公告)号:US07480662B2

    公开(公告)日:2009-01-20

    申请号:US10719819

    申请日:2003-11-20

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

    摘要: A fact table is set up without any dimension columns. The data in the table is ordered according to an order corresponding to the ordering of the dimensions. The table is divided into segments corresponding to contiguous portions of data. The portions of the table containing non-null values for the measures are placed into the segments. The size of the segments and the location segments may be determined according to the density of discontinuities in the data. An indexed organized table is used to determine the beginning and end of each segment of the table, the locations of the discontinuities in the data, and to facilitate accessing the measures of the table.

    摘要翻译: 事实表设置没有任何维度列。 表中的数据按照与尺寸顺序对应的顺序进行排序。 该表被分成对应于数据的连续部分的段。 包含度量值的非空值的表的部分被放入段中。 可以根据数据中的不连续密度来确定段和位置段的大小。 索引的有组织的表用于确定表的每个段的开始和结束,数据中的不连续性的位置,以及便于访问表的度量。

    System and method for performing a data uniqueness check in a sorted data set
    7.
    发明授权
    System and method for performing a data uniqueness check in a sorted data set 有权
    用于在排序数据集中执行数据唯一性检查的系统和方法

    公开(公告)号:US07752181B2

    公开(公告)日:2010-07-06

    申请号:US10984113

    申请日:2004-11-08

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30312 G06F17/30371

    摘要: Embodiments of the present invention include a method for performing a data uniqueness check in a set of sorted data blocks comprising accessing data to be inserted into the set of sorted data blocks, determining a proper data block of the set of sorted data blocks for which the data to be inserted should be located based on a first sorting key. The method further includes examining the proper data block for an existing data entry and if the proper data block is empty, the method further includes inserting the data to be inserted into the proper data block of the set of sorted data blocks.

    摘要翻译: 本发明的实施例包括一种用于在一组分类数据块中执行数据唯一性检查的方法,包括访问要插入到该排序数据块集合中的数据,确定该排序数据块集合中的适当数据块, 应插入的数据应基于第一个排序键来定位。 该方法还包括检查现有数据条目的正确数据块,如果正确的数据块为空,则该方法还包括将要插入的数据插入到该排序数据块集合的正确数据块中。

    System and method for performing a data uniqueness check in a sorted data set
    8.
    发明申请
    System and method for performing a data uniqueness check in a sorted data set 有权
    用于在排序数据集中执行数据唯一性检查的系统和方法

    公开(公告)号:US20060122963A1

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

    申请号:US10984113

    申请日:2004-11-08

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30312 G06F17/30371

    摘要: Embodiments of the present invention include a method for performing a data uniqueness check in a set of sorted data blocks comprising accessing data to be inserted into the set of sorted data blocks, determining a proper data block of the set of sorted data blocks for which the data to be inserted should be located based on a first sorting key. The method further includes examining the proper data block for an existing data entry and if the proper data block is empty, the method further includes inserting the data to be inserted into the proper data block of the set of sorted data blocks.

    摘要翻译: 本发明的实施例包括一种用于在一组分类数据块中执行数据唯一性检查的方法,包括访问要插入到该排序数据块集合中的数据,确定该排序数据块集合中的适当数据块, 应插入的数据应基于第一个排序键来定位。 该方法还包括检查现有数据条目的正确数据块,如果正确的数据块为空,则该方法还包括将要插入的数据插入到该排序数据块集合的正确数据块中。

    Dynamic partitioning of a reusable resource
    9.
    发明授权
    Dynamic partitioning of a reusable resource 有权
    可重用资源的动态分区

    公开(公告)号:US07047386B1

    公开(公告)日:2006-05-16

    申请号:US09872243

    申请日:2001-05-31

    IPC分类号: G06F12/00

    摘要: Techniques for managing changes in a computer system include storing, in a storage space, undo information for removing changes that are being made by entities. The undo information for each entity is stored in a segment of multiple segments within the storage space. Usage of the storage space by the entities is monitored. The number of segments in the plurality of segments or the sizes of the plurality of segments or both are adjusted automatically based on the usage. These techniques allow a resource to be recycled and allocated for new uses by other entities in a computer system dynamically based on usage. These techniques do not burden a human administrator with partitioning the resource and then penalize the administrator and users by generating errors when the partitions do not match usage.

    摘要翻译: 用于管理计算机系统中的变化的技术包括在存储空间中存储用于去除由实体进行的改变的撤销信息。 每个实体的撤消信息存储在存储空间内的多个段的段中。 监视实体对存储空间的使用情况。 根据使用情况自动调整多个段中的段的数量或多个段或两者的大小。 这些技术允许资源根据用途动态地回收和分配给计算机系统中的其他实体的新用途。 这些技术不会给管理员分配资源造成负担,然后通过在分区与使用情况不匹配时生成错误来惩罚管理员和用户。

    Techniques for time-based retention of a reusable resource
    10.
    发明授权
    Techniques for time-based retention of a reusable resource 有权
    用于基于时间的保留可重用资源的技术

    公开(公告)号:US06574717B1

    公开(公告)日:2003-06-03

    申请号:US09872267

    申请日:2001-05-31

    IPC分类号: G06F1300

    CPC分类号: G06F17/30371

    摘要: Techniques for managing, within a computer system, a resource that is reusable by a plurality of entities include establishing a minimum period of time for retaining an amount of the resource after completion of use of the resource by an entity. A first amount of the resource is allocated to a first entity. After allocating the first amount to the first entity, the first amount is prevented from being allocated to a second entity before the minimum period of time expires after the first entity completes use of the first resource. These techniques allow resources to be recycled and allocated for new uses by other entities in a computer system, but also guarantee the resources are retained in a given state for consistent use by other entities, even after the entity terminates that first had the resource allocated.

    摘要翻译: 在计算机系统内管理由多个实体可重用的资源的技术包括在实体完成使用资源之后建立用于保留资源量的最小时间段。 资源的第一数量被分配给第一实体。 在向第一实体分配第一数量之后,在第一实体完成使用第一资源之后的最短时间段到期之前,防止第一数量被分配给第二实体。 这些技术允许资源被回收并分配给计算机系统中的其他实体的新用途,而且还保证资源被保持在给定状态以供其他实体的一致使用,即使在实体终止之后,首先资源被分配。