JP3036628B2 - Table data processing device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table data processing apparatus, and more particularly to a table data processing apparatus for reconstructing table data and generating a new table.

[0002]

2. Description of the Related Art In data processing apparatuses such as personal computers and word processors, data described in the form of tables are widely used in the fields of industry, commerce, education and the like. For example, it is widely used for analysis of prerequisite information such as various planning such as a sales plan and simulation. FIG. 15 is an example of table data created on the data processing device.

[0003] Numbers for identification are assigned to rows and columns of a table, and each cell (hereinafter referred to as a cell) is assigned a row number (R).
n) and a column number (Cn) (hereinafter referred to as a cell address).

[0004] Each column of the table is called a field, and the first cell stores a field name representing a property of data such as "year" and "model". Each line after the second line excluding the field name is called a record, in which actual data such as "1994" and "PC" corresponding to the field name is stored.

In FIG. 15, a cell 41 represents a cell, an identifier 42 represents a cell address (R1C1), data 42a represents a field name, a column 43 represents a field, and rows 44 and below represent records.

Now, once the table is created, the data is classified and
Tables are sometimes reconstructed to create multidimensional tables for the purpose of organizing and performing simulations.
FIG. 16B is an example of such a multidimensional table. FIG.
In the multidimensional table, fields such as year and district are arranged in both horizontal and vertical directions.

In general, in the table data processing method, a base table as shown in FIG.
Is called a view. Data such as "1994" and "PC" displayed in the vertical or horizontal field of the view is called an item.

For this purpose, a conventional table data processing system uses a system in which a user sets conditions for reconstruction. For example, when the sales data in FIG. 15 is classified into “by year”, “by model”, and “by district”, a dialog as shown in FIG. 16A is opened, and “year”, “model”, and “region” are opened.
In the horizontal or vertical field and sales in the data field. When the dialog is closed in this state, the sales data is classified, and a table shown in FIG. 16B is obtained.

Here, when one cell of a multidimensional table corresponds to a plurality of cells of a table of original data (hereinafter, referred to as an elementary table), as in cell 51, the result of summing them up is stored in a multidimensional table. Is displayed.

[0010]

In such a conventional table data processing method, for example, when a comment is arranged in a data field instead of the sales shown in FIG. 15, the corresponding data is not a numerical value but a character string. The aggregation results of the multidimensional table are all zero, and have no meaning (FIG. 17).
(A), (b)).

That is, in the conventional example, there is an inconvenience that a table for a character string cannot be reconstructed.

[0012]

SUMMARY OF THE INVENTION The object of the present invention is to improve the disadvantages of the conventional example, and particularly to introduce a concatenated display in addition to a tabulated display, thereby enabling an effective reconstruction even in the case of a table composed of character strings. It is an object of the present invention to provide a table data processing device that can be realized.

[0013]

Therefore, according to the present invention, as a first means (claim 1), a sheet having a plurality of cells designated by a row number and a column number, and a data input to this sheet are provided. And a base table storage unit that stores a field name as a base table, a view definition generating unit that generates a view definition based on the input of the field name, and a base table based on the view definition information generated by the view definition generating unit. And reconstructing means for reconstructing the contents of each cell and creating a new table. In addition, the reconstructing unit is configured to execute a plurality of multi-dimensional processes based on the view definition based on the row number and the column number specified by the view definition generating unit.
A data linking section for linking the character data of the file to the data of a plurality of cells, and a data output section for outputting the linked data linked by the data linking section to the cell of the new table at the position specified in the view definition information. Equipped.

In the first means, first, a field which forms a framework of a base table is defined by a user, and a field name is input to a cell. Further, data constituting the base table is input along with the field name, and data having the field name as an attribute is created on the sheet.

Next, a view for analyzing the base table is defined from an arbitrary viewpoint of the user. This is, for example, among data such as “1994” and “1995” belonging to a field having a field name of “year”,
The contents of the other fields for the same data (field name) are reconstructed and displayed. In the example of this fiscal year, the processing is such that the total of the sales in 1994 and the total of the sales in 1995 are totaled.

Further, the reconstructing means reconstructs the contents of each cell of the original table and creates a new table based on the view definition information generated by the view definition generating means. At this time, in the reconstructing means, the data connection unit connects the data of the cells specified by the view definition, and the data output unit specifies the connection data connected by the data connection unit in the view definition information. Output to cell of new table of position. For this reason, even if the contents of the cells of the original table are characters, the reconstructing means creates a new table by connecting the characters. For this reason, even if the data of the base table is composed of characters, the base table is made multidimensional to reconstruct the data.

As a second means (Claim 2), in addition to the matter specifying the first means, the reconstructing means may include a plurality of cells based on the row number and the column number specified by the view definition generating means. A data aggregation unit that aggregates data and a processing selection unit that selects one of the data aggregation unit or the data connection unit based on the display format information input to the view definition generation unit are provided. .

For this reason, in the second means, when the object of the reconstruction is a numerical value, the numerical value is totaled, and when it is a character string, the character string is concatenated. Further, the total or the connection is selected based on the display format information input by the user. Therefore, numerical values are totaled, averaged, and the like, and listed as character strings.

As a third means (claim 1), in addition to the item for specifying the first means, a cell classification unit for extracting a row number and a column number of a cell belonging to the same field based on view definition information is provided. The reconstructing means has a character string synthesizing function of synthesizing a character string in the cell for each cell list extracted by the cell classification unit.

The third means specifies that the connection target is a character string.

The present invention aims to achieve the above-mentioned object by each of these means.

[0022]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of the table data processing apparatus according to the present embodiment. The table data processing device
A sheet 1 having a plurality of cells specified by row numbers and column numbers, and a source notation unit (source storage unit) for storing data and field names input to the sheet 1 as a base table
12a, a view definition generating means 8 for generating a view definition based on the input of the field name, and reconstructing the contents of each cell of the base table based on the view definition information generated by the view definition generating means 8 Reconstructing means 9 for creating a new table.

Further, the reconstructing means includes a data linking section 9a for linking data of a plurality of cells based on the row number and the column number specified by the view definition generating means, and a linking section linked by the data linking section 9a. A data output unit 9c for outputting data to a cell of a new table at a position designated in the view definition information.

This will be described in detail.

As shown in FIG. 1, a storage means 12 for storing data or the like input to a sheet includes a source storage unit (original notation unit) 12a for storing data of an original table, and a condition for reconfiguring the original table. , A record storage unit 12c and a classification data storage unit 12d for storing the classification information of the base table, and a view storage unit 12e for storing the information of the view (multidimensional table). I have.

The table data processing device includes an input means 10 for storing original table data input from a keyboard or the like in a source storage section 12a, and a view definition for performing data processing based on the data stored in each storage section. Generating means 8 and data reconstructing means 9 for reconstructing data based on the view definition information generated by the view definition generating means 8
And

The view definition generating means 8 displays a dialog for setting the conditions for reconfiguring the base table and stores the view definition information in the view definition information storage unit 12b. The records in the base table are classified and the classification information is stored in the record storage unit 12.
c and the record storage unit 1
A data classification unit 8c that classifies each data of the data field for each combination of items based on the information of 2c and stores the classification information in the classification data storage unit 12d.

On the other hand, the data reconstructing means 9 aggregates the data by classification and stores the aggregated information in the view storage unit 12.
e, a data summarizing unit 9b for storing data in a corresponding cell, a data linking unit 9a for synthesizing data into a linking format for each classification, and storing the linking information in a corresponding cell of the view storage unit 12e, and a view storage unit 12e. A data output unit 9c for controlling the display of the stored multidimensional table format data (new table) on the screen.

In this embodiment, first, the view definition unit 8a
Is started, and view definition information is generated on the dialog based on the reconstruction condition of the base table input by the user.
At this time, whether to perform the total display or the consolidated display is selected by a dialog or another method.

When the definition of the view is completed, the record classifying unit 8b is activated, and classifies the records of the base table by view items. Further, the data classification unit 8c is activated, and classifies each data in the data field for each combination of items.

When the classification of the data is completed, one of the data totaling section 9b and the data linking section 9a is activated according to the user's selection. When the data linking unit 9a is activated, the data classified by the data classifying unit 8c is displayed in a linked form on the cell of the corresponding view.

[First Embodiment] FIG. 2 is a flowchart showing an overall image of the processing procedure.
Here, after requesting the user to input the base table and define the view, the contents are recognized, and the data classification process and the display process are started. Hereinafter, an example in which FIG. 15 is used as a base table will be described.

In step S21, a process corresponding to the input means 10 is started, and after the user inputs a base table as shown in FIG. 15, the data is stored in the source storage unit 12a. In step S22, the process corresponding to the view definition unit 8a is activated, and the user is requested to set the conditions for reconstructing the base table in a dialog as shown in FIG.

The comment data shown in FIG.
At the right end of the dialog that is classified into "by model" and "by district", the field names of the original table are displayed in a list format (FIG. 1).
7 (a)). When making such a classification,
The field names “model” and “district” are arranged in the horizontal / vertical field columns on the dialog, and the comment field is arranged in the data field column.

When the user closes the dialog in this state, the view definition unit 8a sets the set field name and
The corresponding column number (Cn) is stored in the view definition information storage unit 12b as view definition information. For example, as shown in FIG. 5, for the year field, a corresponding column number C1 is stored.

In step S23, the user is made to select whether to perform total display or link display in the multidimensional table. Next, a step S24 activates a process corresponding to the record classification unit 8b. Here, the records (Rn) of the base table are classified according to the data of the horizontal and vertical fields which are the items of the view, and the list (hereinafter, referred to as a record list) is stored in the record storage unit 12c. In the example shown in FIG. 6, eight line numbers of R2 to R9 including one item in the fiscal year field of 1994 are stored.

In step S25, as shown in FIG. 7, a process corresponding to the data classification unit 8c is started. Here, for each combination of items, a duplicate portion of a corresponding record list is extracted (hereinafter, referred to as AND). Further, a list of cell addresses at the intersection of the extracted record and the data field is made (hereinafter, referred to as a cell list) and stored in the classification data storage unit 12d.

In the example shown in FIG. 7, the line numbers R16 and R17, which are the duplicate parts of the record list, are extracted for the three items "1995", "word processor", and "Kansai", The cells R16C6 and R17C6, which are the intersections of, are stored in the cell list.

In step S26, according to the display selected by the user in step S23, the process proceeds to step S27 if the display is a total display, or to step S28 if the display is a combination display. A step S27 activates a process corresponding to the data tabulation unit 9b. Here, the data of the cell list is totaled for each combination of items and stored in the corresponding cell (cell of the new table) in the view storage unit 12e.

A step S28 activates a process corresponding to the data linking section 9a. Here, similarly, the data of the cell list is grouped into a linked form for each combination of items, and stored in the corresponding cell of the view storage unit 12e.

In step S29, the processing corresponding to the data output unit 9c is started, and the multidimensional table format data stored in the view storage unit 12e is output to the display unit 11. As a result, the view of FIG. 4 is finally obtained.

FIG. 3 is a flowchart showing the data linking process in step S28. Here, the LIST command for connection display is stored in each cell of the view.

In step S31, the classification data storage unit 12
Get the first cell list from d. Step S32
Is an LIS for linking and displaying cell list data
Define the T command. Here, the LIST command is "
LIST "and a cell address stored in the cell list.

A step S33 stores the LIST command in a corresponding cell of the view storage unit 12e. FIG.
In the example shown in (a), R2C6, R3 of the original table are added to the cells of the views corresponding to "1994", "PC" and "Kanto".
A LIST command for linking data of C6 is stored. When this command is executed by the data output unit 9c, the corresponding data is displayed on the view in a linked format.

In step S34, the classification data storage unit 12
It is checked whether or not the final list of d has been reached, and if so, the processing of FIG. 3 ends. Otherwise, in step S35, the next cell list is obtained from the classification data storage unit 12d, and the processing from step S32 is repeated.

The data totaling process of step S27 in FIG. 2 is performed by using a total display command SU instead of the LIST command.
Except for using M, the process is the same as step S28 (FIG. 8B).

Second Embodiment Next, a second embodiment will be described. FIG. 9 shows an example in which the base table has a multidimensional format. In this example, each item row / item column becomes a field (hereinafter, referred to as a field row / field column), and the last cell thereof becomes a field name. As the field matrix becomes bidirectional, records orthogonal to it become matrix bidirectional (hereinafter referred to as record rows / record columns).

In FIG. 9, row R1 represents the field row and column C
1 and C2 represent field columns, rows R2 to R9 represent record rows, columns C3 to C4 represent record columns, and cells R10C1 and R10
10C1, R1C5, and R10C5 represent field names.

When the view definition section 8a is executed on this base table, a dialog as shown in FIG. 10 is displayed. At this time, since the data fields of the view and the base table are unconditionally the same, the same field name (comment) as the base table is automatically entered in the corresponding column of the dialog. Here the horizontal
When the vertical field field is set as shown in FIG. 10 and the dialog is closed, the setting information is stored in the view definition section 8a. In the example of FIG. 11, the row number indicating the district field is stored in addition to the column number of the first embodiment (R1).

Next, the record classification section 8b is activated, and the record rows / columns are classified by item, and the record storage section 12b is classified.
c (FIG. 12). At this time, if there is an empty item cell such as the cell R3C1, it is recognized that it is the same as the immediately preceding non-empty item (1994). Also, the region (cell R1C1, R1C2) where the field row / column is orthogonal is
Not recognized as an item. Further, in the second embodiment, since the record row / column is bidirectional, a cell address is stored in the record list of FIG. Where R? , R? Refers to any record row / column.

When the above classification is completed, the data classification unit 8c
As a result, AND of the record list is obtained for each combination of items, and a corresponding cell list is generated. At this time,
As shown at the end of FIG. 13, first, record rows
The AND is separately obtained between the record sequences, and then the AND of both is obtained. When the generation of the cell list is completed, it is stored in the classification data storage unit 12d. Subsequent processing is the same as in the first embodiment (FIG. 14).

As described above, when the table data processing apparatus according to the present embodiment is used, even if the table is composed of characters such as a market analysis table and a product comparison table, they are made multidimensional, and the table can be viewed from an arbitrary viewpoint of the user. Since it can be reconfigured, there is an effect that it can be used for various analyzes and planning.

[0054]

According to the present invention, the data linking unit links the data of the cells specified based on the view definition information generated by the view definition generating means. Further, since the data output unit outputs the linked data linked by the data linking unit to the cell of the new table at the position specified in the view definition information, even if the content of the cell of the original table is a character, , The reconstruction means can create a new table by concatenating the characters, so that even if the data of the original table is composed of characters,
It is possible to provide an unprecedented superior table data processing apparatus capable of reconstructing data by multiplying the base table.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a table data processing device according to an embodiment of the present invention.

FIG. 2 is a flowchart showing an overall image of a processing procedure of the table data processing apparatus shown in FIG. 1;

FIG. 3 is a flowchart illustrating a processing procedure of a data connection unit illustrated in FIG. 1;

FIG. 4 is an explanatory diagram showing an example of a view generated by the configuration shown in FIG. 1;

FIG. 5 is an explanatory diagram illustrating an operation of a view definition unit illustrated in FIG. 1;

FIG. 6 is an explanatory diagram illustrating an operation of the record storage unit illustrated in FIG. 1;

FIG. 7 is an explanatory diagram illustrating an operation of a classification data storage unit illustrated in FIG. 1;

8A and 8B are explanatory diagrams illustrating an example of data stored in a view storage unit illustrated in FIG. 1; FIG. 8A is a diagram illustrating an example of a case where linked display is performed; FIG. It is a figure showing an example when performing display.

9 is an explanatory diagram showing an example of a multidimensional base table from which a view is generated by the configuration shown in FIG. 1;

FIG. 10 is a diagram illustrating an example of a dialog when reconstructing the multidimensional base table illustrated in FIG. 9;

FIG. 11 is an explanatory diagram showing an operation of a view definition unit when the multidimensional base table shown in FIG. 9 is reconstructed.

FIG. 12 is an explanatory diagram showing an operation of the record storage unit when the multidimensional base table shown in FIG. 9 is reconstructed.

FIG. 13 is an explanatory diagram showing an operation of a classification data storage unit when the multidimensional base table shown in FIG. 9 is reconstructed.

FIG. 14 is an explanatory diagram showing an example of a view when the multidimensional base table shown in FIG. 9 is reconstructed.

FIG. 15 is an explanatory diagram showing an example of a base table.

FIG. 16A is a diagram illustrating an example of a view definition dialog, and FIG. 16B is a diagram illustrating an example of a case where total display is performed;

17A and 17B are diagrams illustrating an example of a case where character string data is reconstructed by a conventional table data processing apparatus. FIG. 17A illustrates an example of a view definition dialog, and FIG.
FIG. 9 is a diagram showing an example of a case where total display is performed.

[Explanation of symbols]

 8 View definition generation means 8a View definition part 8b Record classification part 8c Data classification part 9 Data reconstruction part 9a Data totalization part 9b Data totalization part 9c Data output part 9d Process selection part 10 Input means 11 Display means 12 Storage means 12a Original notation Billion copies (source storage unit) 12b View definition unit 12c Record storage unit 12d Classification data storage unit 12e View storage unit

──────────────────────────────────────────────────続 き Continuation of the front page (56) References JP-A-6-96104 (JP, A) JP-A-5-225250 (JP, A) JP-A-5-81338 (JP, A) JP-A-2-96 190963 (JP, A) JP-A-63-175925 (JP, A) JP-A-4-33164 (JP, A) JP-A-6-35975 (JP, A) (58) Fields investigated (Int. Cl. ⁷ , DB name) G06F 19/00

Claims (3)

(57) [Claims] 1. A sheet having a plurality of cells designated by a row number and a column number, a base table storage unit for storing data and field names input to the sheet as a base table, and a table for inputting the field names. View definition generation means for generating a view definition based on the view definition information, and reconfiguration means for reconfiguring the contents of each cell of the base table and creating a new table based on the view definition information generated by the view definition generation means. In the table data processing device comprising: the reconstruction means, based on the row number and column number specified by the view definition generation means ,
A data linking unit for linking character data of a plurality of cells to be multi-dimensionalized, and data for outputting the linking data linked by the data linking unit to a cell of the new table at a position designated in the view definition information A table data processing device comprising an output unit. 2. A data summarizing unit for summing data of a plurality of cells based on a row number and a column number specified by the view definition generating unit, wherein the reconstructing unit is input to the view definition generating unit. 2. The table data processing device according to claim 1, further comprising: a processing selection unit that selects one of the data aggregation unit and the data connection unit based on display format information. 3. A cell classifying unit for extracting a row number and a column number of a cell belonging to the same field based on the view definition information is provided in the reconstructing unit, and the reconstructing unit is provided with the cell classifying unit. 2. The table data processing apparatus according to claim 1, further comprising a character string synthesizing function for synthesizing a character string in the cell for each extracted cell list.