利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

6 条记录 (耗时 0.016 秒)

    Efficient storing and querying of snapshot measures
    1.
    发明申请
    Efficient storing and querying of snapshot measures 有权
    有效地存储和查询快照测量

    公开(公告)号：US20060253414A1

    公开(公告)日：2006-11-09

    申请号：US11314733

    申请日：2005-12-21

    申请人： Ashish Mittal ,  Edward Suen

    发明人： Ashish Mittal ,  Edward Suen

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30592 ,  G06F17/30551

    摘要： A facility for efficiently storing and querying snapshot measures from a relational data warehouse is provided. The facility allows for the efficient query of measures at any given point in time by efficiently modeling snapshot measures. In one technique, the facility stores periodic snapshots of a metric at longer time intervals, and computes intermediate snapshots of the metric as necessary in between these time intervals. Under this technique, the facility can compute an intermediate snapshot measure of a metric for any specified time by determining the last snapshot measure of the metric from the most recent periodic snapshot, and adding to the last snapshot measure the value of the changes to the metric that happened since the time of the most recent periodic snapshot and the specified time.

    摘要翻译： 提供了一种从关系数据仓库有效地存储和查询快照测量的设施。 该设施允许通过有效地建模快照测量来在任何给定时间点高效地查询措施。 在一种技术中，该设施以更长的时间间隔存储度量的周期性快照，并且在这些时间间隔之间根据需要计算度量的中间快照。 在这种技术下，该设施可以通过从最新的周期性快照中确定度量的最后一个快照度量来计算任何指定时间的度量的中间快照度量，并将最近的快照测量值添加到度量值的变化值 这是从最近的定期快照和指定时间开始的。

    Optimization for aggregate navigation for distinct count metrics
    2.
    发明申请
    Optimization for aggregate navigation for distinct count metrics 有权
    不同计数指标的汇总导览优化

    公开(公告)号：US20050138001A1

    公开(公告)日：2005-06-23

    申请号：US10994905

    申请日：2004-11-22

    申请人： Ashish Mittal ,  Edward Suen

    发明人： Ashish Mittal ,  Edward Suen

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30457 ,  G06F17/30489 ,  Y10S707/99933

    摘要： A facility for performing a distinct count metric by utilizing aggregate navigation is provided. For a distinct count query of an identifier of a detail table, where the query specifies zero or more restrictions, the facility identifies an aggregate table that is associated with the detail table. The facility then determines whether the aggregate table contains the identifier that is being distinct counted, and if so, further determines whether the identifier is different in every row of the aggregate table. If it is, then the facility performs a count operation on the rows of the aggregate table that satisfy the specified restrictions to obtain a result for the distinct count query. If the identifier is not different in every row of the aggregate table, the facility performs a distinct count operation on the rows of the aggregate table that satisfy the specified restrictions to obtain a result for the distinct count query.

    摘要翻译： 提供了通过利用汇总导航执行不同计数度量的设施。 对于详细表的标识符的不同计数查询，其中查询指定零个或多个限制，该设施标识与详细表相关联的聚合表。 然后，该设施确定聚合表是否包含不同的计数的标识符，如果是，则进一步确定聚合表的每一行中的标识符是否不同。 如果是，则设施对满足指定限制的聚合表的行执行计数操作，以获得不同计数查询的结果。 如果标识符在聚合表的每一行中都不相同，则设施将对满足指定限制的聚合表的行执行不同的计数操作，以获得不同计数查询的结果。

    Efficient storing and querying of snapshot measures
    3.
    发明授权
    Efficient storing and querying of snapshot measures 有权
    有效地存储和查询快照测量

    公开(公告)号：US07711709B2

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

    申请号：US11314733

    申请日：2005-12-21

    申请人： Ashish Mittal ,  Edward S. Suen

    发明人： Ashish Mittal ,  Edward S. Suen

    IPC分类号： G06F17/00

    CPC分类号： G06F17/30592 ,  G06F17/30551

    摘要： A facility for efficiently storing and querying snapshot measures from a relational data warehouse is provided. The facility allows for the efficient query of measures at any given point in time by efficiently modeling snapshot measures. In one technique, the facility stores periodic snapshots of a metric at longer time intervals, and computes intermediate snapshots of the metric as necessary in between these time intervals. Under this technique, the facility can compute an intermediate snapshot measure of a metric for any specified time by determining the last snapshot measure of the metric from the most recent periodic snapshot, and adding to the last snapshot measure the value of the changes to the metric that happened since the time of the most recent periodic snapshot and the specified time.

    摘要翻译： 提供了一种从关系数据仓库有效地存储和查询快照测量的设施。 该设施允许通过有效地建模快照测量来在任何给定时间点高效地查询措施。 在一种技术中，该设施以更长的时间间隔存储度量的周期性快照，并且在这些时间间隔之间根据需要计算度量的中间快照。 在这种技术下，该设施可以通过从最新的周期性快照中确定度量的最后一个快照度量来计算任何指定时间的度量的中间快照度量，并将最近的快照测量值添加到度量值的变化值 这是从最近的定期快照和指定时间开始的。

    Optimization for aggregate navigation for distinct count metrics
    4.
    发明授权
    Optimization for aggregate navigation for distinct count metrics 有权
    不同计数指标的汇总导览优化

    公开(公告)号：US07707144B2

    公开(公告)日：2010-04-27

    申请号：US10994905

    申请日：2004-11-22

    申请人： Ashish Mittal ,  Edward Shaw-Lee Suen

    发明人： Ashish Mittal ,  Edward Shaw-Lee Suen

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30457 ,  G06F17/30489 ,  Y10S707/99933

    摘要： A method and apparatus for performing a distinct count metric by utilizing aggregate navigation. For a distinct count query of an identifier of a detail table, where the query specifies zero or more restrictions, an aggregate table associated with the detail table is identified. It is then determined whether the aggregate table contains the identifier that is being distinct counted, and if so, whether the identifier is different in every row of the aggregate table. If it is, then the rows of the aggregate table that satisfy the specified restrictions are plain counted to obtain a result for the distinct count query. If the identifier is not different in every row of the aggregate table, a distinct count operation is performed on the rows of the aggregate table that satisfy the specified restrictions to obtain a result for the distinct count query.

    摘要翻译： 一种通过利用聚合导航来执行不同计数度量的方法和装置。 对于详细表的标识符的不同计数查询，其中查询指定零个或多个限制，则识别与详细表相关联的聚合表。 然后确定聚合表是否包含不同的计数的标识符，如果是，则标识符在聚合表的每一行中是否不同。 如果是，那么满足指定限制的聚合表的行被简单地计数，以获得不同的计数查询的结果。 如果标识符在聚合表的每一行中都不相同，则对满足指定限制的聚合表的行执行不同的计数操作，以获取不同计数查询的结果。