JP2006235783A - Management method for facility information - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a management method for facility information capable of carrying out management that is the same as when facility information is stored in one data table even when it is separated in a plurality of data tables. <P>SOLUTION: Management items which are pieces of attribute information indicating characteristics of a facility segmented into predetermined facility segments (such as a transformer or a breaker) are divided into common items (an apparatus name, an installed location, or the like) which are management items that are common in each facility segment, and general items (inherent items) (such as a voltage, or a maximum breaking current) which are management items inherent to each facility segment. A common item data table and a general item data table are created in relation to the common items and the general items, and the management items are managed in a state of retaining a relationship between the common item data table and the general item data table by attaching an association key associating the data tables with each other to each record of the data tables. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a facility information management method, and more particularly to an improvement in facility information management method for managing facilities having a large number of devices and parts in the fields of electric power, gas, roads, and the like.

  The amount of facility information for facilities having a large number of devices and parts becomes enormous. Even if this facility information is to be combined into one huge data table, it is often divided into a plurality of data tables and managed due to hardware restrictions. For example, you can define the attribute items (management items) for the equipment you want to manage, label the attribute item groups as a single unit, and manage each item hierarchically by having an independent data table for each attribute item group. However, a facility information management method has been proposed that makes it easy to perform additional registration, reference, attribute change, and the like of data (for example, see Patent Document 1).

JP 2002-251431 (paragraph numbers 0019 to 0021, 0027 and FIG. 2)

  The conventional facility information management method is configured as described above, and a data table is created for each attribute item group corresponding to the facility classification of the present invention. Therefore, in order to search for the attribute information of the equipment having a certain management item (attribute item), there is a problem that a plurality of inquiries are generated and the search becomes complicated. In addition, when searching for the entire facility, a parent data table and a hierarchical data table have to be created separately for the attribute item group data tables. In addition, when management items and new equipment were added, it was necessary to modify the function of the display program accordingly.

  The present invention has been made to solve the above-mentioned problems, and even if the facility information is divided into a plurality of data tables, it can be managed in the same manner as when stored in one data table. An object of the present invention is to provide a facility information management method that does not require maintenance of a display program even if management items and new facilities are added.

  The facility information management method according to the present invention includes a management item, which is attribute information indicating characteristics of a facility classified into a predetermined facility category, a common item that is a common management item for each facility category, and a unique property for each facility category. The common item data table and the general item data table are generated for the common item and the general item, and the association key for associating the records with the common item data table and the general item data table is attached. Management items are managed in a state where the relationship between the two is maintained.

  The present invention provides a management item, which is attribute information representing the characteristics of equipment divided into predetermined equipment categories, a common item that is a management item common to each equipment category, and a general item that is a management item unique to each equipment category, The common item data table and the general item data table are generated for the common item and the general item, and the relation key is associated with each record of the common item data table and the general item data table, and the relationship between the two is maintained. Since the management items are managed in this way, even if the management items are divided into a plurality of data tables, they can be managed in the same manner as in the case where they are accommodated in one data table.

Embodiment 1 FIG.
1 to 3 show Embodiment 1 for carrying out the present invention. FIG. 1 is a diagram showing a configuration of management information in a facility information management method, and FIG. 2 is a record of an attribute information data table. FIG. 3 is a diagram showing a common item data table and a general item data table. In FIG. 1, facility information related to facilities to be managed is divided into a common item data table and a general item data table as described below to create two data tables, and these records are provided with a connection key. Link. In the present invention, a combination of the common item data table and the general item data table is referred to as an equipment information data table. This will be specifically described below. First, the equipment is divided into predetermined equipment categories. For example, item numbers 01 to 04, 11 to 14 that define attribute information indicating the characteristics of equipment in each of the equipment category A (transformer), the equipment category B (breaker), and the equipment category C (induction motor). Assume that the management items 21 to 24 and 31 to 34 are set as shown in FIG. At this time, the management items of the item numbers 01 to 04 that are common to the respective equipment categories A to C are common items, and the item numbers 11 to 14 and the item numbers 21 to 21 that are management items unique to the respective equipment categories A to C. 24, management items of item numbers 31 to 34 are defined as general items.

  Then, a common item data table having common items (item numbers 01 to 03) and general items (item numbers 11 to 13, item numbers 21 to 23, item numbers 31 to 33) having common items as shown in FIG. Create an item data table. And, for example, in the case of an transformer of the same equipment, the same serial number is assigned to each record of the common item data table and the general item data table of the transformer, and this is used as a key for connection, and the common item data table and The record divided into two in the general item data table is logically identified as one record. As a result, the common item data table and the general item data table can be handled as if they were one data table.

  The data types are as shown in FIGS. 2A to 2C, and the item names of the management items of the item numbers 01 to 04 which are common items are, in order, equipment classification, equipment name, installation location, and administrator. The data representing the attribute is input to each. When the equipment category is a transformer, as shown in FIG. 2A, the item names of the management items of item numbers 11 to 14 are model, capacity, primary voltage, and secondary voltage in this order. The data representing the attribute is input to each. When the equipment classification is a circuit breaker, as shown in FIG. 2 (b), the item names of the management items of item numbers 21 to 24 are model, rated voltage, rated current, rated breaking current in order, Data representing an attribute is input to each. When the equipment category is an induction motor, as shown in FIG. 2 (c), the item names of the management items of item numbers 31 to 34 are, in order, model, capacity, voltage, and maximum load. Is input.

The common item data table and the general item data table are, for example, as shown in FIG. 3, and records of each data table are associated one-to-one by serial numbers (00001,00004,00007).
As a result, even if the management items, that is, the management information data is divided into a plurality of data tables, they can be managed as easily as if they were accommodated in one large data table. Desired data can be obtained from the data table, and can be searched efficiently.

Embodiment 2. FIG.
FIG. 4 is a diagram showing a facility view in the facility information management method according to another embodiment of the present invention. As shown in FIG. 4, the general item data table includes general items of all equipment categories (for example, management items 11 to 13, 21 to 23, 31 to 33). When inquiring, it will refer to unnecessary general items. For example, the general items (management items) 21 to 23 of the equipment category (breaker) are not necessary for the equipment category (transformer). If such unnecessary general items are referred to, the processing efficiency decreases.

  In order to prevent this, as shown in FIG. 4, the projection (view) is defined for each of the equipment categories A to C (transformer, circuit breaker, induction motor) based on the general item data table, In other words, only general items required for the equipment category are extracted to create an equipment view (data table), which is used when inquiring about the general items described above. For example, in the equipment view of the equipment category (transformer), the general items are only the management items 21 to 24. Since there are a plurality of equipment categories, the equipment information view has a naming convention of “equipment information view (equipment category)”. For example, if the equipment classification is (transformer), the equipment information view (transformer) is named. For a specific example of the equipment view created in this way, refer to FIG. 5 described later.

  As a result, while managing the management items in a unified manner, the same effect as managing the data table for each equipment category can be obtained, and it is possible to prevent reference to even unnecessary general items, and to search efficiently. .

Embodiment 3 FIG.
5 and 6 further show a facility information management method according to another embodiment of the present invention, and FIG. 5 is a flowchart showing a flow when data search is performed using the facility view. 6 is a diagram showing an equipment view.
Hereinafter, this will be described with reference to the flowchart of FIG.
In step S11, from the common item data table in FIG. 6A and the general item data table in FIG. 6B, each transformer, circuit breaker, and induction motor shown in FIG. ), Equipment view (transformer), equipment view (breaker), equipment view (induction motor) as shown in FIG.
In step S12, a management item (general item) is acquired from the equipment view.
In step S13, the acquired management items are displayed as a list on the screen.

In step S14, the user selects a management item to be used for the search from the displayed management items.
In step S15, a search condition is set and the corresponding data is searched for the general item data table. For example, a condition of 60 kV <rated voltage (management item 22) <72 kV is set. Since the search target is a circuit breaker, a search is performed under a specified condition using the equipment view (breaker) (see FIG. 6D), and a serial number 00004 that is a key for connecting records that meet the condition is displayed. return.
In step S16, the common item record and the general item record corresponding to the serial number 00004 of the record matching the condition are connected, and these management items are displayed on the screen as shown in FIG.

  In this way, since the two records are connected by the connection key, all the facilities can be searched by one operation. In this example, as shown in FIG. You can know the item. In addition, it is possible to prevent reference to unnecessary general items when searching for general items, and to efficiently search. And it can grasp | ascertain briefly what the content of the management item is. Furthermore, skewered search can be performed for all managed equipment using any management item as a search condition, and the search speed is also improved.

Embodiment 4 FIG.
FIGS. 7 and 8 further show a facility information management method according to another embodiment of the present invention. FIG. 7 is a flowchart showing a flow for searching for facility information, and FIG. 8 is facility information. It is a figure which shows an example of this data.
According to this embodiment, even when a new management target equipment is added or a management item is added to or deleted from an existing management target equipment, the display program is not maintained. The item name of the management item of equipment and its data (attribute) can be displayed. Hereinafter, this will be described with reference to the flowchart of FIG.
In step S21, the facility hierarchy diagram is displayed.
In step S22, the user selects a facility category for which management items are to be queried from the displayed hierarchy diagram. Here, it is assumed that an equipment category (breaker) is selected as an example.

In step S23, a set of all item numbers / item names (see FIG. 2) is acquired from the common item data table and the general item data table using the equipment classification (breaker) as a key.
In step S24, data (attribute data) of all management items corresponding to each item name is acquired. For example, when the equipment classification is a circuit breaker, the item number / item name is item number 21 / model, item number 22 / rated voltage, item number 23 / rated current, item number 24 / rated breaking current. After this, for example, when item number 25 / the number of operations at the previous inspection is added, this item number / item name is also acquired.
In step S25, the item number / item name set obtained in step S23 and the item number / data set obtained in step S24 are combined and returned as a search result.
In step S26, a table of item names and their data is created and displayed on the screen as a list.

  By adopting this method, there is no need to be aware of the increase or decrease in management items and managed equipment, and management item data can be acquired by referring to all management items, so no maintenance of the display program is required. .

  As described above, the facility information management method according to the present invention includes a management item that is attribute information representing characteristics of a facility that is classified into a predetermined facility category, and a common item that is a management item common to each facility category and each facility. It is divided into general items that are management items specific to the category, a common item data table and a general item data table are generated for the common items and general items, and the records are associated with each other in the common item data table and the general item data table. Since the management items are managed in a state where a key is attached and the relationship between the two is maintained, even if the management items are divided into a plurality of data tables, they can be managed in the same manner as in a case where they are accommodated in one large data table.

  Then, the general item data in the specific equipment category of the equipment category is extracted from the general item data table to generate the equipment information view, and the management information can be managed by this equipment information view. Therefore, the same effect as managing the data table for each equipment category while managing the management items in an integrated manner is obtained.

  Furthermore, the search target is selected from the general item, the record satisfying the search target search condition is searched from the general item data table, the corresponding record is extracted, and the record corresponding to the association key of the corresponding record in the common item data table Since the management items satisfying the search conditions are obtained in combination, it is possible to prevent the reference to unnecessary general items when searching for the general items, and to search efficiently.

  Also, the names of all the management items are acquired from the common item data table and the general item data table, the display target to be displayed is selected from the names of all the acquired management items, and the common item data table and the general item data table are selected. Since the display target data is obtained from the data and the names and data of the management items to be displayed are displayed, maintenance of the display program is not required.

It is a figure which shows the structure of management information. It is a figure which shows the specific example of the record of an attribute information data table. It is a figure which shows a common item data table and a general item data table. It is a figure which shows the equipment view in the management method of the equipment information which is other embodiment of this invention. Furthermore, it is a flowchart in the case of performing a data search using the equipment view which is other embodiment of this invention. It is a figure which shows an equipment view. Furthermore, it is a flowchart which shows the flow in the case of searching the installation information which is other embodiment of this invention. It is a figure which shows an example of the data of equipment information.

Claims (4)

Management items, which are attribute information representing the characteristics of the equipment classified into the predetermined equipment categories, are divided into common items that are common to the above equipment categories and general items that are management items specific to each equipment category. , Generate a common item data table and a general item data table for the common item and the general item, and attach a correlation key to correlate each record of the common item data table and the general item data table to maintain the relationship between them. A facility information management method for managing the management items in a state of being performed. The general item data in the specific equipment category among the equipment categories is extracted from the general item data table to generate the equipment information view, and the management items can be managed by this equipment information view. The facility information management method according to claim 1. Select a search target from the general item, search for a record satisfying the search target search condition from the general item data table, extract the corresponding record, and use it as the association key of the corresponding record in the common item data table. 2. The facility information management method according to claim 1, wherein the management item satisfying the search condition is obtained in combination with a corresponding record. The names of all management items are acquired from the common item data table and the general item data table, the display target to be displayed is selected from the names of all the acquired management items, and the common item data table and the general item data are selected. 2. The facility information management method according to claim 1, wherein the display target data is obtained from a table and the name of the display target management item and the data are displayed.

Images