JPH03257593A - Method and device for collection of data - Google Patents

Abstract

PURPOSE:To shorten the response time of a screen and to reduce the load applied to a computer by processing en block the totalization of data inputted via the screen by means of a totalizing data editing means, a totalizing data store means, and a means which totalizes data into a relation table. CONSTITUTION:A screen data store means 1 reads data out of a table contained in a magnetic disk and evolves these data into the data segments of a screen image and a table image in a main storage. A totalizing data editing means 2 edits the screen input data into the segments of the table image. A totalizing data store means 3 stores the data segments of the unupdated table image into a data totalization means 5 of the magnetic disk. Then the means 3 stores the updated table image into the means 5. A means 4 which totalizes data into a relation table reads the table image data out of the means 5 and then totalizes the data on the relation table to update the relation table. In such a constitution, the screen response time is shortened and the load is reduced to a computer.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to a data collection method by online data updating, and in particular, to reduce the time and computer load required for repeated aggregation processing for related tables. The present invention relates to a data collection method and apparatus that reduce the amount of data collected.

[Conventional technology]

Online data update processing updates tables interactively through the screen. Conventionally, the aggregation process for related tables was such that each time the table was updated with data input from a screen, the related tables were aggregated and updated (the related tables were not updated at the same time).

[Problem to be solved by the invention]

In the conventional data collection method described above, each update data is aggregated and updated in a related table each time, so the aggregation process is repeated as a large amount of update data is generated. This increases the reaction time of the screen and also increases the load on the computer.

An object of the present invention is to provide a data collection method that shortens interaction time and reduces the load on a computer by collectively performing aggregation processing by interactively updating data through a screen. be.

[Means to solve the problem]

The data collection method of the present invention stores online screen data, edits data for aggregation, stores data for aggregation,
It is characterized by aggregating data into related tables.

The data collection device of the present invention includes means for storing online screen data, means for editing data for aggregation, means for storing data for aggregation, and means for aggregating data into a related table. Features.

〔Example〕

Next, the present invention will be explained with reference to the drawings.

FIG. 1 is a flowchart showing one embodiment of the present invention. This data collection device includes a one-screen data storage means 1, a data storage means 3 for aggregation, and a data aggregation means 4 for data aggregation into related tables.
It consists of

The screen data storage means 1 reads data from a table (file) existing on a magnetic disk and develops it into a screen image data segment and a table image data segment on the main memory. The aggregation data editing means 2 edits the screen input data into data segments of a table image. The aggregation data storage means 3 stores the data segment of the table image before update into the data aggregation means 5 on the magnetic disk (if there is no data to be updated, the aggregation data storage means 3 can be omitted). Then, the updated table image data is stored in the data aggregation means 5. The data aggregation means 4 for relational tables reads the table image data from the data aggregation means 5 on the magnetic disk, performs aggregation operations on the data of the relational tables, and updates the relational tables.

Arrows 21 and 22 in FIG. 2 indicate the procedure for storing data in the screen data storage means 1, and arrows 23 indicate that the input data from the screen is edited by the totalizing data editing means 2 and stored in the table image area. Show the steps. An arrow 24 indicates a procedure for adding an ID according to the update format and storing it in the tabulation file 5 as a table image.

FIG. 3 illustrates a state in which table image data stored in a tally file is read and data in a related table is updated based on the update format.

〔Effect of the invention〕

As explained above, the present invention processes data input at once from a screen by subjecting the data input from the screen to aggregation data editing means, aggregation data storage means, and a data aggregation means to related tables. By employing the present invention, it is possible to speed up the screen response associated with the data aggregation process that was conventionally performed at any time, and to reduce the load on the computer.

[Brief explanation of drawings]

FIG. 1 is a block diagram of one embodiment of the present invention, FIG.
The figure is a diagram showing the operation of the same embodiment. DESCRIPTION OF SYMBOLS 1... Screen data storage means, 2... Data compilation means for aggregation, 3... Data storage means for aggregation, 4... Data aggregation means, 5... Data aggregation means.

Claims (1)

[Claims] 1. A data collection method characterized by storing online screen data, editing data for aggregation, storing data for aggregation, and aggregating the data in a related table. 2. A data collection device comprising means for storing online screen data, means for editing aggregation data, means for storing aggregation data, and means for aggregating data into a related table. .