JP6419275B1 - Data conversion system and data conversion program - Google Patents

Abstract

The present invention addresses various data conversions. In a data conversion system, a specification analysis unit analyzes an application data specification and responds to a pre-conversion item name for each pre-conversion item name that is an item name of device data on a memory. The conversion buffer 30 for storing the item value to be stored is constructed, and the item value corresponding to the post-conversion item name using the item value stored in the conversion buffer 30 for each post-conversion item name that is the item name of the application data 51 Set the process to generate. At least one process is a process of generating an item value corresponding to the post-conversion item name using a plurality of item values corresponding to different pre-conversion item names. The conversion formula evaluation unit 23 selects the process set by the specification analysis unit 21 for each item name after conversion, acquires the item value used in the selected process from the conversion buffer 30, and acquires the selected process. Apply to the item value and output the obtained item value. [Selection] Figure 1

Description

  The present invention relates to a data conversion system and a data conversion program.

  In order to improve the efficiency of the development of IoT applications that utilize device data and improve the reusability at the time of device change, a mechanism for uniformly accessing various device data is required. “IoT” is an abbreviation for Internet of Things.

  Patent Document 1 discloses a method of converting data based on a specification description of device data serving as original data and a required specification description of the application and providing the converted data to the application. By such a method, for example, it becomes possible to develop an application without being aware of whether speed information obtained from a device is expressed in km / hour or miles / hour.

Special table 2013-530431 gazette

  In the prior art, the original data item and the application data item need to correspond one-to-one, and cannot cope with various data conversions. For example, it cannot cope with a case where an item of application data is derived by combining a plurality of items of original data. In particular, it cannot cope with a case where a plurality of items of original data are obtained at different timings.

  An object of this invention is to respond | correspond to various data conversion.

A data conversion system according to an aspect of the present invention includes:
Analyzing the specifications for data conversion, and building a conversion buffer that stores the item value corresponding to the item name before conversion for each item name before conversion that is the item name of the data before conversion on the memory, For each post-conversion item name that is the post-conversion data item name, set a process for generating an item value corresponding to the post-conversion item name using the item value stored in the conversion buffer, At least one process is a process of generating an item value corresponding to an item name after conversion using a plurality of item values corresponding to different item names before conversion;
For each item name after conversion, select the process set by the specification analysis unit, acquire the item value used in the selected process from the conversion buffer, apply the selected process to the acquired item value, A conversion expression evaluation unit that outputs the obtained item value.

  In the present invention, various data conversions can be handled by the conversion buffer.

1 is a block diagram illustrating a configuration of a data conversion system according to a first embodiment. FIG. 3 shows a use case of the data conversion system according to the first embodiment. 4 is a flowchart showing an operation of a specification analysis unit of the data conversion system according to the first embodiment. FIG. 3 is a diagram illustrating a description example of application data specifications of the data conversion system according to the first embodiment. FIG. 3 is a diagram illustrating a description example of a conversion rule of the data conversion system according to the first embodiment. FIG. 3 is a block diagram illustrating a configuration example of a conversion buffer of the data conversion system according to the first embodiment. 4 is a flowchart showing an operation of a data decomposition unit of the data conversion system according to the first embodiment. 5 is a flowchart showing an operation of a conversion formula evaluation unit of the data conversion system according to the first embodiment. FIG. 3 is a block diagram showing a configuration of a data conversion system according to a modification of the first embodiment. The figure which shows the use case of the data conversion system which concerns on Embodiment 2. FIG. FIG. 10 is a diagram illustrating a description example of application data specifications of the data conversion system according to the second embodiment. FIG. 4 is a block diagram illustrating a configuration example of a conversion buffer of a data conversion system according to a second embodiment. FIG. 10 shows a use case of the data conversion system according to the third embodiment. FIG. 10 shows a description example of application data specifications of the data conversion system according to the third embodiment. FIG. 9 is a block diagram illustrating a configuration example of a conversion buffer of a data conversion system according to a third embodiment.

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

Embodiment 1 FIG.
This embodiment will be described with reference to FIGS.

  According to the system, method, and program according to the present embodiment, every time data items necessary for conversion are received by receiving a conversion formula that combines a plurality of data items sequentially given at different timings into different formats, the conversion result is obtained. By outputting, it is possible to flexibly realize conversion of received data into a total value, a difference value, or a cumulative value.

*** Explanation of configuration ***
With reference to FIG. 1, the structure of the data conversion system 10 which concerns on this Embodiment is demonstrated.

  The data conversion system 10 is a computer. The data conversion system 10 includes a processor 11 and other hardware such as a memory 12 and a communication device 13. The processor 11 is connected to other hardware via a signal line, and controls these other hardware.

  The data conversion system 10 includes a specification analysis unit 21, a data decomposition unit 22, and a conversion formula evaluation unit 23 as functional elements. The functions of the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23 are realized by software.

  The processor 11 is a device that executes a data conversion program. The data conversion program is a program that realizes the functions of the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23. The processor 11 is a CPU, for example. “CPU” is an abbreviation for Central Processing Unit.

  The memory 12 is a device that stores a data conversion program. The memory 12 is, for example, a flash memory or a RAM. “RAM” is an abbreviation for Random Access Memory.

  A conversion buffer 30 for converting device data 41 into application data 51 is constructed in the memory 12. The conversion buffer 30 includes an update area 31 for storing the latest data and a holding area 32 for storing past data.

  The communication device 13 includes a receiver that receives data input to the data conversion program and a transmitter that transmits data output from the data conversion program. The communication device 13 is, for example, a communication chip or a NIC. “NIC” is an abbreviation for Network Interface Card.

  In the present embodiment, device data 41, device profile 42, application data specification 52, and conversion rule 53 are received from the outside via communication device 13. The device profile 42, the application data specification 52, and the conversion rule 53 may be input via an input device or may be stored in advance in the memory 12 or the auxiliary storage device. The input device is, for example, a mouse, a keyboard, or a touch panel. The auxiliary storage device is, for example, a flash memory or an HDD. “HDD” is an abbreviation for Hard Disk Drive.

  In the present embodiment, application data 51 is transmitted to the outside via the communication device 13. The application data 51 may be displayed on the screen of the display, or may simply be stored in the memory 12 or the auxiliary storage device and used later. The display is, for example, an LCD. “LCD” is an abbreviation for Liquid Crystal Display.

  The data conversion program is read into the processor 11 and executed by the processor 11. The memory 12 stores not only the data conversion program but also the OS. “OS” is an abbreviation for Operating System. The processor 11 executes the data conversion program while executing the OS.

  The data conversion program and the OS may be stored in the auxiliary storage device. The data conversion program and OS stored in the auxiliary storage device are loaded into the memory 12 and executed by the processor 11.

  A part or all of the data conversion program may be incorporated in the OS.

  The data conversion system 10 may include a plurality of processors that replace the processor 11. The plurality of processors share the execution of the data conversion program. Each processor is, for example, a CPU.

  Data, information, signal values, and variable values used, processed, or output by the data conversion program are stored in the memory 12, the auxiliary storage device, or a register or cache memory in the processor 11.

  The data conversion program is a program that causes the computer to execute each process in which “part” in the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23 is read as “process”. Alternatively, the data conversion program is a program that causes the computer to execute each procedure in which the “part” of the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23 is read as “procedure”. The data conversion program may be provided by being recorded on a computer-readable medium, or may be provided as a program product.

  The data conversion system 10 may be composed of a single computer or a plurality of computers. When the data conversion system 10 is configured by a plurality of computers, the functions of the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23 may be realized by being distributed to each computer.

*** Explanation of operation ***
The operation of the data conversion system 10 according to the present embodiment will be described with reference to FIGS. 2 to 8 in addition to FIG. The operation of the data conversion system 10 corresponds to the data conversion method according to the present embodiment.

  In the present embodiment, when the device data 41 is converted into the application data 51, the device data 41 obtained at different timings can be used together by using the conversion buffer 30. As a specific example, as shown in FIG. 2, the device data 41 can correspond to a measurement value at a certain point in time, and can correspond to a case where an application requires a difference between two measurement values before and after.

  The operation of the specification analysis unit 21 will be described with reference to FIG. This operation is performed when the data conversion system 10 is initialized.

  In step S101, the specification analysis unit 21 receives an application data specification 52 including an item name as shown in FIG. 4 from the application. Further, the specification analysis unit 21 receives a conversion rule 53 including an item definition formula as shown in FIG. The specification analysis unit 21 analyzes the received application data specification 52 and the conversion rule 53.

In the example of FIG. 4, the outline of the notation used for the application data specification 52 is as follows.
A name beginning with “.” Represents an item name of the application data 51. The item name of the application data 51 corresponds to the column name of the database table.
The right side of “<−” represents an expression for deriving the item value of the application data 51.
A name beginning with “:” represents one of the following item names in the device data 41. Note that “ID” is an abbreviation for Idetifier.
-Time stamp ": timestamp"
-Device ID “: device”
-Data type name “: type”
-Value ": value"
A name beginning with “@” represents an item name obtained by decomposing the value of the device data 41. “@ Energy_30min” represents an item name corresponding to a measured value of power consumption for 30 minutes. “@ D1” represents an item name corresponding to a first value which is an arbitrary item value. “@ D2” represents an item name corresponding to a second value that is an arbitrary item value.
“Last ()” represents using a value corresponding to the item name in parentheses in the holding area 32 instead of the update area 31, that is, referring to past data.
“Key {}” represents that the item of the application data 51 in the range enclosed in parentheses is a key of the database table.

  In the example of FIG. 5, the conversion rule 53 represents that the left side is derived from the right side of “<−”. “@Energy_accum” represents an item name corresponding to an integrated value of power consumption that monotonously increases.

  In step S102, the specification analysis unit 21 creates a row of the conversion buffer 30 corresponding to the right side of the application data specification 52.

  In step S <b> 103, the specification analysis unit 21 applies the conversion rule 53 to the term on the right side of the application data specification 52 and adds the newly added item to the row of the conversion buffer 30.

  In step S <b> 104, the specification analysis unit 21 sets the left side of the application data specification 52, the right side of the application data specification 52, and the right side term of the conversion formula that is the result of applying the conversion rule 53 to the row of the conversion buffer 30. Corresponds to the operation tree to be referenced. At this time, the specification analysis unit 21 uses a known syntax analysis tree or the like as the operation tree. As described above, in the present embodiment, it is possible to store the arithmetic processing in the form of the arithmetic tree and call the reference destination value to obtain the value, but as a modification, the arithmetic processing is stored in the form of an equation, It is also possible to obtain the value with an interpreter. Alternatively, instead of storing the arithmetic processing in the conversion buffer 30, it may be possible to store it in another element as an arithmetic instruction or the like.

  In the example of FIG. 6, the item names of the application data 51 listed in the application data specification 52 are arranged on the output side of the conversion buffer 30, and the item of the device data 41 is on the input side of the update area 31 of the conversion buffer 30. Names are lined up. When the update area 31 of the conversion buffer 30 is regarded as a one-dimensional array, each element of the array corresponds to the row described above, and the item value of the device data 41 corresponding to the i-th row is stored in the i-th element. The In the present embodiment, the conversion buffer 30 is constructed as a separate hash table for each device ID of the transmission source of the device data 41, but one table may be constructed so as to correspond to a plurality of devices, It may be implemented with a data structure other than a hash table. In the present embodiment, the application data 51 is a record added to the database table, but may be output in other formats such as XML. “XML” is an abbreviation for Extensible Markup Language.

  The application data specification 52 shown in FIG. 4 requests that the value of the item “energy_30min” of the device data 41 be stored in the item “ENERGY” of the application data 51. If the device data 41 includes a measured value of power consumption for 30 minutes, the value can be used directly. In the conversion buffer 30 shown in FIG. 6, the value of “energy_30min” in the update area 31 is stored as it is in “ENERGY” of the application data 51. On the other hand, when there is a device X that reports only the integrated value of power consumption that increases monotonously instead of the measured value of power consumption for 30 minutes, the conversion rule 53 shown in FIG. In the conversion buffer 30 shown in FIG. 6, the value of “energy_30min” is derived from the value of “energy_accum” in the update area 31 and the value of “last (energy_accum)” in the holding area 32, and becomes “ENERGY” in the application data 51. Stored.

  As described above, in the present embodiment, by configuring the conversion buffer 30 according to all conversion methods that can derive the items of the application data 51, it is possible to similarly handle a plurality of devices that report the same information in different expressions.

  The application data specification 52 shown in FIG. 4 requests that the result of adding the value of the item “d1” of the device data 41 to the value of “D1” immediately before the item “D1” of the application data 51 is stored. ing. In the conversion buffer 30 shown in FIG. 6, the result of adding the value of “d1” in the update area 31 to the value of “last (D1)” in the holding area 32 is stored in “D1” of the application data 51, The stored value is held in the holding area 32.

  Thus, in the present embodiment, the accumulated value of the device data 41 can be used as the item of the application data 51.

  The application data specification 52 shown in FIG. 4 requests the item “D2” of the application data 51 to store values obtained from the values of the multiple items “d1” and “d2” of the device data 41. In the conversion buffer 30 illustrated in FIG. 6, the sum of the values “d1” and “d2” in the update area 31 is stored in “D2” in the application data 51.

  Thus, in the present embodiment, the total value of the device data 41 can be used as the item of the application data 51.

  As described above, in the present embodiment, the specification analysis unit 21 analyzes the application data specification 52 that is a specification for converting data, and converts the item name of the device data 41 on the memory 12. For each previous item name, a conversion buffer 30 for storing the item value corresponding to the pre-conversion item name is constructed. At this time, the specification analysis unit 21 performs a process of generating an item value corresponding to the post-conversion item name using the item value stored in the conversion buffer 30 for each post-conversion item name that is the item name of the application data 51. Set. In this embodiment, device data 41 is used as pre-conversion data, and application data 51 is used as post-conversion data. However, other types of pre-conversion and post-conversion data may be used.

  In the present embodiment, the specification analysis unit 21 constructs a conversion buffer 30 for each post-conversion item name that becomes a key in the application data 51 that is the post-conversion data.

  In the present embodiment, at least one of the processes set by the specification analysis unit 21 generates an item value corresponding to the post-conversion item name using a plurality of item values corresponding to different pre-conversion item names. It is processing to do. Specifically, the at least one process is a process of calculating an item value corresponding to the converted item name from the plurality of item values.

  In the application data specification 52 shown in FIG. 4, the sum of the item value “d1” of the device data 41 and the item value “d2” of the device data 41 corresponds to the item value “D2” of the application data 51. Is defined. Therefore, the specification analysis unit 21 sets the “d1” row and the “d2” row in the update area 31. The specification analysis unit 21 sets a process for calculating the sum of the item values stored in the “d1” and “d2” rows of the update area 31 and outputting the calculation result as the item value of “D2” in the operation tree. To do.

  In the present embodiment, the specification analysis unit 21 sets a process for generating an item value having the same value as the item value stored in the conversion buffer 30 as a process different from the at least one process.

  In the application data specification 52 illustrated in FIG. 4, it is defined that the item value “energy_30min” of the device data 41 corresponds to the item value “ENERGY” of the application data 51. Therefore, the specification analysis unit 21 sets a line “energy_30min” in the update area 31. The specification analysis unit 21 sets a process for outputting the same value as the item value stored in the “energy_30min” row of the update area 31 as the item value “ENERGY” in the operation tree.

  In the present embodiment, the specification analysis unit 21 converts the item value corresponding to the first item name that is one item name before conversion into the item value corresponding to the second item name that is another item name before conversion. When the conversion rule 53 is input, the item value corresponding to the first item name is changed to the first value as part of the process of generating the item value corresponding to the converted item name using the item value corresponding to the second item name. Set the process to convert to item values corresponding to two item names.

  In the conversion rule 53 illustrated in FIG. 5, an expression for converting the item value “energy_accum” of the device data 41 into the item value “energy_30min” is defined. Therefore, the specification analysis unit 21 sets a line “energy_accum” in the update area 31. The specification analysis unit 21 converts the item value stored in the “energy_accum” row of the update area 31 into the item value “energy_30min” in the operation tree, and sets the item value “energy_30min” as the item value “ENERGY”. Set the process to output.

  In the present embodiment, some of the processes set by the specification analysis unit 21 are converted items using the item values stored in the update area 31 and the item values stored in the holding area 32. This is a process for generating an item value corresponding to a name. Specifically, the part of the processing is the same as the item value corresponding to one pre-conversion item name stored in the update area 31 and the one pre-conversion item name stored in the holding area 32. This is a process of calculating the item value corresponding to the post-conversion item name from the item value corresponding to the pre-conversion item name.

  In the conversion rule 53 illustrated in FIG. 5, the item value “energy_accum” of the device data 41 corresponds to the integrated value of the item value “energy_30 min”. Therefore, as described above, the specification analysis unit 21 not only sets the “energy_accum” line in the update area 31 but also sets the “last (energy_accum)” line in the holding area 32. The specification analysis unit 21 calculates a difference between the item value stored in the “energy_accum” row of the update area 31 and the item value stored in the “last (energy_accum)” row of the holding area 32 in the operation tree. Then, a process for outputting the calculation result as an item value of “ENERGY” is set.

  In the present embodiment, the specification analysis unit 21 sets a plurality of different processes for at least one post-conversion item name as in the example of the process of outputting the item value “ENERGY” described above. Specifically, each of the plurality of processes is a process of generating an item value corresponding to the post-conversion item name using an item value corresponding to the pre-conversion item name of a combination that differs depending on the process.

  With reference to FIG. 7, the operation of the data decomposing unit 22 will be described. This operation is performed every time the data decomposing unit 22 receives the device data 41.

  In step S201, the data decomposition unit 22 interprets the value received as a single character string based on the data type name, and generates one or more pairs of item names and item values.

  In step S202, the data decomposing unit 22 calculates the key of the conversion buffer 30 from the item value, and searches for the conversion buffer 30 corresponding to the key value. At this time, if the conversion buffer 30 corresponding to the key value does not exist, the data decomposing unit 22 newly creates an empty conversion buffer 30 and sets the key value.

  In step S203, the data decomposing unit 22 searches the converted buffer 30 searched for each of the generated item values, and sets an item value corresponding to the item name.

  In step S <b> 204, the data decomposition unit 22 notifies the conversion formula evaluation unit 23 of reception of the device data 41.

  As described above, in the present embodiment, each time the data decomposition unit 22 acquires the device data 41 that is the data before conversion, the data decomposition unit 22 decomposes the acquired device data 41 and corresponds to the item name before conversion. Extract one or more item values. The data decomposing unit 22 stores the extracted item value in the update area 31.

  The operation of the conversion formula evaluation unit 23 will be described with reference to FIG. This operation is performed every time the conversion formula evaluation unit 23 receives a notification from the data decomposition unit 22.

  In step S301, the conversion formula evaluation unit 23 checks, for each item name of the application data 51, which is the data after conversion, whether there is an operation tree in which all the terms to be referenced are defined in the corresponding operation tree. .

  In step S <b> 302, the conversion expression evaluation unit 23 evaluates each operation tree if all the item names of the application data 51 correspond to operation trees in which all the terms to be referenced are defined, and the evaluation result is applied to the application data 51. Stored as an item value.

  In step S <b> 303, the conversion formula evaluation unit 23 stores the item value referred to by “last ()” as past data in the holding region 32 among the item value of the update region 31 and the item value of the application data 51. That is, the conversion formula evaluation unit 23 stores the update device 31 to the storage region 32 of the conversion buffer 30 so that the current device data 41 item and the output application data 51 item can be referred to when the device data 41 is received thereafter. To store.

  As described above, in the present embodiment, the conversion formula evaluation unit 23 selects a process set by the specification analysis unit 21 for each item name after conversion. The conversion formula evaluation unit 23 acquires item values used in the selected process from the conversion buffer 30 for each item name after conversion. The conversion formula evaluation unit 23 applies the selected process to the acquired item value for each item name after conversion, and outputs the obtained item value.

  As described above, in the present embodiment, the specification analysis unit 21 sets a plurality of different processes for at least one post-conversion item name. Therefore, the conversion formula evaluation unit 23 selects a process to be applied from among a plurality of processes set by the specification analysis unit 21 for the at least one post-conversion item name. Specifically, the conversion formula evaluation unit 23, when all the item values used in one of the plurality of processes are stored in the conversion buffer 30 for the at least one post-conversion item name, One process is selected as a process to apply.

  As a first specific example, it is assumed that the item value is stored in the “energy_30min” line of the update area 31 and the item value is not stored in the “energy_accum” line of the update area 31. In this case, the conversion formula evaluation unit 23 selects a process for outputting the same value as the item value stored in the “energy_30min” row of the update area 31 as the “ENERGY” item value of the application data 51 from the operation tree. And execute.

  As a second specific example, it is assumed that no item value is stored in the “energy_30min” line of the update area 31 and that an item value is stored in the “energy_accum” line of the update area 31. It is assumed that the item value is also stored in the “last (energy_accum)” line of the holding area 32. In this case, the conversion formula evaluation unit 23 calculates, from the operation tree, the item value stored in the “energy_accum” line of the update area 31 and the item value stored in the “last (energy_accum)” line of the holding area 32. The process of calculating the difference between the two and selecting and executing the process of outputting the calculation result as the item value of “ENERGY” of the application data 51 is executed.

  As described above, in the present embodiment, some of the processes set by the specification analysis unit 21 include the item value stored in the update area 31 and the item value stored in the holding area 32. This is a process for generating an item value corresponding to the post-conversion item name. Therefore, when the conversion formula evaluation unit 23 selects the part of the process, the conversion formula evaluation unit 23 acquires item values used in the selected process from the update area 31 and the holding area 32, and converts the selected process into the acquired item value. Apply and output the obtained item value. At this time, the conversion formula evaluation unit 23 uses the item value stored in the holding area 32 used in the selected process, the item value stored in the update area 31 used in the selected process, and the output item value. And update to either.

  In the second specific example, the conversion formula evaluation unit 23 converts the item value stored in the “last (energy_accum)” line of the holding area 32 into the item value stored in the “energy_accum” line of the update area 31. Update to

  As a third specific example, it is assumed that item values are stored in the “d1” and “d2” rows of the update area 31. In this case, the conversion formula evaluation unit 23 calculates the sum of the item value stored in the “d1” row of the update area 31 and the item value stored in the “d2” row of the update area 31 from the operation tree. A process of calculating and outputting the calculation result as the item value “D2” of the application data 51 is selected and executed.

*** Explanation of the effect of the embodiment ***
In the present embodiment, the conversion buffer 30 can support various data conversions.

  In this embodiment, since the conversion buffer 30 for temporarily storing received data is provided, the device data 41 received from different devices can be aggregated and converted.

  In the present embodiment, since the update area 31 and the holding area 32 are provided in the conversion buffer 30, the total value of the device data 41 received from the same device can be calculated and integrated. By appropriately changing the application data specification 52, other calculations such as a difference value calculation can be performed instead of the total value calculation.

  In the present embodiment, the conversion rule 53 is used and the conversion buffer 30 is configured corresponding to a plurality of conversion methods for obtaining the same conversion result, so that the data conversion system 10 and the data conversion system 10 and No changes to the application are required.

*** Other configurations ***
In the present embodiment, the functions of the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23 are realized by software. However, as a modification, the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23 These functions may be realized by hardware. About this modification, the difference with this Embodiment is mainly demonstrated.

  With reference to FIG. 9, the structure of the data conversion system 10 which concerns on the modification of this Embodiment is demonstrated.

  The data conversion system 10 includes hardware such as an electronic circuit 14 and a communication device 13.

  The electronic circuit 14 is dedicated hardware for realizing the functions of the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23. The electronic circuit 14 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 Specific Integrated Circuit.

  The data conversion system 10 may include a plurality of electronic circuits that replace the electronic circuit 14. The plurality of electronic circuits as a whole realize the functions of the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23. Each electronic circuit 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 specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23 may be realized by a combination of software and hardware. That is, some of the functions of the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23 may be realized by dedicated hardware, and the rest may be realized by software.

  The processor 11 and the electronic circuit 14 are both processing circuits. That is, regardless of the configuration of the data conversion system 10 shown in FIGS. 1 and 9, the functions of the specification analysis unit 21, the data decomposition unit 22, and the conversion formula evaluation unit 23 are realized by a processing circuit. .

Embodiment 2. FIG.
In this embodiment, differences from the first embodiment will be mainly described with reference to FIGS.

*** Explanation of configuration ***
The configuration of the data conversion system 10 according to the present embodiment is the same as that of the first embodiment shown in FIG.

*** Explanation of operation ***
The operation of the data conversion system 10 according to the present embodiment is the same as that of the first embodiment shown in FIG. 3, FIG. 7 and FIG. The conversion buffer 30 is different.

  In the present embodiment, as shown in FIG. 10, device data 41 is transmitted independently from a plurality of devices, and the application needs the result of aggregating measured values at the same time received from the plurality of devices at different times. Can handle the case.

  In the application data specification 52 shown in FIG. 11, “energy_30min_01” and “energy_30min_02” of the device data 41 from 99 devices whose right two digits of the device ID are “01”, “02”,. ,..., “Energy_30min_99” is defined to correspond to the item value “ENERGY” of the application data 51. Therefore, the specification analysis unit 21 sets the rows “energy_30min_01”, “energy_30min_02”,..., “Energy_30min_99” in the update area 31. The specification analysis unit 21 calculates the sum of the item values stored in the rows “energy_30min_01”, “energy_30min_02”,..., “Energy_30min_99” in the update area 31 in the operation tree, and the calculation result is “ENERGY”. Set the process to be output as item value.

  In the first embodiment, the device ID is a key, but in this embodiment, the device ID is 12 digits, and the group ID represented by the left 10 digits of the device ID is the key.

  It is assumed that the item values “energy_30min_01”, “energy_30min_02”,..., “Energy_30min_99” of the device data 41 from 99 devices are stored in all 99 rows corresponding to the update area 31. In this case, the conversion formula evaluation unit 23 calculates the sum of the item values stored in the rows “energy_30min_01”, “energy_30min_02”,..., “Energy_30min_99” in the update area 31 from the operation tree, A process to be output as the item value “ENERGY” of the application data 51 is selected and executed.

  In the first embodiment, the conversion buffer 30 is constructed as a separate hash table for each device ID of the transmission source of the device data 41. In this embodiment, the conversion buffer 30 is constructed as a separate hash table for each device group ID. Is done.

*** Explanation of the effect of the embodiment ***
In the present embodiment, as in the first embodiment, the conversion buffer 30 can support various data conversions. In this embodiment, in particular, it is possible to cope with a case where a plurality of items of original data are obtained at different timings.

Embodiment 3 FIG.
In the present embodiment, differences from the first embodiment will be mainly described with reference to FIGS.

*** Explanation of configuration ***
The configuration of the data conversion system 10 according to the present embodiment is the same as that of the first embodiment shown in FIG.

*** Explanation of operation ***
The operation of the data conversion system 10 according to the present embodiment is the same as that of the first embodiment shown in FIG. 3, FIG. 7 and FIG. The conversion buffer 30 is different.

  In the present embodiment, as a specific example, as shown in FIG. 13, device data 41 is transmitted independently from a plurality of devices, and device data 41 indicating the state at the same time received from the plurality of devices at different times is used as an application. Can be acquired in a batch.

  In the application data specification 52 shown in FIG. 14, “energy_30min_01” and “energy_30min_02” of the device data 41 from 99 devices whose right two digits of the device ID are “01”, “02”,. ,..., “Energy_30min_99” are defined to correspond to the item values “E01”, “E02”,..., “E99” of the application data 51, respectively. Therefore, the specification analysis unit 21 sets the rows “energy_30min_01”, “energy_30min_02”,..., “Energy_30min_99” in the update area 31. The specification analyzing unit 21 sets the same values as the item values stored in the rows “energy_30min_01”, “energy_30min_02”,..., “Energy_30min_99” in the update area 31 to “E01”, “E02”, ..., a process to be output as an item value of “E99” is set. For example, the specification analysis unit 21 sets a process of outputting the item value “energy_30min” as the item value “E01”.

  In the first embodiment, the device ID is a key, but in this embodiment, as in the second embodiment, the device ID is 12 digits, and the group is represented by the left 10 digits of the device ID. ID is the key.

  It is assumed that the item value “energy_30min_01” of the device data 41 from the device whose right two digits of the device ID is “01” is stored in the corresponding row of the update area 31. In this case, the conversion formula evaluation unit 23 selects processing for outputting the same value as the item value stored in the “energy_30min_01” row of the update area 31 as the item value of “E01” of the application data 51 from the operation tree. And execute.

  Similarly, the item values of “energy_30min_02”,..., “Energy_30min_99” of the device data 41 from the devices whose right two digits are “02”,..., “99” correspond to the update area 31. When stored in each row, the conversion formula evaluation unit 23 uses the same value as the item value stored in the “energy_30min_02”,..., “Energy_30min_99” row in the update area 31 from the operation tree, respectively. , “E02”,..., “E99” to be output as item values are selected and executed.

  In the first embodiment, the conversion buffer 30 is constructed as a separate hash table for each device ID of the transmission source of the device data 41. In this embodiment, the conversion buffer 30 is constructed as a separate hash table for each device group ID. Is done.

*** Explanation of the effect of the embodiment ***
In the present embodiment, as in the first embodiment, the conversion buffer 30 can support various data conversions. In this embodiment, in particular, it is possible to cope with a case where a plurality of items of original data are obtained at different timings.

  DESCRIPTION OF SYMBOLS 10 Data conversion system, 11 Processor, 12 Memory, 13 Communication apparatus, 14 Electronic circuit, 21 Specification analysis part, 22 Data decomposition part, 23 Conversion formula evaluation part, 30 Conversion buffer, 31 Update area | region, 32 Holding area | region, 41 Equipment data , 42 device profile, 51 application data, 52 application data specifications, 53 conversion rules.

Claims (10)

Analyzing the specifications for data conversion, and building a conversion buffer that stores the item value corresponding to the item name before conversion for each item name before conversion that is the item name of the data before conversion on the memory, For each post-conversion item name that is the post-conversion data item name, set a process for generating an item value corresponding to the post-conversion item name using the item value stored in the conversion buffer, At least one process is a process of generating an item value corresponding to an item name after conversion using a plurality of item values corresponding to different item names before conversion;
For each item name after conversion, select the process set by the specification analysis unit, acquire the item value used in the selected process from the conversion buffer, apply the selected process to the acquired item value, A data conversion system comprising a conversion formula evaluation unit that outputs the obtained item value. The specification analysis unit sets a plurality of different processes for at least one post-conversion item name,
The data conversion system according to claim 1, wherein the conversion formula evaluation unit selects a process to be applied from among a plurality of processes set by the specification analysis unit for the at least one post-conversion item name. Each of the plurality of processes is a process of generating an item value corresponding to the post-conversion item name using an item value corresponding to the pre-conversion item name of a combination that differs depending on the process,
The conversion formula evaluation unit applies the one process when all the item values used in one of the plurality of processes are stored in the conversion buffer for the at least one post-conversion item name. The data conversion system according to claim 2, wherein the data conversion system is selected as a process to be performed. The conversion buffer includes an update area and a holding area,
The data conversion system includes:
A data decomposing unit for decomposing the acquired data every time the pre-conversion data is acquired, extracting one or more item values corresponding to the pre-conversion item names, and storing the extracted item values in the update area; In addition,
Some of the processes set by the specification analysis unit use the item value stored in the update area and the item value corresponding to the post-conversion item name using the item value stored in the holding area Is a process for generating
When the conversion formula evaluation unit selects the partial process, the conversion formula evaluation unit acquires the item value used in the selected process from the update area and the holding area, and applies the selected process to the acquired item value. Output the obtained item value and output the item value stored in the holding area used in the selected process and the item value stored in the update area used in the selected process. The data conversion system according to any one of claims 1 to 3, wherein the data conversion system is updated to any one of item values. The part of processing includes an item value corresponding to one pre-conversion item name stored in the update area and a pre-conversion item name stored in the holding area and the same pre-conversion item name. It is a process to calculate the item value corresponding to the item name after conversion from the corresponding item value,
When the conversion formula evaluation unit selects the partial process, the item value stored in the holding area used in the selected process is the item stored in the update area used in the selected process. The data conversion system according to claim 4, wherein the data conversion system is updated with a value.   The specification analysis unit receives a conversion rule for converting an item value corresponding to a first item name which is one item name before conversion into an item value corresponding to a second item name which is another item name before conversion. In this case, as part of the process of generating the item value corresponding to the converted item name using the item value corresponding to the second item name, the item value corresponding to the first item name is set to the second item name. The data conversion system according to any one of claims 1 to 5, wherein a process for converting to a corresponding item value is set.   The data conversion system according to any one of claims 1 to 6, wherein the at least one process is a process of calculating an item value corresponding to an item name after conversion from the plurality of item values.   The said specification analysis part sets the process which produces | generates the item value of the same value as the item value stored in the said conversion buffer as a process different from the said at least 1 process. The data conversion system described in 1.   The data conversion system according to any one of claims 1 to 8, wherein the specification analysis unit constructs the conversion buffer for each post-conversion item name that is a key in the post-conversion data. On the computer,
Analyzing the specifications for data conversion, and building a conversion buffer that stores the item value corresponding to the item name before conversion for each item name before conversion that is the item name of the data before conversion on the memory, For each post-conversion item name that is the post-conversion data item name, set a process for generating an item value corresponding to the post-conversion item name using the item value stored in the conversion buffer, A specification analysis procedure in which at least one process is a process of generating an item value corresponding to an item name after conversion using a plurality of item values corresponding to different item names before conversion;
For each item name after conversion, select the process set by the specification analysis procedure, acquire the item value used in the selected process from the conversion buffer, apply the selected process to the acquired item value, A data conversion program for executing a conversion formula evaluation procedure for outputting the obtained item value.

Images