JP2007328669A - Measurement data storage system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a measurement data storage system which is capable of safely storing measurement data at a proper cost and ensuring the validity of measurement data by centralizing and collectively managing the measurement data. <P>SOLUTION: A measuring instrument, a server 42 for remote measurement which stores data obtained by execution of measurement, and browser terminals 44 and 75 for accessing the server for remote measurement are connected to a network 71, and the server for remote measurement is accessed by browser terminals, and measurement is executed on the basis of a selected measurement scenario, and obtained data is referenced. A user accessing the server 42 for remote measurement is checked by registered information. Since measurement can be executed from a remote place and measurement and data storage can be managed intensively, alteration and loss of data due to operation mistakes can be reduced and the man-hour for management can be considerably reduced. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a measurement data storage system capable of centrally managing measurement data such as inspection / measurement data and safely storing / using the same.

  In recent years, various measuring devices have been used, but measurement data as measurement results of these measuring devices are usually stored and operated under the responsibility of the operator of the measuring device. An example of such storage and operation mode is shown in FIG. Note that the measurement data here includes data continuously measured in observations, experiments, inspections, etc., waste and exhaust waste components and amounts, temperature, vibration, images, warehouse inventory, etc. included.

  In FIG. 6, measurement data 21 to 23 measured by the measurement devices 11 to 13 are stored in the database 31 as electronic records, stored and operated. In addition, a backup 32 of the database 31 is created as necessary to prepare for unexpected situations.

  With the development of computer technology and network technology, the environment that allows easy access to measurement data has become widespread, but as a result, measurement data can be easily changed. In particular, morality has recently declined, and there have been many incidents of falsifying inconvenient data, which has become a social problem. Therefore, there is an increasing need to prevent unauthorized access and store measurement data safely.

JP 2004-350085 A

  However, if the measurement data is stored safely with only a single measuring device, there is a problem that the labor of management increases and the overhead for auditing also increases.

  When the business operator tries to manage the measurement data independently, because of manual intervention, the risk of replacement and falsification of the measurement data increases, and it is difficult to check the validity of the data from the outside. In addition, measurement data storage management depends on the skill of the administrator and the system environment, and it takes a lot of time to safely manage the data, which increases the burden.

  Accordingly, an object of the present invention is to provide a measurement data storage system capable of safely storing measurement data at an appropriate cost and guaranteeing its correctness by centrally managing the measurement data in a centralized manner. is there.

In order to achieve such a problem, the invention according to claim 1 of the present invention is:
A measuring device connected to the network;
A database in which measurement data measured by the measurement device and data related thereto are stored;
A browser terminal connected to the network;
Connected to the network, manages information and status of the measurement device via the network, collects measurement data from the measurement device based on a selected measurement scenario, and obtains the measurement data and related data. A remote measurement server that stores in the database and outputs measurement data stored in the database to the browser terminal when there is a reference request from the browser terminal;
Is provided. The measuring device can be used from anywhere and the measured data can be referred to.

The invention according to claim 2 is the invention according to claim 1,
The remote measurement server registers user information and prevents unauthorized access by confirming the identity of the user who has logged in via the browser terminal based on the registered information. It is. Unauthorized actions such as data tampering can be prevented.

The invention according to claim 3 is the invention according to claim 1 or claim 2,
A plurality of users can log in to the remote measurement server, and an accessible range can be set for each user. Secure the system and data.

The invention according to claim 4 is the invention according to any one of claims 1 to 3,
The remote measurement server is operated by an operator different from the user, and the user can only refer to the measurement data stored in the database. Unauthorized actions can be prevented and system and data safety can be ensured.

The invention according to claim 5 is the invention according to any one of claims 1 to 4,
The remote measurement server includes a measurement data analysis unit that analyzes stored measurement data and creates a report based on the analysis result. Measurement, data analysis, and report creation can be done with one system.

The invention according to claim 6 is the invention according to any one of claims 1 to 5,
The remote measurement server uses a digital ID issued by a certificate authority to guarantee that a legitimate operator has performed data processing, and proves the authenticity of measurement data using a public key issued by the certificate authority. Is. Data falsification can be prevented.

The invention according to claim 7 is the invention according to any one of claims 1 to 6,
An audit log is created for changes to this measurement data management system, storage of measurement data, and creation of backups, and this audit log is output at the request of the user. Data loss can be prevented and the validity of the system and data can be confirmed.

The invention according to claim 8 is the invention according to any one of claims 1 to 7,
In the measurement scenario, an execution start time, a stop time, and a cycle can be specified. Users can be operated easily.

The invention according to claim 9 is the invention according to any one of claims 1 to 8,
The measurement data is analyzed simultaneously with the storage of the measurement data. A flexible diagnosis / alarm system can be configured.

As is apparent from the above description, the present invention has the following effects.
According to the first, second, third, fourth, fifth, sixth, seventh, eighth, and ninth aspects of the invention, the measurement device, the remote measurement server that stores the data obtained by executing the measurement, and the remote measurement A browser terminal for accessing the server is connected to the network, the remote measurement server is accessed by the browser terminal, the measurement is executed based on the selected measurement scenario, and the obtained data is referred to.

  Since measurement and data storage can be centrally managed, tampering and loss of data due to operational errors and the like can be prevented, and man-hours for management can be greatly reduced. Therefore, the burden on the manager can be greatly reduced, the shortage of skilled personnel can be solved, and the management cost can be reduced. In addition, the collective management has the effect of improving reliability and facilitating auditing.

  Also, unauthorized access can be prevented by confirming the identity of the user with registration information or authentication. Therefore, there is an effect that the reliability of data can be dramatically improved.

  Hereinafter, the present invention will be described in detail with reference to the drawings. FIG. 1 is a configuration diagram of an embodiment of a measurement data storage system according to the present invention. In FIG. 1, reference numeral 40 denotes a data center, which includes a database 41, a remote measurement server 42, a firewall 43 and a browser terminal 44. The data center 40 is managed by a dedicated operation manager. The browser terminal 44 is used by an operation manager or customer service.

  The database 41 includes device management information 41a, user management information 41b, measurement data ledger 41c, measurement report document data 41d, measurement data 41e, and audit log data 41f. The remote measurement server 42 is connected to the database 41, and includes an apparatus configuration management unit 42a, a measurement data collection management unit 42b, a measurement data storage management unit 42c, a measurement data analysis unit 42d, a measurement data reference unit 42e, an access management unit 42f, and an audit. A log unit 42g is incorporated. The remote measurement server 42 is connected to the network 71 via the firewall 43. Various data can be referred to by the browser terminal 44. The network 71 is assumed to be a network in a company or factory, but the Internet, a mobile phone network, a wireless network, etc. can also be used.

  Reference numeral 50 denotes a storage, in which device management information and backup data 51 and 52 of measurement data are stored. Reference numeral 72 denotes a certificate authority which can be used via the network 71. Reference numeral 60 denotes a factory, and measuring devices 63a and 63b are connected to the measurement objects 64a and 64b, respectively. These measuring devices 63 a and 63 b are connected to a network 71 via a hub 62 and a firewall 61. A browser terminal 75 that refers to measurement data and the like is connected to the network 71 via a hub 74 and a firewall 73. The firewalls 43, 61, and 73 are security devices that prevent outsiders from entering via the network 71.

  The remote measurement server 42 is a server having a function of controlling the measurement devices 63a and 63b in an integrated manner from a remote location using web service communication, and performs measurement processing according to a measurement scenario designated by the user. The obtained measurement data is processed into a specified format and stored in the database 41. In addition, user access restrictions can be registered, and measurement data can be stored safely by performing access management according to this access right. Further, the measurement data can be accessed and referenced from the outside using the browser terminal 75. The remote measurement server 42 communicates with the browser terminal 75 using a web service interface such as SOAP (Simple Object Access Protocol) or CORBA (Common Object Request Broker Architecture).

The device configuration management unit 42a is built in the remote measurement server 42 and has the following three functions.
1. Information on the measurement device to be used is registered in the device management information 41a, updated, and deleted. It also displays a list of registered devices.
2. Displays the status of registered devices, and checks and confirms them. That is, the status information of the apparatus is inquired and the response result is displayed.
3. In order to maintain consistency with the recording time of the registered device, the internal time of the remote measurement server 42 and the registered device is synchronized with the standard time provided by the network 71.

The measurement data collection management unit 42b is built in the remote measurement server 42 and collects data. The measurement data collection management unit 42b has the following three functions.
1. A measurement data set having a logical meaning is defined by combining physical measurement interface data of one or a plurality of measurement devices in advance.
2. Define and save a measurement scenario that includes specifying a URI (Universal Resource Identifier) corresponding to measurement data, setting measurement conditions, specifying setting parameters to be performed before starting measurement, and specifying the storage location of measurement data. This definition and storage is performed using the browser terminal 75.
3. Starts and executes the selected measurement scenario from the registered measurement scenarios. That is, the selected measurement scenario is read, the measurement device information defined in this scenario is read, all the devices or interfaces having URIs mapped to the measurement data are instructed sequentially, and the measurement data is received. To do. Then, all received measurement data is temporarily recorded in a format that conforms to the measurement data definition. The temporarily recorded measurement data is stored in the database specified by the measurement scenario after being processed by the measurement data storage management unit 42c.

  The measurement data storage management unit 42c is built in the remote measurement server 42 and stores measurement data. The measurement data storage management unit 42c stores measurement device information, attribute information such as measurement conditions and measurement date / time for each measurement data unit, hash value (MD5 etc.) calculated by a hash function, electronic signature, and time stamp for these data. Add and save in append mode. The hash value is used to check whether the data has been tampered with. The electronic signature is used to prove that the operation manager registered in the certificate authority 72 has collected and managed the measurement data and to guarantee the measurement data.

  The measurement data analysis unit 42d is built in the remote measurement server 42, analyzes the measurement data, and creates a report. The measurement data analysis unit 42d can add and expand applications that analyze stored measurement data and output reports in various formats. In addition, a function for displaying alarms and the like in the form of daily reports, weekly reports, monthly reports, trends, etc. can be added according to the user's request.

  The measurement data reference unit 42e is built in the remote measurement server 42, and has a function of referring to measurement data and an inspection report registered in the measurement data ledger 41c using the web service or the browser terminal 75.

  The access management unit 42f is built in the remote measurement server 42 and manages access to management resources such as stored measurement data, measurement device configuration information, measurement scenarios, and measurement data set definitions. Access authority can be set for each resource, but the user can only refer to the measurement data. The access is recorded in the audit log data 41f. Note that it is possible to set so that access to the measurement data is restricted on a user-by-user basis or on an organizational basis.

  The audit log unit 42g is built in the remote measurement server 42, records that various services such as setting change, execution collection, storage, and backup are properly operated, and audits these records in response to customer requests. It has a function to output as a record.

  The database 41 stores device management information 41a, user management information 41b, measurement data ledger 41c, measurement report document data 41d, measurement data 41e, and audit log data 41f.

  The device management information 41a is data for the user to register and refer to the unique information and management information of the measuring device, and the unique information for identifying the measuring device and interface is registered and assigned. This unique information includes managed device ID, device vendor, product model number, serial number, name, affiliation interface, last recorded date, remarks, scheduled maintenance date, status update date, request status, result status, installation information / customer ID Device attributes such as information / URI inspection request service are included. Further, in the inquiry about whether or not the status of the registered device is valid, the result is held as a status.

  The user management information 41b stores members who can access the remote measurement server 42 and their authority. Specifically, customer information such as a login ID, password, access authority, and contact information is included. The operation manager also stores the data as one of the access members.

  The measurement data ledger 41c is automatically created when remotely measured, and stores a list of measurement record information.

  The measurement report document data 41d is data in which the measurement report is recorded in a document format. The measurement report information 41d is issued by the certificate authority 72, measurement data information, measurement conditions, measurement period, measurement device used, customer information, hash value for preventing falsification. An electronic document to which electronic seal information created using a private key is added is included. The measurement report document data 41d is recorded every time the user executes the measurement scenario. When the measurement data is continuous data, a separate file configuration may be used, or the continuous data may be stored as variable length data in one record. Whether the report document is genuine can be checked every time it is accessed, or all records can be checked periodically.

  The measurement data 41e is data measured by the measurement devices 63a and 63b. When the measurement data is stored in a single electronic file, it is stored in a dedicated folder, and the directory path of the folder is registered in the measurement report document data 41d. By doing in this way, measurement data can be referred from a measurement report document.

  The audit log data 41f is a record of access to device management information and user management information, measurement report documents, and the like, and is automatically recorded.

  The storage 50 stores a backup 51 of device management information and a backup 52 of measurement data for countermeasures against device failures. These backups are periodically updated by the operation manager based on the operation rules and stored for a predetermined period. Note that the storage 50 uses a medium of a device in a different location from the data center 40.

  The measurement devices 63a and 63b are devices that generate measurement data, have at least one measurement interface and sensor corresponding to the measurement objects 64a and 64b, and measure physical quantities. The conversion from the measured signal to the measurement data may be performed by the measurement devices 63a and 63b, or may be performed by the host remote measurement server 42.

  The measuring devices 63 a and 63 b have a function corresponding to web service communication and can be connected to the network 71. That is, it has a function of accepting a web service request and returning it in response to the request, assigning a URI to the measurement interface, and specifying this URI to access measurement data. This web service communication function may be built in the measuring devices 63a and 63b or may be externally attached.

  When the Internet or the like is used for the network 71, security is required. In this case, communication using IPSec (Security Architecture for Internet Protocol), https (Hyper Text Transfer Protocol Security), or the like is used, or an authentication ID is issued to confirm whether the other party's measuring device is authentic. To.

  The browser terminal 75 is a personal computer or PDA (Personal Digital Assistants) equipped with a browser function, and browses the device information of the measurement devices 63a and 63b managed by the remote measurement server 42, and is also provided by the remote measurement server 42. Used to receive various services.

  The certificate authority 72 can be used via the network 71. By registering the remote measurement server 42 and the measurement devices 63a and 63b and users and operators of these devices to the certificate authority 72, issuing a digital ID of the registrant and providing a public key, It is used to realize a function that prevents spoofing and proves the authenticity of measurement data. The certificate authority 72 may be a public certificate authority, or may be a private certificate authority as long as the environment is accessible from the user via the network 71.

  FIG. 2 shows the relationship among the user, the dedicated operation manager, the remote measurement server 42, and the measurement devices 63a and 63b. When the user registers / updates the user registration information / device information, the access management unit 42f and the device configuration management unit 42a register the user management information 41b and the user ID access management for registering / updating the device management information 41a. Perform device information management. When the device information management is performed, the statuses of the measuring devices 63a and 63b are read.

  When the user creates a measurement scenario, the remote measurement server 42 registers the scenario and sets parameters of the measurement devices 63a and 63b. The measuring devices 63a and 63b set parameters of the measurement objects 64a and 64b as necessary.

  When the user sets measurement conditions and instructs execution of measurement, the remote measurement server 42 executes the registered scenario. That is, the measurement devices 63a and 63b are instructed to perform data measurement and transmission to collect measurement data, and this data is safely recorded in the database 41. The measurement devices 63a and 63b access the measurement objects 64a and 64b and perform measurement.

  When the user instructs the reference of the measurement data or analysis data or the printing of the report, the measurement data analysis unit 42d analyzes the data and creates a report. The measurement data reference unit 42e performs a data reference process.

  In addition, the measurement devices 63a and 63b access the measurement objects 64a and 64b as necessary, and perform local diagnosis or storage of measurement data.

  The full-time operation manager performs maintenance of the data center 40 by performing processing such as operation operation, system monitoring / management, database area setting, user registration management, and backup.

  FIG. 3 describes the user's instruction and the corresponding operation over time. When the user logs in to the data center 40, the access management unit 42f checks whether the user is a registered user, and permits access if the user is a valid user.

  When the user requests display of a scenario that has already been registered, the remote measurement server 42 displays a candidate measurement scenario. The user selects one of the displayed scenarios and instructs execution. The remote measurement server 42 reads the measurement device specified in the scenario, outputs a parameter, and sets measurement conditions. The measurement devices 63a and 63b output measurement conditions for the measurement objects 64a and 64b as necessary, and output OK to the remote measurement server 42 when the condition setting is completed.

  Next, the remote measurement server 42 requests the measurement devices 63a and 63b to perform measurement, and the measurement devices 63a and 63b return measurement data. When the measurement of all the measurement devices is completed, the remote measurement server 42 requests transmission of all measurement data including the measurement data temporarily stored in the measurement device, converts it into the format specified in the measurement scenario, and specifies it. Store in position. After that, the measurement data is read, checked, and displayed according to the user's request.

  FIG. 4 shows an example of a measurement record document format. In addition, the same code | symbol is attached | subjected to the same element as FIG. 1, and description is abbreviate | omitted. In FIG. 4, format 1 is an example of a recorded document used for individual measurement, and measurement data here is described following customer ID information, measurement device information, and measurement conditions. Finally, a hash value including a checksum, an electronic signature, and a time stamp are described.

  Format 2 is an example of a recorded document used in the case of continuous measurement, in which measurement data is described after measurement conditions including customer ID information and measurement time, and finally a hash value, an electronic signature, and a time stamp are described. These recorded documents are created with reference to the measurement data 41e and stored in the measurement report document data 41d in the database 41. It is also printed in the form of a report upon request.

  FIG. 5A is an example of a measurement scenario definition. The owner of the scenario, the database for recording measurement data and file information, the file path to the measurement data structure, the measurement conditions, and the target measurement device are specified in this order. be written. In the designation of the measuring device, request contents such as a URI, input / output setting parameters, and output time are described in order.

  FIG. 5B shows an example of the measurement data structure definition, which describes the definition of the corresponding item and the data type. That is, for all measurement data, URI, data description, data tag name, and data type are defined. Note that XML (Extensible Markup Language) may be used for expression description.

  If the measurement scenario function is expanded so that the execution start time, stop time, and cycle can be specified, data can be collected and recorded automatically without bothering the user. System that can be used more easily by the user.

  Further, by adding a function capable of analyzing and diagnosing the measurement data at the same time as storing the measurement data, a flexible diagnosis and alarm system combining a plurality of measurement data can be configured. It was difficult to add this function with a conventional measuring device.

  In addition, when this measurement data storage system is used, a more accurate fire alarm system is configured by combining smoke detection signals and image information, and a monitoring / intrusion detection system is combined by combining intrusion alarm signals and image information. A highly reliable alarm device can be configured by flexibly combining measuring devices.

  Furthermore, if user registration information and access rights can be set in detail, it is possible to provide a cheaper proxy service for a plurality of customers.

It is a block diagram which shows one Example of this invention. It is a figure which shows the relationship between a user, the server for remote measurement, a measuring device, and a measuring object. It is a figure for demonstrating the flow of measurement. It is a figure which shows the example of a measurement recording document format. It is a figure which shows the example of a definition of a measurement scenario and a measurement data structure. It is a figure which shows the conventional measurement data and its operation procedure.

Explanation of symbols

40 data center 41 database 41a device management information 41b user management information 41c measurement data ledger 41d measurement report document data 41e measurement data 41f audit log data 42 remote measurement server 42a device configuration management unit 42b measurement data collection management unit 42c measurement data storage Management unit 42d Measurement data analysis unit 42e Measurement data reference unit 42f Access management unit 42g Audit log unit 43, 61, 73 Firewall 44, 75 Browser terminal 50 Storage 51 Device management information 52 Measurement data 60 Factory 62, 74 Hub 63a, 63b Measuring device 64a, 64b Measuring object 71 Network 72 Certification authority

Claims (9)

A measuring device connected to the network;
A database in which measurement data measured by the measurement device and data related thereto are stored;
A browser terminal connected to the network;
Connected to the network, manages information and status of the measurement device via the network, collects measurement data from the measurement device based on a selected measurement scenario, and obtains the measurement data and related data. A remote measurement server that stores in the database and outputs measurement data stored in the database to the browser terminal when there is a reference request from the browser terminal;
A measurement data storage system comprising:   The remote measurement server registers user information and prevents unauthorized access by confirming the identity of the user who has logged in via the browser terminal based on the registered information. The measurement data storage system according to claim 1.   The measurement data storage system according to claim 1 or 2, wherein a plurality of users can log in to the remote measurement server, and an accessible range can be set for each user.   4. The remote measurement server is operated by an operator different from a user, and the user can only refer to measurement data stored in the database. Measurement data storage system described.   5. The remote measurement server includes a measurement data analysis unit that analyzes stored measurement data and creates a report based on the analysis result. Measurement data storage system described.   The remote measurement server uses a digital ID issued by a certificate authority to guarantee that a legitimate operator has processed the data, and proves the authenticity of the measurement data using a public key issued by the certificate authority. The measurement data storage system according to any one of claims 1 to 5, wherein   An audit log is created for the change of the measurement data management system, the storage of the measurement data, and the creation of a backup, and the audit log is output according to a user's request. 6. The measurement data storage system according to any one of 6.   The measurement data storage system according to claim 1, wherein an execution start time, a stop time, and a cycle can be specified for the measurement scenario. The measurement data storage system according to claim 1, wherein the measurement data is analyzed simultaneously with the storage of the measurement data.

Images