JPH0573621A - Time series data processing system - Google Patents

Abstract

PURPOSE:To efficiently execute a processing for statistics, which designates plural periods as to time series data on plural files. CONSTITUTION:A time series data management part 3 classifies time series data stored in plural input files by individual data types and generates data files 4. At that time, management data having the time of initial data and the time of final data are written into a management file 5 with the medium types designated by the individual data types, a volume name and a file name. When the data type and the period are designated, a data retrieval processing part 6 retrieves the concerned data file 4 from the management file 5 and extracts data in the period of the data file 4.

Description

Detailed Description of the Invention

[0001]

The present invention relates to a time series data processing system,
In particular, it relates to a series data processing method for processing data stored in time series in each of a plurality of files.

[0002]

2. Description of the Related Art Conventionally, this type of time-series data processing method uses data of a plurality of files to be processed as date / time data.
After the time data is used as a key for sorting and merging into one file, data processing such as searching is executed.

[0003]

According to the conventional time series data processing method described above, a plurality of files containing time series data of a period to be processed are sorted and merged into one file. There is a problem that the processing procedure becomes complicated as the number increases.
To input the period to be processed as a parameter and to process at multiple different periods, it is necessary to execute the process of extracting only the target data from the file for the number of parameters. Number of periods,
There is a drawback that the processing time increases with the amount of data.

[0004]

The time series data processing method of the present invention is a time series data processing method for processing data stored in time series in each of a plurality of input files. Generates a data file that classifies the time-series data of the specified input file for each data type, and generates the data type, recording medium type, volume name, file name, time of the first data, and last data of each generated data file. A time-series data management unit that outputs management data including time, a management file that writes the management data output from the time-series data management unit, and a management file corresponding to the data type and the period specified. Search the management data to be read and read the time series data for the specified period from the data file indicated by the searched management data. It constituted by having a data search processing means.

[0005]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram of an embodiment of the present invention.
In the embodiment of FIG. 1, the time-series data management unit 3 includes a plurality of input files 1 and operation consoles 2 that record time-series data.
The parameters of the storage medium type and volume name of the data file 4 output from are read, the time-series data is classified by the data type, and output to the data file 4. Also, based on the output time-series data, management data of the data file is generated and output to the management file 5. The data search processing unit 6 reads the data type and parameters (period) input from the console 2, searches the management data on the management file 5 on the condition of the specified data type and parameter,
Find the data file that matches the conditions from the management data and read the corresponding data file.

FIG. 2 is a format diagram of the record of the input file 1 of FIG. 1, and the data type shows the type of time series data. Each of the input files 1 is a set of data recorded in ascending order using the date and time given to each record as a key, and forms a sequential file.

FIG. 3 is a format diagram of the management file 5 of FIG.
Data for centrally managing the time series data is written in a table format. A data file that is a set of time series data for each type, including the data type, storage medium type, volume name, file name, first data time, and last data time in each item of one line of the management file 5 to manage.

FIG. 4 is a flow chart of processing of the time series data management unit 3 of FIG. Referring to FIG. 4, the time series data management unit 3
The processing of the time series data management unit 3
First, the time series data is read from the input file 1 and the storage medium type and volume name of the data file that outputs the time series data from the console are read as parameters (step 101). Next, the read time-series data is classified by data type, and a data file is generated and output on the designated volume (step 102). At this time, in order to manage the time-series data on the data file, the times of the first record and the last record are stored for each data type unit, and when the processing of the input file 1 is completed, the data type of the output data file 4 is output. , Medium type, volume name, and file name are added to generate management data (step 10
3), output to the management file 5 (step 104).

FIG. 5 is a flow chart of processing of the data search processing unit 6 of FIG. To explain the processing of the data detection processing unit 6 with reference to FIG. 5, the data detection processing unit 6 first reads from the operator console 2 the data type and the period to be subjected to the data processing as parameters (step 201), The management data of the management file 5 is searched using this parameter as the search condition, and the medium type, volume name, and file name, which are the information for accessing the data file 4 that is the target of the data processing, are calculated from the management data with the matching parameters. The data file is extracted (step 202) and the data file is opened (step 203). The open data file 4 is read and the time-series data of the period designated by the parameter is extracted (step 204).

[0011]

As described above, the present invention is required by generating a data file for each data type and a management file for managing this data file from an input file storing a plurality of time series data. The time series data processing of the period and the data type to be performed can be easily executed only by inputting the parameter from the operator console, and the operation procedure can be greatly simplified. Further, there is an effect that the time required for the conventional data sort / merge processing and the time required for the extraction processing of the corresponding data can be shortened and efficient data processing can be performed.

[Brief description of drawings]

FIG. 1 is a configuration diagram of an embodiment of the present invention.

FIG. 2 is a format diagram of a record of the input file shown in FIG.

FIG. 3 is a format diagram of a management file shown in FIG.

FIG. 4 is a flowchart of processing of a time series data management unit of FIG.

5 is a flow chart of processing of a data search processing unit in FIG.

[Explanation of symbols]

 1 input file 2 operation console 3 time series data management unit 4 data file 5 management file 6 data search processing unit

Claims (1)

[Claims] 1. A time-series data processing method for processing data stored in time series in each of a plurality of input files, in which a time-series data of an input file is classified by a data type by specifying a recording medium type and a volume name. Time-series data management means for generating the generated data file and outputting management data including the data type, the recording medium type, the volume name, the file name, the time of the first data, and the time of the last data for each generated data file. And a management file in which the management data output from this time series data management means is written, and a corresponding management data is searched from the management file in response to designation of the data type and period, and the searched management data indicates And a data search processing means for reading time-series data of a specified period from the data file. Series data processing method.