会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 1. 发明授权
    • Maintaining time-sorted aggregation records representing aggregations of values from multiple database records using multiple partitions
    • 维护使用多个分区的来自多个数据库记录的值的聚合的时间排序聚合记录
    • US07149736B2
    • 2006-12-12
    • US10670561
    • 2003-09-26
    • Gueorgui Bonov ChkodrovRichard Zachary JasonEric Anthony ReelChun Yu
    • Gueorgui Bonov ChkodrovRichard Zachary JasonEric Anthony ReelChun Yu
    • G06F17/30G06F7/00
    • G06F17/30551G06F17/30489G06F17/3051G06Q10/087Y10S707/99931Y10S707/99937
    • Multiple aggregation groups, which can be multiple partitions in an aggregated data table, are formed. Each group includes multiple aggregation records; each aggregation record includes an aggregation of values contained by a different subset of multiple database records. While an aggregation group is accessed by a single program thread during an aggregation group update transaction, no other threads are allowed to access that group. The aggregation groups are combined into a single table of aggregation records. Each of the multiple database records may correspond to an instance of an organizational activity and include a field having a value indicating the corresponding instance to be in one of several process states. Each aggregation group may further include time-sorted aggregation records, each time-sorted aggregation record containing an aggregation value for instances in one of the several process states during a time period associated with the time-sorted aggregation record. Aggregation records corresponding to instances completed outside of a preselected time window are deleted.
    • 形成了聚合数据表中可以是多个分区的多个聚合组。 每组包括多个汇总记录; 每个聚合记录包括由多个数据库记录的不同子集包含的值的聚合。 虽然聚合组更新事务期间由单个程序线程访问聚合组,但是不允许其他线程访问该组。 聚合组合成一个聚合记录表。 多个数据库记录中的每一个可以对应于组织活动的实例,并且包括具有指示相应实例的值处于若干进程状态之一的字段。 每个聚合组还可以包括时间排序的聚合记录,每个时间排序的聚合记录包含在与时间排序的聚合记录相关联的时间段内的几个进程状态之一的实例的聚合值。 与预选时间窗口之外完成的实例相对应的聚合记录将被删除。