JP6916708B2 - Data management system, server device, data utilization device, server program and data utilization program - Google Patents

Description

The present invention relates to a data management system, a server device, a data utilization device, a server program, and a data utilization program.

Patent Document 1, Patent Document 2 and Patent Document 3 describe a technique of dividing the data to be stored into a plurality of data and distributing and storing the plurality of data in a plurality of storage devices.

Japanese Unexamined Patent Publication No. 2000-1731178 Japanese Unexamined Patent Publication No. 2004-171207 International Publication No. 2001/046808

In a system that analyzes data using time-series data generated by a sensor device, if the location where the sensor device is installed and the location where the data is used are geographically different, or if the sensor devices are widely scattered, the sensor Collecting time-series data on devices is an issue. In a configuration where data collection is performed on a cloud platform and stored in storage on the cloud, geographical issues associated with data collection can be solved via the Internet, but there is a possibility of data leakage due to placing data in the cloud. Challenge arises.

As a method of strengthening confidentiality in data storage, there are a method of dividing data into units that do not make sense by itself and storing them in different storages, and a method of storing data in encrypted form. In the method of dividing data as in the techniques described in Patent Document 1, Patent Document 2, and Patent Document 3, it is necessary to acquire data from a plurality of storages when using the data, and the cost of using the plurality of storages is also high in storage. It takes. The method of encrypting data requires the management of encryption keys.

An object of the present invention is to store time-series data in a format out of temporal order so that it can be reconstructed at the time of use.

The data management system according to one aspect of the present invention is
A plurality of first data indicating the time and the first value obtained at the time are acquired, and for each of the acquired first data, the first value shown in the first data and the first value are obtained. Second data indicating a second value that is a value uniquely corresponding to the time shown in one data is generated, and the generated plurality of second data are the first one shown in each second data. A server device that stores the values in a storage area accessed from the outside by arranging them in a different order from the time when the values were obtained.
A plurality of second data arranged by the server device are acquired from the storage area, and the correspondence table, which is a table showing the correspondence between the time and the second value, is referred to, and for each acquired second data, the second data is obtained. 2 Obtained by the server device by specifying the time corresponding to the second value shown in the data and generating data indicating the specified time and the first value shown in the second data. It is provided with a data utilization device that restores a plurality of first data.

The server device according to one aspect of the present invention is
An acquisition processing unit that acquires a plurality of first data indicating a time and a first value that is a value obtained at that time.
For each of the first data acquired by the acquisition processing unit, a first value shown in the first data and a second value which is a value uniquely corresponding to the time shown in the first data are shown. A mixing processing unit that generates the second data and arranges the generated plurality of second data in an order different from the order of the time when the first value shown in each second data is obtained.
It includes a storage processing unit that stores a plurality of second data arranged by the mixing processing unit in a storage area accessed from the outside.

The acquisition processing unit acquires, as the first data, data indicating the time, the first value obtained at the time, and the device identifier that uniquely identifies the device that obtained the first value at the time. death,
The mixing processing unit uniquely corresponds to the set of the time and the device identifier shown in the first data as the second value shown in the second data for each of the first data acquired by the acquisition processing unit. Generate a value.

The storage processing unit stores a plurality of second data arranged by the mixing processing unit in a database constructed in the storage area.

The mixing processing unit calculates a hash value as a second value shown in the second data for each first data acquired by the acquisition processing unit.
The storage processing unit stores the time indicated in the plurality of first data acquired by the acquisition processing unit in the storage area in a form separated from the first value shown in each of the first data. Write.

The mixing processing unit decomposes the time shown in the first data into a time of the first unit and a time of the second unit for each first data acquired by the acquisition processing unit, and the first unit. The third data indicating the time of the above and the third value which is the hash value corresponding to the time of the second unit is generated, and the generated plurality of third data are used as the basis of the respective third data. 1 Arrange in a different order from the time shown in the data,
The storage processing unit stores a plurality of third data arranged by the mixing processing unit in the storage area.

The first unit is the year, and the second unit is the month, day, and day.

The data utilization device according to one aspect of the present invention is
An acquisition processing unit that acquires a plurality of second data indicating a first value and a second value that is a value uniquely corresponding to the time when the first value is obtained from an external storage area.
With reference to the correspondence table, which is a table showing the correspondence between the time and the second value, for each second data acquired by the acquisition processing unit, the time corresponding to the second value shown in the second data. It is provided with an output processing unit which specifies, generates first data indicating the specified time and the first value shown in the second data, and outputs a plurality of generated first data.

As the second value shown in each second data, the acquisition processing unit uniquely selects the time when the first value shown in each second data is obtained and the device which obtained the first value at that time. Gets the value that uniquely corresponds to the set of device identifiers to identify
The output processing unit refers to a table showing the correspondence between the set of time and device identifiers and the second value as the correspondence table, and for each of the second data acquired by the acquisition processing unit, the second data The set of time and device identifier corresponding to the second value shown in is specified, and the specified time and the specified device identifier are shown as the first data together with the first value shown in the second data. Generate data.

The acquisition processing unit stores a plurality of acquired second data in the database, and stores the acquired second data in the database.
By searching the database, the output processing unit generates first data for each second data stored in the database.

The acquisition processing unit reads the time when the first value shown in the acquired second data is obtained from the storage area, and reads the time when the first value is obtained.
The output processing unit generates the correspondence table by calculating a hash value corresponding to the time read by the acquisition processing unit as a second value.

The acquisition processing unit acquires a plurality of third data indicating each of the time of the first unit and the third value which is a hash value corresponding to the time of the second unit from the storage area.
The output processing unit refers to a hash table that associates the time of the second unit with the third value, and each third data acquired by the acquisition processing unit is shown in the third data. The time of the second unit corresponding to the three values is specified, and the hash value corresponding to the time consisting of the time of the first unit shown in the third data and the time of the specified second unit is the second. The correspondence table is generated by calculating as two values.

The first unit is the year, and the second unit is the month, day, and day.

The server program according to one aspect of the present invention
On the computer
An acquisition process for acquiring a plurality of first data indicating a time and a first value obtained at that time, respectively.
For each of the first data acquired by the acquisition process, a first value indicating the first value shown in the first data and a second value indicating a second value uniquely corresponding to the time indicated in the first data. A mixed process in which two data are generated and the generated plurality of second data are arranged in an order different from the order of the time when the first value shown in each second data is obtained.
A storage process of storing a plurality of second data arranged by the mixed process in a storage area accessed from the outside is executed.

The data utilization program according to one aspect of the present invention is
On the computer
An acquisition process for acquiring a plurality of second data indicating a first value and a second value that is a value uniquely corresponding to the time when the first value is obtained from an external storage area.
With reference to the correspondence table, which is a table showing the correspondence between the time and the second value, for each second data acquired by the acquisition process, the time corresponding to the second value shown in the second data is set. The first data indicating the specified time and the first value shown in the second data is generated, and the output process for outputting the generated plurality of first data is executed.

According to the present invention, time series data can be stored in a format without temporal order and reconstructed at the time of use. As a result, it is possible to reduce the damage at the time of data leakage while reducing the cost and labor required for storing the time series data.

The block diagram which shows the structure of the data management system which concerns on Embodiment 1. FIG. The block diagram which shows the hardware configuration example of the server apparatus which concerns on Embodiment 1. FIG. The block diagram which shows the hardware configuration example of the data utilization apparatus which concerns on Embodiment 1. FIG. The flowchart which shows the operation of the server apparatus which concerns on Embodiment 1. The flowchart which shows the operation of the data utilization apparatus which concerns on Embodiment 1. The block diagram which shows the structure of the data management system which concerns on Embodiment 2. The table which shows the example of the time stamp table of the data utilization apparatus which concerns on Embodiment 2. The table which shows the example of the measurement value table of the data utilization apparatus which concerns on Embodiment 2. The flowchart which shows the operation of the data utilization apparatus which concerns on Embodiment 2. The block diagram which shows the structure of the data management system which concerns on Embodiment 3. The block diagram which shows the structure of the data management system which concerns on Embodiment 4. The flowchart which shows the operation of the server apparatus which concerns on Embodiment 4. The flowchart which shows the operation of the data utilization apparatus which concerns on Embodiment 4.

Hereinafter, embodiments of the present invention will be described with reference to the drawings. In each figure, the same or corresponding parts are designated by the same reference numerals. In the description of the embodiment, the description will be omitted or simplified as appropriate for the same or corresponding parts. The present invention is not limited to the embodiments described below, and various modifications can be made as needed. For example, among the embodiments described below, two or more embodiments may be combined and implemented. Alternatively, of the embodiments described below, one embodiment or a combination of two or more embodiments may be partially implemented.

Embodiment 1.
The present embodiment will be described with reference to FIGS. 1 to 5.

*** Explanation of configuration ***
The configuration of the data management system 700 according to the present embodiment will be described with reference to FIG.

The data management system 700 includes a server device 100, an object storage 150, a data utilization device 200, and a sensor device 300. The server device 100, the object storage 150, and the data utilization device 200 may be at least one each. At least one sensor device 300 may be used, but in the present embodiment, there are a plurality of sensor devices 300.

The server device 100, the object storage 150, the data utilization device 200, and the sensor device 300 are connected to the Internet 400. The Internet 400 may be replaced by other types of networks such as LAN or WAN. "LAN" is an abbreviation for Local Area Network. "WAN" is an abbreviation for Wide Area Network.

The sensor device 300 is a device that periodically transmits the measured value to the server device 100 via the Internet 400. Transmission to the server device 100 may be via a gateway or edge device. The measured value is, for example, an environmental measured value such as temperature, or a measured value for an industrial device as a measurement target. The sensor device 300 may be replaced by another type of device that transmits some time series data.

The server device 100 may be any computer, but in the present embodiment, it is a server computer that provides a cloud platform. The cloud infrastructure is, for example, a private cloud or a public cloud.

The server device 100 includes an acquisition processing unit 101, a mixing processing unit 102, a storage processing unit 103, and a device management unit 104 as functional elements.

The acquisition processing unit 101 performs stream processing. Specifically, the acquisition processing unit 101 receives data in real time. The acquisition processing unit 101 holds the received data for a certain period of time. It is possible to execute processing and output data for retained data.

The mixing processing unit 102 performs data order mixing processing. Specifically, the mixing processing unit 102 separates the time series data from the sensor device 300 into a time stamp and a measured value. The mixing processing unit 102 generates a time stamp file 601 which is a file in which the time stamp is recorded. Further, the mixing processing unit 102 is a file in which the device ID and the measured value are recorded, and generates the measured value file 602 in which the order of the measured values is randomly changed. "ID" is an abbreviation for Identifier.

The storage processing unit 103 stores the time stamp file 601 and the measurement value file 602 generated by the mixing processing unit 102 in the object storage 150.

The device management unit 104 manages the identification of the sensor device 300. Specifically, the device management unit 104 manages information for associating the data received by the acquisition processing unit 101 with the sensor device 300.

The object storage 150 is a storage on the cloud that can be accessed via the Internet 400. Data access is performed to the object storage 150 by the URL and the access key. "URL" is an abbreviation for Uniform Resource Locator. The object storage 150 may be built in the server device 100.

The data utilization device 200 may be any computer, but in the present embodiment, it is a personal computer installed at the data utilization base. The data use base is a base for performing data analysis and the like using time series data from the sensor device 300.

The data utilization device 200 includes an acquisition processing unit 201 and an output processing unit 202 as functional elements.

The acquisition processing unit 201 acquires the necessary time stamp file 601 and the measured value file 602 from the object storage 150.

The output processing unit 202 performs data order restoration processing. Specifically, the output processing unit 202 generates a time-series data file 603, which is a file in which the time stamp, the device ID, and the measured value are recorded, from the time stamp file 601 and the measured value file 602.

A hardware configuration example of the server device 100 will be described with reference to FIG.

The server device 100 includes a processor 111 and other hardware such as a memory 112, an auxiliary storage device 113, a communication device 114, an input device 115, and a display 116. The processor 111 is connected to other hardware via the signal line 117 and controls these other hardware.

The functions of the acquisition processing unit 101, the mixing processing unit 102, the storage processing unit 103, and the device management unit 104 of the server device 100 are realized by software.

The processor 111 is a device that executes a server program. The server program is a program that realizes the functions of the acquisition processing unit 101, the mixing processing unit 102, the storage processing unit 103, and the device management unit 104. The processor 111 is, for example, a CPU. "CPU" is an abbreviation for Central Processing Unit.

The memory 112 and the auxiliary storage device 113 are devices for storing the server program. The memory 112 is, for example, a flash memory or RAM. "RAM" is an abbreviation for Random Access Memory. The auxiliary storage device 113 is, for example, a flash memory or an HDD. "HDD" is an abbreviation for Hard Disk Drive.

The communication device 114 includes a receiver 118 that receives data input to the server program and a transmitter 119 that transmits data output from the server program. The communication device 114 is, for example, a communication chip or a NIC. "NIC" is an abbreviation for Network Interface Card.

The input device 115 is a device operated for inputting data to the server program. The input device 115 is, for example, a mouse, a keyboard, or a touch panel.

The display 116 is a device that displays data output from the server program on the screen. The display 116 is, for example, an LCD. "LCD" is an abbreviation for Liquid Crystal Display.

The server program is loaded from the auxiliary storage 113 into the memory 112 and executed by the processor 111. The auxiliary storage device 113 stores not only the server program but also the OS. "OS" is an abbreviation for Operating System. The processor 111 executes the server program while executing the OS. A part or all of the server program may be incorporated in the OS.

The server device 100 may include a plurality of processors that replace the processor 111. These plurality of processors share the execution of the server program. Each processor is, for example, a CPU.

Data, information, signal values and variable values used, processed or output by the server program are stored in the memory 112, the auxiliary storage 113, or the register or cache memory in the processor 111.

The server program is a program that causes a computer to execute the processes performed by the acquisition processing unit 101, the mixing processing unit 102, the storage processing unit 103, and the device management unit 104 as acquisition processing, mixing processing, storage processing, and device management processing, respectively. The server program may be recorded and provided on a computer-readable medium, may be stored and provided on a recording medium, or may be provided as a program product.

The server device 100 may be composed of one computer or a plurality of computers. When the server device 100 is composed of a plurality of computers, the functions of the acquisition processing unit 101, the mixing processing unit 102, the storage processing unit 103, and the device management unit 104 may be distributed and realized in each computer. ..

A hardware configuration example of the data utilization device 200 will be described with reference to FIG.

The data utilization device 200 includes a processor 211 and other hardware such as a memory 212, an auxiliary storage device 213, a communication device 214, an input device 215, and a display 216. The processor 211 is connected to other hardware via the signal line 217 and controls these other hardware.

The functions of the acquisition processing unit 201 and the output processing unit 202 of the data utilization device 200 are realized by software.

The processor 211 is a device that executes a data utilization program. The data utilization program is a program that realizes the functions of the acquisition processing unit 201 and the output processing unit 202. The processor 211 is, for example, a CPU.

The memory 212 and the auxiliary storage device 213 are devices for storing the data utilization program. The memory 212 is, for example, a flash memory or a RAM. The auxiliary storage device 213 is, for example, a flash memory or an HDD.

The communication device 214 includes a receiver 218 that receives data input to the data utilization program and a transmitter 219 that transmits data output from the data utilization program. The communication device 214 is, for example, a communication chip or a NIC.

The input device 215 is a device operated for inputting data into the data utilization program. The input device 215 is, for example, a mouse, a keyboard, or a touch panel.

The display 216 is a device that displays the data output from the data utilization program on the screen. The display 216 is, for example, an LCD.

The data utilization program is loaded from the auxiliary storage device 213 into the memory 212 and executed by the processor 211. The auxiliary storage device 213 stores not only the data utilization program but also the OS. The processor 211 executes a data utilization program while executing the OS. A part or all of the data utilization program may be incorporated in the OS.

The data utilization device 200 may include a plurality of processors that replace the processor 211. These plurality of processors share the execution of the data utilization program. Each processor is, for example, a CPU.

The data, information, signal values and variable values used, processed or output by the data utilization program are stored in the memory 212, the auxiliary storage device 213, or the register or cache memory in the processor 211.

The data utilization program is a program that causes a computer to execute the processes performed by the acquisition processing unit 201 and the output processing unit 202 as acquisition processing and output processing, respectively. The data utilization program may be recorded and provided on a computer-readable medium, may be stored and provided on a recording medium, or may be provided as a program product.

The data utilization device 200 may be composed of one computer or a plurality of computers. When the data utilization device 200 is composed of a plurality of computers, the functions of the acquisition processing unit 201 and the output processing unit 202 may be distributed and realized in each computer.

*** Explanation of operation ***
In addition to FIG. 1, the operation of the data management system 700 according to the present embodiment will be described with reference to FIGS. 4 and 5. The operation of the data management system 700 corresponds to the data management method according to the present embodiment.

The operation of the data management system 700 includes a data storage phase and a reconstruction phase.

The data storage phase is a phase in which the server device 100 converts time-series data and stores it in the object storage 150. The reconstruction phase is a phase in which the data utilization device 200 reconstructs available time-series data from the data in the object storage 150.

In the data storage phase, the acquisition processing unit 101 receives the measured value from the sensor device 300 by stream processing, and passes the time series data to the data order mixing process at regular intervals such as every minute. Each cycle is identified as a recording time window. In the data order mixing process, the mixing process unit 102 converts the time series data and outputs the result to the time stamp file 601 and the measured value file 602. After that, the storage processing unit 103 writes the time stamp file 601 and the measurement value file 602 to the object storage 150.

The flow of the data order mixing process is shown in FIG.

Before starting the data sequence mixing process, the acquisition processing unit 101 acquires a plurality of first data indicating the time and the first value which is the value obtained at the time. In the present embodiment, the first data is a record for each case included in the sensor data from the sensor device 300. The time is indicated in the form of a time stamp in this embodiment. The first value is a measured value in the present embodiment.

In the present embodiment, the acquisition processing unit 101 uniquely identifies the time, the first value obtained at the time, and the sensor device 300 that obtained the first value at the time as the first data of each. Acquires data indicating the device ID to be used.

In step S11, a plurality of sensor data are input to the mixing processing unit 102 from the acquisition processing unit 101 in units of recording time windows.

In step S12, the mixing processing unit 102 retrieves one record from the sensor data. The record contains data for time stamps, device IDs and one or more measurements. The time stamp corresponds to the measurement time. The device ID corresponds to the identifier of the sensor device 300 that performed the measurement.

In step S13, the mixing processing unit 102 performs hash processing on the time stamp of the record and the device ID, and calculates the hash value.

In step S14, the mixing processing unit 102 adds the set of the hash value, the device ID, the measured value, and the recording time window ID as a record to the measured value buffer. The recording time window ID is an ID that uniquely identifies the recording time window. The measurement value buffer is secured on the memory 112.

In step S15, if the time stamp value of the record does not exist in the time stamp buffer, the mixing processing unit 102 adds it to the time stamp buffer. The time stamp buffer is secured on the memory 112.

In step S16, the mixing processing unit 102 repeats the processing of steps S12 to S15 when there is a record of unprocessed sensor data. When the processing of all the records is completed, the process proceeds to step S17.

In step S17, the mixing processing unit 102 randomly changes the order of the records in the measurement value buffer by a random number or the like, and outputs the contents to the measurement value file 602.

In step S18, the mixing processing unit 102 outputs the contents of the time stamp buffer to the time stamp file 601 in the form of a record of a set of the time stamp and the recording time window ID.

As described above, in the data sequence mixing process, the mixing processing unit 102 shows the first value shown in the first data and the first data for each first data acquired by the acquisition processing unit 101. Second data indicating a second value, which is a value uniquely corresponding to a certain time, is generated. In the present embodiment, the second data is a record for each case stored in the measurement value buffer. The second value is a hash value in the present embodiment. The mixing processing unit 102 arranges the generated second data in an order different from the order of the time when the first value shown in each second data is obtained.

In the present embodiment, the mixing processing unit 102 sets the time and device ID shown in the first data as the second value shown in the second data for each first data acquired by the acquisition processing unit 101. Generate a value that corresponds uniquely to the pair. Specifically, the mixing processing unit 102 calculates a hash value as a second value shown in the second data for each first data acquired by the acquisition processing unit 101.

After the data sequence mixing process is completed, the storage processing unit 103 stores a plurality of second data arranged by the mixing processing unit 102 in a storage area accessed from the outside. The storage area is secured in the object storage 150 in the present embodiment. In the present embodiment, the plurality of second data are stored in the format of the measurement value file 602.

In the present embodiment, the storage processing unit 103 separates the times shown in the plurality of first data acquired by the acquisition processing unit 101 from the first values shown in the respective first data. Write to the storage area in the form. In the present embodiment, the times shown in the plurality of first data are written in the format of the time stamp file 601.

In the reconstruction phase, the acquisition processing unit 201 extracts the necessary time stamp file 601 and the measured value file 602 from the object storage 150 and passes them to the data order restoration process. In the data order restoration process, the output processing unit 202 restores the time series data from the time stamp file 601 and the measured value file 602, and outputs the time series data to the time series data file 603.

The flow of the data order restoration process is shown in FIG.

Prior to the start of the data order restoration process, the acquisition processing unit 201 receives a plurality of second data indicating the first value and the second value which is a value uniquely corresponding to the time when the first value is obtained. Obtained from an external storage area. As described above, the storage area is secured in the object storage 150 in the present embodiment. The second data is, in the present embodiment, one record for each case included in the measurement value file 602. The first value is a measured value in the present embodiment. The second value is a hash value in the present embodiment.

In the present embodiment, the acquisition processing unit 201 sets the first value as the second value shown in the second data at the time when the first value shown in the second data is obtained and at the time. A value uniquely corresponding to the set of device IDs that uniquely identifies the obtained sensor device 300 is acquired. Specifically, the acquisition processing unit 201 acquires a hash value as the second value shown in the respective second data.

Further, in the present embodiment, the acquisition processing unit 201 reads from the storage area the time when the first value shown in the acquired plurality of second data is obtained. As described above, in the present embodiment, the time is written in the time stamp file 601 in the form of a time stamp.

In step S21, the time stamp file 601 and the measurement value file 602 are input to the output processing unit 202 from the acquisition processing unit 201.

In step S22, the output processing unit 202 extracts all the device IDs used in the data from the data of the measurement value file 602.

In step S23, the output processing unit 202 performs hash processing on all combinations of the time stamp value of the time stamp file 601 and the device ID extracted in step S22, and sets the time stamp value and the set of the device ID and the hash value. Create a hash value table as a record.

In step S24, the output processing unit 202 retrieves one record from the data of the measurement value file 602.

In step S25, the output processing unit 202 matches the hash value and device ID of the record with the hash value table created in step S23, and identifies a time stamp in which the hash value and device ID match.

In step S26, the output processing unit 202 outputs the set of the time stamp specified in step S25, the device ID of the record, and the measured value as a record to the time series data file 603.

In step S27, the output processing unit 202 repeats the processing of steps S24 to S26 when there is a record of the unprocessed measurement value file 602. It ends when the processing of all records is completed.

As described above, in the data order restoration processing, the output processing unit 202 refers to the correspondence table, which is a table showing the correspondence between the time and the second value, for each second data acquired by the acquisition processing unit 201. , The time corresponding to the second value shown in the second data is specified, and the first data indicating the specified time and the first value shown in the second data is generated. As a result, the output processing unit 202 restores the plurality of first data acquired by the server device 100. The correspondence table is a hash value table in the present embodiment. The plurality of first data are restored in the format of the time series data file 603 in the present embodiment. The output processing unit 202 outputs a plurality of restored first data.

In the present embodiment, the output processing unit 202 refers to a table showing the correspondence between the time and device ID set and the second value as a correspondence table, and for each second data acquired by the acquisition processing unit 201. The time and device ID set corresponding to the second value shown in the second data is specified. The output processing unit 202 generates data indicating the specified device ID as the first data together with the specified time and the first value shown in the second data.

Further, in the present embodiment, the output processing unit 202 generates a correspondence table by calculating the hash value corresponding to the time read by the acquisition processing unit 201 as the second value.

*** Explanation of the effect of the embodiment ***
According to this embodiment, time-series data can be stored in a format that is not in order in time and can be reconstructed at the time of use. As a result, it is possible to reduce the damage at the time of data leakage while reducing the cost and labor required for storing the time series data.

In the present embodiment, even if the pair of the time stamp file 601 and the measured value file 602 is leaked, the information as time series data is not lost, but the information on the temporal order can be obtained even if it is referred to as it is. Therefore, the value of the data can be reduced and the damage can be reduced.

In the present embodiment, since the decryption can be performed only by the combination of the time stamp file 601 and the measurement value file 602, the cooperation processing between the data collection side and the data use side becomes unnecessary.

In the present embodiment, unlike data encryption, it is not necessary to manage the encryption key.

In the present embodiment, since the measured values can be used without decoding, analysis regardless of the order such as statistical basic quantities such as mean, variance, maximum or minimum can be performed as it is.

*** Other configurations ***
In the present embodiment, the functions of the acquisition processing unit 101, the mixing processing unit 102, the storage processing unit 103, and the device management unit 104 of the server device 100 are realized by software, but as a modification, the acquisition processing unit 101 and the mixing process The functions of the unit 102, the storage processing unit 103, and the device management unit 104 may be realized by dedicated hardware.

Dedicated hardware is, for example, a single circuit, a composite circuit, a programmed processor, a parallel programmed processor, a logic IC, a GA, an FPGA or an ASIC. "IC" is an abbreviation for Integrated Circuit. "GA" is an abbreviation for Gate Array. "FPGA" is an abbreviation for Field-Programmable Gate Array. "ASIC" is an abbreviation for Application Special Integrated Circuit.

As another modification, the functions of the acquisition processing unit 101, the mixing processing unit 102, the storage processing unit 103, and the device management unit 104 may be realized by a combination of software and hardware. That is, a part of the functions of the acquisition processing unit 101, the mixing processing unit 102, the storage processing unit 103, and the device management unit 104 may be realized by dedicated hardware, and the rest may be realized by software.

Both the processor 111 and the dedicated hardware are processing circuits. That is, regardless of the hardware configuration of the server device 100, the operations of the acquisition processing unit 101, the mixing processing unit 102, the storage processing unit 103, and the device management unit 104 are performed by the processing circuit.

In the present embodiment, the functions of the acquisition processing unit 201 and the output processing unit 202 of the data utilization device 200 are also realized by software, but as a modification, the functions of the acquisition processing unit 201 and the output processing unit 202 are dedicated hardware. May be realized by.

Dedicated hardware is, for example, a single circuit, a composite circuit, a programmed processor, a parallel programmed processor, a logic IC, a GA, an FPGA or an ASIC.

As another modification, the functions of the acquisition processing unit 201 and the output processing unit 202 may be realized by a combination of software and hardware. That is, a part of the functions of the acquisition processing unit 201 and the output processing unit 202 may be realized by dedicated hardware, and the rest may be realized by software.

The processor 211 and the dedicated hardware are both processing circuits. That is, regardless of the hardware configuration of the data utilization device 200, the operations of the acquisition processing unit 201 and the output processing unit 202 are performed by the processing circuit.

Embodiment 2.
The differences between the present embodiment and the first embodiment will be mainly described with reference to FIGS. 6 to 9.

*** Explanation of configuration ***
The configuration of the data management system 700 according to the present embodiment will be described with reference to FIG.

In the present embodiment, when the time series data is used, the time series data is not individually reconstructed, but the data is stored in the RDB and the time series data is reconstructed by using the DB processing. "RDB" is an abbreviation for Relational Database. "DB" is an abbreviation for Database.

The data management system 700 includes a server device 100, an object storage 150, a data utilization device 200, and a sensor device 300, as in the first embodiment.

Since the server device 100, the object storage 150, and the sensor device 300 are the same as those in the first embodiment, the description thereof will be omitted.

In the present embodiment, the data utilization device 200 includes a database 610 in addition to the acquisition processing unit 201 and the output processing unit 202.

The acquisition processing unit 201 has an RDB management function. The acquisition processing unit 201 performs data loading processing. Specifically, the acquisition processing unit 201 acquires the time stamp file 601 and the measurement value file 602 from the object storage 150 and loads them into the database 610.

The output processing unit 202 performs a data search process. Specifically, the output processing unit 202 searches the database 610 and reconstructs the time series data from the search results. The reconstructed time-series data may be output in the same time-series data file 603 format as in the first embodiment, but in the present embodiment, it is output to the database 610 in the table format.

The database 610 may be any kind of DB, but in the present embodiment, it is an RDB. The database 610 is built, for example, in the auxiliary storage device 213 shown in FIG. The database 610 has a time stamp table 611 "TS-Tbl" and a measured value table 612 "VAL-Tbl".

The time stamp table 611 is a table for storing the data of the time stamp file 601. As shown in FIG. 7, the time stamp table 611 has columns for the recording time window ID “WIN-ID” and the time stamp “S-TS”.

The measurement value table 612 is a table for storing the data of the measurement value file 602. As shown in FIG. 8, the measurement value table 612 has columns for the recording time window ID “WIN-ID”, the hash value “HASH-VAL”, the device ID “DEV-ID”, and the measurement value “S-VALUE”. ..

*** Explanation of operation ***
In addition to FIG. 6, the operation of the data management system 700 according to the present embodiment will be described with reference to FIG. The operation of the data management system 700 corresponds to the data management method according to the present embodiment.

The operation of the data management system 700 includes a data storage phase and a reconstruction phase, as in the first embodiment.

Since the data storage phase is the same as that of the first embodiment, the description thereof will be omitted.

In the reconstruction phase, the acquisition processing unit 201 extracts the time stamp file 601 and the measured value file 602 required from the object storage 150 in the data load processing, and uses the RDB management function to take out the time stamp table 611 and the measured value table, respectively. Load the data into 612. When the data is used, the output processing unit 202 reconstructs and uses the time series data in the data search process.

The flow of the data search process is shown in FIG. Although the data search process is divided into a plurality of steps for convenience of explanation, it can actually be executed by one query.

Before starting the data search process, the acquisition processing unit 201 externally outputs a plurality of second data indicating the first value and the second value which is a value uniquely corresponding to the time when the first value is obtained. Get from the storage area of. Similar to the first embodiment, the storage area is secured in the object storage 150 in the present embodiment as well. The second data is a record for each case included in the measurement value file 602 even in the present embodiment. The first value is also a measured value in this embodiment. The second value is also a hash value in this embodiment.

Also in the present embodiment, the acquisition processing unit 201 sets the first value as the second value shown in the second data at the time when the first value shown in the second data is obtained and at the time. A value uniquely corresponding to the set of device IDs that uniquely identifies the obtained sensor device 300 is acquired. Specifically, the acquisition processing unit 201 acquires a hash value as the second value shown in the respective second data.

Further, also in the present embodiment, the acquisition processing unit 201 reads from the storage area the time when the first value shown in the acquired plurality of second data is obtained. The time is also written in the time stamp file 601 in the form of a time stamp in this embodiment.

Unlike the first embodiment, in the present embodiment, the acquisition processing unit 201 stores the acquired plurality of second data in the database 610.

In step S31, the output processing unit 202 extracts the device ID of the record having the recording time window ID corresponding to the recording time window including the data to be used from the measured value table 612 by the following query.
SELECT DISTINCT DEV-ID FROM VAL-Tbl
WHERE WIN-ID = <Recording time window ID>
The result is a DEVID-Tmp table.

In step S32, the output processing unit 202 extracts the time stamp value of the record having the recording time window ID corresponding to the recording time window including the data to be used from the time stamp table 611 by the following query.
SELECT S-TS FROM TS-Tbl
WHERE WIN-ID = <Recording time window ID>
The result is a TS-Tmp table.

In step S33, the output processing unit 202 obtains the direct product of the time stamp extracted in step S32 and the device ID extracted in step S31 by the following query, and creates a hash value table using the UDF that performs hash processing. do. "UDF" is an abbreviation for User Defined Function.
SELECT S-TS, hash_tsdev (S-TS, DEV-ID) AS HASH-VAL
FROM TS-Tmp, DEVID-Tmp
hash_tsdev is a UDF that calculates a hash value. The result is a TDHASH-Tmp table.

In step S34, the output processing unit 202 joins the hash value table created in step S33 and the measured value table 612 to create a time series data table by the following query.
SELECT H. S-TS, V.I. DEV-ID, V.I. S-VALUE
FROM VAL-Tbl V, TDHASH-Tmp H
WHERE V. HASH-VAL = H. HASH-VAL AND V. WIN-ID = <Recording time window ID>

As described above, in the data search process, the output processing unit 202 refers to the correspondence table, which is a table showing the correspondence relationship between the time and the second value, for each second data acquired by the acquisition processing unit 201. The time corresponding to the second value shown in the second data is specified, and the first data indicating the specified time and the first value shown in the second data is generated. As a result, the output processing unit 202 restores the plurality of first data acquired by the server device 100. The correspondence table is also a hash value table in this embodiment. The plurality of first data are restored in the form of a table in the present embodiment. The output processing unit 202 outputs a plurality of restored first data.

Also in the present embodiment, the output processing unit 202 refers to the table showing the correspondence between the time and device ID set and the second value as the correspondence table, and for each second data acquired by the acquisition processing unit 201. The time and device ID set corresponding to the second value shown in the second data is specified. The output processing unit 202 generates data indicating the specified device ID as the first data together with the specified time and the first value shown in the second data.

Further, also in the present embodiment, the output processing unit 202 generates a correspondence table by calculating the hash value corresponding to the time read by the acquisition processing unit 201 as the second value.

In the present embodiment, the output processing unit 202 searches the database 610 to generate the first data for each of the second data stored in the database 610.

*** Explanation of the effect of the embodiment ***
In the present embodiment, since the time series data can be restored by the RDB operation, a program or the like for data order decoding processing becomes unnecessary.

In the present embodiment, since the RDB is used, it is easy to cooperate with data analysis after decoding.

Embodiment 3.
The difference between the present embodiment and the second embodiment will be mainly described with reference to FIG.

*** Explanation of configuration ***
The configuration of the data management system 700 according to the present embodiment will be described with reference to FIG.

In the present embodiment, the time stamp file 601 and the measurement value file 602 are not stored in the object storage 150 but stored in the RDB on the cloud, and at the data usage base, the BI tool 220 is used in the RDB on the cloud. Access and reconstruct time series data. "BI" is an abbreviation for Business Intelligence.

The data management system 700 includes a server device 100, a data utilization device 200, and a sensor device 300.

Since the sensor device 300 is the same as that of the first embodiment, the description thereof will be omitted.

In the present embodiment, the server device 100 includes a database 610 in addition to the acquisition processing unit 101, the mixing processing unit 102, the storage processing unit 103, and the device management unit 104.

The acquisition processing unit 101, the mixing processing unit 102, and the device management unit 104 are the same as those in the first embodiment, and thus the description thereof will be omitted.

The storage processing unit 103 has an RDB management function. The storage processing unit 103 performs a file loading process. Specifically, the storage processing unit 103 loads the time stamp file 601 and the measurement value file 602 generated by the mixing processing unit 102 into the database 610.

The database 610 may be any kind of DB, but in the present embodiment, it is an RDB. The database 610 is built, for example, in the auxiliary storage device 113 shown in FIG. The database 610 has a time stamp table 611 "TS-Tbl" and a measured value table 612 "VAL-Tbl".

The time stamp table 611 is a table for storing the data of the time stamp file 601. The time stamp table 611 may be the same as that of the second embodiment shown in FIG.

The measurement value table 612 is a table for storing the data of the measurement value file 602. The measurement value table 612 may be the same as that of the second embodiment shown in FIG.

In the present embodiment, the data utilization device 200 includes a BI tool 220 as software that realizes the functions of the acquisition processing unit 201 and the output processing unit 202.

The BI tool 220 is a tool for analyzing and visualizing data in cooperation with the database 610. It is possible to input data from the database 610 and perform data manipulation.

The acquisition processing unit 201 acquires data from the database 610 by using the function of the BI tool 220.

The output processing unit 202 performs a data search process. Specifically, the output processing unit 202 searches the database 610 using the function of the BI tool 220, and reconstructs the time series data from the search results. The reconstructed time-series data may be output in the same time-series data file 603 format as in the first embodiment, or may be output in the table format as in the second embodiment. It may be output in other formats.

*** Explanation of operation ***
The operation of the data management system 700 according to the present embodiment will be described with reference to FIG. The operation of the data management system 700 corresponds to the data management method according to the present embodiment.

The operation of the data management system 700 includes a data storage phase and a reconstruction phase, as in the first embodiment.

The data storage phase is equivalent to the procedure in the second embodiment from the conversion of the time series data to the storage in the RDB without going through the object storage 150. The reconstruction phase is a procedure in which the target data of the cloud database 610 is read by the BI tool 220 and the data search process similar to that of the second embodiment is performed on the BI tool 220.

As described above, in the present embodiment, the storage processing unit 103 stores the plurality of second data arranged by the mixing processing unit 102 in the database 610 constructed in the storage area. The storage area is secured in the server device 100 in the present embodiment. The plurality of second data are stored in the format of the measured value table 612 in the present embodiment.

*** Explanation of the effect of the embodiment ***
In the present embodiment, since the data is stored in the RDB on the cloud, it is possible to easily execute an analysis regardless of the order such as a statistical basic quantity.

In the present embodiment, since the data is stored in the database 610, management is easy.

Embodiment 4.
The differences between the present embodiment and the first embodiment will be mainly described with reference to FIGS. 11 to 13.

*** Explanation of configuration ***
The configuration of the data management system 700 according to the present embodiment will be described with reference to FIG.

In the present embodiment, the time stamp file 601 disappears, and the device ID table 604 for managing the device ID is added.

In the present embodiment, the time series data is converted only into the measurement value file 605. The measurement value file 605 contains a first hash value, a year, a second hash value, and one or more measurement values.

*** Explanation of operation ***
In addition to FIG. 11, the operation of the data management system 700 according to the present embodiment will be described with reference to FIGS. 12 and 13. The operation of the data management system 700 corresponds to the data management method according to the present embodiment.

The operation of the data management system 700 includes a data storage phase and a reconstruction phase, as in the first embodiment.

The flow of the data order mixing process in the data storage phase is shown in FIG.

Before starting the data sequence mixing process, the acquisition processing unit 101 acquires a plurality of first data indicating the time and the first value which is the value obtained at the time. Similar to the first embodiment, the first data is a record for each case included in the sensor data from the sensor device 300 in the present embodiment as well. The time is also shown in the form of a time stamp in this embodiment. The first value is also a measured value in this embodiment.

Also in the present embodiment, the acquisition processing unit 101 uniquely identifies the time, the first value obtained at the time, and the sensor device 300 that obtained the first value at the time as the first data of each. Acquires data indicating the device ID to be used.

In step S41, a plurality of sensor data are input to the mixing processing unit 102 from the acquisition processing unit 101 in units of recording time windows.

In step S42, the mixing processing unit 102 retrieves one record from the sensor data. The record contains data for time stamps, device IDs and one or more measurements. The time stamp corresponds to the measurement time. The device ID corresponds to the identifier of the sensor device 300 that performed the measurement.

In step S43, the mixing processing unit 102 performs hash processing on the time stamp of the record and the device ID, and calculates the first hash value.

In step S44, the mixing processing unit 102 calculates the second hash value from the date “MM-DD” and the time “hh” of the time stamp information “YYYY-MM-DD hh: mm: ss”.

In step S45, the mixing processing unit 102 adds a record in which the first hash value, the measured value, and the year “YYYY” of the time stamp information and the second hash value are set to the measured value buffer.

In step S46, the mixing processing unit 102 repeats the processing of steps S42 to S45 when there is a record of unprocessed sensor data. When the processing of all the records is completed, the process proceeds to step S47.

In step S47, the mixing processing unit 102 randomly changes the order of the records in the measurement value buffer by a random number or the like, and outputs the contents to the measurement value file 605.

As described above, in the data sequence mixing process, the mixing processing unit 102 shows the first value shown in the first data and the first data for each first data acquired by the acquisition processing unit 101. Second data indicating a second value, which is a value uniquely corresponding to a certain time, is generated. The second data is a record for each case stored in the measurement value buffer even in the present embodiment. The second value is the first hash value in the present embodiment. The mixing processing unit 102 arranges the generated second data in an order different from the order of the time when the first value shown in each second data is obtained.

Also in the present embodiment, the mixing processing unit 102 sets the time and device ID shown in the first data as the second value shown in the second data for each first data acquired by the acquisition processing unit 101. Generate a value that corresponds uniquely to the pair. Specifically, the mixing processing unit 102 calculates the first hash value as the second value shown in the second data for each of the first data acquired by the acquisition processing unit 101.

Unlike the first embodiment, in the present embodiment, the mixing processing unit 102 sets the time shown in the first data as the time of the first unit for each first data acquired by the acquisition processing unit 101. It is decomposed into two units of time, and third data showing the time of the first unit and the third value which is a hash value corresponding to the time of the second unit is generated. The first unit is the year and the second unit is the month and time, but the first unit and the second unit may be a combination of different units. For example, the first unit may be the year and month, and the second unit may be the date and time. The third value is the second hash value in the present embodiment. The mixing processing unit 102 arranges the generated plurality of third data in an order different from the time order shown in the first data on which the third data is based.

After the data sequence mixing process is completed, the storage processing unit 103 stores the plurality of second data and the plurality of third data arranged by the mixing processing unit 102 in a storage area accessed from the outside. The storage area is secured in the object storage 150 also in this embodiment. The plurality of second data are stored in the format of the measurement value file 605 in the present embodiment. In the present embodiment, the plurality of third data are stored together with the plurality of second data in the format of the measurement value file 605, but may be stored in a file different from the plurality of second data, or a plurality of third data. It may be stored in a format different from the second data of.

In the reconstruction phase, the acquisition processing unit 201 extracts the necessary measurement value file 605 from the object storage 150 and passes it to the data order restoration process. In the data order restoration process, the device ID group is acquired from the device ID table 604 in advance in cooperation with the device management unit 104 of the server device 100, and the acquired device ID group and the measured value file 605 are used in a time series. The data is restored and output to the time series data file 603.

The flow of the data order restoration process is shown in FIG.

Prior to the start of the data order restoration process, the acquisition processing unit 201 receives a plurality of second data indicating the first value and the second value which is a value uniquely corresponding to the time when the first value is obtained. Obtained from an external storage area. As described above, the storage area is secured in the object storage 150 also in this embodiment. The second data is a record for each case included in the measurement value file 605 even in the present embodiment. The first value is also a measured value in this embodiment. The second value is the first hash value in the present embodiment.

In the present embodiment, the acquisition processing unit 201 sets the first value as the second value shown in the second data at the time when the first value shown in the second data is obtained and at the time. A value uniquely corresponding to the set of device IDs that uniquely identifies the obtained sensor device 300 is acquired. Specifically, the acquisition processing unit 201 acquires the first hash value as the second value shown in the respective second data.

Unlike the first embodiment, in the present embodiment, the acquisition processing unit 201 has a plurality of third data indicating the time of the first unit and the third value which is a hash value corresponding to the time of the second unit. From the storage area. As described above, the first unit is the year and the second unit is the month and time, but the first unit and the second unit may be a combination of different units. The third value is the second hash value in the present embodiment.

In step S51, the output processing unit 202 calculates the second hash value from 0:00 on January 1st to 23:00 on December 31st, and creates a second hash value table.

In step S52, the data of the measurement value file 605 is input to the output processing unit 202 from the acquisition processing unit 201.

In step S53, the output processing unit 202 extracts all the year and the second hash value included in the data from the data of the measurement value file 605.

In step S54, the output processing unit 202 collates the second hash value extracted in step S53 with the second hash value table created in step S51, and sets all the dates and times of the data in the measurement value file 605 as the reference year and month. Derived as a date and time.

In step S55, the output processing unit 202 creates all variations of the time stamp included in the period of the base date and time. Specifically, the output processing unit 202 expands the reference date and time “YYYY-MM-DD hh” into the time stamp values “YYYY-MM-DD hh: mm: ss” of all patterns. The output processing unit 202 combines these time stamp values with the device IDs included in the acquired device ID group to perform hash processing, and creates a first hash value table.

In step S56, the output processing unit 202 extracts one record from the data of the measurement value file 605.

In step S57, the output processing unit 202 matches the first hash value of the record with the first hash value table created in step S55, and identifies the time stamp and the device ID in which the first hash values match.

In step S58, the output processing unit 202 outputs the set of the time stamp and the device ID specified in step S57 and the measured value of the record as a record to the time series data file 603.

In step S59, the output processing unit 202 repeats the processing of steps S56 to S58 if there is a record of the unprocessed measurement value file 605. It ends when the processing of all records is completed.

As described above, in the data order restoration processing, the output processing unit 202 refers to the correspondence table, which is a table showing the correspondence between the time and the second value, for each second data acquired by the acquisition processing unit 201. , The time corresponding to the second value shown in the second data is specified, and the first data indicating the specified time and the first value shown in the second data is generated. As a result, the output processing unit 202 restores the plurality of first data acquired by the server device 100. The correspondence table is the first hash value table in the present embodiment. The plurality of first data are restored in the format of the time series data file 603 in the present embodiment. The output processing unit 202 outputs a plurality of restored first data.

In the present embodiment, the output processing unit 202 refers to a table showing the correspondence between the time and device ID set and the second value as a correspondence table, and for each second data acquired by the acquisition processing unit 201. The time and device ID set corresponding to the second value shown in the second data is specified. The output processing unit 202 generates data indicating the specified device ID as the first data together with the specified time and the first value shown in the second data.

Unlike the first embodiment, in the present embodiment, the output processing unit 202 refers to the hash table that associates the time of the second unit with the third value, and the third data acquired by the acquisition processing unit 201. For each, the time of the second unit corresponding to the third value shown in the third data is specified, and from the time of the first unit shown in the third data and the time of the specified second unit. A correspondence table is generated by calculating the hash value corresponding to the time as the second value. The hash table is the second hash value table in the present embodiment.

*** Explanation of the effect of the embodiment ***
In the present embodiment, the measurement value file 605 is merely a collection of measurement values, and even if it is referred to as it is, information on the temporal order or measurement device information cannot be obtained, so that it is possible to take measures against data leakage. ..

100 server unit, 101 acquisition processing unit, 102 mixing processing unit, 103 storage processing unit, 104 device management unit, 111 processor, 112 memory, 113 auxiliary storage device, 114 communication device, 115 input device, 116 display, 117 signal line, 118 receiver, 119 transmitter, 150 object storage, 200 data utilization device, 201 acquisition processing unit, 202 output processing unit, 211 processor, 212 memory, 213 auxiliary storage device, 214 communication device, 215 input device, 216 display, 217 signal line , 218 receiver, 219 transmitter, 220 BI tool, 300 sensor device, 400 internet, 601 time stamp file, 602 measurement value file, 603 time series data file, 604 device ID table, 605 measurement value file, 610 database, 611 time stamp. Table, 612 measurement table, 700 data management system.

Claims (15)

A plurality of first data indicating the time and the first value obtained at the time are acquired, and for each of the acquired first data, the first value shown in the first data and the first value are obtained. Second data indicating a second value that is a value uniquely corresponding to the time shown in one data is generated, and the generated plurality of second data are the first one shown in each second data. A server device that stores the values in a storage area accessed from the outside by arranging them in a different order from the time when the values were obtained.
A plurality of second data arranged by the server device are acquired from the storage area, and the correspondence table, which is a table showing the correspondence between the time and the second value, is referred to, and for each acquired second data, the second data is obtained. 2 Obtained by the server device by specifying the time corresponding to the second value shown in the data and generating data indicating the specified time and the first value shown in the second data. A data management system including a data utilization device that restores a plurality of first data. An acquisition processing unit that acquires a plurality of first data indicating a time and a first value that is a value obtained at that time.
For each of the first data acquired by the acquisition processing unit, a first value shown in the first data and a second value which is a value uniquely corresponding to the time shown in the first data are shown. A mixing processing unit that generates the second data and arranges the generated plurality of second data in an order different from the order of the time when the first value shown in each second data is obtained.
A server device including a storage processing unit that stores a plurality of second data arranged by the mixing processing unit in a storage area accessed from the outside. The acquisition processing unit acquires, as the first data, data indicating the time, the first value obtained at the time, and the device identifier that uniquely identifies the device that obtained the first value at the time. death,
The mixing processing unit uniquely corresponds to the set of the time and the device identifier shown in the first data as the second value shown in the second data for each of the first data acquired by the acquisition processing unit. The server device according to claim 2, which generates a value. The server device according to claim 2 or 3, wherein the storage processing unit stores a plurality of second data arranged by the mixing processing unit in a database constructed in the storage area. The mixing processing unit calculates a hash value as a second value shown in the second data for each first data acquired by the acquisition processing unit.
The storage processing unit stores the time indicated in the plurality of first data acquired by the acquisition processing unit in the storage area in a form separated from the first value shown in each of the first data. The server device according to any one of claims 2 to 4 to be written. The mixing processing unit decomposes the time shown in the first data into a time of the first unit and a time of the second unit for each first data acquired by the acquisition processing unit, and the first unit. The third data indicating the time of the above and the third value which is the hash value corresponding to the time of the second unit is generated, and the generated plurality of third data are used as the basis of the respective third data. 1 Arrange in a different order from the time shown in the data,
The server device according to any one of claims 2 to 4, wherein the storage processing unit stores a plurality of third data arranged by the mixing processing unit in the storage area. The server device according to claim 6, wherein the first unit is a year and the second unit is a month and time. An acquisition processing unit that acquires a plurality of second data indicating a first value and a second value that is a value uniquely corresponding to the time when the first value is obtained from an external storage area.
With reference to the correspondence table, which is a table showing the correspondence between the time and the second value, for each second data acquired by the acquisition processing unit, the time corresponding to the second value shown in the second data. A data utilization device including an output processing unit that specifies, generates first data indicating the specified time and the first value shown in the second data, and outputs a plurality of generated first data. As the second value shown in each second data, the acquisition processing unit uniquely selects the time when the first value shown in each second data is obtained and the device which obtained the first value at that time. Gets the value that uniquely corresponds to the set of device identifiers to identify
The output processing unit refers to a table showing the correspondence between the set of time and device identifiers and the second value as the correspondence table, and for each of the second data acquired by the acquisition processing unit, the second data The set of time and device identifier corresponding to the second value shown in is specified, and the specified time and the specified device identifier are shown as the first data together with the first value shown in the second data. The data utilization device according to claim 8, which generates data. The acquisition processing unit stores a plurality of acquired second data in the database, and stores the acquired second data in the database.
The data utilization device according to claim 8 or 9, wherein the output processing unit generates first data for each second data stored in the database by searching the database. The acquisition processing unit reads the time when the first value shown in the acquired second data is obtained from the storage area, and reads the time when the first value is obtained.
The data utilization according to any one of claims 8 to 10, wherein the output processing unit generates the correspondence table by calculating the hash value corresponding to the time read by the acquisition processing unit as the second value. Device. The acquisition processing unit acquires a plurality of third data indicating each of the time of the first unit and the third value which is a hash value corresponding to the time of the second unit from the storage area.
The output processing unit refers to a hash table that associates the time of the second unit with the third value, and each third data acquired by the acquisition processing unit is shown in the third data. The time of the second unit corresponding to the three values is specified, and the hash value corresponding to the time consisting of the time of the first unit shown in the third data and the time of the specified second unit is the second. The data utilization device according to any one of claims 8 to 10, which generates the correspondence table by calculating as two values. The data utilization device according to claim 12, wherein the first unit is a year and the second unit is a month and time. On the computer
An acquisition process for acquiring a plurality of first data indicating a time and a first value obtained at that time, respectively.
For each of the first data acquired by the acquisition process, a first value indicating the first value shown in the first data and a second value indicating a second value uniquely corresponding to the time indicated in the first data. A mixed process in which two data are generated and the generated plurality of second data are arranged in an order different from the order of the time when the first value shown in each second data is obtained.
A server program that executes a storage process of storing a plurality of second data arranged by the mixed process in a storage area accessed from the outside. On the computer
An acquisition process for acquiring a plurality of second data indicating a first value and a second value that is a value uniquely corresponding to the time when the first value is obtained from an external storage area.
With reference to the correspondence table, which is a table showing the correspondence between the time and the second value, for each second data acquired by the acquisition process, the time corresponding to the second value shown in the second data is set. A data utilization program that executes an output process that generates first data indicating a specified time and a first value shown in the second data, and outputs a plurality of generated first data.

Images