JP5744791B2 - Equipment management system - Google Patents

Description

The present invention relates to an equipment management system for managing equipment attribute information of related equipment required for maintenance management of equipment to be managed.
The maintenance management work of the management target equipment includes, for example, the power equipment management work of the power company engineering department and the road equipment maintenance management work in the local government.

Information such as the date of manufacture and manufacturer held by any equipment is called equipment attribute information. In the operation of maintaining equipment, the equipment attribute information stored in the database is often referred to.
In such a business, it is necessary to refer not only to the referring facility but also to the facility attribute information of the facility related to the corresponding facility.

JP-A-4-195591 (pages 5-6, FIG. 1)

In the conventional equipment management system, as shown in Patent Document 1, the management is mainly performed from the viewpoint of how to efficiently manage a group of equipment conscious of the user's affiliation.
However, in actual business execution, it is not sufficient for the section or group to which the user belongs to to efficiently find the equipment that is the jurisdiction, and how efficiently the equipment related to the found equipment can be found. Is important.
In the conventional method, the related equipment has to be searched from within the jurisdiction, and there is a problem that the burden is great on the user.

  The present invention has been made to solve the above-described problems, and an object thereof is to obtain an equipment management system capable of efficiently referring to equipment attribute information of equipment related to an arbitrary equipment.

In the equipment management system according to the present invention, a database for storing equipment ledger which is equipment attribute information and related equipment information in which equipment related equipment is defined in advance, database management means for managing this database, and this database management means Requesting the equipment ledger of the equipment and related equipment information of this equipment, and the equipment ledger display means for displaying the equipment ledger and the related equipment information acquired from the database management means , the database includes the ID of the related equipment in the equipment ledger of the equipment The equipment ledger display means displays a link to the equipment ledger of related equipment of the equipment based on the database when displaying the equipment ledger .

According to the present invention, the database storing the equipment ledger which is the attribute information of the equipment and the related equipment information in which the related equipment of the equipment is defined in advance, the database management means for managing the database, and the equipment of the equipment in the database management means The system includes facility ledger display means for requesting the ledger and related equipment information of this equipment and displaying the equipment ledger and related equipment information acquired from the database management means , and the database associates the ID of the related equipment with the equipment ledger of the equipment. The equipment ledger display means has a structure and displays a link to the equipment ledger of the related equipment of the equipment based on the database when displaying the equipment ledger, so refer to the attribute information of equipment related to any equipment. In doing so, the user's work can be reduced.

It is a figure which shows the software structure of the equipment management system by Embodiment 1-8 of this invention. It is a figure which shows the image which refers the installation attribute information of the related installation which is not physically connected with the installation with the installation management system by Embodiment 1 of this invention. It is a figure which shows the data structure of the database of the equipment management system by Embodiment 1 of this invention. It is a flowchart which shows the process of the equipment management system by Embodiment 1 of this invention. It is a figure which shows the example of a screen when there exist two or more related facilities of the installation with the installation management system by Embodiment 2 of this invention. It is a figure which shows the data structure of the database of the equipment management system by Embodiment 2 of this invention. It is a figure which shows the data structure in case the number of the facilities relevant to a certain installation with the installation management system by Embodiment 3 of this invention is not fixed.

It is a figure which shows the example of a screen which implements the cross-reference of the equipment ledger of the equipment management system by Embodiment 4 of this invention. It is a flowchart which shows the process of the equipment management system by Embodiment 4 of this invention. It is a figure which shows the data structure for setting the kind of installation linked | related with the installation with the installation management system by Embodiment 5 of this invention. It is a flowchart which shows the process of the equipment management system by Embodiment 5 of this invention. It is a figure which shows the data structure in case the number of related facilities is fixed with the kind of installation of the installation management system by Embodiment 6 of this invention. It is a figure which shows the data structure of the database in case the bidirectional | two-way reference and one-way reference of the equipment ledger of the equipment management system by Embodiment 7 of this invention are mixed. It is a figure which shows the example of a screen in case the bidirectional | two-way reference and one-way reference of the equipment ledger of the equipment management system by Embodiment 7 of this invention are mixed. It is a figure which shows the data structure of the database when the bidirectional | two-way reference and one-way reference of the equipment ledger of the equipment management system by Embodiment 8 of this invention are mixed, and the number of related equipment which can be set differs.

Embodiment 1 FIG.
FIG. 1 is a diagram showing a software configuration of an equipment management system according to Embodiment 1 of the present invention.
In FIG. 1, a user terminal 1 has a Web browser that provides a screen to the user, and is connected to a facility management system 10 via a network.
The facility management system 10 is formed by a computer having a storage device, and has the following software configuration.
The facility management application 2 (facility ledger display means) is accessed by the user terminal 1 and displays a screen of the requested information on the Web browser of the user terminal 1. The related facility information management unit 3 (database management means) passes the related facility information search result to the facility management application 2 or sets the related facility information in the database 4. The database 4 is formed on a storage device and stores an equipment ledger and related equipment information created in advance.
The configuration shown in FIG. 1 is also used in Embodiments 2 to 8 described below.

FIG. 2 is a diagram showing an image referring to equipment attribute information of related equipment that is not physically connected to equipment with the equipment management system according to Embodiment 1 of the present invention.
FIG. 2A is a configuration example of a physical facility. FIG. 2B is a screen display example of the facility attribute information of the utility pole A in FIG. “Next equipment” is displayed in the sixth line of FIG.
A facility related to a certain facility is displayed as a “next facility” on the Web browser of the user terminal 1, and the facility attribute information of the associated facility is displayed by pressing this link.

FIG. 3 is a diagram showing a data structure of a database of the facility management system according to Embodiment 1 of the present invention.
In FIG. 3, it is the data structure of the database 4 which stored the equipment attribute information for performing the display of FIG.2 (b), ID (ID of the said equipment), a manufacturer, a manufacturing date, an installation date, It has each column of allowable power, maximum resistance, and the following equipment. In the “next equipment” column, the ID of the equipment related to the equipment indicated by the ID is stored.

Next, the operation will be described.
The related facility information management unit 3 functions in the facility management system 10 and performs an operation according to the operation of the user terminal 1 via the facility management application 2 of the facility management system 10. The equipment management application 2 displays equipment attribute information of related equipment of a certain equipment or sets related equipment information that is information of related equipment of a equipment on the user terminal 1.
FIG. 2 shows an image of referring to equipment attribute information of equipment (electric wire in FIG. 2) related to a certain equipment (electric pole A in FIG. 2), which is not physically connected. In the first embodiment, as one equipment attribute of the equipment attribute information, the ID of the related equipment is stored in the database 4 in a data structure as shown in FIG. The equipment attribute information stored in the database 4 shown in FIG. 3 is called an equipment ledger. The equipment stored in the equipment ledger can be uniquely identified in the equipment management system 10 by the ID which is one attribute thereof.

Next, the processing flow of the facility management system will be described with reference to FIG. FIG. 4 shows a processing flow for generating the screen of FIG. 2 from the data structure of the equipment ledger of FIG.
First, the facility management application 2 is requested to acquire the facility attribute information of the facility of ID = 1 by the operation of the user terminal 1, and the related facility information management unit 3 acquires the facility attribute information of the facility of ID = 1. Instruct. The related equipment information management unit 3 acquires equipment ledger data with ID = 1 instructed from the equipment management application 2 from the database 4 (step S1).

Next, the related facility information management unit 3 checks whether or not a value is stored in the “next facility” of the facility ledger with ID = 1 (step S2). If the value is stored, the equipment ledger with ID = 1 is displayed on the web browser in the equipment management application 2 using the notation for displaying the link for “next equipment” as shown in FIG. (Step S3).
If no value is stored, the equipment management application 2 displays the equipment ledger of the relevant equipment with “next equipment” blank on the Web browser (step S4).
As shown in FIG. 3, since “2” is stored in “next equipment” for the equipment of ID = 1, in step S3, “next equipment” displays a link display as shown in FIG. Displayed using the notation to be performed.

According to the first embodiment, it is possible to continuously refer to the equipment attribute information of related equipment that is not physically connected by pressing a link of the Web browser.
Thereby, the attribute information of the equipment relevant to arbitrary equipment can be referred efficiently, and a user's burden can be reduced.

Embodiment 2. FIG.
FIG. 5 is a diagram showing an example of a screen when there are a plurality of related facilities of a facility with the facility management system according to the second embodiment of the present invention.
FIG. 5A displays the facility attribute information of a certain facility. FIG. 5B shows related facility information. When there are a plurality of “next facilities”, a plurality of “next facilities” are displayed in another table.

FIG. 6 is a diagram showing a data structure of a database of the facility management system according to the second embodiment of the present invention.
In FIG. 6, the equipment ledger of the database 4 is provided with related equipment 1, related equipment 2, and related equipment 3 in place of the “next equipment” having the configuration shown in FIG. 3. This related equipment has as many columns as necessary. In FIG. 6, three columns of related equipment are provided.

The second embodiment is for a case where there are a plurality of facilities related to a certain facility.
When there are multiple facilities related to a certain facility, as shown in Fig. 5 (b), the link of "next facility" is displayed in the table of facility attribute information as shown in Fig. 2 (b). The facility information is displayed in a separate table. The data structure of the equipment ledger in this case is as shown in FIG.

  According to the second embodiment, even when there are a plurality of facilities related to a certain facility, the link is displayed in a separate table so that the related facility information can be easily referred to, so that it is easy for the user to operate.

Embodiment 3 FIG.
FIG. 7 is a diagram showing a data structure when the number of facilities related to a certain facility in the facility management system according to the third embodiment of the present invention is not fixed.
FIG. 7A shows an equipment ledger having equipment attribute information of the equipment. FIG. 7B shows related facility information defined by pairing a certain facility with a related facility.

In the second embodiment, the related equipment of a certain equipment is a fixed number. The third embodiment relates to a case where there are a plurality of facilities related to a certain facility instead of a fixed number. When there are a plurality of facilities related to a certain facility instead of a fixed number, the screen display is the same as in FIG. 5, but the data structure of the database 4 is different.
FIG. 7 shows an example of the data structure of related equipment information when the number of related equipment is not fixed.
As shown in FIG. 7B, since there is related facility information defined as a pair of a certain facility and a related facility, the number of related facilities for an arbitrary facility is eliminated with this data structure.
Moreover, the record of the related equipment information with respect to the equipment with no related equipment is not created.

  According to the third embodiment, in addition to the equipment ledger, related equipment information defining a certain equipment and related equipment is provided separately, so that the number of related equipment for any equipment is not limited.

Embodiment 4 FIG.
FIG. 8 is a diagram showing an example of a screen for performing cross-reference of the equipment ledger of the equipment management system according to Embodiment 4 of the present invention.
FIG. 8A shows a display example of the equipment ledger. FIG. 8B shows a display example of related facility information. FIG. 3C is an example in which “facility that refers to this facility” is displayed as a link for a certain facility. In FIG. 8B, the equipment having the equipment ledger in FIG. 8A refers to “next equipment”, and in FIG. 8C, the equipment having the equipment ledger in FIG. It shows the reference source equipment which is “Equipment”. That is, as viewed from the reference source facility, the “next facility” is a facility having the facility ledger of FIG.

If the data structure shown in FIG. 7 of Embodiment 3 is used, it is possible to acquire not only the equipment related to any equipment but also the equipment that is currently set as the related equipment as the equipment ledger. Thus, it is possible to cross-reference between facilities from the equipment ledger screen. Embodiment 4 is about the cross-reference of this installation.
In FIG.7 (b), the installation of ID = 1 refers to the installation of ID = 2 as a related installation. Conversely, the facility with ID = 2 is referenced from the facility with ID = 1. That is, when viewed from the related equipment column of the related equipment information, the equipment in the ID column is the reference source equipment.

Next, the processing flow of the fourth embodiment will be described with reference to FIG.
First, in accordance with an instruction from the equipment management application 2, the related equipment information management unit 3 acquires equipment ledger data and related equipment information of the equipment with ID = 1 from the database 4 (step S11). Next, the related facility information management unit 3 checks whether or not the data of the facility with ID = 1 is stored in the ID column of the related facility information (step S12). If stored, the equipment management application 2 displays the related equipment information shown in FIG. 8B on the web browser of the user terminal 1 using the notation for displaying the link on the web browser (step S13). . If not stored, the facility management application 2 displays the related facility information blank on the Web browser of the user terminal 1 (step S14).

  Next, the related facility information management unit 3 checks whether data of ID = 1 is stored in the related facility column of the related facility information (step S15). If it is stored, the equipment management application 2 displays the “facility that refers to this equipment” shown in FIG. 8C on the user's web browser using the notation for displaying the link on the web browser. (Step S16). If it is not stored, the facility management application 2 displays the “facility that refers to this facility” blank on the Web browser of the user terminal 1 (step S17).

  According to the fourth embodiment, for a certain facility, the facility referring to this facility can be displayed as a link.

Embodiment 5 FIG.
FIG. 10 is a diagram showing a data structure for setting the type of equipment associated with a certain equipment in the equipment management system according to Embodiment 5 of the present invention.
FIG. 10A shows an equipment ledger, and FIG. 10B shows related equipment information. These are the same as in FIG. The related equipment type information in FIG. 10C defines equipment types that can be set for each equipment type. For example, electric poles can be set with electric wires, transformers, and operation boxes. Only the equipment types defined in FIG. 10C are set in the related equipment information in FIG.

Depending on the facility management work, it may be desired to limit the types of facilities that may be set as related facilities. The fifth embodiment is for such a case.
For example, in the power distribution business, the number of facilities is an order of 10 million, so if all types of facilities are set in the related facility information, the number of records in the related facility information increases, and the screen of the facility ledger is generated. It takes time.
In such business, it is necessary to limit the types of equipment associated with a certain equipment and suppress an increase in screen generation time. For this reason, in the fifth embodiment, it is possible to define a settable facility type for each facility type as shown in FIG. 10C, and here, the related facility in FIG. Information is formed.

Next, the processing flow of referring to related equipment when the types of equipment associated with a certain equipment are limited will be described with reference to FIG.
First, the related facility information management unit 3 receives an instruction from the facility management application 2 and acquires a record with ID = 1 from the facility ledger of the database 4 (step S21). Next, the related facility information management unit 3 acquires the facility type of the acquired record (step S22). I
The equipment type of equipment with D = 1 is “electric pole”.

Next, from the related equipment type information in FIG. 10C, a record in which “electric pole” that is the equipment type with ID = 1 is set in the “equipment type” column is acquired (step S23). From these records, “wire, transformer, operation box” in the settable facility type column is acquired as a settable facility type, and these “wire, transformer, operation box” are returned to the facility management application 2 (steps). S24).
In the facility management application 2, facilities other than the acquired “wire, transformer, operation box” are not displayed as related facilities (step S25).

  According to the fifth embodiment, since the types of equipment that can be set as related equipment are limited and the number of records of related equipment information is limited, an increase in screen generation time of the equipment ledger can be suppressed.

Embodiment 6 FIG.
FIG. 12 is a diagram showing a data structure in the case where the number of related facilities is fixed depending on the type of facility in the facility management system according to the sixth embodiment of the present invention.
12 (a) and 12 (b) are the same as those in FIG. In the related facility type information in FIG. 12C, a column of the number of related facilities is provided, and the number of related facilities that can be set for each settable facility type is defined. For example, “Pole” can be set to “Electric wire, transformer, operation box”, but “Electric wire” is set to 2, “Transformer” is set to 3, and “Operation box” is set to one related facility. it can.

The number of related facility information may be fixed depending on the type of facility. For example, the equipment related to “electric pole” includes two “electric wires” (for example, electric wire A and electric wire B) and three “transformers”. The sixth embodiment is for this case.
The data structure of the sixth embodiment is as shown in FIG. A related equipment number column is added to the related equipment type information in FIG. 12C, and the settable related equipment number is set in this column. When setting the related equipment information of a certain equipment, refer to the information in this related equipment number column and limit the number of related equipment that can be set.

  According to the sixth embodiment, by limiting the number of related facilities that can be set for a certain facility for each facility type, it is possible to suppress an increase in records of related facility information and an increase in screen generation processing time.

Embodiment 7 FIG.
FIG. 13 is a diagram showing a data structure of a database when bidirectional reference and unidirectional reference of the equipment ledger of the equipment management system according to Embodiment 7 of the present invention are mixed.
13 (a) and 13 (b) are the same as those in FIG. The related equipment type information in FIG. 13C is provided with a direction column. A value 0 in the direction column indicates that the reference is only in one direction between the equipment ledgers (reference order), and a value 1 indicates that it is a bidirectional reference between the equipment ledgers (reference order and reverse order). Yes.

FIG. 14 is a diagram showing an example of a screen when bidirectional reference and unidirectional reference of the equipment ledger of the equipment management system according to Embodiment 7 of the present invention are mixed.
14A is a display example of a facility ledger of a certain facility, FIG. 14B is a display example of related facility information of a certain facility, and FIG. 14C is a table of facilities referring to a certain facility. It is a figure which shows an example.
In the case of the value 0 indicating the one-way reference in FIG. 13C, it is not displayed in the “facility referring to this facility” in FIG. 14C.

In Embodiment 4, although the form which enables mutual reference of an equipment ledger was shown, depending on the kind of equipment, there is a case where it is desired to refer to only one direction instead of both. The seventh embodiment is for such a case.
For example, as a related facility of “electric pole”, “electric wire” and “transformer” may be referred to bidirectionally, but “operation box” may be referred to as “unidirectional reference” from “electric pole”. A data structure for realizing this form is shown in FIG. By using the data structure shown in FIG. 13, it is only necessary to set one record for bidirectional use (it is not necessary to set two records of electric pole → electric wire and electric wire → electric pole), and data required for setting related facility type information. The amount can be reduced.

  According to Embodiment 7, since bidirectional reference and unidirectional reference can be set separately, the amount of data required for setting related facility type information can be reduced.

Embodiment 8 FIG.
FIG. 15 is a diagram showing a data structure of a database when bidirectional reference and one-way reference of the equipment ledger of the equipment management system according to Embodiment 8 of the present invention are mixed and the number of related equipments that can be set is different.
15 (a) and 15 (b) are the same as those in FIG. In FIG.15 (c), the reverse direction equipment number column is added to FIG.13 (c). In FIG. 13 (c), the number of related facilities that can be set in the forward direction (in the case of a utility pole is a utility pole → electric wire) is defined in the relevant facility number column, and the reverse direction ( The number of related equipment that can be set is defined. When the value in the direction column is 0, the number of backward equipment is not defined.

In the bi-directional reference, the reference of the electric pole → electric wire is defined as the reference from the upstream, and the reference of the electric pole → electric pole is defined as the reference from the downstream. In a certain business, there is a case where it is desired to change the number of reference destinations that can be set as upstream and the number of reference sources that can be set as downstream. The eighth embodiment is for this case.
For example, as shown in FIG. 15C, when the type of equipment is “electric pole”, “electric pole” → “electric wire” can be set to three facilities, but “electric wire” → “electric pole” is set to “2”. It is. The “electric pole” related to the “electric wire” corresponds to a case where it is clear from a business point of view that the two electric poles are connected to both ends of the “electric wire”.

  According to Embodiment 8, the number of related equipment that can be set is defined separately between a certain equipment and related equipment in the forward direction (reference from upstream) and the reverse direction (reference from downstream). By restricting the number of related facilities that can be set for a certain facility separately from each other, it is possible to suppress an increase in records of related facility information and an increase in screen generation processing time.

  It should be noted that the present invention can be freely combined with each other within the scope of the invention, and each embodiment can be appropriately modified or omitted.

DESCRIPTION OF SYMBOLS 1 User terminal 2 Equipment management application 3 Related equipment information management part 4 Database 10 Equipment management system

Claims (8)

A database that stores equipment ledger that is attribute information of equipment and related equipment information that defines the related equipment of the equipment in advance,
Database management means for managing this database;
And requesting the equipment ledger of the equipment and related equipment information of the equipment to the database management means, and comprising the equipment ledger display means for displaying the equipment ledger and the related equipment information acquired from the database management means ,
The database has a structure in which an ID of the related equipment is associated with an equipment ledger of the equipment,
The facility ledger display means displays a link to a facility ledger of related facilities of the facility based on the database when displaying the facility ledger . The equipment management system according to claim 1 , wherein a plurality of links to the equipment ledger of the related equipment by the equipment ledger display means are provided . The equipment ledger and the related equipment information are formed in a separate table on the database,
3. The equipment management system according to claim 1, wherein the table of related equipment information is formed by a record of a pair of an ID of a certain equipment and an ID of the related equipment. 4. The facility management system according to claim 3 , wherein the facility ledger display means displays a link to a facility ledger of a reference source facility having the facility as a related facility when displaying the facility ledger of a certain facility. The equipment management system according to claim 3 or 4 , wherein the database stores related equipment type information in which the types of related equipment that can be set according to the type of equipment are defined in advance. 6. The equipment management system according to claim 5, wherein the related equipment type information stored in the database defines in advance a number that can be set for each type of related equipment that can be set according to the type of equipment. . The number that can be set for each type of related equipment that can be set according to the type of equipment defined by the related equipment type information stored in the database is a reference from the type of equipment to the type of related equipment that can be set. 7. The facility management system according to claim 6 , wherein the facility management system is defined in order or in the reference order and the reverse order. The number that can be set for each type of related equipment that can be set according to the type of equipment defined by the related equipment type information stored in the database is a reference from the type of equipment to the type of related equipment that can be set. 7. The facility management system according to claim 6 , wherein the order is defined for each order in the order and the reverse order.

Images