JP2000259728A - Monitor system and facility management system, and data managing method in the same system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable data retrieval which does not depend upon a database management system and to easily enable associative management among databases by giving an identification code common to respective systems to an object to be monitored or managed and constructing a database. SOLUTION: In a monitor system database 201 and a facility management system database 301, data to the same device 101 are registered. Here, item names and item numbers which are managed to the device 101 are not the same between both the databases. Thus, a GUID is given to the same facilities or device 101 to be managed or monitored. Consequently, data can be associated by using the GUID. After, for example, the data association, a monitor system terminal 202 can easily retrieve even an item which is not present in the monitor database regardless of differences in specifications between the database management systems of the monitor system and facility management system.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a monitoring system and a facility management system for monitoring and managing devices and building facilities, and more particularly to managing data relating to devices and facilities in each system in cooperation with a plurality of systems. The present invention relates to a monitoring system and a facility management system suitable for use in the system, and a data management method in the system.

[0002]

2. Description of the Related Art In recent years, for a building such as a building, and facilities and devices in the building, a monitoring system for monitoring and managing the operation status of the facilities and devices, and asset information and the like of the facilities and devices have been provided. Automation of a facility management system for management has been promoted. In such a system, generally, data for the facilities and devices managed by each system is individually compiled into a database and managed individually in each system.

[0003]

As described above, in the conventional system, the database and the system are individually constructed and managed in each of the monitoring system and the facility management system. For example, it is difficult to link data with the same device or equipment, and for example, it is complicated to perform data search for the same device or device between the monitoring system and the equipment management system. Also, when it is necessary to create or change data for equipment and devices managed by multiple systems, it is necessary to create and change data individually in each system, which complicates database management work. I was

According to the present invention, in a plurality of monitoring and facility management systems, not only a database search system but also a data search system can be searched, and a cooperative management among a plurality of databases can be easily performed.
It is an object of the present invention to provide a monitoring system and a facility management system capable of performing data management using a plurality of databases including a database of another system, and a data management method in the system.

[0005]

Means for Solving the Problems In order to solve the above problems, the invention according to claim 1 specifies a facility or an apparatus in a system for monitoring one or more facilities or apparatuses. In one other system, including identification data commonly assigned to the facility or device, a plurality of data relating to the facility or device, a database that manages each facility or device, and using the identification data, Means for searching for data relating to the equipment or device specified by the identification data from the database of the other system, and using the data in the database of the searched other system, creating data in the database of the own system; Changing means. The invention according to claim 2 is characterized in that the identification data is a numerical value that is unique worldwide.

According to a third aspect of the present invention, in a system for managing one or more facilities or apparatuses, the facilities or apparatuses are specified, and the facilities are commonly used in at least one other system. Or, including identification data given to the device, a plurality of data on the facility or device, a database to manage for each facility or each device,
Using the identification data, means for searching for data relating to the equipment or apparatus specified by the identification data from a database of another system, and using the data in the database of the searched other system, And means for creating and changing data in the file. The invention according to claim 4 is characterized in that the identification data is a numerical value that is unique worldwide.

[0007] The invention according to claim 5 provides the invention according to claims 1 to
4. In the system according to any one of (4), when newly registering equipment or apparatus data in the database of the own system, the same equipment or the same equipment in the database of another system or the database common to each system. When the data corresponding to the device is not included, an identification code is assigned to the device or the device, and the identification code is assigned to the device or the device in the database of the own system or the database of the own system and the database common to each system. Create and register data for the equipment or device from the identification code and the other data that can be changed in the own system with respect to the equipment or device. When data corresponding to the same equipment or device is included in the database, select the data, In the database of the system, create and register data for the facility or device from the identification code assigned to the facility or device and other data that can be changed in the system for the facility or device. It is characterized by doing.

[0008]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a schematic diagram showing an embodiment of a monitoring system and a facility management system according to the present invention. In the following example, description will be made using one monitoring and facility management system and one device.
In the configuration of each system according to the present invention, a system,
There is no need to limit the number of devices.

The monitoring system shown in FIG. 1 has a monitoring system database 20 for registering and managing data to be monitored.
1, a monitoring system terminal 202 for searching and displaying data for each monitoring target and the status of each monitoring target, and a control device including a workstation (not shown) and the like. In the monitoring system database 201, a plurality of data are registered for each facility or apparatus relating to one or more facilities or apparatuses to be monitored. In the configuration shown in FIG. 1, in the monitoring system database 201, for the device 101 in the building 100, the device name (“a device”), the building name (“A building”), the GUID
A plurality of data such as (Global Unique ID) (“a19990131”) and contact information (“Z monitoring center”) are registered. Here, the GUID assigned to each device is used as a common code with another system, and
The UID identifies the only facility or device.
The GUID is an indispensable item in the data in each database, and setting the GUID in each database is one of the features of the present invention.

[0010] The GUID is a numerical value that is unique all over the world. For example, the assignment is managed by a specific organization so as not to overlap with other monitoring or management targets,
It is generated by combining information of the generation source and the generation date and time to calculate. The concept of GUID is not limited to the field of the monitoring and management system according to the present invention. For example, in a Windows (registered trademark) environment,
By defining the class ID of an object with a 128-bit GUID and issuing the GUID by application, the ID is managed so as not to overlap with other objects.

In the case shown in FIG. 1, each database is connected via a communication line, and each database is connected to each other by at least one common database standard (eg, SQL (ISO standard)). It is assumed that means for accessing the database or conversion means for enabling access are provided.

On the other hand, the equipment management system in FIG.
The system includes a facility management system database 301 for registering and managing data to be managed, a facility management system terminal 302 for searching and displaying data, and a control device including a workstation (not shown) and the like. In the facility management system database 301, a plurality of data are registered for each facility or apparatus relating to one or more facilities or apparatuses to be managed. In the configuration shown in FIG.
The device name (“x device”) for the device 101 in the
Building name (“X Building”), GUID (“a19990131”),
A plurality of data such as an asset source (“Y Corporation”) and an installation date (“19850212”) are registered. Where GUID
Is a code common to that assigned to the same device in the monitoring system database 201, and is an essential item in the facility management system database. Other items are optional.

In the example shown in FIG. 1, data for the same device 101 is registered in the monitoring system database 201 and the facility management system database 301. However, the item name and the number of items managed for the device 101 do not match between the two databases. Further, the contents of the same items are not always the same. This is because the required specifications for the setting contents of each item are different due to differences in the management purpose of each system and the nature of the management or monitoring target. In this example, the same building 100
The monitoring system is set as “A building” and “a device”, and the equipment management system is set as “X building” and “x device”.

According to the above configuration, the same facility or device to be managed or monitored is given a GUID as a common code, so that data can be linked using the GUID. For example, after data linkage,
In the monitoring system terminal 202, the monitoring database 201
Regarding items that are not in the above, regardless of the difference between the specifications of the database management system of the monitoring system and the facility management system,
Searching becomes easy. For example, in the monitoring system, it is possible to easily search for the asset source of the device name a.

On the other hand, in the equipment management system, after data linking, items that are not in the equipment management database 301 can be easily searched on the equipment management system terminal 302. For example, a search for a contact of the device name x is performed.

As described above, according to the present embodiment, the same data can be cooperatively managed among a plurality of databases by assigning a unique code to equipment data worldwide. In addition, a search using a GUID as a key is realized between the respective systems, and data search can be performed regardless of the database management system. Further, it is possible to easily perform cooperative management among a plurality of databases, and perform data management in each system.

Next, with reference to FIG. 2 and FIG. 3, a flow of data creation processing in the monitoring system and the facility management system according to the present invention will be described. First, with reference to FIG. 2, a description will be given of a procedure for creating data with the facility management system after creating data with the monitoring system for the s device 101a in the building 100a.

In this case, in the monitoring system, the s device 10 is set as the s device by operating the monitoring system terminal 202.
Monitoring data is created for 1a and registered in the monitoring system database 201. At this time, a GUID (“s199990201”) is assigned to the s device (). Next, when data is created for the same device 101a in the facility management system, first, the same device is selected from the monitoring system database 201, and facility management data is created. At this time, the GUID ("s199902
01 "). Next, the created data is registered as facility management data in the facility management database 301. At this time, as shown in the figure, even if the device name and the building name are changed (monitoring system database). In 201, “s equipment”, “s building”, equipment management database 301
In the figure, “t device”, “T building”) and GUID link each data.

Next, referring to FIG. 3, the equipment management system →
A procedure for creating data for the t device 101b in the building 100b in the order of the monitoring system will be described. In this case, in the equipment management system, the equipment management system terminal 30
By the operation of 2, the equipment management data is created as the t device and registered in the equipment management system database 301. At this time, a GUID (“t19990
Next, data for the registered t device is read from the facility management system database 301 and is exported to the export database 400, which is a common database in each system. When the GUID ("t199902
01 ") is taken over ().

On the other hand, in the monitoring system, when the same device can be selected from the monitoring system database 201 and the export database 400, it is selected and monitoring data is created (). Here, the GUID (“t199990201”) included in the selected data
Will be included in the created data. If the same device cannot be selected, data is created in the same manner as described with reference to FIG.

Next, the created data is registered in the monitoring system database 201 (). At this time, the device name,
Even if the building name is changed (the equipment management database 30
1, “t device” and “T building”, and the monitoring system database 201 “s device” and “S building”), and each data is linked by the GUID.

As described above, in the present embodiment,
By creating and assigning unique codes around the world to equipment data, the same data can be cooperatively managed between multiple databases. At this time, in this example,
GUID is used as the code. According to this,
A search using a GUID as a key is realized between each system,
Data retrieval is possible worldwide, regardless of the database management system. In addition, cooperation management between a plurality of databases can be easily performed, and data management can be performed in each system.

[0023]

According to the present invention, a database is constructed by assigning a common identification code to each object to be monitored or managed by each system, thereby constructing a database. In addition to enabling search, it is possible to easily perform cooperative management among a plurality of databases, and to achieve data management using a plurality of databases in each system.

[Brief description of the drawings]

FIG. 1 is a schematic view showing an embodiment of the present invention.

FIG. 2 is a diagram for explaining a data creation procedure according to the embodiment of the present invention.

FIG. 3 is a diagram for explaining another data creation procedure according to the embodiment of the present invention.

[Explanation of symbols]

 100, 100a, 100b Building 101, 101a, 101b Equipment 201 Monitoring system database 202 Monitoring system terminal 301 Equipment management system database 302 Equipment management system terminal 400 Export database

 ──────────────────────────────────────────────────続 き Continuing on the front page (72) Inventor Hisao Masuyama 3-4-1 Shibaura, Minato-ku, Tokyo Inside NTT Facilities Inc. (72) Tadao Ishiguro 3-4-1 Shibaura, Minato-ku, Tokyo No. 1 F-term in NTT Facilities Corporation (reference)

Claims (5)

[Claims] 1. A system for monitoring one or more facilities or apparatuses, which identifies the facilities or apparatuses, and identification data commonly assigned to the facilities or apparatuses in at least one other system. Including, a plurality of data relating to the facility or device, a database that manages each facility or device, and using the identification data, from the database of another system, the data related to the facility or device specified by the identification data A monitoring system comprising: means for searching; and means for creating and changing data in the database of the own system using the searched data in the database of the other system. 2. The monitoring system according to claim 1, wherein the identification data is a numerical value that is unique worldwide. 3. A system for managing one or more facilities or apparatuses, which specifies facilities or apparatuses, and identification data commonly assigned to the facilities or apparatuses in at least one other system. Including, a plurality of data relating to the facility or device, a database that manages each facility or device, and using the identification data, from the database of another system, the data related to the facility or device specified by the identification data A facility management system comprising: means for searching; and means for creating and changing data in the database of the own system using the searched data in the database of the other system. 4. The equipment management system according to claim 3, wherein said identification data is a numerical value that is unique worldwide. 5. The system according to any one of claims 1 to 4, wherein when newly registering equipment or device data in a database of its own system, the system or another system of another system. When the data corresponding to the same equipment or device is not included in the common database, an identification code is assigned to the equipment or device, and the database of the own system or the database of the own system and the database common to each system In the system, create and register data for the facility or device from the identification code given to the facility or device and other plural data that can be changed in the own system with respect to the facility or device. Data corresponding to the same equipment or device in the database of When the data is selected, in the database of the own system, the identification code given to the equipment or the apparatus and the plurality of other data that can be changed in the own system with respect to the equipment or the apparatus, Alternatively, a data management method for creating and registering data for an apparatus.