Method of applying a function to a data set

• US 8,510,645 B2
• Filed: 10/04/2006
• Issued: 08/13/2013
• Est. Priority Date: 10/10/2005
• Status: Expired due to Fees

• Current Assignee: Canon Kabushiki Kaisha (Canon Inc.)
• Original Assignee: Canon Kabushiki Kaisha (Canon Inc.)
• Inventors: Will, Alexander, Beach, Joel Timothy
• Primary Examiner(s): DWIVEDI, MAHESH H
• Application Number:
  US11/538,558
• Publication Number:
  US 20070112724A1
• Time in Patent Office: 2,505 Days
• Field of Search: 707/2, 707/101, 707/729, 715212-220
• US Class Current: 715/212
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data

Abstract

Disclosed is a method of applying a function to a set of data. Initially a tabular representation of the set of data is displayed, the representation comprising a plurality of columns. The data in the representation is grouped in each column based upon an order of the at least one column in the tabular representation. The method also generates a new column of data comprising a transform of existing column data contained in the tabular representation, wherein transform data within the new column depends upon a grouping context of the existing column data. Desirably the method further repositions the new column of data in the tabular representation and updates the transform data in the new column in accordance with a destination grouping context of a destination position of the new column in the tabular representation.

Claims

1. A computer-implemented method of updating a display of a tabular representation, said method comprising the steps of:

(i) generating a tabular representation of a set of data, said representation comprising a plurality of columns containing the set of data;

(ii) grouping the set of data by grouping a plurality of identical rows in at least one column to form a plurality of groups in each column of the tabular representation, said grouping being based on data in at least one column of the tabular representation;

(iii) generating an aggregate column in the tabular representation comprising aggregate data derived from an aggregate function applied to at least some of the set of data based on the grouping of the data in an existing column;

(iv) displaying the tabular representation with the aggregate column of data;

(v) moving the aggregate column in the tabular representation; and

(vi) updating the display of the tabular representation,

wherein vertically adjacent cells within the moved aggregate column are grouped according to grouping of vertically left adjacent data within a second column of the tabular representation adjacent the moved aggregate column, and wherein the aggregate data in the moved aggregate column is determined by applying the aggregate function to at least some of the set of data in the existing column selected according to the grouping of the data in the second column adjacent the moved aggregate column to calculate an aggregate value for each group in the aggregate column when the aggregate column is moved, wherein the vertically left adjacent data within the second column corresponds to the set of data in the existing column,

wherein at least first and second columns of the tabular representation display a grouping hierarchy relationship, so that the first column is displayed to the left of the second column and occupies a higher position in the hierarchy than the second column.

2. The method according to claim 1 wherein step (ii) comprises detecting a user moving of a grouping indicator and grouping the set of data according to an order of said columns established by the moving.

3. The method according to claim 1 wherein step (ii) comprises moving a position of at least one said column in said tabular representation and grouping the set of data according to an order of said columns established by the moving.

4. The method according to claim 1 further comprising the step, after step (iii) of:

(vii) repeating step (ii).

5. The method according to claim 1 further comprising the step, after step (v) of:

(viii) repeating steps (iii) and (iv).

6. The method according to claim 1 further comprising the step, before step (iii), of applying a filter function to the tabular representation to exclude from display certain data thereof.

7. The method according to claim 1 further comprising the step, before step (iii), of applying a sort function to the tabular representation to rearrange display of certain data thereof.

8. The method according to claim 1 wherein each of said method steps comprise reproducing said tabular representation upon a display device.

9. The method according to claim 8 wherein said set of data persists during execution of said method and said tabular representation varies the extent of said set of data reproduced via the display device.

10. A non-transitory computer readable storage medium encoded with a computer program executable to perform a method of updating the display of a tabular representation, said method comprising:

(i) generating a tabular representation of the set of data, said representation comprising a plurality of columns containing the set of data;

(ii) grouping the set of data by grouping a plurality of identical rows in at least one column to form a plurality of groups in each column of the tabular representation, said grouping being based on data in at least one column of the tabular representations;

(iii) generating an aggregate column in the tabular representation comprising aggregate data derived from an aggregate function applied to at least some of the set of data based on the grouping of the data in an existing column;

(iv) displaying the tabular representation with the aggregate column of data;

(v) moving the aggregate column of data in the tabular representation; and

(vi) updating the display of the tabular representation,

wherein vertically adjacent cells within the moved aggregate column are grouped according to grouping of vertically left adjacent data within a second column of the tabular representation adjacent the moved aggregate column, and wherein the aggregate data in the moved aggregate column is determined by applying the aggregate function to at least some of the set of data in the existing column selected according to the grouping of the data in the second column adjacent the moved aggregate column to calculate an aggregate value for each group in the aggregate column when the aggregate column is moved, wherein the vertically left adjacent data within the second column corresponds to the set of data in the existing column,

wherein at least first and second columns of the tabular representation display a grouping hierarchy relationship, so that the first column is displayed to the left of the second column and occupies a higher position in the hierarchy than the second column.

11. Computer apparatus for updating a display of a tabular representation applying a function to a set of data, said apparatus comprising:

a memory storing the set of data;

a display for displaying a tabular representation of a set of data, said representation comprising a plurality of columns containing the set of data; and

a processor configured for;

detecting a user input associated with a grouping of the set of data by grouping a plurality of identical rows in at least one column to form a plurality of groups in each column of the tabular representation, said grouping being based on data in at least one said column of the tabular representation;

generating an aggregate column in the tabular representation comprising aggregate data derived from an aggregate function applied to at least some of the set of data based on the grouping of the data in an existing column;

displaying the tabular representation with the aggregate column of data;

moving the aggregate column of data in the tabular representation; and

updating the display of the tabular representation,

wherein vertically adjacent cells within the moved aggregate column are grouped according to grouping of vertically left adjacent data within a second column of the tabular representation adjacent the moved column, and wherein the aggregate data in the moved aggregate column is determined by applying the aggregate function to at least some of the set of data in the existing column selected according to the grouping of the data in the second column adjacent the moved aggregate column to calculate an aggregate value for each group in the aggregate column when the aggregate column is moved,

wherein the vertically left adjacent data within the second column corresponds to the set of data in the existing column,

wherein at least first and second columns of the tabular representation display a grouping hierarchy relationship, so that the first column is displayed to the left of the second column and occupies a higher position in the hierarchy than the second column.