Very large dataset representation system and method

• US 20060004813A1
• Filed: 07/02/2004
• Published: 01/05/2006
• Est. Priority Date: 07/02/2004
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Desbiens, Marc A.
• Granted Patent: US 7,333,995 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99936 Pattern matching access

Abstract

A system and method for representing a very large dataset that enables a plan manager to define, based upon an organization modelling object, a delegation modelling object for a very large dataset. A very large dataset delegation of multiple subplans is created whose subplans can then be individually filtered for specific size restrictions. This enables a plan manager to filter the definition of each subplan prior to the execution of the delegation modelling object, precluding any need for higher-level subplans to contain all the data contained in their subordinate subplans. This allows subplans to contain increased levels of detail not included in their superior subplans, detail that will instead only be summarized in higher-level subplans. A subsequent consolidation process will then extract data not found at higher levels from each delegated subplan, and return that data to its original dataset.

Claims

1. A very large dataset representation system comprising:

a delegation modelling object including;

a master dataset definition;

one or more than one data dimension-to-user mapping;

a target organization definition defining relationships between said master dataset definition and said data dimension-to-user mappings; and

a subplan definition derived from each data dimension-to-user mapping; and

a subplan manager for filtering data from said subplan definitions in accordance with a predetermined data size limitation in advance of executing said delegation modelling object.

2. The system according to claim 1, wherein said data dimension-to-user mappings are described by an organization hierarchy description.

3. The system according to claim 2, wherein said organizational hierarchy description is provided by an organization modelling object having:

one or more than one data dimension reference;

one or more than one user identifier defining intended recipients; and

a mapping between each data dimension reference and one or more than one user identifier.

4. The system according to claim 1, further including a consolidator for, upon completion of user interaction, extracting data from each delegated subplan not found in its superior subplans and returning that extracted data to its original dataset.

5. The system according to claim 1, further including a background server process to improve performance when generating a large number of datasource-based subplans.

6. The system according to claim 1, wherein one or more of said subplan definitions is a proposal to aid in a planning process.

7. A method of representing very large datasets, comprising the steps of:

(i) constructing a delegation modelling object by;

a) defining a master dataset;

b) mapping each data dimension to one or more than one user identifier;

c) defining relationships between said master dataset and said data dimension-to-user mappings; and

d) deriving a subplan definition from each data dimension-to-user mapping;

(ii) filtering data from said subplan definitions in accordance with a predetermined data size limitation in advance of executing said delegation modelling object; and

(iii) executing said delegation modelling object to extract and generate subplans.

8. The method according to claim 7, wherein said mapping step is described by the step of providing an organization hierarchy description.

9. The method according to claim 8, wherein said organization hierarchy description is provided by the step of constructing an organization modelling object by:

referencing one or more than one data dimension;

defining intended recipients with one or more than one user identifier; and

mapping each data dimension reference to one or more than one user identifier.

10. The method according to claim 7, further including the step of consolidating data from said delegated subplans upon completion of user interaction.

11. The method according to claim 10, wherein said consolidation step includes the steps of:

extracting data from each delegated subplan not found in its superior subplans; and

returning said extracted data to its original dataset.

12. The method according to claim 7, further including the step of including a background server process to improve performance when generating a large number of datasource-based subplans.

13. A computer program product for a very large dataset representation method, the computer program product comprising:

a computer readable medium for storing machine-executable instructions for use in the execution in a computer of the very large dataset representation method, the method including the steps of;

constructing a delegation modelling object by;

defining a master dataset;

mapping each data dimension to one or more than one user identifier;

defining relationships between said master dataset and said data dimension-to-user mappings; and

deriving a subplan definition from each data dimension-to-user mapping;

filtering data from said subplan definitions in accordance with a predetermined data size limitation in advance of executing said delegation modelling object; and

executing said delegation modelling object to extract and generate subplans.