JP5250614B2 - Data collection system - Google Patents

Description

  The present invention relates to a data collection system. The present invention particularly relates to a system for collecting and acquiring data from different places and different types of measuring devices.

  Buildings scattered throughout the country are equipped with multiple types of measuring equipment sold by various manufacturers, and can measure building voltage and power consumption. These measuring devices output the measurement results in their own formats (XML (extensible, markup, language) and CSV (comma, separated values, values)), but there is no unified standard. In addition, the types of measuring devices and formats are increasing year by year, and there are devices that do not have contact points with the network.

  The Law Concerning the Rational Use of Energy (Energy Conservation Law) has been revised, and it has become mandatory to report the amount of energy used by companies with a certain size of office buildings and multiple locations. For this reason, in many companies, it is necessary to collect data in various formats from a plurality of types of measuring devices for each building or base, and to manage them centrally.

  Conventionally, each definition information that defines operation / diagnosis data of different data formats output from the diagnosis terminals of elevators of different models is provided in the database, and operation / diagnosis data that differs for each elevator model based on the definition information There is a system that analyzes the data and stores it in a database (for example, see Patent Document 1). In addition, there is a system that searches a database storing a plurality of data formats, determines a data format of information transferred from a remotely monitored device, and analyzes the information using the determined data format (for example, , See Patent Document 2).

JP 2005-231850 A JP 2004-145890 A

  As described above, various measuring devices that measure voltage and electric energy for each manufacturer are on the market. However, measurement result data is output in a unique format for each manufacturer and model. Alternatively, it is acquired manually. Conventionally, there has been no mechanism for collecting data with different output formats in a batch. In addition, since the types of measuring instruments differ from building to building, companies with multiple locations had to collect data for each building. In addition, since there is no mechanism corresponding to a plurality of formats of each manufacturer, it is difficult to centrally manage data with different formats.

  In the conventional system, there is a problem that efficient processing cannot be performed because it is necessary to specify a format by referring to a database every time data is acquired.

  For example, an object of the present invention is to efficiently store a plurality of types of output data output from a measuring device or the like in a common format and manage them in a unified manner.

A data collection system according to one aspect of the present invention includes:
A data collection system that collects a plurality of types of output data that is output from at least one device and that has a format determined for each type,
A terminal device for storing a plurality of authentication data in a storage device in advance for each format of output data;
In addition to having multiple storage areas set for each authentication data, multiple conversion processes for converting the format of output data to a common format, each of which is executed for each storage area, are implemented A server device,
The terminal device
A data acquisition unit for acquiring, by an input device, a plurality of types of output data output from the at least one device;
Data transmission for reading the corresponding authentication data from the storage device for each format of output data, accessing the server device using the authentication data, and transmitting the output data acquired by the data acquisition unit to the server device And
The server device
Data storage for receiving output data transmitted by the data transmission unit and storing the output data in a storage area set in the authentication data used by the data transmission unit every time accessed by the data transmission unit And
For each storage area, a corresponding conversion process is executed by the processing device to convert the format of the output data stored by the data storage unit into the common format, and a data storage unit for storing the output data in a database; Have.

The database stores a list indicating combinations of the plurality of storage areas and the plurality of conversion processes,
The data storage unit identifies conversion processing to be executed for each storage area with reference to the list,
The server device further includes:
When a new combination is added to the list, new authentication data corresponding to the format of output data converted by the conversion processing of the combination is issued by the processing device, and the storage area of the combination is processed in the authentication data A data setting unit is set by the apparatus.

The database stores a list indicating combinations of the plurality of storage areas and the plurality of conversion processes,
The data storage unit identifies conversion processing to be executed for each storage area with reference to the list,
The terminal device further includes:
A format notification unit for notifying the server device of the format of output data;
The server device further includes:
And a list management unit for adding a combination of a new storage area and a conversion process for converting the format of the output data to the common format when the format notification unit notifies the format of the output data.

The server device further includes:
When new authentication data is issued by the data setting unit, the data setting unit notifies the terminal device of the authentication data.

  The data transmission unit transmits the output data acquired by the data acquisition unit to the server device using FTP (File / Transfer / Protocol).

  The data acquisition unit acquires, as the at least one device, a plurality of types of output data indicating measured values of energy usage output from devices that measure energy usage.

  In one aspect of the present invention, the terminal device acquires a plurality of types of output data output from the device, accesses the server device using the corresponding authentication data for each format of the output data, and acquires the output data Is transmitted to the server device. Each time the server device is accessed by the terminal device, it receives the output data transmitted by the terminal device, stores the output data in the storage area set in the authentication data used by the terminal device, and stores it. For each area, a corresponding conversion process is executed to convert the format of the output data into a common format. For this reason, it becomes possible to efficiently store a plurality of types of output data output from a measuring device or the like in a common format and manage them centrally.

1 is a block diagram illustrating an example of a configuration of a data collection system according to Embodiment 1. FIG. The figure which shows an example of (a) output data which concerns on Embodiment 1, (b) list | wrist, (c) the output data converted by the conversion process. FIG. 3 is a diagram illustrating an example of a hardware configuration of a terminal device and a server device according to the first embodiment. 3 is a flowchart showing an example of the operation of the data collection system according to the first embodiment. 3 is a flowchart showing an example of the operation of the data collection system according to the first embodiment. 3 is a flowchart showing an example of the operation of the data collection system according to the first embodiment. FIG. 4 is a block diagram illustrating an example of a configuration of a data collection system according to a second embodiment. 9 is a flowchart showing an example of the operation of the data collection system according to the second embodiment. FIG. 4 is a block diagram illustrating an example of a configuration of a data collection system according to a third embodiment. 10 is a flowchart illustrating an example of the operation of the data collection system according to the third embodiment.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

Embodiment 1 FIG.
FIG. 1 is a block diagram showing an example of the configuration of the data collection system 100 according to the present embodiment.

  In FIG. 1, a data collection system 100 is a system that collects a plurality of types of output data 111 output from a measurement device 101. The data collection system 100 includes a PC 200 (personal computer), a server group 300, and a DB 400 (database).

  The measuring device 101 is a device installed at least one at each of the plurality of bases 121. The measuring device 101 measures the amount of energy used at each site 121 and outputs at least one type of output data 111 indicating the measured value of the amount of energy used. The amount of energy used refers to the amount of electricity, gas, fuel, heat, water, etc. used at each site 121, as well as those that can be measured in relation to them (voltage, etc.). The output data 111 has a format defined for each different type. The types of output data 111 are classified according to, for example, the measurement target, the measurement frequency, and the model (manufacturer or model) of the measurement device 101. The measuring device 101 transmits the output data 111 to the PC 200 and stores it in the PC 200, or simply stores the output data 111 in a recording medium (for example, a memory card). At this time, it is desirable that the measuring device 101 stores the output data 111 in a storage area (for example, a folder) defined for each type of the output data 111 in the PC 200 or the recording medium.

  In FIG. 1, four models of measurement device A, measurement device B, measurement device C, and measurement device F are shown as examples of the model of measurement device 101. In addition, as examples of the base 121, three buildings of A building, B building, and C building are shown. As examples of the format of the output data 111, seven types of A1, A2, A3, B1, B2, C1, and C2 are shown.

  In building A, two measuring devices A and one measuring device B are installed. One of the measuring devices A outputs the output data 111 of A1, and the other outputs the output data 111 of A2. Device B outputs the output data 111 of A3. In Building B, only one measuring device C is installed, and the measuring device C outputs the output data 111 of B1 and the output data 111 of B2. In the C building, the measuring device A and the measuring device F are installed one by one, the measuring device A outputs the output data 111 of C1, and the measuring device F outputs the output data 111 of C2.

  For example, the measuring device A of A building outputs data indicating the power consumption of air conditioning on each floor of A building and the power consumption of lighting on each floor of A building as output data 111 of A1 every hour. Another measuring device A in the building A outputs data indicating the gas consumption of each floor of the building A as output data 111 of the A2 every hour. The measuring device B of A building outputs data indicating the water usage amount of each floor of the A building as output data 111 of A3 every day. In addition, for example, the measuring device C of the B building outputs data indicating the power consumption of the air conditioning of each floor of the B building and the power consumption of the lighting of each floor of the B building as the output data 111 of the B1 every hour. Data indicating gas consumption of each floor of the building is output as output data 111 of B2 every hour. Here, FIG. 2A shows an example of the output data 111 of A1 and B1. In the example of FIG. 2A, the output data 111 of A1 indicates the measurement target (for example, air conditioning on the first floor, air conditioning on the second floor,... Lighting on the first floor, lighting on the second floor,...). Along with the unique number to be identified, this is data indicating the accumulated power consumption (unit: kilowatts) every 5 minutes for 1 hour from 1 o'clock to 2 o'clock. The output data 111 of B1 is data indicating the power consumption (unit: kilowatts) every 5 minutes for 1 hour from 1 o'clock to 2 o'clock together with a unique number similar to the output data 111 of A1.

  Note that the number of models of the measuring device 101 is not limited to four, and may be one model, two models, three models, or five or more models. Further, the number of bases 121 is not limited to three, and may be one, two, or four or more. For example, even if there is only one base 121 and only one measuring device 101 is installed at the base 121, a plurality of types of output data 111 may be output from the measuring device 101. For example, by adopting a system similar to the present embodiment, the effects described below can be obtained.

  Further, the format of the output data 111 is not necessarily different for each measurement target and measurement frequency, and a common format may be determined for different measurement targets and measurement frequencies. Furthermore, the format of the output data 111 is not necessarily different for each model and installation location (base 121) of the measuring device 101, and a common format may be defined for different models and installation locations.

  In the present embodiment, the measuring device 101 that outputs the output data 111 that indicates the measured value of the energy consumption is used as the measuring device that outputs the output data that indicates other measured values (for example, measured values of weather and the environment). Alternatively, even if it is replaced with a device that outputs output data indicating another value (for example, sales amount of a store), if a plurality of types of output data are output from the device, the following effects can be obtained. It is done.

  At least one PC 200 is installed at each of the plurality of bases 121. The server group 300 is installed in one place or distributed in a plurality of places. The DB 400 is connected to the server group 300 and is installed at the same or different location as the server group 300. The PC 200 and the server group 300 are connected to the network 103 via the router 102 and communicate with each other via the network 103. The protocol used for communication is not limited to a specific one, but here, it is assumed that IP (Internet Protocol) is used as an example.

  In the example of FIG. 1, one PC 200 is installed in each of A building, B building, and C building. In the A building PC 200, a transmission program 201 that performs communication using FTP (File, Transfer, Protocol) operates. In the B building PC 200, a browser 202 that performs communication using HTTP (HyperText, Transfer, Protocol) operates. In the PC 200 of C building, both the transmission program 201 and the browser 202 operate. In the example of FIG. 1, the server group 300 and the DB 400 are installed in the data center 122. The server group 300 is realized as one or a plurality of server computers, and an FTP server 301, an HTTP server 302, and a DB server 303 operate on the server computer. In the figure and the following description, the transmission program 201, the browser 202, the FTP server 301, the HTTP server 302, and the DB server 303 are not only software, but also elements necessary for executing the software (processing to be described later) Including hardware such as a device and a storage device). The same applies to a data capturing program 304, a monitoring program 307, and a management program 308, which will be described later as part of the DB server 303. For example, in FIG. 1, the transmission program 201, the browser 202, the FTP server 301, the HTTP server 302, the DB server 303, and the data import program 304 are shown as blocks, but each block is realized by a combination of software and hardware. It is what is done. In each block, each unit of the PC 200 and the server group 300 (a data acquisition unit 211, a data transmission unit 212, a data storage unit 311, a data storage unit 312 and the like which will be described later) is also shown as separate (smaller) blocks. These blocks are also realized by a combination of software and hardware.

  The PC 200 is an example of a terminal device, and includes a data acquisition unit 211 and a data transmission unit 212. In the example of FIG. 1, a data acquisition unit 211 and a data transmission unit 212 are installed in each of the transmission program 201 and the browser 202. The operations of the data acquisition unit 211 and the data transmission unit 212 will be described later.

  The server group 300 is an example of a server device, and includes a data storage unit 311 and a data storage unit 312. In the example of FIG. 1, the data storage unit 311 is mounted on each of the FTP server 301 and the HTTP server 302, and the data storage unit 312 is mounted on the data capturing program 304 that is a part of the DB server 303. The operations of the data storage unit 311 and the data storage unit 312 will be described later.

  Although not shown in FIG. 1, the PC 200 and the server group 300 include hardware such as a processing device, a storage device, an input device, and an output device. The hardware is used by each part of the PC 200 and the server group 300. For example, the processing device is used to perform calculation, processing, reading, writing, and the like of data and information in each unit of the PC 200 and the server group 300. The storage device is used to store the data and information. The input device is used for inputting the data and information, and the output device is used for outputting the data and information.

  FIG. 3 is a diagram illustrating an example of a hardware configuration of the PC 200 (terminal device) and the server group 300 (server device).

  In FIG. 3, a PC 900 or a computer 900 that is a server computer for realizing the server group 300 includes an LCD 901 (Liquid / Crystal / Display), a keyboard 902 (K / B), a mouse 903, and an FDD 904 (Flexible / Disk / Drive). And hardware devices such as a CDD 905 (Compact Disc Drive) and a printer 906. These hardware devices are connected by cables and signal lines. Instead of the LCD 901, a CRT (Cathode / Ray / Tube) or other display device may be used. Instead of the mouse 903, a touch panel, a touch pad, a trackball, a pen tablet, or other pointing devices may be used.

  The computer 900 includes a CPU 911 (Central Processing Unit) that executes a program. The CPU 911 is an example of a processing device. The CPU 911 includes a ROM 913 (Read / Only / Memory), a RAM 914 (Random / Access / Memory), a communication board 915, an LCD 901, a keyboard 902, a mouse 903, an FDD 904, a CDD 905, a printer 906, and an HDD 920 (Hard / Disk) via a bus 912. Connected with Drive) to control these hardware devices. Instead of the HDD 920, a flash memory, an optical disk device, a memory card reader / writer, or other storage medium may be used.

  The RAM 914 is an example of a volatile memory. The ROM 913, the FDD 904, the CDD 905, and the HDD 920 are examples of nonvolatile memories. These are examples of the storage device. The communication board 915, the keyboard 902, the mouse 903, the FDD 904, and the CDD 905 are examples of input devices. The communication board 915, the LCD 901, and the printer 906 are examples of output devices.

  The communication board 915 is connected to a LAN (Local / Area / Network) or the like. The communication board 915 is a WAN (Wide Area Network) such as an IP-VPN (Internet, Protocol, Virtual, Private, Network), a wide area LAN, or an ATM (Asynchronous / Transfer / Mode) network via a LAN or the like. Connected to the internet. WAN and the Internet are examples of the network 103.

  The HDD 920 stores an operating system 921 (OS), a window system 922, a program group 923, and a file group 924. The programs in the program group 923 are executed by the CPU 911, the operating system 921, and the window system 922. The program group 923 includes programs that execute the functions described as “˜units” in the description of the present embodiment. The program is read and executed by the CPU 911. The file group 924 includes data, information, and signal values described as “˜data”, “˜information”, “˜ID (identifier)”, “˜flag”, and “˜result” in the description of this embodiment. And variable values and parameters are included as items of “˜file”, “˜database”, and “˜table”. The “˜file”, “˜database”, and “˜table” are stored in a storage medium such as the RAM 914 or the HDD 920. Data, information, signal values, variable values, and parameters stored in a storage medium such as the RAM 914 and the HDD 920 are read out to the main memory and the cache memory by the CPU 911 via a read / write circuit, and extracted, searched, referenced, compared, and calculated. It is used for processing (operation) of the CPU 911 such as calculation, control, output, printing, and display. During the processing of the CPU 911 such as extraction, search, reference, comparison, calculation, calculation, control, output, printing, and display, data, information, signal values, variable values, and parameters are temporarily stored in the main memory, cache memory, and buffer memory. Remembered.

  The arrows in the block diagrams and flowcharts used in the description of this embodiment mainly indicate input / output of data and signals. Data and signals are recorded in memory such as RAM 914, FDD904 flexible disk (FD), CDD905 compact disk (CD), HDD920 magnetic disk, optical disk, DVD (Digital Versatile Disc), or other recording media Is done. Data and signals are transmitted by a bus 912, a signal line, a cable, or other transmission media.

  In the description of the present embodiment, what is described as “to part” and “to program” may be “to circuit”, “to device”, and “to device”, and “to step” and “to device”. -"Step", "-Procedure", "-Process" may be used. That is, what is described as “˜unit” and “˜program” may be realized by firmware stored in the ROM 913. Alternatively, what is described as “˜unit” and “˜program” may be realized only by software or only by hardware such as an element, a device, a board, and wiring. Alternatively, what is described as “˜unit” and “˜program” may be realized by a combination of software and hardware, or a combination of software, hardware and firmware. Firmware and software are stored in a recording medium such as a flexible disk, a compact disk, a magnetic disk, an optical disk, and a DVD as a program of the program group 923. The program is read by the CPU 911 and executed by the CPU 911. That is, the program causes the computer to function as “˜unit” and “˜program” described in the description of the present embodiment. Alternatively, the program causes a computer to execute the procedures and methods of “˜unit” and “˜program” described in the description of the present embodiment.

  In FIG. 1, the PC 200 stores a plurality of authentication data 112 for receiving authentication from the server group 300 in a storage device in advance for each format of the output data 111. For example, the A building PC 200 stores a combination of a user ID (identifier) and a password for logging in to the FTP server 301 in the storage device one by one in association with each of A1, A2, and A3. The B building PC 200 stores a combination of a user ID and a password for logging in to the HTTP server 302 in a storage device one by one in association with B1 and B2.

  The server group 300 has a plurality of folders 305 set for each authentication data 112 in the storage device. Then, the server group 300 stores the set identifier (for example, folder name) of the folder 305 for each authentication data 112 in a storage device in advance. For example, the DB server 303 has folders 305 with names “10001”, “10002”, “10003”, “10004”, and “10005”. The FTP server 301 stores “10001”, “10002”, and “10003” in order in the storage device in association with combinations of user IDs and passwords corresponding to A1, A2, and A3. The HTTP server 302 stores “10004” and “10005” in order in the storage device in association with combinations of user IDs and passwords corresponding to B1 and B2. Note that both the FTP server 301 and the HTTP server 302 may store all the authentication data 112 and the identifier of the folder 305 in the storage device in association with each other. Further, instead of the folder 305, a table of the DB 400 (for example, a list 113 described later) or other storage area may be set and used for each authentication data 112. Further, the authentication data 112 stored in the FTP server 301 and the HTTP server 302, the identifier of the folder 305, and the like may be stored in the table of the DB 400 instead.

  In the data capturing program 304 of the server group 300, a plurality of conversion processes 306 for converting the format of the output data 111 into a common format are implemented. As will be described later, the conversion process 306 is executed for each folder 305. The DB 400 stores a list 113 indicating a combination of a folder 305 and a conversion process 306 to be executed on the output data 111 stored in the folder 305. For example, the data import program 304 includes an A1, A2, A3, B1, and B2 processes for converting formats such as A1, A2, A3, B1, and B2 into formats that can be stored in a common table of the DB 400, respectively. Etc. are implemented. Here, FIG. 2B shows an example of the list 113. In the example of FIG. 2B, the list 113 includes a name “10001” of the folder 305 and A1 processing, and a combination of the building A and the measuring device A as the corresponding base 121 and measuring device 101 models. Is stored as one record. Similarly, the table of the list 113 includes “10002”, A2 processing, combination of A building and measuring device A, “10003”, A3 processing, combination of A building and measuring device B, and “10004” and B1 processing. And a combination of B building and measuring device C, “10005”, a combination of B2 processing, B building and measuring device C, and the like are stored as a record group.

  Hereinafter, the operation of the data collection system 100 (the data collection method according to the present embodiment, the processing procedure of the data collection program according to the present embodiment) will be described with reference to the example of FIG.

  FIG. 4 is a flowchart illustrating an example of operations of the transmission program 201 of the PC 200 in the A building and the FTP server 301 of the server group 300.

  In step S101, the transmission program 201 (data acquisition unit 211) periodically checks whether the output data 111 of A1 output from the measuring device A of A building is stored in the folder corresponding to A1 (preferably , By the processing device) (every hour according to the measurement frequency of the output data 111 of A1). The output data 111 of A1 is transmitted from the measuring device A of the A building via the LAN or the like every hour if the measuring device A of the A building is operating normally, and is received by the input device of the PC 200 and received from the A1. It is stored in the folder corresponding to. If it is confirmed that the output data 111 of A1 is stored, the process proceeds to step S102. If the output data 111 of A1 is not stored, the process proceeds to step S109.

  In step S102, the transmission program 201 (data acquisition unit 211) reads the output data 111 of A1 from the folder corresponding to A1.

  In step S103, the transmission program 201 (data transmission unit 212) stores, from the storage device, the combination of the user ID and password corresponding to the same format (ie, A1) of the output data 111 as the folder from which the output data 111 was read in step S102. read.

  In step S104, the transmission program 201 (data transmission unit 212) transmits the user ID and password read in step S103 to the FTP server 301 to request login.

  In step S105, the FTP server 301 (data storage unit 311) receives the user ID and password transmitted in step S104, and confirms whether or not the received user ID and password are stored in the storage device. If the user ID and password are not stored, the transmission program 201 is notified of the login failure and the process ends. If the user ID and password are stored, the process proceeds to step S106.

  In step S106, the FTP server 301 (data storage unit 311) acquires the name “10001” of the folder 305 corresponding to the user ID and password received in step S105 from the storage device, and notifies the transmission program 201 of the successful login. At the same time, the transmission program 201 is connected to the folder 305 of “10001”.

  In step S107, the transmission program 201 (data transmission unit 212) transmits the output data 111 of A1 read in step S102 to the FTP server 301 and stores it in the folder 305 “10001”. That is, the FTP server 301 (data storage unit 311) receives the output data 111 of A1 transmitted by the transmission program 201 (data transmission unit 212), and stores the received output data 111 of A1 in the folder 305 “10001”. save.

  In step S108, the transmission program 201 (data transmission unit 212) deletes the output data 111 that has been transmitted in step S107, or archives it and stores it in another folder or the like.

  In step S109, if there is an unprocessed folder (unconfirmed in step S101), the process returns to step S101 to set the folder as a new processing target. Therefore, the processing of steps S101 to S108 is also executed for the output data 111 of A2 transmitted from another measuring device A of A building and the output data 111 of A3 transmitted from the measuring device B of A building.

  The processing in steps S101 to S109 is also executed by the transmission program 201 and the FTP server 301 of the C building PC 200. Therefore, the processing of steps S101 to S108 is also executed for the output data 111 of C1 transmitted from the measuring device A of C building.

  Note that the FTP used in the processing of steps S101 to S109 is not limited to the FTP defined by RFC (Request For Comments) 959, but FTPS defined by RFC2228 and RFC4217 (FTP / over / SSL / (TLS), etc., may be a protocol that applies or extends FTP (in the present application, “FTP” simply includes FTPS and the like).

  FIG. 5 is a flowchart showing an example of the operation of the browser 202 of the PC 200 of Building B and the HTTP server 302 of the server group 300.

  In step S201, the browser 202 (data transmission unit 212) is operated by the user of the PC 200 and reads the combination of the user ID and password corresponding to B1 from the storage device. Note that the browser 202 (data transmission unit 212) may accept manual input of a combination of the user ID and password corresponding to B1 from the user by the input device.

  In step S202, the browser 202 (data transmission unit 212) transmits the user ID and password read in step S201 to the HTTP server 302 to request login.

  In step S203, the HTTP server 302 (data storage unit 311) receives the user ID and password transmitted in step S202, and confirms whether or not the received user ID and password are stored in the storage device. If the user ID and password are not stored, the browser 202 is notified of the login failure and the process ends. If the user ID and password are stored, the process proceeds to step S204.

  In step S204, the HTTP server 302 (data storage unit 311) acquires the name “10004” of the folder 305 corresponding to the user ID and password received in step S202 from the storage device, and notifies the browser 202 of successful login. .

  In step S205, the browser 202 (data acquisition unit 211) outputs the B1 output data output from the measuring device C of the B building from the folder (preferably the folder corresponding to B1) in the memory card attached to the PC 200. 111 is read. This memory card is obtained by allowing the user of the PC 200 to store the output data 111 of B1 in the above-mentioned folder in the measuring device C of the B building, and is inserted into the PC 200 by the user of the PC 200 every hour (or at an arbitrary timing). Is done.

  In step S206, the browser 202 (data transmission unit 212) transmits the output data 111 of B1 read in step S205 to the HTTP server 302.

  In step S207, the HTTP server 302 (data storage unit 311) receives the B1 output data 111 transmitted in step S206, and receives the name of the received B1 output data 111 in “10004” obtained in step S204. Save to folder 305.

  In step S208, if there is output data 111 in an unprocessed format (not transmitted in step S205), the process returns to step S201, and the output data 111 in the format is set as a new processing target. Accordingly, the processing of steps S201 to S207 is also executed for the output data 111 of B2 output from the measuring device C of B building.

  The processing in steps S201 to S208 is also executed by the browser 202 and the HTTP server 302 of the PC 200 of C building. Accordingly, the processing of steps S201 to S207 is also executed for the output data 111 of C2 output from the measuring device F of C building.

  Note that the processing in steps S201 to S208 may be executed by the browser 202 of the PC 200 and the FTP server 301 using FTP instead of HTTP.

  In steps S201 to S208, instead of using different authentication data 112 for each format of output data 111, authentication data 112 assigned to each base 121 may be used. In this case, the HTTP server 302 stores a combination of a user ID and a password for each base 121 in the storage device. In step S204, the HTTP server 302 (data storage unit 311) refers to the storage device and identifies the base 121 corresponding to the user ID and password received in step S202. In step S <b> 205, the browser 202 (data transmission unit 212) accepts specification of the format of the output data 111 to be transmitted from now on (for example, selectable by a pull-down list or the like) from the user by the input device. In step S206, when transmitting the output data 111 to the HTTP server 302, the browser 202 (data transmission unit 212) notifies the HTTP server 302 of the format of the output data 111 specified in step S205. The HTTP server 302 (data storage unit 311) refers to the list 113 of the DB 400 and identifies the folder 305 corresponding to the base 121 identified in step S204 and the conversion process 306 used for the format notified from the browser 202. In step S207, the HTTP server 302 (data storage unit 311) receives the output data 111 transmitted in step S206, and stores the received output data 111 in the folder 305 specified in step S206. In step S208, if there is output data 111 in an unprocessed format (not transmitted in step S205), the process returns to step S205, and the output data 111 in the format is set as a new processing target.

  As described above, the data acquisition unit 211 of the PC 200 acquires a plurality of types of output data 111 output from the measurement device 101 using the input device. The data transmission unit 212 of the PC 200 reads the corresponding authentication data 112 from the storage device for each format of the output data 111, accesses the server group 300 using the authentication data 112, and acquires data using FTP, HTTP, or the like. The output data 111 acquired by the unit 211 is transmitted to the server group 300. The data storage unit 311 of the server group 300 receives the output data 111 transmitted by the data transmission unit 212 each time it is accessed by the data transmission unit 212, and uses the output data 111 for the authentication used by the data transmission unit 212. The data is stored in the folder 305 set in the data 112.

  FIG. 6 is a flowchart showing an example of the operation of the data import program 304 of the DB server 303 of the server group 300.

  In step S301, the data capturing program 304 (data storage unit 312) periodically checks whether the A1 output data 111 is stored in the folder “10001” 305 (preferably, the measurement frequency of the output data 111 of A1). Check with the processing equipment every hour). If it is confirmed that the output data 111 of A1 is stored, the process proceeds to step S302. If the output data 111 of A1 is not stored, the process proceeds to step S305.

  In step S302, the data import program 304 (data storage unit 312) reads the output data 111 of A1 from the folder 305 of “10001”.

  In step S303, the data import program 304 (data storage unit 312) refers to the list 113 of the DB 400 and performs the A1 process as the conversion process 306 (conversion process 306 to be executed) corresponding to the folder 305 of “10001”. Specified.

  In step S304, the data capture program 304 (data storage unit 312) executes the A1 process specified in step S303 on the A1 output data 111 read in step S302 by the processing device and shares the A1 output data 111. Is converted into output data 114 of the format. Then, the data capturing program 304 (data storage unit 312) stores the output data 114 in the common format in the DB 400.

  If there is an unprocessed folder 305 in step S305 (unconfirmed in step S301), the process returns to step S305, and the folder 305 is set as a new processing target. Therefore, the processing in steps S301 to S304 is executed for folders 305 other than “10001”, that is, folders 305 such as “10002”, “10003”, “10004”, and “10005”.

  Here, FIG. 2C shows an example of the output data 114 converted by the conversion process 306. In the example of FIG. 2C, the output data 114 includes the base 121 (for example, A building, B building,...), The measurement location (for example, the first floor, the second floor,...), And the type of measurement target. 1 (for example, power consumption, gas consumption, water usage,...), Measurement type 2 (for example, air conditioning, lighting, gas, water,...), Measurement value for one hour, unit (For example, it is determined automatically from the type of the measurement target or is used if it is indicated by the output data 111 before conversion). It should be noted that other information such as the model of the measuring device 101 may be included. 2C specifically shows an example in which the output data 111 of A1 and B1 in the example of FIG. 2A is converted into output data 114 in a common format. Since the output data 111 of A1 indicates the integrated power consumption every 5 minutes, the integrated power consumption of the last 5 minutes is output as the measured value of the corresponding output data 114 by the A1 process and stored in the DB 400. Is done. On the other hand, since the B1 output data 111 indicates the power consumption (not the integrated value) every 5 minutes, all the power consumption is added by the B1 process, and the total value is the corresponding output data 114. The measured value is output and stored in the DB 400.

  As described above, the data storage unit 312 of the server group 300 executes, for each folder 305, the corresponding conversion processing 306 by the processing device and the format of the output data 111 stored by the data storage unit 311 to a common format. The output data 114 is converted and stored in the DB 400. For this reason, according to the present embodiment, it is possible to efficiently store a plurality of types of output data 111 output from the measuring device 101 in a common format and manage them in an integrated manner. .

  As described above, in the present embodiment, the data capturing program 304 of the DB server 303 of the server group 300 has a data capturing function that can support any data format when collecting data from the plurality of bases 121. Therefore, it becomes easy to manage data of different formats in a unified manner. The user can acquire information from different measuring devices 101 as centrally managed information.

  According to the present embodiment, when a new model of the measuring device 101 or a new format of the output data 111 is added, the corresponding folder 305 and processing program (conversion processing 306) are created and the authentication data 112 is updated. Since it is only necessary to issue and update the list 113 of the DB 400, it is possible to respond quickly. In particular, each base 121 can transmit any data as long as it knows the user ID and password, and there is no need to develop the transmission program 201 or the like each time. Therefore, a system with high versatility and expandability can be provided.

  Further, according to the present embodiment, since the folder 305 is divided for each model of the base 121 and the measuring device 101 (that is, the format of the output data 111), the data can be captured without permanently mixing the data. Yes. Further, since data can be fetched in a batch for each folder 305, efficient processing is possible.

  Further, according to the present embodiment, even if the model of the base 121 and the measuring device 101 (that is, the format of the output data 111) is the same, the captured data (output data 114) can be changed by changing the corresponding processing function (conversion processing 306). ) Can be changed.

Embodiment 2. FIG.
In the present embodiment, differences from the first embodiment will be mainly described.

  FIG. 7 is a block diagram showing an example of the configuration of the data collection system 100 according to the present embodiment.

  In FIG. 7, the server group 300 further includes a data setting unit 313 and a data notification unit 314. In the example of FIG. 7, the data setting unit 313 and the data notification unit 314 are implemented in the monitoring program 307 that is a part of the DB server 303. Other configurations are the same as those of the first embodiment shown in FIG. FIG. 7 does not show a part of the data shown in FIG. 1 (data storage unit 312 or the like), but this is simply omitted.

  Hereinafter, the operation of the data collection system 100 (the data collection method according to the present embodiment and the processing procedure of the data collection program according to the present embodiment) will be described with reference to the example of FIG.

  FIG. 8 is a flowchart illustrating an example of the operation of the monitoring program 307 of the DB server 303 of the server group 300.

  In step S401, the monitoring program 307 (data setting unit 313) checks the list 113 of the DB 400 periodically (for example, every day) by the processing device. When a new record is added to the list 113 (for example, when a record having a creation time after the previous confirmation is confirmed), the process proceeds to step S402. Here, as an example of a new record, the name “10008” of the new folder 305 (the folder 305 of “10008” has not yet been created and does not exist at this time), and A4 which is the new conversion process 306 A combination of processing (A4 processing is already implemented at this point), A building, and a new measuring device D installed in A building (outputting output data 111 of A4) is added To do.

  In step S402, the monitoring program 307 (data setting unit 313) adds a new format corresponding to the format (ie, A4) of the output data 111 converted by the conversion processing 306 (ie, A4 processing) of the record added to the list 113. A valid user ID and password combination is issued by the processing device. Specifically, the monitoring program 307 (data setting unit 313) determines a new user ID and password combination corresponding to A4 by the processing device so that the user ID does not overlap with an existing one.

  In step S403, the monitoring program 307 (data setting unit 313) uses the processing device to set the folder 305 “10008” designated by the record added to the list 113 for the user ID and password issued in step S402. . Specifically, the monitoring program 307 (data setting unit 313) creates the folder 305 “10008” designated by the record added to the list 113, and the user determined in step S402 together with the name “10008”. The ID and password are transmitted to the FTP server 301. The FTP server 301 stores “10008” transmitted at the same time in the storage device in association with the combination of the transmitted user ID and password (that is, the combination of the user ID and password corresponding to A4). As a result, the processing in steps S301 to S304 can be executed for the folder 305 of “10008”.

  In step S404, the monitoring program 307 (data notification unit 315) transmits the user ID and password issued in step S402 to the PC 200 and stores them in the storage device in association with A4. As a result, the processing of steps S101 to S108 can be executed for the output data 111 of A4 transmitted from the measuring device D of the A building. Note that step S404 may be omitted, and the user ID and password issued in step S402 may be manually notified (for example, by e-mail, facsimile, telephone, letter, etc.) to the user of the PC 200 or the like. In this case, the PC 200 acquires a newly issued combination of user ID and password from the user or the like via the input device, and stores the combination in A4 in association with A4.

  Note that the processing in steps S401 to S404 can be similarly executed when a new measuring device 101 is installed in a B building or a C building, or when a new base 121 is added. For example, when a new measuring device 101 is installed in Building B, in step S403, the monitoring program 307 (data setting unit 313) adds the user ID and password determined in step S402 to the record added to the list 113. It is transmitted to the HTTP server 302 together with the name of the included folder 305. The HTTP server 302 stores the name of the folder 305 transmitted at the same time in the storage device in association with the combination of the transmitted user ID and password. In step S404, the monitoring program 307 (data notification unit 315) transmits the user ID and password issued in step S402 to the PC 200 of B building, and output data 111 output from the new measuring device 101 of B building. Are stored in the storage device in association with the format. Thereby, the process of step S201-S207 can be performed also about the output data 111 output from the new measuring device 101 of B building.

  As described above, when a new combination is added to the list 113 of the DB 400, the data setting unit 313 of the server group 300 performs a new authentication corresponding to the format of the output data 111 converted by the conversion processing 306 of the combination. Data 112 is issued by the processing device. Then, the data setting unit 313 sets the combination folder 305 in the authentication data 112 by the processing device. For this reason, according to the present embodiment, the format of the output data 111 can be efficiently added.

  Further, according to the present embodiment, when the data notification unit 314 of the server group 300 issues new authentication data 112 by the data setting unit 313, the PC 200 side notifies the PC 200 of the authentication data 112. Renewal work can be performed quickly and efficiently.

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

  FIG. 9 is a block diagram showing an example of the configuration of the data collection system 100 according to the present embodiment.

  In FIG. 9, the PC 200 further includes a format notification unit 213. In the example of FIG. 9, the format notification unit 213 is installed in each of the transmission program 201 and the browser 202. The server group 300 further includes a list management unit 315. In the example of FIG. 9, the list management unit 315 is implemented in the management program 308 that is a part of the DB server 303. Other configurations are the same as those of the second embodiment shown in FIG. 9 does not show part of the data shown in FIG. 7 (data setting unit 313, data notification unit 314, etc.), this is merely omitted.

  Hereinafter, the operation of the data collection system 100 (the data collection method according to the present embodiment and the processing procedure of the data collection program according to the present embodiment) will be described with reference to the example of FIG.

  FIG. 10 is a flowchart illustrating an example of operations of the transmission program 201 of the PC 200 in the A building and the management program 308 of the DB server 303 in the server group 300.

  In step S501, the transmission program 201 (format notifying unit 213) inputs the information indicating that a new measuring device D is installed in the A building (A4 is added as the format of the output data 111) to the user. Alternatively, the information is received from the measuring device D by the input device, and the information is transmitted to the monitoring program 307.

  In step S502, the management program 308 (list management unit 315) receives the information transmitted in step S501.

  In step S503, the management program 308 (list management unit 315) determines the name “10008” of the new folder 305 by the processing device.

  In step S504, the management program 308 (list management unit 315) implements A4 processing, which is a new conversion processing 306, by the processing device. At this time, for example, if the definition information related to A4 is included in the information received in step S502, the management program 308 (list management unit 315) automatically implements the A4 processing based on the definition information, Or, request external developers to implement A4 processing.

  In step S505, the management program 308 (list management unit 315) determines “10008” determined in step S503, the A4 process implemented in step S504, the A building indicated by the information received in step S502, and the A building. Is added to the list 113 of the DB 400 by the processing device as a new record.

  The information notified (transmitted) from the PC 200 side to the server group 300 side in step S501 may be information directly indicating the format of the output data 111, or substantially indicates the format of the output data 111. It may be information. As the former information, for example, notification of A4 can be considered. As the latter information, for example, it is conceivable to notify the measuring device D on the assumption that the format of the output data 111 output from the measuring device D is A4 only.

  The processing in steps S501 to S505 is not limited to the case where a new measuring device 101 is installed at the base 121, but when the existing measuring device 101 outputs output data 111 in a format different from the previous one. Is also performed in the same way. Further, when a new measuring device 101 is installed at the base 121, the new measuring device 101 may output the output data 111 in the same format as other measuring devices 101. Similarly, when an existing measuring device 101 outputs output data 111 in a format different from the conventional one, the measuring device 101 outputs output data 111 in the same format as the other measuring devices 101. There may be things. For example, when the measuring device D newly installed in the A building outputs the same B1 output data 111 as the measuring device C in the B building, first, the processing of steps S501 to S503 is executed. After that, in step S504, the management program 308 (list management unit 315) refers to the list 113 and the like, and specifies the B1 process as the existing conversion process 306 by the processing device. In step S505, the management program 308 (list management unit 315) determines “10008” determined in step S503, the B1 process specified in step S504, the A building indicated by the information received in step S502, and the A building. The processing device adds the combination with the measuring device D installed in the DB 400 to the list 113 of the DB 400 as a new record. At this time, step S503 may be omitted, and the folder 305 in which the output data 111 of B1 output from the measuring device C of B building is stored may be shared. That is, in step S505, a record including the existing “10004” instead of the new “10008” may be added as the name of the folder 305.

  As described above, the format notification unit 213 of the PC 200 notifies the server group 300 of the format of the new output data 111. The list management unit 315 of the server group 300, when notified of the format of the new output data 111 by the format notification unit 213, performs a new conversion process for converting the format of the new folder 305 and the output data 111 into a common format. The combination with 306 is added to the list 113 of the DB 400. For this reason, according to the present embodiment, the format of the output data 111 can be added more efficiently.

  In the present embodiment, the format notification unit 213 of the PC 200 may be implemented in a browser or the like different from the transmission program 201. In addition, when the format notifying unit 213 is notified of the format of the new output data 111 by the format notifying unit 213, the list management unit 315 of the server group 300 acquires the corresponding conversion process 306 from the code table held in advance by the DB 400. The process 306 may be added to the list 113 of the DB 400. For example, the DB 400 uses a combination of the model of the measuring device 101 (which may be used in the future, but also not used at this time) and a conversion process 306 (which may be plural) prepared in advance. Assume that a code table to be managed (stored) is held. It is assumed that a combination of the measuring device D and the A4 process is already stored in this code table. In step S501, after the new measuring device D is installed in the building A, the user of the PC 200 displays the contents of the code table displayed on the pull-down menu or the like by the browser or the like (format notifying unit 213). The combination of the measuring device D and the A4 process is selected from the DB 400 via the group 300), and information on the base 121 is input. The browser or the like (format notifying unit 213) transmits information selected and input by the user to the server group 300. In steps S502 to S505, the management program 308 (list management unit 315) of the DB server 303 of the server group 300 receives information transmitted from a browser or the like, and adds one record to the list 113 based on this information. At this time, in the record to be added, an automatically numbered name (not duplicated with others) is set as the name of the folder 305. Thereafter, unlike the second embodiment, the folder 305 with the name may be created manually. Also, the corresponding new authentication data 112 may be set manually. That is, the authentication data 112 may be manually registered on each of the PC 200 side and the server group 300 side.

  100 data collection system, 101 measuring device, 102 router, 103 network, 111 output data, 112 authentication data, 113 list, 114 output data, 121 sites, 122 data centers, 200 PC, 201 transmission program, 202 browser, 211 data acquisition Unit, 212 data transmission unit, 213 format notification unit, 300 server group, 301 FTP server, 302 HTTP server, 303 DB server, 304 data import program, 305 folder, 306 conversion process, 307 monitoring program, 308 management program, 311 data Storage unit, 312 data storage unit, 313 data setting unit, 314 data notification unit, 315 list management unit, 400 DB, 900 computer, 901 LCD 902 keyboard, 903 mouse, 904 FDD, 905 CDD, 906 Printer, 911 CPU, 912 Bus, 913 ROM, 914 RAM, 915 communication board, 920 HDD, 921 operating system, 922 Window system, 923 Program group, 924 File group.

Claims (6)

In a data collection system that collects a plurality of types of output data output from at least one device and having a format determined for each type,
A terminal device for storing authentication data different for each format of output data in a storage device in advance;
In addition to having multiple storage areas set for each authentication data, multiple conversion processes for converting the format of output data to a common format, each of which is executed for each storage area, are implemented A server device,
The terminal device
A data acquisition unit for acquiring, by an input device, a plurality of types of output data output from the at least one device;
For any one type of output data acquired from the plurality of types of output data acquired by the data acquisition unit, (1) reading authentication data corresponding to the format of the one type of output data from the storage device, (2) ) and the request to log by transmitting authentication data before Symbol server device (3) if a successful login has been notified from the server apparatus, and transmits the one of the output data to the server apparatus, (1 ) To (3) including a data transmission unit that executes each type of output data other than the one type of output data among the plurality of types of output data acquired by the data acquisition unit ,
The server device
Each time that will receive authentication data transmitted by the data transmission unit, the authentication data to determine whether legitimate, if the authentication data is legitimate, the successful login to the data transmission unit and notifies said in a storage area set in the authentication data to connect the data transmission unit receives the output data transmitted by the data transmission unit, a data storage unit for storing the output data in the storage area ,
For each storage area, a corresponding conversion process is executed by the processing device to convert the format of the output data stored by the data storage unit into the common format, and a data storage unit for storing the output data in a database; A data collection system comprising: The database stores a list indicating combinations of the plurality of storage areas and the plurality of conversion processes,
The data storage unit identifies conversion processing to be executed for each storage area with reference to the list,
The server device further includes:
When a new combination is added to the list, new authentication data corresponding to the format of output data converted by the conversion processing of the combination is issued by the processing device, and the storage area of the combination is processed in the authentication data The data collection system according to claim 1, further comprising a data setting unit set by an apparatus. The database stores a list indicating combinations of the plurality of storage areas and the plurality of conversion processes,
The data storage unit identifies conversion processing to be executed for each storage area with reference to the list,
The terminal device further includes:
A format notification unit for notifying the server device of the format of output data;
The server device further includes:
A list management unit for adding a combination of a new storage area and a conversion process for converting the format of the output data to the common format to the list when the format notification unit notifies the format of the output data; The data collection system according to claim 1. The server device further includes:
The data collection system according to claim 2, further comprising a data notification unit that notifies the terminal device of the authentication data when new authentication data is issued by the data setting unit.   5. The data collection according to claim 1, wherein the data transmission unit transmits the output data acquired by the data acquisition unit to the server device using FTP (File / Transfer / Protocol). system.   The said data acquisition part acquires the multiple types of output data which show the measured value of energy usage output from the apparatus which measures energy usage as said at least 1 apparatus from Claim 1 characterized by the above-mentioned. 5. The data collection system according to any one of 5.

Images