Chun Yin Yu

US Patent:

7149736, Dec 12, 2006

Filed:

Sep 26, 2003

Appl. No.:

10/670561

Inventors:

Gueorgui Bonov Chkodrov - Redmond WA, US
Richard Zachary Jason - Seattle WA, US
Eric Anthony Reel - Seattle WA, US
Chun Yu - Bothell WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707 7, 707 1, 707100, 707200

Abstract:

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.

US Patent:

20060190433, Aug 24, 2006

Filed:

Feb 23, 2005

Appl. No.:

11/063622

Inventors:

Gueorgui Chkodrov - Redmond WA, US
Richard Jason - Seattle WA, US
John Ballard - Woodinville WA, US
Chun Yu - Bothell WA, US
David Taniguchi - Kirkland WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707003000

Abstract:

Business activity management of monitoring multiple instances of a business activity and navigating business activity data in a distributed system. A system includes a plurality of databases storing data relating to multiple instances of a monitored business activity. A user interface receives a request from a user for business activity data independent of which database stores the requested data. An activity monitoring component for navigating to one of the databases as a function of defined relationships to retrieve the requested business activity data. The user interface displays the retrieved data to the user based on the user's permission.