Multi-dimensional table data management unit and recording medium storing therein a spreadsheet program

• US 20010016855A1
• Filed: 02/14/2001
• Published: 08/23/2001
• Est. Priority Date: 02/18/2000
• Status: Abandoned Application

• Current Assignee: Mitsubishi Denki Kabushiki Kaisha (Mitsubishi Electric Corporation)
• Original Assignee: Mitsubishi Denki Kabushiki Kaisha (Mitsubishi Electric Corporation)
• Inventors: Hiroshige, Yuko
• Application Number:
  US09/782,157
• Publication Number:
  US 20010016855A1
• Time in Patent Office: Days
• US Class Current: 715/503
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A multi-dimensional table data management unit inserts two bookmarks into a sequence of two-dimensional tables to define a plurality of tables, enclosed by the bookmarks, as a three-dimensional storage area (box). Normally, the unit defines a storage position, in which the item data of the box is stored, as three-dimensional data cubes (i, j, k). The multi-dimensional table data management unit allows the user to perform sorting, calculation, or box rotation of three-dimensional item data based on the three-dimensional item data.

Claims

1. A multi-dimensional table data management unit comprising table data management means for defining a data block as a processable data group, the data block being composed of a plurality of (n-1)-dimensional tables (n is a natural number equal to or larger than 3), and for defining item data of the processable data group as n-dimensional data for data management.

2. The multi-dimensional table data management unit as claimed in

claim 1

, further comprising calculation processing means for executing a table calculation function based on the item data in each dimension of the data block.

3. The multi-dimensional table data management unit as claimed in

claim 1

, wherein said table data management means execute a table editing function based on the item data of the data block in each dimension.

4. The multi-dimensional table data management unit as claimed in

claim 1

, wherein said table data management means enclose a portion of a sequence of tables with punctuation tables to define the data block.

5. The multi-dimensional table data management unit as claimed in

claim 4

, wherein information indicating a start is added to a first table in the data block to make the first table act as the punctuation table.

6. The multi-dimensional table data management unit as claimed in

claim 4

, wherein information indicating an end is added to a last table in the data block to make the last table act as the punctuation table.

7. The multi-dimensional table data management unit as claimed in

claim 1

, wherein a title is attached to each of the tables of the data block.

8. The multi-dimensional table data management unit as claimed in

claim 3

, wherein, in response to a plurality of sorted item data for which sorting is specified in the data block and a sort direction thereof, said table data management means sort the entire data block by exchanging storage positions where item data for which the sorting is not specified is stored.

9. The multi-dimensional table data management unit as claimed in

claim 3

, wherein said table data management means rotate the data block according to a specified rotation axis, a rotation direction, and an angle to exchange storage positions of the item data.

10. The multi-dimensional table data management unit as claimed in

claim 1

, wherein said table data management means combine a plurality of data blocks to generate a new data block.

11. The multi-dimensional table data management unit as claimed in

claim 10

, wherein said table data management means combine and compose the plurality of data blocks to generate the new data block.

12. The multi-dimensional table data management unit as claimed in

claim 10

, wherein, when the plurality of data blocks are combined, said table data management means includes only a common portion to generate the new data block.

13. The multi-dimensional table data management unit as claimed in

claim 10

, wherein, when the plurality of data blocks are combined, said table data management means excludes only a common portion to generate the new data block.

14. A recording medium recording therein a spreadsheet program that defines a data block as a processable data group, the data block being composed of a plurality of (n-1)-dimensional tables (n is a natural number equal to or larger than 3), and defines item data of the processable data group as n-dimensional data for data management.

15. The recording medium according to

claim 14

wherein said spreadsheet program executes a table calculation function based on the item data in each dimension of the data block.

16. The recording medium according to

claim 14

wherein said spreadsheet program executes a table editing function based on the item data of the data block in each dimension.

17. The recording medium recording according to

claim 14

wherein said spreadsheet program processes the data block defined by enclosing a portion of a sequence of tables with punctuation tables.