JP3047400B2 - Data processing device - Google Patents

Description

Description: TECHNICAL FIELD The present invention relates to a data processing device having a plurality of files.

2. Description of the Related Art In general, a system in a data processing apparatus such as an office computer is provided with various files having different record configurations for each file. Record data stored in these files is appropriately selected and read out. It can be used for book output, data search, etc.
It is well known that in order to be able to operate these systems in response to a request of a user (for example, a company that has introduced the above-described data processing system), a system design corresponding to the request is necessary. is there.

[Problem to be Solved by the Invention] Usually, such a system design consumes a great deal of time and money, and the performance of the entire system is limited by the ability of a system designer (generally, a system engineer). There was a problem of being affected. For example, when designing for outputting a predetermined book table according to a user's request, the designer first needs to create an output record required for the book table. In order to create this output record, how many source files in the device are required, which records in which source files are to be extracted, and which words of those records are classified as keywords, It is necessary to carry out a task of determining in advance whether to create a program, and then to move to a task of designing a processing program according to the task. In this work, especially when dealing with a plurality of source files, since the record configuration of each file is different, designing a processing program in consideration of such a record was very complicated and difficult.

It is an object of the present invention to automatically generate a record including necessary output keywords and output data words for various files having different aggregation levels, and to immediately output the generated record. .

Means for Solving the Problems According to the present invention, at least a first file storing a plurality of records including data words divided by a predetermined keyword, and a first file divided by a keyword of a higher order key than the keyword, A file storing means for storing a plurality of aggregation records including data words obtained by aggregating the contents of the words with the upper key, a plurality of output keywords of the output records and a plurality of output data words of the output record, Table storage means for storing a word correspondence table in which keywords and data words of records in one file and keywords and data words of total records in the second file are associated with each other; The first file and the second file are specified by the Record generation means for generating a record composed of the output keyword and output data word of the output record based on the storage content of the record, and output control means for outputting each record generated by the record generation means It is characterized by having done.

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

FIG. 1 shows an overall system configuration diagram of the data processing apparatus. In FIG. 1, reference numeral 11 denotes an input device for inputting slip data and the like, and includes, for example, a designation key for designating various designated data in advance, a numeric keypad for inputting data, a function key, and the like. This input device 11
Is connected to an input record processing device 12, and the input record processing device 12 stores data input from the input device 11 in the input record memory 13 as an input record.
When the input device 11 instructs the end of a series of data input (for example, the end of data input for one slip), the input record processing device 12 determines this, and the file processing device
14 is given a processing start command. File processing device 14
Sequentially reads the input records (records for updating) stored in the input record memory 13 in response to the processing start command, and updates a previously designated file in the file memory 15 based on the input records. .
The file memory 15 includes a plurality of files having different record structures, for example, a product management file having a record structure in which a keyword is “product code” and data words are “money” and “quantity”, and a keyword is “product code” and “product code”. It has a merchandise tendency management file which has a record structure of “money amount” and “number” in “business partner” and data words. The file memory 15 is connected to an output record processing device 16. The output record processing device 16 starts processing according to the output instruction given from the input device 11, and records the records in the corresponding file in the file memory 15 according to the specified contents for output record creation specified in advance in the output record specifying memory 17 as the source record. And creates an output record having a record structure in accordance with the designated content, and stores the output record in the output record memory 18. Output record specification memory
If the content specified in 17 is the specified content for creating an update record, each output record stored in the output record memory 18 is used as a source record, and an update record is created according to the specified content, Input record memory 13
To memorize. The output record stored in the output record memory 18 is read out to the output processing device 19 which starts processing in accordance with an output instruction from the input device 11, and the output format of the book table specified in the output format designation memory 20 in advance. Output device converted to book table output format according to the specified contents
Output to 21. The output device 21 displays or prints out the book based on the output format data from the output processing device 19.

The output record specification memory 17 stores a plurality of sets of specification contents for creating an output record, specifies a file name of a file to be read, specifies a record extraction condition,
The correspondence between the keyword and data word of the output record and the word of the record extracted from the file is specified. This designation is made by the input device 11
This is performed according to the designated data from.

The output format specification memory 20 is an output record processing device.
The designated data is stored by the input device 11 for converting the output record processed by the step 16 into a format of a predetermined output format.

 Next, the operation of this embodiment will be described.

FIG. 2 is an explanatory diagram for explaining a change state of a record based on a processing process. The contents of an input record memory 13, a file memory 15, and an output record memory 18 and the contents of designated data of an output record designation memory 17 are shown. Is shown.

Word data input from the input device 11 is sequentially written into the input record memory 13 while being separated into a record discrimination code "(", a word delimiter code ".", And a keyword delimiter code ".". What is a record?
A word indicating “file update contents and target file name” indicated by a word such as “ ₁ ” or “dF ₂ ”;
A word indicating “product code” indicated by a word such as “11” or “1211”, a word indicating “customer” indicated by “B company” or “A company”, and “m ₁ ” or “m” ₂₎ and a word indicating “number” indicated by “n ₁ ” or “n ₂ ”, and each record includes the number of words included in the record and The variable length record has an undefined word length. Further, the “file update content” is any of “addition”, “deletion”, “correction” and “total”, “addition” is a code “a”, and “deletion” is a code “b”. In the code, "Correction" is the code "c" and "Total" is "d"
Is indicated by the code Therefore, for example, since the first record in the input record memory 13 is “(dF ₁ .1111.m ₁ .n ₁₎ , this record has data words“ m ₁ ”and“ n ₁ ”and a keyword (product code). ) Indicates that the file F ₁ (product management file) is to be “totaled” by the record “1111.” The second record is “(d
F _2. 1111. Company B.m ₁ . Since n ₁ "is, this record file F ₂ (trade propensity managed by a record of" Company B "data word is the keyword in the" m ₁ "and" n ₁ "(product code and the customer) is the" 1111 " File) is updated.

Each record stored in the input record memory 13 in this way is read by the file processing device 14 and updates the target file in the file memory 15. The two files shown in the file memory 15 shown in FIG. 2 show the contents of the file to be updated specified by each record stored in the input record memory 13. That is, the record structure of the file F ₁ are indicated by the word No. keywords is "01", the data word represented by the word No. "11" and "12". Here, the word No. of “01”
Indicates "product code" and the word number "11" is "money"
The word number “12” indicates “number”. On the other hand, the record structure of the file F ₂ keyword is indicated by the word No. "01" and "02", the data word represented by the word No. "11" and "12". Here, the word No. of “01” and the word No. of “02” indicate “product code” and “business partner”, and the word No. of “11” and the word No. of “12” indicate “money” and "Number" is shown. By the way, in the file F ₁ , the record having the keyword “1 *” is the data of the record in which the first digit of the product code as the keyword is “1” among the records for updating the input file F _1. This indicates that the record is a totaled word, and the record with “11 *” as the keyword is the first and second digits of the product code that is the keyword among the input update records. Is "11" (in this case, indicates a clock), indicating that the data words of the common record are totaled. That is, there is a relationship of (M ₁ = M ₂ + M ₃ ) and (N ₁ = N ₂ + N ₃ ). Similarly, it records a keyword only "1111" in the file F _2, among the records in the file F ₂ updates that are input, records the first keyword No. "01" is common to "1111" Indicates that the record is a record in which the data words of the above are aggregated. That is, (M ₂ = M ₅₀ + M ₅₁
+ M ₅₂ ) and (N ₂ = N ₅₀ + N ₅₁ + N ₅₂ ).

When the record structure is different for each file as described above, a book table as shown in FIG. 3 is created using these two files. When creating such a book table, the output record specification memory 17 has the second
Specify the contents as shown in the figure.

That is, the output record specification memory 17 first specifies how to read the data in the file F1 as the _{first specification} content. Here, “A”, “*”, “01”, “02”, “11”, and “12” shown on the left side of the setting content indicate the file name, record condition, keyword No. and data word No. The file name “F ₁ ” and the first keyword No. “01.
2 ", the second keyword No." 01 "and the first data word N
o. Designate "11" and the second data word No. "12". This specification has the following meaning. That is, the file to be read target record is a file F _1, record extraction conditions at this time no. Then the file F upper 2 digits of the keywords No. "01" of the file record in the ₁ corresponds to the first keyword No. "01" of the output record, keywords No. "0 file record in the file F ₁
1 "remaining digit (lower two digits) of the first keyword No. output record""corresponding to the data word No. of the file record in the file F _1" 02 second "and" 11 12 "and the output record One data word No. "11" and the second data word No. "1"
2 ".

The likewise output record memory 17 to specify how the read data in the file F ₂ as the second specified contents as shown in Figure 2. That is, the file to be read target record is a file F _2, record extraction condition at this time is the second keyword in the file record in the file F ₂ "0" other than the record, that is, the second keyword is specified Indicates that only records are to be extracted. The first keyword No. File Records in the file F ₂ "01" first keyword No. upper 2 digits output record "01" corresponding to the first keyword No. File Records in the file F ₂ " 01 "the last two digits of the second keyword No. of output record" corresponds to 02 ", the second keyword N of the file record in the file F ₂
o. "02" corresponds to the third keyword No. "03" of the output record, the first data word of the data word No. "11" and "12" and an output record in the file record in the file F ₂ No. "11" and the second data word No. "12".

In this way, the 2 designated in the output record designation memory 17
The specified contents of the set are read by the output record processing device 16, and based on the specified contents, records in the read target file are extracted and output records are generated.
FIG. 4 is a flowchart showing the contents of this processing.

That is, the output record processing apparatus 16 starts the process based on the flowchart shown in FIG. 4 given the output instruction from the input device 11, first, the specified output records created in the output record designation memory 17 at step S ₁ is formed It is determined whether or not it has been performed. In this case, the file F1 is specified as the _first specification.
The procedure proceeds to S _2, read target file (now of the case file F ₁₎
Performs a designation of reading out the first record in the file (Step S _3). Next, it is checked whether or not the record matches the specified record condition (step S ₄ ). However, since no record condition is specified in the first specification, it is determined that the record matches and the step S _{5 is performed.} Proceed to. Generation processing of output record based on the specified content is performed in step S _5. However,
In this generation process, if the read record is a record that cannot be an output record generation target, the output record generation process is not performed. For now, file F ₁
Is the first read record of "(1 * .M.N)", and the upper two digits of the keyword No. "01" of this record do not exist, and the lower two digits of the keyword No. "01" do not exist. Therefore, the first keyword No. “01” and the second keyword No. “02” of the output record cannot be specified from the read record, and the output record cannot be generated, so in this case, the output record generation process is performed. without, in. step S ₆ which moves to step S _6, whether the file record of unread exists in read target file is examined. If now, in step S ₇ since the second record is present Then, this record is read out,
Returns to step S _4, the same processing as described above is repeated.
The second record in the file F ₁ is “(11 * .M ₁ .N ₁ )
Since it is, in step S _5, since there is key data "11" corresponding to the first keyword No. "01" of the output record, the generation of the output records is performed. In this case, there is no data corresponding to the second keyword No. “02” and the third keyword No. “03” of the output record, and the first data word No. “11” and the second data word No. “12” An output record having the corresponding data “M ₁ ” and “N ₁ ” as data words is created, and the created output record is stored in the output record memory 18. Then, in step S ₇ is the third record in the file F ₁ is read. 3
Since th record is "(1111.M ₂ .N _2", the first keyword No. "0 output record in step S ₅
Since key data “11” and “11” corresponding to “1” and the second keyword No. “02” exist, an output record is generated. In this case, the third keyword in the output record
There is no data corresponding to No. "03" and the first data word N
o. An output record having data words “M ₂ ” and “N ₂ ” corresponding to “11” and the second data word No. “12” is created, and this output record is stored in the output record memory 18. You. Following a similar manner each record in the file F ₁ is read sequentially, is sequentially stored is converted to an output record in the output record memory 18. When reading of all records in the target file is completed,
Proceeds to step S ₈ next to S _6, the output record designation memory
It is determined whether or not the specified content for creating an updated record is specified in 17. The designated contents for creating an update record are designated contents for converting an output record created and stored in the output record memory 18 as a source record into an update record stored in the input record memory 13 described above. In this case, which file in the file memory 15 is to be updated and how to update the file are specified. Although stores the created record by performing processing for creating the update record moves to step S ₉ if there is the specified in the output record memory 17 in the input record memory 13, step S ₁ since the designation is not the present case To determine whether there is another specification for creating an output record. In the present case, the second specified contents to the file F ₂ because there specify the file F _2, sequentially performs generation processing of sequentially reading the records in the file output record based on the specified content. The reading is completed for all records in the file F _2, the process of generating the corresponding output record is completed, the process returns from step S ₈ to S _1, further whether there is another specified output record in a specified memory 17 Judge. In this manner, the various designation contents for each file designated in the output record designation memory 17 are sequentially read out each time the processing based on the designation contents is completed, and are continuously processed. In the present case, since the output record in a specified memory 17 not performed third specified, proceeds to step S _10, the output records sequentially stored output record in the memory 18 (in this memory 18, the file and an output records created by the record in the output record created file F ₂ by records in the F ₁ are mixed), thereby terminating the process are sorted in ascending order of keyword. The contents of the output record memory 18 in FIG. 2 show the contents obtained by sorting the output records.

The output records in the order of keywords stored in the output record memory 18 in this manner are read by the output processing device 19, and are output by the output device 21 together with a ruled line form indicating a book table or the like based on the designated data in the output format designation memory 20. Displayed or printed out. Hereinafter, the output processing of the book table and the like will be described.

FIG. 5 is a view showing an example of designated data in the output format designation memory 28. Here, the renit indicates a unit in which the output records are hierarchically classified according to the weight of the keyword (the number of words of the keyword). "Renit 1" has a record key consisting of only the first keyword No. "01". "Renit 2" refers to an output record whose record key is composed of a first keyword No. "01" and a second keyword No. "02", and Renit 3 is a first, second and third keyword No. “01”, “02” and “03” all keyword No.
An output record consisting of Then, an output word No. and a ruled line are designated corresponding to the output record of each unit. The ruled line indicates the starting point or 1 / page of the printed page.
Shown by X and Y coordinates corresponding to the screen, the length is shown by the length in the X direction (right direction) and the Y direction (downward) from the starting point, and the line type corresponds to the four sides determined by the starting point and the length do it,
Specify each of the upper, lower, left, and right sides. As the line type, “0” is not printed, “1” is a thick line, “2” is a medium thick line, “3” is a thin line, “4” is a dotted line, “5” is a dashed line,. Specify an edge. For example, line type (101
0) specifies that the upper side is a thick line, the lower side is not output, the left side is a thick line, and the right side is not output. Explaining the example of the designated data shown in FIG. 5, the ruled line of the output record of the unit 1 is the starting point (X ₁₁ , Y ₁₁ ) corresponding to the output of the word data of the word number “01” of the output record. Length (l
₁₁ , m ₁₁ ) Output the top and left sides as bold lines at the position determined by
The output in the state shown in FIG. Furthermore, the word
No. "11" corresponds to the output of the word data of the start point (X _12, Y
₁₂ ) and the length determined by the length (l ₁₂ , m ₁₂ )
When the left side is output as a thin line and combined with the output of the word No. "01", the output in the state shown in FIG. Similarly, based on the specified data of each unit, FIG.
The output state shown in (k) is designated. The word data output together with the ruled line is the word data of the designated word number in the output format designation memory 20.
8 is read from the output record, and the output position of the read word data is specified corresponding to the specified data of the ruled line of each word (not shown). In particular, when the word data is characters, the output position is specified based on the upper digit of the character string, and when the data is numeric, the output position is specified based on the lower digit of the numerical string.

Next, the processing operation of the output processing device 19 will be described with reference to the flowchart of FIG. In Step C _1, the word data and border header portion which is previously specified by the output format designated memory 20 (not shown) is printed as shown in FIG. (A). Next, in the process step C _2, reads the beginning of the output record from the output record memory 18, a further step C _3, reads out the designated data Renitto corresponding to Renitto of the output record from the output format designated memory 20, The word data of the output record specified by each word No. of the specified data is created for one record together with the ruled line corresponding to each word No. and output to the output device 21. The printing state in this case is shown in FIG. As shown in the figure, the word data of the word numbers "01", "11" and "12" of the first record in the output record memory 18 of FIG. 2 are printed together with the ruled lines. Below output record memory
Steps described above until all output records in 18 are output
The processing of C ₂ and C ₃ is repeated, and printing is performed as shown in FIGS. 6 (c) and 6 (d). Step C _4, when there is no output record is detected, underlined Step C ₅ is a length corresponding to the lateral border of the Renitto 1, is printed on a thick line in accordance with the line type of Renitto 1. In specifying the printing position of the ruled line in the output format memory 20, Y coordinates of the starting point need only have specified as a reference value the output position of the first record, thereafter the processing at step C _3, record Each time is output for one line, the Y coordinate of the reference value is set to one line of Y
The value is sequentially updated by the length in the direction, and the updated value is used as the Y coordinate of each word. Further, when outputting to the next page, the Y coordinate is returned to the reference value, and thereafter every time one line is printed, the Y coordinate is updated in the same manner as described above. In the same manner, the print position of the data need only be specified by using the output position of the first record as the reference value.

In the above embodiment, the words included in each record are expressed as a word delimiter code "." And a keyword delimiter code ".", But only one type of word delimiter code (for example, ".") Is used. In this case, the number of keywords in one record in each file may be separately specified, or the number of keywords may be fixed to all files.

[Effects of the Invention] According to the present invention, a word correspondence table in which the word structure of a record of a file storing various real records is associated with the word structure of a predetermined output record for each file having various aggregation levels in advance. By storing and preparing, when a record using the output keyword and the data word of the output record is required, the first file and the second file are immediately specified based on the storage contents of the word correspondence table. Therefore, a record consisting of the output keyword and the output data word of the output record is automatically generated based on the actual storage contents of each record in each file. The output keyword and data word of the output record based on the stored contents Can be output to

In the present invention, such a word correspondence table, that is, a table having a correspondence between the word configuration of the output record and the word configuration of the records of various files having different aggregation levels is adopted, so that the output keyword of the output record is Records consisting of output data words are the same output keywords, the same output data words, but different aggregation levels (this is the aggregation level of each file that stores the record from which the record was generated) Are different) can be output immediately.

[Brief description of the drawings]

1 to 6 show an embodiment of the present invention. FIG. 1 is a diagram showing the overall system configuration of a data processing apparatus, and FIG. 2 is a view for explaining a change state of a record based on a processing process. FIG. 3 is a diagram showing an example of an output book table, FIG.
FIG. 5 is a flowchart for explaining an output record generation process. FIG. 5 is a diagram showing the contents of designation in the output format designation memory 20, and FIGS. 5A to 7K are diagrams showing output forms of designated data. FIG. 6 is a flowchart showing the output processing operation of the output processing device 19, and FIGS. 6A to 6D show the printing state. 15 ... File memory, 16 ... Output record processing device,
17 ... Output record designation memory, 18 ... Output record memory, 19 ... Output processing device.

Claims (1)

(57) [Claims] 1. A first file storing at least a plurality of records including data words classified by a predetermined keyword, and a first file classified by a keyword having a higher order key than the keyword, and the contents of the data word being classified by the higher order key. File storage means for storing a plurality of aggregated records including the aggregated data words; and a plurality of output keywords and a plurality of output data words of the output record, and a keyword of the record in the first file. A table storage means for storing a data word and a word correspondence table corresponding to a keyword and a data word of a tally record in the second file; and the first memory based on the storage contents of the word correspondence table.
A record generation unit for specifying a file and a second file, and generating a record including an output keyword and an output data word of the output record based on the storage content of each record in each file; Output control means for outputting each generated record; and a data processing device comprising: