JPH08234808A - Installation register managing device - Google Patents

Abstract

PURPOSE: To output the result in a short time by efficiently processing the data of sorting required for a user by reducing necessity to retrieve all related partial data at the time of data extraction. CONSTITUTION: When there is a data extracting request from the user, the conditions of that data extraction are interpreted by a first output data deciding means 3. Corresponding to that decision, the suitable destination of data extraction is reported to a related data retrieving means 6 and a data retrieving means 7. For example, when the user requests data in an 'installation group', the output data deciding means 3 instructs the data retrieving means 7 to retrieve only an installation group data base 9. Thus, the data extracting request of large sorting is speedily responded to without retrieving all the related partial data. Therefore, the collecting conditions of large facilities can be immediately recognized even in the case of a large scale plant.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an equipment ledger management apparatus suitable for managing equipment installed in various large-scale plants such as thermal power plants and nuclear power plants.

[0002]

2. Description of the Related Art Since the number of facilities in various large-scale plants such as thermal power plants is huge, they are generally classified and managed hierarchically. For example, in the case of a thermal power plant, turbines, boilers, generators, etc. are categorized as a large classification "equipment group", and a medium classification "equipment" is a high-pressure turbine, medium-pressure turbine , A low-pressure turbine, and a small degree of “parts” below that, a high-pressure turbine is classified into a moving blade, a stationary blade, and a shaft.

In recent years, thermal power plants have been required to have an improved operating rate due to an increasing demand for electric power, while the facilities of the thermal power plants have deteriorated. It is necessary to effectively manage the maintenance period and the number of facilities to be temporarily maintained in the thermal power plant in a long-term plan.

As shown in FIG. 6, the conventional equipment ledger device includes a data output device 1, a data input device 2, a relational data updating means 4, a data updating means 5, a relational data searching means 6, a data searching means 7, It is composed of a relational database 8, an equipment group database 9, an equipment database 10 and a part database 11, and information on the equipment is managed for each "equipment group", "equipment", "part",
In particular, the equipment group database 9 and the equipment database 10 manage only the names of “equipment” and “site” that belong to each, or the codes of “equipment” and “site” that can be specified within the thermal power plant.

In the conventional device having such a structure, when the data of the management ledger is taken out, the search condition 13 is set on the screen of the data output device 1 as shown in the upper part of FIG. 7 by using the data input device 2. Designate and interpret it by the relational data retrieval means 6 and the data retrieval means 7, retrieve the relation between the equipments from the relational database 8, and retrieve the equipment data from the equipment group database 9, equipment database 10 and part database 11. After that, as shown in the lower part of FIG. 7, the search result 15 is displayed on the screen of the data output device 1.

The procedure for extracting the equipment data is as follows. The equipment name or code belonging to the equipment group is extracted from the equipment group database, the equipment is specified, and then the data name of the part belonging to the equipment, Alternatively, the code is taken out, one or a plurality of parts are specified, and detailed information is taken out from the database of the part.

Even when the facility data is newly registered or updated, the data is registered in the database after the above-mentioned data retrieval procedure. Specifically, when data is input using the data input device 2, the data is delivered to the relational data updating means 4 and the data updating means 5, and the relational data searching means 6 and the data searching means 7 register the data or The database to be updated is determined. The relational data updating means 4 and the data updating means 5 exchange information for maintaining data consistency with each other, and then the relational database 8, equipment group database 9, equipment database 10 and site database 11
To issue a new registration or update command to cause the equipment information input from the data input device 2 to be newly registered or updated.

[0008]

In order to know the status of the equipment group in the equipment number management device as described above, for example, to know the inspection portion ratio (number of inspected parts / total number of parts) of the turbine. Even in such a case, since the actual inspection data exists in the part database 11 which is the minimum management unit, the data search means 7 must search all the part databases 11 belonging to the turbine. Therefore, in an equipment number management device such as a thermal power plant that manages an enormous number of equipments, it takes a long time to identify the data requested by the user and retrieve it.

The present invention has been made in order to solve the above-mentioned problems of the conventional apparatus, and provides an equipment ledger management apparatus capable of efficiently processing data in a classification required by a user and outputting the result in a short time. The purpose is to do.

[0010]

The equipment ledger management apparatus of the present invention hierarchically classifies the equipment installed in the plant into a large classification, a middle classification, and a small classification, and specifies the specifications for each classification. Large classification database, middle classification database and small classification database that store information such as equipment maintenance history and maintenance plan, relational database that holds the relationship between the content information of these databases and the relationship between each database, and data input Data input device for updating, data updating means for updating the data in the database based on this input information, relational data updating means for updating the relationship between the information, and data retrieval for extracting the data as required by the user And a related data retrieval means having a function of retrieving relational information between data necessary for retrieving the data, and The relational database a classification of a request, characterized in that it comprises major classification databases, the output data determining means for determining from the middle classification database and small classification database, and a data output device for displaying the results.

[0011]

In the equipment ledger management apparatus of the present invention, when the user requests the data retrieval, the retrieval condition of the data is first interpreted by the output data determination means, and the determination is made by the relational data retrieval means and the data. The retrieval means is notified of an appropriate data retrieval destination. That is, for example, the user's request is "equipment group"
In the case of the above data, the output data determination means instructs the data search means to search only the equipment group database. Also, the user's request is "equipment data".
In this case, the output data determination means instructs the data search means to search both the equipment group database and the equipment database. As described above, according to the present invention, a request for data retrieval in a large classification responds promptly without searching for all relevant part data, so that even large-scale plants such as thermal power plants can have a large set of equipment. You can immediately know the situation.

[0012]

Next, an embodiment of the present invention will be described with reference to the drawings.

The equipment ledger management apparatus of the present invention, as shown in FIG. 1, is a data output apparatus 1, a data input apparatus 2, an output data judging means 3, a relational data updating means 4, a data updating means 5, and a relational data searching means. 6, a data retrieval unit 7, a relational database 8, an equipment group database 9 that is a large classification database, an equipment database 10 that is a middle classification database, and a site database 11 that is a small classification database. The arrows in the figure indicate the flow of commands or data between each device and means.

When the user requests data from the data input device 2, the search condition 13 and the search level 14 as shown in FIG. 2 are displayed on the screen of the data output device 1. The user follows the display of this screen and the data input device 2
Enter the request from. When the data input device 2 receives the data request, it delivers them to the output data determination means 3. The output data determination means 3 determines the databases 8 to 11 to be searched by the relational data search means 6 and the data search means 7 based on the delivered search condition and search level.

This determination method is roughly divided into two as shown in the flowchart of FIG. One is a method of forcibly designating a database to be referred in a search process by directly designating a classification hierarchy when the classification hierarchy to be searched (search level) is clear. The other is the relationship between the data items registered in the relational database and the database.
By matching with the entered search condition items,
This is a method of determining the database to be searched. Regarding the priority of these two methods, the search level designation by the user basically has priority. Next, the details of this determination method will be described. In FIG. 3, search condition input (step S1)
If there is, the output data determination means 3 is the data input device 2
2 to the relational data search means 6 is inquired as to which database the item of the search condition as specified on the screen 13 of FIG. 2 is related (step S2). According to the instruction, the relational data search means 6 determines which database the designated item is related to, the data item name “relationship between item and other item” as shown in FIG.
A table having “a database name including an item” and “a relationship between databases of the same item” is searched, and the result is returned to the output data judging means 3. The relational data updating means 4 calculates the relation between the items in this table and other items and updates or registers the registered database name.

In step S3, the output data judging means 3
Determines whether the search level is specified in the search condition. If the search level is specified, the database is specified by the search level (step S4). That is, if the search level is "equipment group",
The database to be searched is only the equipment group database 9, and if "equipment", only the equipment database 10 is designated as the search database, and if "site", only the portion database 11 is designated as the search database. The output data determination means 3 further compares the relational data retrieval result with the retrieval level, and if there is no relation between the target database of the designated retrieval level and the item of the retrieval condition, the item is retrieved from the retrieval condition. After the exclusion, the search condition items (plurality) and the target database (one) are passed to the data search means 7 (step S6).

If the search level is not specified in step S3, the database is specified by the item of the search condition (step S5). In this case, the output data determination means 3 determines the deepest classification hierarchy among the databases related to the items of the search condition as the target database of the item, obtains this for all the items of the specified search condition, and responds. Is created and the table having the correspondence between the search condition items (plural) and the target database (plural) is delivered to the data searching means 7 (step S6). When the data retrieval means 7 receives the retrieval condition and the target database, it retrieves the data from the databases 9 to 11 based on the passed judgment result. In this case, the data search means 7 searches the search target database under the specified search condition, and delivers the search result to the output data determination means 3. The output data determination means 3 organizes the relationship of item data according to the relationship of items obtained at the time of retrieval, and outputs it to the data output device 1. An example of the output is shown in FIG.
In the figure, 12a is a display example when the search level is designated as "equipment group", and 12b and 12c are display examples when the search level is designated as "equipment" and "part", respectively.

Next, regarding a data input request by the user, there are a case where existing data is changed and a case where new data is added. First, when changing existing data, it is necessary to fetch the data to be changed, and this processing is carried out in the same procedure as the above-mentioned data fetch request. After that, the extracted data is modified and registered in the database.
The processing is as follows. That is, the changed data is passed to the output data judging means 3, and the changed items are selected. That is, the relational data search means 6 is inquired about the database relating to the changed data item. According to the result, the output data judging means 3 makes the changed data and the databases 8 to 11 for making changes to the relational data updating means 4 and 5 (the relational data updating means 4 is fixed to the relational database 8). ), The related data updating means 4 and the data updating means 5 update / register the instructed data with respect to the instructed database.

Next, when data is newly added, the following processing is performed. First, new additional data is input from the data input device 2 and passed to the output data determining means 3. The output data determining means 3 is a database (a plurality of items per one) related to each input item.
Is obtained by inquiring the relational data search means 6. When the target databases have been obtained for all items, the output data determination means 3 starts from the site database 11 with the deepest classification hierarchy, and then proceeds to the equipment database 1
0, then the equipment group database 9 is requested to update the data updating means 5, and finally the relational database 8 is requested to update data to the related data updating means 4. The relational data updating means 4 and the data updating means 5 are
Updates / registers the instructed data in the instructed database.

As described above, according to the present invention, in inputting / outputting data to / from a database, in comparison with the conventional case where the relational calculation processing between data and the physical input / output to / from the database are performed, Since the output data determination means 3 collectively performs the determination processing required for input / output on a plurality of pieces of data, it is possible to significantly reduce the amount of processing at the lower level. Since the data necessary for the classification hierarchy is included, the search / registration process is performed efficiently and quickly.

The scope of application of the present invention is not limited to the equipment installed in a thermal power plant, but can be applied to a nuclear power plant with a large number of installed facilities and other large-scale plants. In this case, the classification method and relationship of the data to be registered is specific to that plant, for example, in the case of a nuclear power plant, it is only necessary to change the "boiler" to "boiling water reactor", and the mechanism of the device itself. Need not be changed. Further, the equipment classification method is not limited to the three classifications such as “equipment group”, “equipment”, and “part” as shown in the above-mentioned embodiment, and the relation between the database and the item and the relation between the databases are described as By registering in the database, it is possible to distinguish the database to be referred to by the output data judging means, so that flexible classification according to various requirements can be incorporated in the apparatus.

[0022]

According to the present invention, the result is presented from the time when the condition on the large classification or the middle classification is specified by reducing the need to search all the related part data at the time of data retrieval. It is possible to shorten the search time up to and manage the equipment ledger efficiently.

[Brief description of drawings]

FIG. 1 is a configuration diagram showing an embodiment of an equipment ledger management apparatus according to the present invention.

FIG. 2 is an explanatory diagram illustrating an output screen of a data output device when a search condition is designated in the device of the present invention.

FIG. 3 is a flowchart illustrating a database determination method in the device of the present invention.

FIG. 4 is an explanatory diagram showing a structural example of a relational database in the device of the present invention.

FIG. 5 is an explanatory diagram showing an output example of a data output device in the device of the present invention.

FIG. 6 is a configuration diagram showing a configuration example of a conventional equipment ledger management apparatus.

FIG. 7 is an explanatory diagram showing a search condition designation and an output example of a search result in a conventional equipment ledger management apparatus.

[Explanation of symbols]

 1 ... Data output device 2 ... Data input device 3 ... Output data judging means 4 ... Relational data updating means 5 ... Data updating means 6 ... Relational data searching means 7 ... Data Retrieval means 8 ......... relational database 9 ......... equipment group database 10 ...... equipment database 11 ...... parts database.

Claims (3)

[Claims] 1. Equipment installed in a plant is classified into a large classification, a middle classification, and a small classification hierarchically, and information such as specifications, maintenance history of the equipment, and maintenance plan is stored for each classification. A large classification database, a middle classification database and a small classification database, a relational database that holds the relationship between the content information of these databases and the relationship between each database, a data input device for inputting data, and based on this input information Data updating means for updating the data in the database by means of the above, relational data updating means for updating the relationship between the information, data retrieval means for retrieving the data as required by the user, and data required for retrieving this data. Related data search means having a function of extracting relationship information between the An equipment ledger management apparatus comprising: an output data determination unit that determines from a class database, a middle classification database, and a small classification database; and a data output device that displays a result. 2. The facility ledger management apparatus according to claim 1, wherein the major category is “equipment group”, the middle category is “equipment”, and the minor category is “site”. 3. The equipment ledger management apparatus according to claim 1, wherein the plant is a thermal power plant.