JPH02257282A - Table preparation processor - Google Patents

Abstract

PURPOSE:To start the working processing of data at arbitrary time regardless of the amount of data targeted to be processed by recognizing the existence of row data required for working according to the content of row data existence information, and reading out the row data from a data file when no row data exists in a working file. CONSTITUTION:An existence information flag in row data managing information corresponding to designated row data is referred by an I/O control module 13, and it is judged whether or not the row data is stored in the working file 17. When the existence information flag shows (0), i.e. when no row data is stored in the working file 17, corresponding row data is read out from the data file 14 by a data file input module 15. In such a way, data working can be performed even when all of the data targeted to be processed are not stored in the working file 17, and the processing of data working can be started at the arbitrary time.

Description

[Detailed Description of the Invention] [Object of the Invention] (Industrial Application Field) The present invention relates to a tabulation processing device, and particularly to a tabulation processing device that divides data to be processed into column data and row data, and divides the data to be processed into column data and row data. The present invention relates to a tabulation processing device that performs processing.

(Prior Art) Generally, in table creation processing provided by distributed processing computers, office computers, personal computers, etc., data to be processed is segmented into column data and row data, and data processing is performed. When such data to be processed is applied to a general file, the column data corresponds to a record of the general file, and the column data corresponds to a field within the record.

When processing data for tabulation processing, the data to be processed is first read out in units of row data and stored in a work file. Then, necessary row data is extracted from the processing target data stored in the work file, and specific data processing for table creation is performed.

As described above, in the past, necessary data processing could only be performed after all data to be processed had been stored in a work file. For this reason, when there is a large amount of data to be processed, it takes a long time to store the data in a work file, resulting in a delay in the start of data processing. Furthermore, since the starting point at which processing can be performed differs depending on the amount of data to be processed, there is also the drawback that it is difficult for users to operate.

(Problems to be Solved by the Invention) This invention was made in view of the above-mentioned circumstances, and it improves the point that conventionally data processing could not be performed until the data to be processed is stored in a work file. An object of the present invention is to provide a tabulation processing device that can start processing data at any time regardless of the amount of data.

[Structure of the Invention] (Means for Solving the Problems) The present invention provides a tabulation processing device that divides data to be processed into column data and row data and performs data processing for tabulation processing. A data file in which target data is stored as 5, a work file that temporarily stores data for data processing of the processing target data, and a data file for each row of data in the processing target data that is stored in the processing target data. a memory means for storing row data location information indicating whether or not the row data is stored in a file; a data specifying means for designating row data to be data processed from among the processing pair data; It is determined whether or not the line data specified by the data specifying means is stored in the work file by referring to the information, and if the specified line data is stored in the work file, the line data is data retrieval means for reading the row data from the work file, and reading the row data from the data file when it is not stored in the work file, and storing the read row data in the work file; The method is characterized by comprising a location information updating means for updating the row data location information corresponding to the stored row data when data is stored in the work file.

(Operation) In this tabulation processing device, the location of line data necessary for processing can be recognized according to the contents of the line data location information, and if the line data is not in the work file, the line data is read from the data file. Therefore, data processing can be performed even if all the data to be processed is not stored in the work file, and data processing can be started at any time.

(Example) Hereinafter, the present invention will be described in detail with reference to the drawings.

FIG. 1 shows a table processing device according to an embodiment of the present invention. The data processing module 11 performs various data processing for tabulation processing, and is connected to the row data I10 module 12. This row data I10 module 12 is connected to the I10 control module 18, and receives a command to read the row data output from the data processing module 11 from the I10.
0 control module 13. The I10 control module 13 is connected to the memory 18, the data file input module 15, and the work file I10 module 1B, and according to the row data management information registered in the memory 18, the data file input module 15 or the work file I10 module Access 1B. The data file input module 15 accesses the data file 14 under the control of the (10) control module 13 and reads data stored in the file 14 line by line. Further, the work file I10 module 1B accesses the work file 17 and writes and reads line data to and from the work file 17 under the control of the I10 control module 13.

The row data management information stored in the memory 18 is provided for each row of data in the data to be processed stored in the pig file 14, and has a format as shown in FIG. That is, each line data management information includes information indicating the line number of the corresponding line data, chain information indicating the next line and previous line of the line data, address information indicating the address within the data file 14, and work file 1.
7, address information indicating the storage position in the work file 17, and type information indicating the attributes of the line data.

The location information flag indicates that the corresponding line data is work file 1.
When the data is not stored in the work file 17, it becomes "0", and when it is stored in the work file 17, it becomes "1".

Next, the row data reading operation of the tabulation processing apparatus shown in FIG. 1 will be explained with reference to the flowchart in FIG. First, a command to retrieve the line data to be processed, that is, the line data to be displayed on the screen or calculated, is output from the data processing module 11 (step Sl). In this case, line data is specified by line number. Next, the location information flag in the row data management information corresponding to the specified row data! 10 is referenced by the control module 13 (step S2), and it is determined whether the row data is stored in the work file 17 (step S2).
3). When the location information flag is "1", that is, when the line data is stored in the work file 17, the corresponding line data is read out from the work file 17 by the work file I module 16 (step S4).

On the other hand, if the location information flag is "0", that is, if the line data is not stored in the work file 17, the data file input module 15 reads the corresponding line data from the data file 14 (step S5).
. Then, the read line data is the work file I1
0 module 1B stores it in the work file 17, and the location information flag in the row management information corresponding to the row data is changed from "0" to "1" (step S
6).

Next, the data processing module 11 performs predetermined data processing on the line data read in step S4 or S5, and the processed data is stored in the work file 17 (step S7).

In this way, in this tabulation processing device, it can be determined whether or not the line data necessary for processing is stored in the work file 17 by referring to the contents of the location information flag, and If it does not exist, data can be read from the data file 14. Therefore, data processing can be performed even if all the data to be processed is not stored in the work file 17, and data processing can be started at any time.

[Effects of the Invention] As described above, the present invention provides a tabulation processing device that can start data processing at any time regardless of the amount of data to be processed.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing a tabulation processing device according to an embodiment of the present invention, FIG. 2 is a diagram showing a data format of row data management information used in the tabulation processing device shown in FIG. 1, Third
This figure is a flowchart explaining the operation of the tabulation processing device shown in FIG. 1. 11... Data processing module, 12... Row data I10 module, 13... I10 control module,
14...Data file, 15...Data file input module, IB...Work file I10 module, 17...Work file, 18...Memory. Applicant's agent Patent attorney Takehiko Suzue

Claims (1)

[Scope of Claim] A tabulation processing device that processes data for tabulation processing by dividing processing target data into column data and row data, comprising: a data file in which the processing target data is stored; A work file that temporarily stores data for data processing of the processing target data, and row data location information indicating for each row data in the processing target data whether or not the row data is stored in the work file. a memory means for storing data, a data specifying means for specifying row data to be processed from among the processing target data, and a data specifying means for specifying row data to be processed by the data specifying means with reference to the row data location information. is stored in the work file, and if the specified row data is stored in the work file, read that row data from the work file, and if it is not stored in the work file. a data retrieval means for reading the row data from the data file and storing the read row data in the work file; and when the row data is stored in the work file by the data retrieval means, the stored row data is A tabulation processing device comprising: location information updating means for updating the row data location information corresponding to row data.