JP3047401B2 - Data processing device - Google Patents

Description

Description: TECHNICAL FIELD The present invention relates to a data processing device for counting records in a file.

[Related Art] Generally, in data processing using a computer, various files are stored in a disk or the like, and various files are updated based on input record data. By the way, each file is designed according to the user's request, and the record structure and the word position of each record in the file are substantially fixedly determined on a memory such as a disk.
And when reading records in the file,
In accordance with the record structure of the file, a unique program was designed, and the position of each record or word was designated by this program and read.
Further, in order to output the data as various kinds of book tables and the like, a program is created for totalizing the records read from the file as described above, and the program is totalized. As described above, when operating the system, it is well known that the system was designed in accordance with each user's request.

[Problems to be Solved by the Invention] The system design has to be variously designed according to the demands of the user, which requires a great deal of labor and time. For example, when outputting a book table, it is necessary to extract the records required for the book table from the records in the file and to aggregate the records in the file. Was to respond. In other words, since the output ledger varies depending on the user, it is necessary to design a system for each individual user.

SUMMARY OF THE INVENTION It is an object of the present invention to obtain a high-order total record of a record in a file required for book output without appropriately creating various programs by appropriately specifying it.

[Means for Solving the Problems] The means of the present invention are as follows.

File storage means for storing a plurality of records composed of record keywords and data words, and a total record composed of a record keyword indicating a total record and a data word obtained by totaling the plurality of records.

Record storage means for storing records consisting of record keywords and data words.

Tabulation means for tabulating records stored in the record storage means into records in the file storage means having matching record keywords.

If there is a record keyword indicating a higher-order total record of the records stored in the record storage means, a higher-level totalizer that generates the higher-order total record and totals it into a corresponding data word.

[Operation] The operation of the means of the present invention is as follows.

Records composed of record keywords and data words input to the record storage means are totaled by the file storage means by the totalization means. In the file storage means,
A plurality of records each including a record keyword and a data word, and a total record including a record keyword indicating a total record and a data word obtained by totaling the plurality of records are stored. The counting means counts the records stored in the record storage means into records in the file storage means having the same record keyword. Further, when there is a record keyword indicating a higher-order total record of the records stored in the record storage means, the higher-order totaling means generates the higher-order total record and totals it into a corresponding data word.

Therefore, if the record keyword of the aggregation record is appropriately set and stored in the file storage unit in advance, at the time of writing the record to the file storage unit,
As a result of the tabulation into the tabulation records, the desired tabulation records only need to be read and arranged at the time of outputting the form.

Embodiment An embodiment will be described below with reference to FIGS. 1 to 6.

FIG. 1 shows an overall configuration diagram of a data processing device. In FIG. 1, reference numeral 11 denotes an input device for inputting slip data and the like, and includes, for example, a setting key for setting various kinds of designated data in advance, a numeric keypad for inputting data, a function key, and the like. An input processing device 12, an update record generation device 13, and a file update processing device 14 are sequentially connected to the input device 11. Then, the input processing device 12, the update record generation device 13, the file update processing device
14, an input record designation memory 15, an update record designation memory 16, and an update memory 17 are connected,
The creation record memory 18, the update record memory 19, and the file memory 20 are connected. The input record designation memory
15. In the update record designation memory 16, predetermined designation data is preset by the input device 11, respectively. Although the details of each designated data will be described later, the input record designation memory 15 is set with the correspondence between the word number and the word content of the record to be created. The word content indicates, for example, an “input word”, an “index word”, a “calculation word”, and the like. The update record designation memory 16 stores one or more record keywords, data indicating the correspondence between each word of the update record consisting of data words and each word of the record in the creation record memory 18, and the name of the file to be updated. A file keyword indicating the content and data indicating the content of the update are set.

The input processing device 12 processes the data input from the input device 11 in accordance with the word content set in the input record designation memory 15, and writes a record in the created record memory 18 corresponding to the set word number. Upon completion of writing one record or one record of a plurality of records into the created record memory 18,
The update record generation device 13 is started. The update record generation device 13 generates an update record from a record in the creation record memory 18 based on the settings in the update record designation memory 16 and writes the update record in the update record memory 19. The update record written in the update record memory 19 includes a file keyword, one or a plurality of record keywords, contents of update, and a data word.

The file update processing device 14 includes an update record generation device 13
, Or in the case of batch processing, by an update instruction command from the input device 11 and based on the update record stored in the update record memory 19, that is, the file keyword and the record keyword of the update record. The update process is performed on the record group of the corresponding file in the file memory 20 using the update memory 17 in accordance with the following. The update memory 17 is composed of, for example, a RAM and has areas A, B, and C therein and is used as a work memory.

In the file memory 20, a record group including one or a plurality of record keywords and data words is stored for each file in the order of keywords. Each record in the file stored in the file memory 20 is read by the output record generation device 21.
The output record generation device 21 is connected to an output record designation memory 22. This output record specification memory
Designated data 22 for creating an output record, for example, a file keyword, a search condition, a created word, word content, and the like are set in the input device 22 in advance. The output record generation device 21 is activated by an output instruction command from the input device 11, creates a record based on the settings in the output record designation memory 22, and writes the record into the created record memory 18. The created record memory
The record stored in 18 is read by the output processing device 23, output in a predetermined printing position and a predetermined form according to the specified data set in the output format specifying memory 24, and printed or displayed by the output device 25. .

2A, 2B and 2C show the storage states of records in the file memory 20. FIG. In FIG. 9A, a file keyword "F ₁ " and a word delimiter code "." Are stored after the file delimiter code "[", and a record delimiter code "(" is stored at the head of each record. The word of word No. "01" of each record is a record keyword, a code constituting the record keyword is stored, and is separated by a record keyword delimiter code "." Data words such as “11”, “12”,..., For example, “unit price”, “quantity”,... Only the existing data is completely packed and accommodated.In the figure, a space is provided to clarify the correspondence between words in each record. However, there is no space on a memory such as a disk, and the code stored in the record keyword indicated by the word No. “01” of each record, which is completely inserted and stored. The code system is the code system shown in Fig. 3. The product codes "111", "112", ... indicate the product names "Watch A", "Watch B", .... The product code in the figure represents the major classification and middle classification of each product, and the upper two digits of the product code are common codes, for example, "11" indicates "watch", "12" indicates "clock", The upper one digit of the product code is a common code, for example, "1" represents "clock",
“2” indicates “calculator”. That is, codes used as record keywords such as product codes are weighted in order from the upper digit of each code in accordance with the large classification, the middle classification, and so on. A record in which data words of the lowest level record are totaled (hereinafter, referred to as a totaling record) corresponding to the major classification, the intermediate classification, and the like is stored in the file memory 20 as shown in FIG. , A special code “*” is added after the upper digit code of the code of the record keyword. For example, "11 *" means "watch"
Tally record, “12 *” is a tally record of “Clock”, “1 *” is a tally record of “Clock”, “2”
“*” Indicates a tally record of “calculator”. In addition, the special code "*" has a smaller weight than each character of the code used as a record keyword, for example, 0, 1, 2,...
Are arranged in the ascending order of the record keywords, if the digits of the code of the record keyword are compared in order from the upper digit, they are arranged in the order shown in FIG. 2 (a). FIG. 2 (b) shows an example in which each word is composed of fixed-length data. In this case, the record keyword of the tally record is such that the special code after the upper digit code is continued to the lowermost digit or the upper digit. It only needs to be added to the digit immediately after the code. FIG. 2 (c) shows another example of storage of the tally record. In this example, the record keyword is composed of a plurality of words, and each record keyword is weighted in order from the highest word. The lower record keyword is an empty word. Furthermore, a code with a smaller weight than each character of the code of the record keyword is used as a division code for dividing each word of the record keyword. Therefore, when comparing the record keywords, the comparison is performed sequentially one digit at a time including the delimiter code from the head code of the head word of each record, and large or small is determined based on the weight of the code of the mismatched digit. . Then, the records are arranged and stored in the ascending order of the record keywords according to the result of this determination.

When the above-described total record is set in the file memory 20, at the time of initial setting of the file, a record composed of a record keyword with the special code or a record keyword having an empty word is input from the input unit 11. In accordance with the designated data in the update record designation memory 16, "addition" is designated as a predetermined file keyword and update content. By this designation, an update record is created in the update record memory 19 based on the input record, the update process of the file update processing device 14 is executed based on the update record, and the totaled record is transferred to the file memory 20. Is set. That is,
The user can set an aggregated record of any level simply by inputting a keyword of the aggregated record including a higher-order code and a special code as a keyword of the aggregated record.

Next, the operation of the embodiment will be described. When each word data of an input record is input from the input device 11 based on a slip or the like, the data is input to the input processing device 12. When the data is input, the input processing device 12 refers to the designated data in the input record designation memory 15 as shown in FIG. 4, and reads the word contents corresponding to the word No. “I1, I2,..., In”. "W
1, W2,..., Wn (input, index, calculation, etc.) are processed in the order of word numbers, and the processing results are processed as word data "m1, m2,..., Mn". The data is sequentially written into the created record memory 18. If the word content is "input word", the input word data is input to the word of the created record memory 18 corresponding to the word No. In the case of an "index word", the input word data, for example, code data is converted to character data by referring to an index memory (not shown) in the input processing device 12 and input to the corresponding word of the creation record memory 18. I do. In the case of the "calculation word", the calculation is performed according to the operation between the words defined using the word No., and the data of the calculation result is input to the corresponding word in the creation word memory 18. For example, if “I1 × I2” is defined as the word content “W3”, the word data “m1” and “m” of the word No. “I1” and “I2” in the created record memory 21
2 is read and multiplied, and the resulting word data "3
"m" is input to the input word No. "I3" of the creation record memory 18. In this way, the input processing device 12 performs processing according to the contents of each word in the input record designation memory 15. When the input of one record or one slip of a plurality of records into the created record memory 18 is completed, the update record generating device 13 is started. The update record generation device 13 generates an update record from the record held in the creation record memory 18 based on the specified data in the update record specification memory 16 and writes the generated update record to the update record memory 19. The update record designation memory 16 stores one or more record keywords and data words as shown in FIG.
Data indicating the word No. of the record in 18 and the contents of the update and the name of the file to be updated are stored and set in advance as designated data. For example, designated data 16-1
As the contents of the update, “total” is used, “F2” is used as the file keyword, and “I
2, I3 "is set as a data word, and" I5, I6, I1, I4 "is set, and an example in which there are two record keywords is shown. As the designated data 16-2, "total" is set as the content of the update, "F3" is set as the file keyword, "I1" is set as the record keyword, and "I13, I14" are set as the data words. An example in the case of one keyword is shown. In addition, data indicating any of “add”, “delete”, “total”, and “correction” is set as the content of the update in the designated data.
Then, based on the specified data, the created record memory
Update record is created from the record in 18,
For example, for the designated data 16-1, an update record whose update content is “total”, the file keyword is “F2”, the record keyword is “m2, m3”, and the data word is “m5, m6, m1, m4” 19-1 is created. Other update records are similarly created and stored in the update record memory 19. Each word of the update record stored in the update record memory 19 is divided by a delimiter code ".", ".", And each update record is variable-length data divided by a delimiter code "(". The structure of the record is such that the first word following the record delimiter code "(" is a word indicating "contents of update", the next word is a word indicating a file keyword, and further from the next word to the delimiter code "." Is a record keyword, and each word following the delimiter code "." Is a data word.

Thus, the file update processing device 14 is activated by a command from the update record generation device 13 or an update instruction command from the input device 11, and executes the file update process shown in the flowchart of FIG. That is, the file update processing unit 14, the processing of step S _11, the update records in the update record memory 19 file keywords order by and sorted in a record keyword order and in the processing of the next step S _12, update record memory All update records of the same file keyword in 19 are read out and written in the A area of the update memory 17. Further in step S _13, reads all records of the corresponding file keywords in the file memory 20, and writes the B region of the update memory 17. Then, in the processing of the next step S _14, the update one record read out update record A region of the memory 17, in step S _15, whether or not the contents of the update of the update record is "Aggregate" determine repeats the processing of step S _14, S ₁₅ to update the record of "aggregate" is read. When the update record "Aggregate" is read, it is determined whether there is a summary records matching the summary record or top keywords that match the upper code record keyword of the update records in the next step S _16, there if in the process of step S _17, a record keyword same record keywords and of the summary records, the file keyword and data word file keyword of the update record, the same as the data word, and the contents of the update to the "aggregate" Create a new upper-level summary update record. Hereinafter, in step S _18, the update memory 1
It is determined whether the detection of the presence / absence of the tally record by comparing the record keywords has been completed for each record in one file in the B area of FIG. 7, and the above steps S ₁₆ , S ₁₇ , S ₁₇ Step ₁₈ is repeated. After completed for all records, the processing for all the update records in the A region of the update memory 17 in step S ₁₉ is judged whether or not finished, the processing of the step S ₁₄ If not completed Returning, the next update record is read, and the above-described processing is executed. In step S ₁₉ after the processing for all of the updated records it has been determined to be ended, at the next step S _20, to sort the new host collection updated records created in its record keyword order, the same record keywords The record aggregates the data of the data words into one record. And in the next step S _21, to merge so that the updated records and host collection update records of the A area in the record keyword order. Then, in the process of step S _22, compares the record keyword of the record of the A region and the B region of the update memory 17 sequentially, in accordance with the content of the update records in area B corresponding to the updated record of the A area update I do. The updated record or the record not to be updated in the B area is written in the C area in the update memory 17 in the order of the keywords,
When all the update processes in the area and the area B are completed, the updated record held in the area C of the update memory 17 is written to a new storage area of the file memory 20. Thereafter, it is determined whether or not it is completed to update processing of the update records for all files keywords stored in the update record memory 19 in step S _23, the remaining file keywords returns to step S ₁₂ If not completed Update processing for the update record for. Hereinafter, when the processing for all the update records in the update record memory 19 is performed by the above-described processing of each step, the file update processing ends.

Update processing will be described in accordance with the updated contents of the update records in the step S _22. If the content of the update is “addition”, a record consisting of the record keyword and the data word of this update record is stored in the file memory 20.
Are inserted into the records in the area B read out from the record keywords in the order of the record keywords. In the case of “delete”, the record in the B area that matches the record keyword of the update record is deleted. If the content of the update is “total”, B that matches the record keyword of the update record
Among the data words of the records in the area, the data indicated by the data word of the updated record is added to the corresponding word and totaled. If the data of the data word of the update record is negative, the data is subtracted and counted. If there is an update record of “total” in the update record memory 19, the update record is counted to a record that matches the record keyword in the file memory 20, and is automatically added to the count record preset in the file memory 20. Are tallied. When the content of the update is “correction”, among the words of the record in the B area that match the record keyword of the update record,
The word corresponding to the data word of the update record is corrected to the word data indicated by the data word of the update record.

In the above embodiment, a record keyword delimiter code is specially provided to distinguish a record keyword from a data word in a record. However, the record keyword delimiter code may not be necessary. In this case, the number of record keywords is stored in association with the file keyword, and the storage format of the file in the file memory 16 is as follows. That is, first, the file delimiter code [[] is stored, then the file keyword is the number of record keywords before or after this file keyword, and hereafter, each word is the word delimiter code starting with the record delimiter code "(". It is stored by being divided by ".".
The record keywords are the number of words indicated by the number of record keywords from the beginning of each record indicated by the record separation code. Therefore, a processing device such as a file processing device is configured to detect the head of each record by using a record delimiter code, and detect a record keyword by detecting the number of word delimiter codes indicated by the number of record keywords. In this example, the number of record keywords is stored before or after the file keyword in the file, but each file keyword and the number of record keywords of each file may be stored as a correspondence table. Further, if the number of record keywords in each file is the same, the number of record keywords may be stored collectively, or the processing device itself may use the specified number of words from the beginning of the record as record keywords without special storage. A process to be considered may be incorporated.

In the embodiment, the data of each record in the file has been described as variable-length data. However, the data may be fixed-length data. Good.

[Effect of the Invention] As described above, according to the present invention, if the upper code or upper word of the record keyword of the record to be tabulated is set in the file storage means in advance as the record keyword of the tabulated record, Since the tabulation record is automatically tabulated in the processing, any record in the file can be tabulated without creating various original programs for outputting the book table as in the related art.

[Brief description of the drawings]

1 to 6 are views showing an embodiment of the present invention. FIG. 1 is an overall configuration diagram of a data processing device, and FIG.
(B) and (c) are diagrams of storage states of files in the file memory 20, FIG. 3 is a diagram for explaining a code system, FIG. 4 is a diagram for explaining the operation of the input processing device 12, and FIG. FIG. 6 is a flowchart for explaining the operation of the record generation device 13, and FIG. 6 is a flowchart for explaining the operation of the file update processing device 14. 12 ... input processing device, 13 ... update record generation device, 14
…… File update processing device, 20 …… File memory.

Claims (4)

(57) [Claims] 1. File storage means for storing a plurality of records composed of record keywords and data words, and a record keyword indicating a total record and a total record composed of data words obtained by totaling a plurality of records. A record storage unit for storing a record composed of a record keyword and a data word; a counting unit for counting the records stored in the record storage unit into records in the file storage unit having the same record keyword; If there is a record keyword indicating a higher-order aggregation record of the records stored in the storage device, a higher-order aggregation unit that generates the upper-order aggregation record and aggregates the data into a corresponding data word. 2. The data processing apparatus according to claim 1, wherein the record keyword indicating the higher-order aggregation record has a special code added after the upper digit code of the record keyword. 3. The data processing apparatus according to claim 1, wherein the record keyword indicating the higher-order aggregation record is configured such that a lower word of the record keyword is an empty word. 4. The data processing apparatus according to claim 1, wherein a record in said record storage means includes a word indicating the content of the update, and said counting means counts based on a record indicating the content of the update.