JPS62206664A - Data operating software system - Google Patents

Abstract

PURPOSE:To ensure succession of the attribute expression against the operations of plural tables by showing the arithmetic correspondence relation among the row data items, column data items or cell data of a table in the form of a numerical formula and attribute and storing them as the file information. CONSTITUTION:When data are operated under a software constitution 1 of a data operating computer, the arithmetic dependence relation is maintained among the row data items 16, column data items 15 and cells 17 of a table respectively. Here if it is desired to succeed hereafter said correspondence relation to the arithmetic formula defined by a user, a re-calculation file register request is delivered. Thus the subsequent input contents are registered to a re-calculation file 8. Then it is checked whether the data operation in carried out within a single table or covers plural tables. Thus each file 8 is updated, succeeded and executed according to the result of said checking.

Description

[Detailed Description of the Invention] [Field of Industrial Application] This invention relates to a data manipulation software method for automation and labor saving in, for example, office processing such as slip processing, form processing, and payroll calculation, and spreadsheet data processing in scientific and technological processing; This relates to ensuring the consistency of arithmetic dependencies between numerical data. [Prior Art] FIG. 16 is a block diagram showing a conventional data manipulation software system. In the figure, (1) is the software configuration of a data manipulation computer consisting of a personal computer used as a data manipulation machine. This software configuration (1) is 9. The operating system 08121, which is essential for software development, the data operation section (3) that controls processing related to data operations, and the user interface section (4) that manages the interface with the user who performs the operation.
) Equipped with yk.

In the data operation section (3), the table data (6
). In addition, the user interface section (4
), the line printer L is used as an input/output device with the user.
P+91. Display 0RT (IG, keyboard K
/ Manage and control BaI2.

Figure 1T shows tabular data (6
), FIG. 18 is a dump output of table data in which arithmetic expressions are registered.

Table data (6) is a set of cells (I7), and when a calculation formula is registered, the calculation formula Gυ is stored in cell aη.
is registered. This calculation formula T:3+) is *0nL8=
f('m”t * '''') (where f is a function,
0ILj is row data 01 and column data Lj
cell data defined by ).

Next, the operation will be explained. Figure 19 shows the processing flow for maintaining the calculation dependence relationships between cells ση in Table 9 when performing data manipulation based on the software configuration (1) of the data manipulation computer shown in Figure 1. . If you want to inherit the relationship for the arithmetic expression defined by the user, register the arithmetic expression ((D) for each cell aη. As a result, the calculation formula is registered in table data (6).Next, when the data is changed, all calculation formulas t3υ registered in cell αη are executed (to).The timing of this execution is determined by the data Both cases where the data manipulation unit (3) automatically performs the change and cases where the user specifies the change are supported.

[Problem that the invention seeks to solve]

In traditional data manipulation software methods such as those mentioned above,
Since the registration expression Gυ is closed in one table, row data item 9 in a 9-element table is used in table operations that handle multiple tables.
There was a problem in that the operational dependencies of column data items and cells were not fully inherited by the new table obtained as a result of one table operation.

This invention was made to solve this problem, and in particular, the table to be operated on is statistical row data items such as totals and averages of the entire table data.

If a column data item is included, the statistical row data item 9 column data item can be inherited according to the table operation that handles multiple tables, and its position is also in the rightmost column/bottom row. The purpose is to obtain a software method that can reflect the characteristics and also guarantee the semantics of its contents.

[Means for solving problems]

The data manipulation software system according to the present invention is as follows.

Express the calculation dependencies of each of the row data items, nine column data items, or cell data in a table using formulas and attributes.

It is characterized in that it is stored as file information and its attribute expression is inherited for table operations that handle multiple tables.

[Effect]

In this invention, file information in which the calculation dependencies of each of the row data items, nine column data items, or cell data of one table is expressed in mathematical formulas and attributes holds the statistical attributes of the table, and is used for table operations that handle multiple tables. Furthermore, since this statistical attribute includes position information, it is important to ensure consistency and generality in terms of statistics, especially of the operational dependencies of each row data item and one column data item in one table. guaranteed.

[Embodiments of the invention]

An embodiment of the present invention will be described below with reference to the drawings. 1st
In the figure, (lla is the software configuration of a data manipulation computer consisting of a personal computer used as a data manipulation machine. This software configuration (flV
i. Operating system 08 (21°), which is essential in software development; data manipulation unit (3) that controls processing related to data manipulation;

It is equipped with a user interface unit (4) that manages the interface with the user who performs the operation. In the data operation section (3), there are 9 tables (some tables) that are subject to the operation of the present invention.
5) Full management control, and this table (5) has table data (
6), a format file (7) that stores formats, and a recalculation file (8) that stores information for executing the data manipulation software method that is a feature of the present invention. Further, the user interface unit (4) manages and controls a line printer IJP (9), which serves as an input/output device for the user, a display ORTα [, and a keyboard /B (111).

FIG. 2 shows the structure of the recalculation file (8).

The recalculation file (8) contains statistical row data items (bottom row), one-column data items (
W5α2゜When the table contains a row data item 1 column data item (subtotal of each table, statistics of all tables, etc.) that indicates comprehensive statistics of several tables] It consists of a total attribute 0 that stores its position, and an arithmetic expression section I that stores an arithmetic expression defined by the user.The arithmetic expression section α4 is a function that is a combination of a row data item, two column data items, and a cell.

'n ='('ms ''') *I18 =f(
GnLt e ”' ) * 0nL8 = f(OmL
t,...) (However, 01 is a function, 01 is a row data item, I,...)
1 is a column data item). FIG. 3 is a configuration diagram of table data (6) to be operated.

Table data (6) has row data item σe and column data item 0.
The cell defined by the combination of the two ([η is the minimum configuration unit. Also, the recalculation file (
8) The statistical row data item indicated by the statistical attribute part σ2 is 199 column data item is σ♂.

Next, the operation will be explained. When performing data manipulation based on the software configuration (1) of the data manipulation computer shown in Figure 1, row data item ae9 column data item cI9 of table 1
．． FIG. 4 shows a processing flow for maintaining the computation dependencies of the cells αη. When the user wants to inherit the relationship of an arithmetic expression defined by the user, a recalculation file registration request is issued. With this request, the contents to be input from now on are registered in the recalculation file (8). The next time a data operation is performed, does that operation close within a table?

Check whether it covers multiple tables that are covered by the present invention, update each recalculation file, inheritance and execution processing CD,
Do ■.

FIG. 5 shows a processing flow for registering an arithmetic expression in a recalculation file. When the user inputs an arithmetic expression from K/B (111, etc.), the type of the arithmetic expression is checked.

If it is an arithmetic expression that creates a statistical row data item a19 column data item as, such as the sum or average of the entire table data, it is registered in the statistical attribute section α2 in the re-calculation file (8) (
To) If it is an arithmetic expression between row data item αe1 column data item 119° and cell 19 of table 9, register the arithmetic expression section C14Vc in the recalculation file (8).

FIG. 6 shows the inheritance process C! of the recalculation file (8) when performing data manipulation across multiple tables, which is the subject of the present invention!
This is the flow of υ. Data operations that span multiple tables can be roughly divided into two types: dividing one table into multiple tables, combining multiple tables into one table, and statistically processing multiple tables at once. There are 3 options, check which of them applies to the data operation, and execute (to), @ for each process 0 Recalculation when performing data operation to split one table into multiple tables FIG. 7 shows the inheritance processing flow of the statistical attribute section α2 of file (8). First, check whether the data item with statistical attributes and the direction of data manipulation match (that is, 9
(both rows and columns). If they do not match (rows, columns, and statistical attributes are inherited by each partitioned table (5).
As shown in the figure.

In the figure, the common key refers to the row data item 1e or column data item ttS that is inherited by the nine divided table keys. If a data item with statistical attributes and the direction of data manipulation match, a common key is used.

It is checked whether the row data item Q9j or column data item al in which the statistical attribute is realized is satisfied. If the item is not specified as a common key, only the table that contains the item for which the statistical attribute is achieved as a result of 1 division will inherit the statistical attribute), and if it is specified as the common key, the entire 9-part Inherit statistical attributes from before partitioning into tables (to).

An example of the former is shown in FIG. 10, and an example of the latter is shown in FIG.

FIG. 8 shows the inheritance processing flow of the statistical attribute section 0 of the recalculation file (8) when a data operation is performed to combine a plurality of tables into one table. First, check whether the data item with statistical attributes and the direction of data manipulation match (that is, 9
(both rows and columns). If they match, in the table obtained as a result of 9 combinations, if it is in the 9th row direction, it is the bottom row data item (If it is in the 0th column direction, it is summarized as the bottom row data item). Inherit the attributes (to).On the other hand, if they do not match, 9If the table sizes do not match, create an item of empty data (no data value) inside the statistical row data item α91 column data item ■. Added 1 Inherit the statistical attributes of the table before composition as is (
to). An example of the former is shown in FIG. 13, and an example of the latter is shown in FIG.

A recalculation file (8
) shows the operation flow of the statistical attribute section α2 and the total attribute section 01 in FIG. First, calculate all the subtotals for the 6 tables that were targeted (this process is omitted for tables that are already held as statistical attributes) (To) 9) Next, calculate the statistics for all the tables (the sum of the subtotals for the 6 tables) (to).

This information is entered as a total attribute in the statistical attribute section α3 of the recalculation file (8), and as subtotal and total items in the total attribute section (13).An example of this operation is shown in Section 15.
As shown in the figure. This operation is performed in the same way for other statistical attributes that span multiple tables.

In addition, in the above embodiment, the data manipulation computer (1)
Although a personal computer was used for the data manipulation computer (1), a small computer, a medium computer, and a large computer
Alternatively, a dedicated data processing machine may be used. In addition, in the above embodiment, as shown in FIG.
) has 6 tables (5) as external 7 files, but it can also be used as internal memory (, data (61, formant (7), recalculation file (8) can be divided into 6 tables (5)) However, they can all be used together or in combination (in the above example).

Statistical attribute Q3 in recalculation file (8). ) - Although we have dealt with the inheritance of only the attribute αJ, the calculation formula part Q41 can also be uniquely inherited in terms of the calculation order and update (there is no common key specification, etc.). The entire recalculation file (8) may be constructed without dividing the data attribute section and the arithmetic expression section (I41'!i), and the same effect as in the above embodiment can be obtained.

〔Effect of the invention〕

As described above, this invention is equipped with file information in which the calculation dependencies of each row data item, nine column data items, and cells of a table are expressed as mathematical formulas, and in particular, the statistical relationship 9% is expressed as an attribute. To ensure consistency and generality, especially in terms of statistics, of calculation dependencies of row data items and nine column data items of a table in table operations that handle multiple tables, and to automate data operations.

It is effective in saving labor and improving reliability.

[Brief explanation of drawings]

Fig. 1 is a block diagram of a data manipulation software system according to an embodiment of the present invention, and Fig. 2 is a block diagram of a recalculation file.
Figure 3 is a configuration diagram of table data, and Figure 4 is a processing flow of data manipulation software. Figure 5 shows the processing flow for registering calculation formulas in the recalculation file.
FIG. 6 is a recalculation file inheritance processing flow when performing data manipulation across multiple tables, which is the subject of this invention, and FIGS. 7 to 9 are detailed processing flows of FIG. 6. Figure 7 shows that when dividing one table into multiple tables,
The figure shows each processing flow when multiple tables are combined into one table, and FIG. 9 shows the processing flow when multiple tables are collectively processed statistically. Figures 10 to 15 are diagrams showing the inheritance of the statistical attribute section of the recalculation file, and Figures 16 onwards are conventional ones, and Figure 16 is a diagram showing the configuration of the conventional data manipulation software method. Figure 1T shows the table data that the user can normally view, and Figure 18 shows the dump output of the table data in which calculation formulas are registered.Figure 19 shows the processing flow for maintaining calculation dependencies. . In the figure, (1) is the software configuration of the data manipulation machine, (3) is the data manipulation unit, (5) is the table that is the object of the operation of the present invention, and (61 to (8) are the configurations of this table (5). Elements, (6) is table data, (7) is format file, (8) is recalculation file, 02 is statistical attribute section, (I3
is the total attribute part, I is the calculation expression part, and Kasumi is the column data item. αG is a row data item, and wholesale is a cell.

Claims (1)

[Claims] In a data manipulation software method that performs table operations that handle multiple tables, each calculation dependency relationship of row data items, column data items, or cell data of a table is expressed as a mathematical expression, statistical relationships and characteristics are expressed as attributes, and file information is used. By accumulating the formula information and attribute information from the file, when performing table operations that handle multiple tables, the consistency and generality of these calculation dependencies, especially statistical relationships, can be automatically checked. A data manipulation software method characterized by inheritance in the resulting table.