JPH0225968A - Data processor - Google Patents

Abstract

PURPOSE:To set a complicated operation in a combination of simple operations by designating an operation unit with division into the prescribed units and repeating the operations for each unit in case the operation is applied to the data stored in response to words. CONSTITUTION:Plural types of operation contents are set by plural operation setting means with either one of those words stored in a data memory 26. An operation means 20 reads out the data corresponding to the word set by an operation setting means (B table 1, B table 2) out of various data stored in the memory 26 and performs an operation based on the set operation contents. Then the means 20 repeats the operations in response to the data corresponding to the words stored in the memory 26 in response to each set (B table 1, B table 2) of each operation. As a result, even a complicated operation can be simply set in a combination of simple operations.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a data processing device that creates and outputs specific data based on various data input in advance.

[Conventional technology]

Generally, in a business office processing device, when aggregated data of sales amounts for each product handled by each salesperson (person in charge) is managed in a file in a magnetic disk device, each piece of data in that file is managed. Based on this, you may want to output a specific management output, for example, calculate the sales composition ratio of each product to the total sales of the sales office, select the products whose composition ratio is 10% or more, and output the results. be. In the case of such a table, in a conventional office processing device, a calculation program for calculating the above-mentioned specific management output, that is, in order to calculate the above-mentioned specific management output, which data and which data in the above-mentioned file are read, In addition, it is necessary to set the processing program such as what kind of calculation to perform in a one-to-one correspondence with the above-mentioned specific management output that is desired to be output.

[Problem that the invention seeks to solve]

Therefore, in conventional office processing devices, a specialized programmer is required to set programs for specific output processing, and especially when you want to set a large number of the above specific output processing, it takes a lot of effort and time to set them up. was necessary.

An object of the present invention is to simplify settings for creating and outputting specific data based on various data stored in advance.

[Means to solve the problem]

The present invention provides a plurality of operation setting means (for example, Table B (1) and Table B (2) of the embodiment) for specifying words to be subjected to diatonic multiplication operations and operation contents associated with various words.
), and an arithmetic means (for example, the processing device 20 of the embodiment) that performs a set arithmetic operation on the word set by one arithmetic setting means, and this arithmetic means performs an arithmetic operation on the data in the data storage means. The calculation is repeatedly executed in response to each setting made by a plurality of calculation designation means.

[Effect]

It is assumed that data associated with various words is stored in the data storage means, and various calculations are performed based on these data. First, a plurality of calculation setting means sets the calculation contents by any word in the data storage means in a plurality of lines. The arithmetic means reads data corresponding to the word set by the one arithmetic setting means from among the various data in the data storage means, and performs an arithmetic operation according to the set arithmetic content. This calculation means sets each of the plurality of calculation setting means (for example, Table B (1) of the embodiment,
In response to Table B (2)), an operation is repeatedly performed on the data corresponding to the word in the data storage means. Therefore, complex calculations can be easily set by combining simple calculations, and the above calculations can be repeatedly executed in order to obtain desired calculation result data.

〔Example〕

Hereinafter, one embodiment will be described with reference to FIGS. 1 to 9.

FIG. 1 shows a system configuration diagram of a data processing device. In the figure, reference numeral 10 denotes an input device, which includes, for example, a numeric keypad, function designation keys for designating various types of processing, funky syllan keys, and the like. The processing type designation data and edit data inputted from the input device 10 are sent to the edit processing device 11, and the Ps file 12 is accessed by the edit processing device 11. This PS file 12 is a file that stores the contents arbitrarily set by the user, and this PS file 12 includes a definition table (hereinafter referred to as A table) for defining the basic words when creating a new record. ) and a definition table (
Multiple definition tables can be set; hereinafter referred to as B table)
, a definition table (hereinafter referred to as 0 table) for defining the file name, keyword, update type, and update word when updating the master file, and the words to be displayed and their display format. Definition table for (
(hereinafter referred to as table D), and a definition table (hereinafter referred to as table D) for defining the types of words to be printed and their printing formats.

Table E) is set for each type of processing. Note that tables A to E defined for each process type are collectively referred to as definition documents ps, and the ps file 12 includes a plurality of definition documents PS (Psi.

Psi, . . . ) are arbitrarily set according to the user's request.

Therefore, the edit processing device 1 has an input device 1.
Creation of file format based on instructions from 0,
This is used to set data to the PS file 12 and read out the ps. When ps is read from the ps file 12, table A is stored in the input column memory 13, table B is stored in the processed word memory 14, and table 0 is stored in the file. The D table is loaded into the word memory 16, the D table is loaded into the display word memory 17, and the E table is loaded into the print word memory 18, and then a start command is given to the input processing device 19. The A table loaded into the input Cowart memory 13 is sent to the input processing device 19, the B table loaded into the processed word memory 14 is sent to the processing device 20, and the 0 table loaded into the file word memory 16 is sent to the file creation device. 21, the D loaded into the display word memory 17
The table is read out to the display processing device 22, and the E table loaded into the print word memory 18 is read out to the print processing device 23.

Further, the input device 10 is connected to the input processing device 19, and an index cable memory 24 and a work memory 26 are also connected thereto. In the index cable memory 24,
The product code, product name, unit price, etc. for each inserted and removed product are stored and set in advance.

The input processing device 19 has an input data P memory 1.
Processing such as calculation and aggregation is performed based on the A table read from 3, input data from the input device 10, etc., and the processed word data is stored in a predetermined work area in the work memory 26. Processing equipment 20. The file creation device 21, display processing device 22, and print processing device 23 are started. A work memory 26 and a file format memory 25 are connected to the processing device 20 . A file format is previously set in the file format memory 25 from the input device 10 via the edit processing device 11.

This file format defines the format of each file stored in the master file 29, and sets the record structure of various files such as a "product file". Figure 2 shows the record structure of the "Product File", where "Product Code" is used as a keyword.
“Product name, unit price.

``Number of sales, proceeds from sales'' are set as data words.

Further, a file format memory 25 and a maintenance file 27 are connected to the file creation device 211fC. The file creation device 21 automatically starts processing operation in response to a startup command from the input processing device 19, and based on the 0 table stored in the file word memory 16, maintenance record data (record data of (in which the word data is ordered to match the record structure of the corresponding file),
The stratification is registered in the maintenance file 27. A plurality of maintenance record data are registered in this maintenance file 27, sent to the file update device 28 based on commands from the input device 10 or the file creation device 21, and updated and registered for the corresponding files in the master file 29. be done.

Further, this master file 29 is readably connected to the input processing device 19 and the processing device 20.

The display processing device 22 starts processing operation in response to a startup command from the input processing device 19, reads word data in the work memory 26 based on the D table stored in the display word memory 17, and creates display data. and display device 3
Display at 0. The print processing device 23 is the input processing device 19
Alternatively, when a startup command is given from the processing device 20, data in the work memory 26 is read out based on the E table stored in the print word memory 18, and form data in a specified format is created based on this data. The printing device 31 is driven to print out the form.

Next, a specific example of the PS set in the PS file 12 will be explained. Figure 3 (,) and (b) are ps
This shows the specific structure of Table A and Table B. That is, table A has item A for arbitrarily setting the source file (master file), item A2 for arbitrarily setting the word salt (creation word) of the record to be newly created, and each of these items. Item A for specifying the word salt (source word) in the source memory that corresponds to the created word
There are 3. Table B also includes item Bl for arbitrarily setting the record conditions to be created (these conditions include record conditions for extracting only desired records and sorting conditions) and the set word salt (creation condition). Item B for arbitrarily setting a new word salt (created word) to be added that can be derived based on the existing word data)
2, and item B3 for specifying the word salt or word operation of the created record corresponding to this created word. Table A and Table B (1) p (2) shown in Figures 3 (&) and (b) are calculated based on the total sales amount of all products from the "product file" in the master file 29.
Tables A and B are shown for creating a list of products having a sales ratio of 0'1 or more.

That is, according to this table A, item AZ (source file name)
"Product file" is set, and item A2 (created word) is set with three word names: "product code, product name, amount I", and item AJ is set corresponding to each word name.
For (source word), three word codes corresponding to the above-mentioned "product file", ie, "product code, product name, and complete" are specified. By the way, a plus mark "+" is added to the word salt of the third word "amount I" in item A2, which indicates that this word salt is also the word salt that is subject to aggregation. . Then, the word salt to which this glass mark "+" is added is specified in the designated area of the renit number ""1" in item A2, and furthermore, in this item A2, the word salt with the renit number ""2#" is specified.
is specified (this renit pick-up "2" is specified as soon as the aggregation record is created), the data of the word salt to which the plus mark "+" is added is aggregated. This tally data is regarded as word data for tallying as specified by Renit pick-up ""2", and a record for tallying is created based on this word data. On the other hand,
If Renikto Pickup@2' is specified in the item A2, no tally record is created. In this case, item A2 includes Rennit Nampa @1' and “
2# is specified and the word salt of "ten amount I" is specified in the specified area of Renit pick-up @1", so the word salt of "amount ■" is read from the source file. Aggregate word data (in this case, "complete" word data). This totalized word data is regarded as totalization word data corresponding to the word value of "amount I," and a totalization record is created based on the designation of the renit pick-up "2#."

This image will be further explained with reference to FIG.

Change the source file (product file) Niha keyword name to “
"Product code" and the data word "Product name, unit price,
It is assumed that four records r are stored for ``number of sales, proceeds of sales''. Then, a new 1/code is created according to the A table mentioned above, but first, by setting the created word in Renit 1, there are 4 records with "product code, product name, amount I" as the word code. Created. At this time, since a plus mark "+" is added to the word code of "Amount ■", the word data &1bled of each record corresponding to the word code of "Amount I" is totaled, and in Renit 2, the "Product Code" is added. "Do".

The word data corresponding to the word salt of "product name" is pla/ku code @X', and the word data corresponding to the word salt of "amount ■" is ΣA (" jL4 + b4 + C4+
A record of d4) is created.

Next, Table B will be explained.

In this case, there are two B tables, and the first B table, that is, the B table (
In 1), item B1 (condition) is “none”, and item B
2 (created word) is set to "ratio", and the item BJ (word content) corresponding to this word specifies an arithmetic expression of "amount 1/2 amount ■". That is, this B table (1
) is based on each record created in table A above, and further '
Instructs to add the word "ratio" data to each record. This data can be obtained by dividing the 17-word data of "Amount I" of each record in the Renit 1 by the word data of the "Amount IJ" (this amount is the total amount) in the Renit 2.

To explain this image with reference to FIG. 4 mentioned above, word data of the word "ratio" is newly added to each record created using Table A. That is, word data of a5 (==a4/ΣA) is added to the record with the product code a (calculator), and word data of b5 (=b4/ΣA) is added to the record with the product code b (clock). If the word data of Σperson) corresponds to the record of product code C (instrument), e
If the word data of 5 ("" e a/ΣA) corresponds to the record of product code a (office computer), then d5 (=
d4/ΣA) word data is added. Further, at this time, writing of word data of "ratio" in Renit 2 is not specified, so the fourth word of the 1/code in Renit 2 is not created.

In addition, in the second table B, that is, table B (2), item B
2 (condition) is set as a record extraction condition indicating that the ratio is 10 or more, and item B2 (created word)
The word salt of "100 yen ■" is set, and the word salt of "amount ■" is specified in the item BJ (word content) corresponding to this word salt. In other words, this B-table (2) instructs to extract records in which the word data of "ratio" is 10 or more from among the records created in the above-mentioned B-table (1), and furthermore, the word salt of "amount ■" is extracted. data to be added to each record extracted as above. Then, word data of "amount I" is assigned to this data. In addition, a plus mark "+" is added to the word salt of this created word "Amount ■", so "
Each word data of "Amount ■" is totaled, and this total data is written as word data of "Amount ■" in Rennit 2.

To explain this image using Figure 4 mentioned above, Table B (1
) of each record created with the word "ratio" of 10 or more (in this case, for example, if a5 = 30, b5 = 5, c5 = 20%, d5 = 451, the product code is a, Records c and d) are extracted, and word salt data of "amount ■", that is, "C6", "b6", and "C6" are newly added to each extracted record. At this time, the word data of "amount n" in Renit 2 is data ΣB2 (=J
+C6+d6) is allocated.

Next, specific processing for operating the data processing apparatus of this embodiment shown in FIG. 1 will be explained based on Table A, Table B (1), and Table B (2).

First, when ps is specified on the input device 10 to instruct to create a list of products having a sales ratio of 10% or more with respect to the total sales amount of all products from the "product file" in the master file 29, This designation signal is given to the edit processing device 11. This edit processing device 1
1 is the PS file 12 based on the above specification.
Tables A to E are read out and loaded into each of the word memories 13 to 18, and a start command is given to the input processing device 19.

This activates the input processing device 19, and the input processing device 19 executes the processing shown in the flowchart of FIG. 5 based on the A table loaded into the input memory 13.

That is, the input processing device 19 is Stella fS.

In , the source file specified in table A, that is, the "product file" in the master file 29, is specified. Based on the data of the first record of Create a record L consisting of each word data of "Amount I", among which the word data specifically specified for aggregation, that is, the word data of "Amount I", and write it to the first work area "Work 1" of the work memory 26. (steps 82-84).

This writing is performed for all records in the source file by checking in step S5. After all records have been written, it is determined in step 86 whether or not the second record is specified in the A table.

Then, when there is a second Renite specification, a record of the total data of the word salt with the tally specification, that is, the word salt of "amount ■" is created, and the record is stored in the first work area "Work 1" of the work memory 26. It is written as a 2-unit record (steps Sy and Ss).

When the processing based on the A table is completed, the input processing device 19 starts the processing device 20, and the processing device 20 processes the B table loaded into the processed word memory 14, in this case two B tables, that is, the B table ( 1), 6th table based on B table (2)
The process shown in the flowchart in the figure is automatically executed.

That is, in step S11, the processing device 20 determines whether or not there is an unspecified B table in the processing word memory 14, and if so, specifies the immediately previous work area in the work memory 26 (Stella 7'512).

In this case, since table B (1) is stored in the processing word memory 14 in an unspecified state, the first work area "Work 2" of the work memory 26 is designated as the target memory. Next, an unread record in this work area is specified (step 'f813L).
If there is a record condition in table (1), it is determined whether the specified record meets the above record condition (
Step S14゜515). If the record meets the record conditions, it is further determined whether a creation word has been set in the currently specified table B, and if so, word data is created according to the corresponding word content (step S16). 517). In the case of Table B (1), there is a creation word setting, and the content is a word operation, so step 5
In 17FC, a word operation is performed on the designated record to create word data. At this time, if aggregation is specified, that is, a plus mark "+" is added to the created word, this word data will be aggregated (Stella fSta).
At ``S STELLA'' 819, a record in which the above creation word is newly added to the currently specified record is written into the second work area ``WORK 2'' of the work memory 26. Note that when it is determined in the above step S16 that the creation word is not set in the specified B table, the specified record is written as is into the second work area "Work 2" of the word memory 26 (Stella 7''52o), Above step Sf9 * Stella after 82Qs or 815
821 is executed, and it is determined whether or not there is an unspecified next record in the previous work area "Work 1", and if there is, the process returns to step 51iS. By repeatedly executing steps 815 to Stella 7' 821, the word data of the additional word "ratio" is added to the records that meet the record condition (not present in this case) among all the records in the work area "Work 1". The added records are layered and written to the second work area "Work 2". When all writing to the records of the second record is completed, in step S22, it is determined whether the currently specified B table K sorting condition is set, and if so, a new record is created according to the sorting condition. A rearrangement is performed (step 523). Then step S2
In step 4, it is determined whether or not there is a record of the second record in the work area, and if so, a record of the total data of the word with the total specification is created, and this created record is stored in a predetermined work area of the work memory 26. written. In this case, there is a record for Renit 2 in the first work area "Work 1", and the created word in table B (1) has not been specified for aggregation, so the record corresponding to Renit 2 is the created word, i.e. A record of work data of "ratio" with blank code "7" is created and written to the second work area "work 2" of the work memory 26.

Thereafter, the process returns to step S11, and it is determined again whether or not an unspecified B table is stored in the processed word memory 14. That is, after the processing based on the settings of table B (1) is completed, the presence or absence of table B (2) is checked in step 811, and in this case, since the settings of table B (2) are present, Stella fs
12, the second work area of the work memory 26 "
Work 2'' is designated as the previous work area, and the same process as that for table B (1) described above is executed again. In this case, the newly created record based on table B (2) is written to the third work area "work 3" in the work memory 26. Also, unlike table B (1), table B (2) has record conditions set, so in step 815 only records that meet the record conditions are extracted and written to the third work area "work 3". . Table B (2) differs from Table B (1) in that a mark "+" is added to the created word to specify word aggregation.
In step S18, the word data of "amount ■" is totaled, and in step 825, a record including the word of this total data is created.

As described above, when processing for all B tables stored in the processed word memory 14 is completed, the work memory 2
The record newly written in the third work area "Work 3" of No. 6 is merged with the large part of the renit and newly stored in the final work area "Work X" in the work memory 26 (steps 827 e 828 ).

The processing device 20 thus completes the processing for all B tables, and starts the print processing device 23.

The print processing device 23 is activated by a command from the processing device 20, and based on the E table loaded in the print word memory 18, that is, the definition table that defines the type and format of the word name to be printed. work memory 2
For each record written in the final work area "Work X" of No. 6, a list in the format shown in FIG.

By the way, in the above embodiment, 101 is calculated for the total sales amount of all products from the "product file" in the master file 29.
The explanation was based on the PS that instructs to create a list of products with the above sales ratio, but there are many other PSs. For example, if you want to create a list in descending order of sales amount from the "product file" above. For example, you can use exactly the same table A and set a new table. That is, first, in the input memory 13, the A shown in FIG. 3 (&) is stored.
By loading the table, loading the processed word memory 14 with a unique B table as shown in FIG. 8, and loading the print word memory 18 with a unique E table showing the format of the above list. good. In the case of table B shown in FIG. 8, item B1 (condition) is set with the sorting condition shown as "sorting in descending order of amount", and item B? (Created word) and item B3 (Word content) have no settings, so records created based on Table A, as shown in Figure 9, have the same record structure and the record arrangement order. is changed and written to the second work area "Work 2" in the work memory 26.

This will be explained using the flowchart shown in FIG. First, the presence or absence of the B table is checked in Stella 7'St1, and step 81
In Step 2, the final work area of the work memory 26, that is, the first work area "Work 1" that stores the records created in Table A, is specified, in Step S13 the first record of that area is specified, and in Step St4 It is determined whether or not a record condition is set as a condition. In this case, since the only condition is a rearrangement condition, it is determined to be NQ and the process proceeds to step S16. This Stella 7” 816
Then, it is determined whether or not there is a created word setting in table B. In this case, since there is no such setting, the process proceeds to step 820K.

In Stella F820, the specified record is written as it is to the second work area "Work 2JK" in the work memory 26,
Next, in step S21, the first work area "work 1"
If it is YES, the process returns to step S13 and all records (in this case, 4 records and 1 record) of the 2nd unit created in table A are determined. A process of writing to the second work area "Work 2" is performed. When writing of all records is completed, step S2
Proceeding to step 2, it is determined whether or not a sorting condition is set as a condition for table B. In this case, YES is determined and each record in the second work area is sorted based on the set condition. After this, step S24 * S2
5 * Proceed to S26 and select the first work area “Work 1
” is written as is into the second work area “Work 2”.

Then, the process returns to Stella fS11, and if the answer is NO, the records are merged in descending order of renit in steps 327 and 828, and are written to the final work area "Area X" of the work memory 26.

And in this way, the final work area "Waichiri X"
Each record written in is read out by the print processing device 23, and the record is printed in a format according to the contents of the print word memory 18.

In the above embodiment, the input processing device 1 based on the specifications in Table A
9, the data in the master file 29 is aggregated and written to the work memory 26.
Although the data input from the input device 10 is calculated by the processing of the processing device 2Q based on the specifications in Table B and written into the work memory 26 again, the data input from the input device 10 is calculated by the processing of the processing device 2Q based on the specifications in Table A. It is also possible to write the data into the work memory 26 in step 19 by 'fllllc', and then perform calculations based on the specifications of table B in the same manner as above. In this case, if multiple specifications of table B are made, processing equipment 2
0 repeats the calculation of data in the work memory 26 in order for each B table specified, and the final calculation result is stored in the work memory 26.
is memorized to. Therefore, for complex calculations, it is only necessary to additionally specify the B table, and the file creation device 21, display processing device 22, and print processing device 23 can perform unique calculations based on the data in the work memory 26 where the final calculation results are stored. Processing is possible.

〔Effect of the invention〕

According to this invention, when calculating data stored in association with words to obtain predetermined calculation result data,
Since the unit of calculation is divided into predetermined units and specified, and the calculation is repeated for each unit, the calculation settings for obtaining the desired calculation result data can be simplified, making it easier to use with normal programs. Calculations that are extremely complex in design can be set by combining simple calculations.

[Brief explanation of the drawing]

The drawings show an embodiment of the present invention. Fig. 1 is a system configuration diagram of a data processing device, Fig. 2 is a diagram showing a record structure of a file format, and Fig. 3 is a PSOA table set in a PS7 isle. and Table B (1) f Table B (2
), Figure 4 is an explanatory diagram showing the transition of the processing status of records read from the source file, Figure 5
6 and 6 are flowcharts showing the operations of the input processing device and the processing device, FIG. 7 is a diagram showing the printing state, and FIG.
9 and 9 are diagrams showing other examples of the structure of Table B and changes in the processing status of records. 10... Input device, 12... PS file, 13.
... Input word memory, 14... Processing word memory,
16... File word memory, 18... Print word memory, 19... Input processing device, 20... Processing device, 21... File creation device, 23... Print processing device, 26. ...Work memory, 27...Maintenance file, 28...File update device, z 9
...Master file, 31...Printing device.

Claims (1)

[Claims] a data storage means for storing data associated with various words; a plurality of calculation setting means for setting words to be calculated and calculation contents in the data storage means; and words set by one calculation setting means. and a calculation means for performing a calculation set for the data storage means, the calculation means repeatedly performing calculations on the data in the data storage means in response to each setting by a plurality of calculation setting means. Processing equipment.