JP2002351903A - Database maintenance device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To shorten working hours and improve quality by improving efficiency of manual data input and data confirming operation in transferring data in an existing database to a new database. SOLUTION: The present invention is a database maintenance device which maintains and manages a database. It has a means to extract an existing data managing key only from an existing database 3 and output it to a database 5 corresponding to key information, read all data in the existing database separately and convert the existing data managing key of them to a preset new data managing key, convert a field configuration of the existing database 3 to that of a new database 9 referring to a file 6 corresponding to a field separately established, and in accordance with the field configuration, write data of the existing database 3 to the new database 9 and create the new database 9.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a plant database maintenance apparatus for maintaining and managing a database in a computer system for monitoring and controlling a plant such as a power plant.

[0002]

2. Description of the Related Art In a conventional database maintenance device of a computer system for monitoring and controlling a power generation plant, when data set in an existing database is migrated to a new database, conversion of a data management key or field conversion is performed. The data for converting the configuration has been input using a keyboard, a mouse, or the like with reference to the key information correspondence information and the field configuration correspondence information managed in documents and the like.

[0003] In addition, when a new database is created, or when a database used for screen format information or process input / output data (hereinafter referred to as I / O data) information is created, an existing form created as a form is used. From the data, data similar to the items of the plant database to be newly created was extracted, newly created as a form, and entered.

Further, even if the screen information has the same function, when there is a generational difference in the configuration of the screen database, the existing database cannot be used, and a new database has been created.

Further, when a new plant database is created based on an existing object database, one engineer analyzes the object database in operation, reads drawings and books relating to functions, and requires one engineer. I was collecting one piece of information.

When migrating existing graphic data to a new graphic database, an existing graphic is output as a drawing, and a ratio based on the resolution of a screen display device to be newly applied based on the output drawing is taken into consideration. While calculating the display coordinates and scale of each figure, the result is input to a new figure database by a keyboard or a mouse.

[0007]

As described above, in operation, a conventional database maintenance device for a plant includes:
The method often depends on humans, and has a plurality of problems as described below, and has a problem to improve these problems.

First, when data set in an existing database is transferred to a new database, information corresponding to a data management key is conventionally managed in a document or the like, and the data is manually referred to with reference to the information. I was typing. For this reason, there is a problem that it takes a long time for data input operation and data confirmation operation, and input errors such as omission and duplication occur.

Next, when new data is created, information necessary for the creation is manually collected from a plant database that is already in operation, so that it takes time to collect information, and furthermore, there is a need for work mistakes. There is a problem that the quality is deteriorated and a long time is required for the quality check operation.

Next, screen format information and I / O
When a database having a function that is related like information is created, necessary data is separately collected, and therefore, there is a problem that data inconsistency or omission occurs at the time of completion. In addition, in order to confirm the reliability of data created by collecting multiple file information,
There is a problem that it takes a long time to complete data creation because visual confirmation and the like must be finally performed.

Further, when a conventional database of I / O data is created, it is necessary to manually search for data on systems and manufacturers similar to the plant to be newly created from a plurality of materials. It takes time, there is a problem of selection error, and there is a problem of omission of entry when a new I / O data form is created.

Further, when a conventional database of I / O data is created, as described above, systems and manufacturers similar to the plant to be newly created are extracted from the existing database and edited. We were building a database. Therefore, if the number of existing plants increases, the amount of I / O data detected and acquired also becomes enormous, so that data that cannot be stored by the database maintenance device is held, and the data processing time becomes enormous. There is a problem that the physical storage medium needs to be very large, resulting in a large loss in processing time and a large processing cost.

Next, when the existing screen file is applied to a new database, the data structure is different, so that the data cannot be used as it is, the macro is customized, and the new data is stored in the existing screen. When there is no data in the data, there is a problem that the input must be made one screen at a time.

Next, conventionally, when a new database is created from the object database, even if a reliable database is currently operating, the engineer has to deal with a huge number of objects because the data format is the object database. Analyze the database and replace it with a human-readable format to edit the new database,
Instead of using the object database, data was manually extracted from paper books equivalent to the object database and a new database was edited.
Therefore, when editing a new database, there has been a problem that the information accuracy is reduced due to a human error, and that the data replacement operation takes time.

Further, conventionally, when a drawing of an existing graphic is transferred to a new graphic database, the coordinates and scale of the new graphic are manually calculated based on the resolution ratio, and the calculated graphic data is input. , The time required to validate the input data is enormous,
In addition, there is a problem that quality is deteriorated due to calculation errors. In addition, with the development progress of screen display devices represented by cathode ray tubes in recent years, the density of the resolution has been rapidly increasing, and therefore, there has been a problem that the resolution ratio with the existing screen display device has been various. .

In order to cope with these problems, the database maintenance apparatus according to the present invention, for all the above-mentioned problems, stops document management, performs data input mechanically, and reduces the work of humans as much as possible. The primary purpose is to avoid input errors.

Further, the database maintenance device of the present invention comprises:
A second object of the present invention is to reduce the data processing time and construct a new database without using a large storage medium for editing.

[0018]

According to a first aspect of the present invention, there is provided a database maintenance apparatus for extracting only an existing data management key from an existing database.
Data management key extracting means for outputting to the key information correspondence database, database reading means for reading all data of the existing database, and existing data management key among all data read by the database reading means, the key information Data management key conversion means for converting a new data management key separately set corresponding to the existing data management key output to the corresponding database, and the field configuration of the existing database converted by the data management key conversion means, With reference to the set field correspondence file, database field configuration conversion means for converting to the field configuration of the new database, according to the field configuration of the new database converted by the database field configuration conversion means,
Database writing means for writing data of the existing database to the new database and creating the new database.

According to the first aspect of the present invention, the data management key can be set without an input error such as omission or duplication.
Existing database and new database are consistent,
You can improve the quality of the database. Furthermore, data input errors due to differences in field names and data types can be reduced, and the quality of the database and the work efficiency can be improved.

According to a second aspect of the present invention, there is provided a database maintenance device for extracting only an existing data management key from an existing database and registering the extracted data management key in a data management key history database. Data management key changing means for changing the set existing data management key to a data management key of a separately set new database and registering the data management key in the data management key history database; Data management key replacement means for extracting only the key and replacing it with the new data management key registered in the data management key history database to create a new database, and refer to the existing data in the related database using the existing data management key And replace it with the new data management key A relational database data management key replacement means for creating a database, and having a database change means for changing the data in the existing database.

According to the second aspect of the invention, even if a change occurs in the data management key of the existing database, the history of the change of the data management key is subjected to generation management in the data management key history database. The data can be corrected. Further, it is possible to reduce the time required for data input and reduce human error at the time of data input.

According to a third aspect of the present invention, there is provided a database maintenance device for collecting data corresponding to a specified search condition from a plurality of existing databases, and data for displaying data collected by the data search unit. Display means, data selection means for selecting necessary data from the data displayed by the data display means, and data creation means for creating a new database using the data selected by the data selection means. Features.

According to the third aspect of the present invention, the data necessary for creating the plant database can be obtained mechanically by diverting the existing plant database. It is possible to reduce the trouble of collecting and checking the quality.

According to a fourth aspect of the present invention, in the database maintenance device according to the third aspect, a data management key and a data management key are obtained from a data management key / plant information file which is a new database obtained by the plant database maintenance device. Data management key / plant information reading means for reading plant information, and I / O information extraction for extracting I / O information from related data information files of a plurality of plants based on the read data management key and plant information Means for editing a data format using the I / O information and storing the edited data in a data storage file.

According to the fourth aspect of the present invention, the data extracted in the third aspect is obtained as a reference for creating a new database, thereby avoiding duplication of data management keys and information collection work of plant information. be able to. Further, when collecting data from a plurality of information files, by using a data management key and plant information having a common function, it is possible to prevent omission of data collection. Furthermore, by converting data extracted from a plurality of files without manual operation, editing can be performed at a higher speed than before, and work errors can be prevented.

A database maintenance device according to a fifth aspect of the present invention searches for I / O data of a plurality of existing databases,
I / O data search means for creating a read data file using the I / O data, and data to be edited for constructing a new database from the read data file created by the I / O data search means A first I / O data management key selecting / editing means for selecting a management key and creating an extracted data file in accordance with separately set editing contents, and creating a database based on the data of the extracted data file. Database creation means.

According to the fifth aspect of the present invention, conventionally, data described in a form is manually selected, the selected data is newly described in a form, and the newly described form data is input by input means such as a keyboard. The trouble of inputting becomes unnecessary, and the quality of the I / O database can be improved by avoiding the occurrence of input errors and the like.

According to a sixth aspect of the present invention, a database maintenance device searches for I / O data of a plurality of existing databases,
I / O data search means for creating a database construction file using the searched I / O data, and a data management key to be edited for constructing a new data file from the database construction file, and selection. Second I / O data management key selecting / editing means for acquiring the data of the data management key obtained from the existing database, editing the data contents, and creating I / O data;
I / O database creation means for creating a new database based on I / O data created by the / O data management key selection / editing means.

According to the invention of claim 6, unlike the case of claim 5, it is not necessary to hold all the corresponding I / O data as an editing database, and the data management key (data point) of the corresponding I / O data is eliminated. ), Data can be reduced, a huge storage medium is not required, and the data processing time can be reduced.

A database maintenance device according to a seventh aspect of the present invention reads one screen of data from an existing screen file,
An existing screen file reading means that repeats until the data reading is completed, a macro dividing means for dividing each read macro data of one screen into macros of components, and creating an existing screen table, and the macro dividing means The data of the existing screen table is assigned to the existing screen table in the order of the existing screen table in accordance with the template data file of all macros used in the new database and the data allocation information file for each macro. And data allocation conversion means for generating

According to the seventh aspect of the present invention, since the allocation information is stored in a file, it is possible to flexibly cope with a case where the configuration of the macro in the new database is changed by customization or the like. In addition, most of the data can be automatically assigned by using the existing screen file that has been verified by the existing system as input data, and the labor required to create screen data is greatly reduced. It is possible to reduce the number of input errors and avoid occurrence of input errors and the like.

The database maintenance device according to claim 8 of the present invention reads the existing object database, divides the object format data into data configuration units according to the configuration definition of the existing object database table configuration file, and creates a data reading / writing unit for creating a divided database. Dividing means, field data obtaining means for obtaining divided data in field configuration units based on the field configuration file of the existing object database, and converting the field data into data for each field; field data obtained by the field data obtaining means; Field data replacing means for replacing an existing database with a field of a new database according to a field conversion specification file, and field data replaced by the field data replacing means A new format rearranging means for rearranging according to the configuration of the new database configuration file, and a data output means for outputting the result of the replacement and rearrangement to the new database by the field data replacing means and the new format rearranging means. It is characterized by having.

According to the eighth aspect of the present invention, in the control database maintenance device, it is possible to take in an existing object database and convert it to a new database.

According to a ninth aspect of the present invention, there is provided a database maintenance device for calculating a resolution ratio of an existing screen display device and a resolution ratio of a new screen display device and outputting the resolution ratio database to a resolution ratio database. Drawing database reading means for reading graphic data, graphic conversion means for converting coordinate data and scale data of the graphic data read by the reading means into new graphic data using a resolution ratio, and the graphic conversion means Graphic database writing means for writing the created new graphic data into the new graphic database.

According to the ninth aspect of the present invention, when an existing graphic database is migrated to a new graphic database, the migration can be performed mechanically with various resolution ratios, so that the efficiency of database production and the quality are improved. Can be achieved.

[0036]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 shows a first embodiment (corresponding to claim 1).

FIG. 1 shows a plant database maintenance device for maintaining and managing a database in a computer system for monitoring and controlling a plant by connecting distributed computers via a network. FIG. 3 shows a configuration diagram when a new database is created while performing automatic conversion of a data management key and automatic conversion of a field configuration.

The plant database maintenance device shown in FIG. 1 includes a data management key extracting means 1 for extracting a data management key from an existing database 3 to a key information correspondence database 5, and a database reading device for reading all data from the existing database 3. Means 2, a data management key conversion means 4 for converting a data management key with reference to a key information correspondence database 5, and a database field configuration for converting existing data into a field configuration of a new database 9 with reference to a field correspondence file 7. It comprises a conversion means 6 and a database writing means 8 for writing new data into the new database 9.

Based on the above configuration, the operation of the plant database maintenance device of the present embodiment will be described.

First, the data management key extracting means 1 uses the existing database example 10 as shown in FIG.
The existing data management key is extracted into the key information correspondence database 5. Here, in FIG. 2, "point" is used as a data management key. FIG. 2A2 shows an example (point) 11 of a key information correspondence database. Among them, the new data management key corresponding to the existing data management key is manually set.

The database reading means 2 is provided with the function shown in FIG.
Read all data of the existing database as shown in 1).

The data management key conversion means 4 converts the data read from the existing database 3 into the existing data management key and the new data management key with reference to the key information correspondence database 5.

Database field configuration conversion means 6
Converts the data of the field configuration of the existing database 3 into the field configuration of the new database 9. In the conversion of the field configuration, conversion is mainly performed according to the difference in the field name and the difference in the data type. FIG. 3 (B1) shows a field configuration example 13 of the existing database, and FIG. 3 (B2)
Is a field configuration example 14 of the new database,
Based on these, the field correspondence file example 15 of FIG. 3B3 is manually created.

Database field configuration conversion means 6
Refers to the field correspondence file 7 as shown in the field correspondence file example 15 in FIG. 3 (B3), determines the arrangement method of the new database, determines the field names of the data acquired from the existing database, and reads the data from the existing database. To get. The acquired data is converted into data that is responsible for the field configuration of the new database 9 by matching it with the new field name.

Finally, the database writing means 8 writes the data created by the database field configuration conversion means 6 into the new database 9. FIG. 2 (A3)
Shows the output result of the new database example 12. The data management key has been converted and the field configuration has been adapted to the new database to create a new database.

According to the first embodiment, when migrating an existing database to a new database, it is possible to create a new database while performing automatic conversion of the data management key and automatic conversion of the field configuration. The quality of the database can be improved.

FIG. 4 shows a second embodiment (corresponding to claim 2) of the present invention.

FIG. 5 shows that when the plant database maintenance apparatus recreates a plurality of related existing plant databases into a new database, it replaces the data management key and sets the data management key in another related database. FIG. 6 is a configuration diagram when performing the data management key replacement work performed.

The plant database maintenance device shown in FIG. 1 has a plurality of related existing databases (DB-A) 1.
6, data management key registration means 20 for extracting only the data management key from (DB-B) 17 and (DB-C) 18 and registering the data management key in the data management key history database 19; A data management key changing unit 21 for changing a management key; a data management key replacing unit 23 for automatically creating a new database 22 by replacing an existing data management key of the existing database 16 with a new data management key; ) For another existing database (DB-B) 17 and (DB-C) 18 in which data is set using the 16 data management key, a new database (DB-B) is replaced with a new data management key. 24 and (DB-C) 25, a related database data management key replacement means 26, and existing databases 16-1 And a database change means 27 for changing the data.

The operation of the plant database maintenance device of this embodiment will be described based on the above configuration.

First, the data management key registration means 20
The data management key is acquired from the existing databases 16 to 18 and registered in the data management key history database 19.

The data management key changing means 21 changes the data management key registered in the data management key history database 19 to a new data management key. in this way,
The history of data management key changes can be registered at any time. This is an operation added to the first embodiment.

The database changing means 27 reviews data of the existing database (DB-A) 16.
This is a countermeasure against the database field configuration unit in the first embodiment.

When the database change unit 27 completes the correction, the data management key replacement unit 23 acquires the data in the existing database 16 and, based on the data management key history database 19, updates the latest data corresponding to the original data management key. Select the management key and select the existing database 1
6, a new database (DB-A) 22 is created.

The related database data management key replacement means 26 replaces the data management key of the database (DB-A) 16 set in another existing database (DB-B) 17 and (DB-C) 18 with the database. Replace the new data management key with a new database (D
BB) 24 and (DB-C) 25 are created.

FIG. 5 shows an embodiment from the acquisition of the data management key to the replacement.

As shown in the figure, first, the data management key registration means 20 extracts data of the data management key A, which is a data item, from the existing database configuration table 28 and then extracts the data of the data management key history database configuration table 29. The data item is registered in the management key (REV0).

Next, the data management key changing means 21 converts the management key "AI0001" into a new management key "DI00".
If it is changed to “0”, “DI” is stored in the management key (REV1) of the data item of the data management key history database example 29.
000 ". As described above, the changed contents of the data management key are recorded in the data management key history database 19 as the history of the data management key.

Thereafter, the data management key replacing means 23
Acquire the existing database 16 (Example 28),
The data management key (REV) in the management key A of the data item
0), a separately set data management key (REV
1) is selected from the management key history database 19 (example 29), and REV0 (old management key) is replaced with REV1 (new management key). As a result, the new database is
Edited with a data structure like

FIG. 6 shows an embodiment in which the related database is created with reference to data.

As shown in the drawing, in the existing database configuration table 28a of the existing database (DB-B) 17, the item of the data 1 contains the existing database (DB-B) in advance.
-A) Sixteen data management keys “AI0099” are set.

Therefore, the related database data management key replacing means 26 acquires the configuration table 28a in the existing database (DB-B) 17, and obtains the data management key (REV1) corresponding to the data management key (REV0) of data 1.
Is selected using the configuration table 20 in the management key history database 19, and from REV0 (former management key) to REV1
(New management key) and the new database configuration table 30
A new database 24 is obtained with a data structure such as the data 1 of a.

According to the second embodiment, when recreating a new database from an existing plant database in a plurality of related plant databases, the data management key registration, change and replacement means are used. In addition, the work time can be reduced while maintaining the data quality of the new database.

FIG. 7 shows a third embodiment (corresponding to claim 3) of the present invention.

FIG. 13 is a block diagram showing a case where the plant database maintenance device automatically searches and collects necessary information from an existing plant database according to search conditions, and creates a new database using the collected data. It is.

The plant database maintenance device shown in FIG. 6 includes a data search means 36 for collecting information corresponding to a specified search condition from a plant database 35 of an existing plant, and a terminal 4 for storing the information collected by the means.
0, and data selection means 3 for selecting necessary information from the information displayed by the means.
8 and a data creating means 39 for creating a new plant database 41.

The operation of the plant database maintenance device of this embodiment will be described based on the above configuration.

FIG. 8 shows data along the flow from data search to data selection.

In the present embodiment, data is collected from the screen information file in the existing plant database 35, and the existing screen information file example 42 is shown in FIG.
It is shown in (A). As shown in the figure, the screen information file is managed by the screen name.

First, the data search means 36 searches the screen information file of each plant by a screen name arbitrarily specified (for example, a boiler system).

The data display means 37 displays the boiler system screen information of each corresponding plant as shown in a search result display example 43 of FIG. 8B.

The data selection means 38 selects process value display information (symbol display items, numerical display items, etc. in the screen) necessary for a new plant from the displayed screen.

At the end, the data creation means 39
As shown in the new screen information file example 44 of (C), the selected process value display information is copied from the selected existing screen to create a new screen and stored in the new plant database 41.

According to the third embodiment, when a plant database is created, necessary information such as new screen information is automatically searched and collected from an existing plant database according to search conditions, and the collected data is used. Thus, a new database can be created, so that there is less need for manual work as compared with the related art, and it is possible to reduce the work time and improve the quality.

FIG. 9 shows a fourth embodiment (corresponding to claim 4) of the present invention.

FIG. 13 shows that the plant database maintenance apparatus of the present invention searches and collects related information based on a data management key created from a plurality of information sources and plant information.
FIG. 4 is a configuration diagram when performing data format conversion and data storage.

The plant database maintenance device shown in FIG. 10 considers that the new plant database of the third embodiment has been created from a plurality of information sources and performs data management from this data management key / plant information file 45. Key data / plant information reading means 46 for reading keys and plant information, and I / O data for collecting information from a plurality of related data information files 47 based on the data management keys and plant information read using this means. It comprises an extracting means 48 and a data format editing / storing means 49 for editing information collected from a plurality of related data information into a data format and saving the edited data in a data saving file 50.

The operation of the plant database maintenance device of this embodiment will be described based on the above configuration.

FIG. 10 shows data along a flow from data extraction to database creation in this embodiment. Here, in FIG. 10, "point" is used as a data management key.

Example 5 of accumulated data shown in FIG.
Reference numeral 1 denotes new plant screen information 44 created from a plurality of information sources shown in the third embodiment, and shows data management keys and plant information collected and accumulated from the plurality of information sources. An example 52 of stored data information in FIG. 6B is a data management key and plant information set for each display item.

First, the data management key / plant information reading means 46 acquires the data management key and the plant information from the data file created in the third embodiment.

The I / O information extracting means 48 retrieves various necessary information from the related data information file 47 based on the read data management key and the plant information.

Here, the related data information example 53 in FIG. 10C is an example of a related data information file. This is I / O information separated for each plant, and the I / O information data is managed by a data management key (point).

Finally, the data format editing / storing means 49 converts the acquired related information into a data format to be used, and saves the converted file. FIG.
The new database example 54 of (d) is an example in which data is stored as a converted data storage file 50.

According to the fourth embodiment, related information retrieval, data format conversion and data storage can be performed based on key data and plant information created from a plurality of information sources. As compared with the conventional technique, there is an effect that human intervention is not required and information accuracy is improved.

FIG. 11 shows a fifth embodiment (corresponding to claim 5) of the present invention.

FIG. 11 is a configuration diagram in the case where I / O data is extracted from a plurality of plants in the plant database maintenance device of the present invention.

The plant database maintenance device shown in FIG. 11 searches for I / O data 55 of an existing plant and reads it into a read data file 57. A first method for recognizing a data management key to be edited and contents of editing to be constructed as I / O data of a newly created plant
I / O data management key selecting / editing means 58 and the I / O data created by the first I / O data selecting / editing means.
An I / O database creating means 60 for creating a new I / O database 61 from the data extraction file 59 is provided.

Based on the above configuration, the operation of the plant database maintenance device of the present embodiment will be described.

FIG. 12 shows data along the flow from data search to data conversion according to the present embodiment.

In the figure, “point” is used as a data management key. Reference numeral 62 in FIG. 12A denotes an existing plant I / O.
3 shows a configuration example of data 55.

First, the I / O data search means 56 performs a search by inputting a system and a maker (system = boiler, maker = M) as a search key for constructing a plant database, and reads a read data file. Create 57. The configuration example of the read data file 57 is shown in FIG.
63. Each I / O data retrieved from the existing plant I / O data of each plant is described by adding the name of the plant from which the data was retrieved.

The first I / O data management key selecting / editing means 58 selects a data management key to be edited from the retrieved read data file 57, creates an I / O data extraction file 59, and creates it. The data of the extracted data file 59 is edited. At the time of this editing processing, an editing processing type can be added. 64 in FIG.
Shows a configuration example of the I / O data extraction file 59 to which the editing processing type is added.

Further, when the first I / O data management key selecting / editing means 58 finishes the editing processing, the first I / O data management key selecting / editing means 58 updates the editing processing type and makes unnecessary I / Os in the new I / O database.
Set a deletion metric on your data.

Finally, the I / O database creating means 60
Determines the setting of the editing process type of the I / O data extraction file 59, and sets only the necessary I / O data to the new I / O data.
Output to the database 61.

According to the fifth embodiment, I / O data of an existing computer system can be created as it is as new I / O data, and I / O data forms for registration can be created and data can be created. Since the registration work can be omitted, it is possible to improve work efficiency and data quality.

FIG. 13 shows a sixth embodiment (corresponding to claim 6) of the present invention.

FIG. 14 is a configuration diagram when the plant database maintenance device extracts existing I / O data from a plurality of plants and creates it as new I / O data as it is.

[0099] The plant database maintenance device shown in the figure performs a data search from the existing plant I / O data 70 using a plant construction key, and creates a plant database construction file 72 by an I / O data search means 7.
1 and a data management key (point) for data management key information acquisition and editing from the plant database construction file 72, and the existing plant I / O
Second I to get data from data and edit data
/ O data management key selecting / editing means 73 and second I / O
A database creating means 74 for creating a new database 75 from the I / O data created by the O data management key selecting / editing means 73 is provided.

Based on such a configuration, the operation of the plant database maintenance device of the present embodiment will be described.

FIG. 14 shows data along the flow from data search to data conversion according to the present embodiment. In the figure, “point” is used as a data management key. FIG.
4 (a) shows an example 76 of the existing plant I / O data.

First, the data search means 71 performs a search by inputting a system and a maker (system = boiler, maker = M) as a plant construction search key from the existing plant I / O data 70. The data management key of each plant is extracted, and a plant database construction file 72 is created. A plant database construction file example 77 in FIG. 14B shows a configuration example of the plant database construction file 72, and includes a data management key (point) and a name of each searched I / O data, It is described by adding a plant identification key of the existing plant I / O data from which the data was retrieved.
In this respect, the size is reduced as compared with the read file example 63 of the fifth embodiment.

The second I / O data management key selecting / editing means 73 selects a data management key to be edited from the plant database construction file 72 retrieved and retrieved, and selects the selected point and its data. Is extracted from the existing process I / O data 70, and the data is edited while displaying the extracted I / O data. Reference numeral 78 in FIG. 14C shows a configuration example of the new I / O database 75.

Finally, the I / O database creating means 74
In the data, the file that has been edited by the second I / O data management key selecting / editing unit 73 is stored in a new I / O data management key.
Output to the / O database 75.

According to the sixth embodiment, the I / O data of the existing computer system can be created as it is as new I / O data on the database maintenance device, and the I / O data form for registration can be created. Creation and data registration work can be omitted, and work efficiency and data quality can be improved. Furthermore, compared with claim 5, it is not necessary to hold all the I / O data of the corresponding plant as an editing database, and only the data management key (data point) of the I / O data of the corresponding plant is stored. Accordingly, the data can be reduced, a huge storage medium is not required, and the data processing time can be reduced.

FIG. 15 shows a seventh embodiment (corresponding to claim 7) of the present invention.

FIG. 14 is a configuration diagram when the plant database maintenance device mechanically creates a new screen table file from an existing screen file.

The plant database maintenance device shown in the figure reads the existing screen file reading means 81 which reads data of one screen from the existing screen file 80 and repeats until the data reading is completed, and the data of one screen read. Of the existing table 8
3, a macro data unit 84 for creating macros 3, a macro data file 84 for all macros used in the new database, and a data allocation information file 85 for the macros. It is composed of data allocation conversion means 86 for performing allocation conversion using information and creating an output table file 87.

Based on such a configuration, the operation of the plant database maintenance device of the present embodiment will be described.

FIG. 16 shows data along the flow from the reading of an existing screen file to the creation of an output data file according to the present embodiment. FIG. 16A shows an existing screen file example 88, which shows that the existing screen file 80 is composed of a plurality of macros.

First, the existing screen file reading means 81
Reads the screen data of the data area for one screen from the existing screen file 80 in which all the screen information is stored.

The macro dividing means 82 stores the existing table 8 for each macro based on the read screen data for one screen.
Create 3.

Finally, the data allocation conversion means 86 stores the macro template data and allocation information corresponding to the existing table 83 divided for each macro into the template data file 84.
And a data allocation information file 85, and allocates data according to the template structure to create a new table file.

Note that the template data has a table of a structure that can be used in a new database and macro information indicating a shape, and the allocation information defines a data allocation method for each macro. Types of allocation methods include allocation using default values in the template table, allocation referring to data in the existing table, and allocation of separately prepared constant values and formulas.

Examples in which data is allocated to a template structure in accordance with allocation information are shown in FIGS.
Shown in

The existing table example 89 in FIG. 16B is the data of the XXX macro corresponding to one macro of the existing table and has already been allocated.

FIG. 18C shows an example of a macro template table 90.
X is a similar macro that exists on the macro model table of the model data file 84 corresponding to the XXX macro.
The structure of the XXa macro is selected for a new table.

The data allocation information table example 91 shown in FIG. 18D instructs each item of the XXXa macro to follow the definition information.

In this example, according to the item 1 definition information “see existing table 1.”, the items 1.
In the output table according to item 2 definition information “see template table 2.”. Is set to “shape a”, and item 3
According to the definition information “set fixed value 3”, item 3 in the output table. Is set to “fixed value 3”.

The new table example 92 of FIG. 16E is obtained by the data allocation conversion means performing the above operation.

According to the seventh embodiment, if the template data file 84 and the data allocation information 85 are created in advance, a new database can be mechanically created from the existing screen file 80, so that the screen data is created. The labor of the operator becomes unnecessary, and the occurrence of input errors and the like can be avoided.

FIG. 17 shows an eighth embodiment (corresponding to claim 8) of the present invention.

FIG. 20 is a configuration diagram in the case where the plant database maintenance apparatus mechanically creates a database to be newly used for the plant monitoring system from the existing object database.

The plant database maintenance device shown in the figure reads the existing object database 97 and divides it into each table unit by the existing database table configuration file 96, and the data reading / dividing unit 95 The divided database A0 thus created is stored in the existing database field configuration file 9
9, a field acquiring means 98 for dividing the data into field structures and a data obtained by dividing the data for each field structure from the existing object database 96 to the new database A.
6, the field conversion specification file A2
A1 for performing field replacement processing according to the above, a new format rearranging means A3 for rearranging the data that has been replaced for each field in the format of the new database configuration file A4, and a new database for rearranging the data. Data output means A5 for outputting to A6
It is composed of

Based on such a configuration, the operation of the plant database maintenance device of the present embodiment will be described.

FIG. 18 shows the configuration of the reading / dividing means and the field obtaining means in this embodiment.

In the figure, data reading / dividing means 95
Means a plurality of existing object databases (A, B,
C) Existing object database table configuration file A defining the table size for each table from A8
According to 7, a divided file AA divided for each table is created.

Further, the field data obtaining means 98
From the divided file AA for each table of the existing object database, the field data AC divided for each field structure in FIG. 19 is created according to the existing object database field configuration file A9 indicating the field structure of the existing object database.

FIG. 19 shows the structure of the field replacing means and the new format rearranging means of the present embodiment.

The field replacing means A1 creates the conversion data AE in accordance with the field data AC and the field conversion specification file AB defining the field conversion specification.

The new format rearranging means A3
Converts the converted data AE converted according to the conversion rules into a rearrangement configuration file AD defining an array of a new format.
, The rearrangement data AF of FIG. 20 is created.

FIG. 20 shows the configuration of the output means of this embodiment. As shown in the figure, the data output means A5 outputs a new database AG from the rearranged data AF.

According to the eighth embodiment, it is not necessary for an engineer to analyze an existing object database or to input a new database described on paper via input means such as a keyboard, as in the conventional case. In addition, it is possible to avoid input errors and the like, and to improve the quality of the database.

A ninth embodiment (corresponding to claim 9) of the present invention is shown in FIG.

FIG. 14 is a configuration diagram in the case where the plant database maintenance apparatus of the present invention mechanically performs the operation of transferring an existing graphic database to a new graphic database at various resolution ratios.

The plant database maintenance device shown in the figure calculates a resolution ratio using the resolution of an existing screen display device and the resolution of a new screen display device, and outputs a resolution ratio database B2 as a resolution ratio database B2.
A figure database reading means B4 for reading all figure data from the existing figure database B3; and a figure data read by the figure database reading means B4.
A graphic conversion means B5 for converting coordinate data and scale data into new graphic data according to the resolution ratio obtained from the resolution ratio database B2, and a new graphic data generated by the graphic conversion means B5 as a new graphic database B
7, a graphic database writing means B6 for writing the data into the graphic database.

Based on such a configuration, the operation of the plant database maintenance device of the present embodiment will be described.

FIG. 22 is a configuration diagram showing an example of a data file provided in the plant database maintenance device of FIG.

First, figure database reading means B4
Reads all graphic data from the existing graphic database B3. FIG. B3A shows an example of existing graphic data.

The graphic database reading means B5 uses the resolution ratio data shown in FIG. B2A to read the existing graphic data B read by the graphic database reading means B4.
Of the 3A, the coordinate data and the scale data are converted to obtain new graphic data B7A. Note that data that does not require conversion by ratio calculation is shifted to new graphic data B7A without conversion.

Finally, the new figure data writing means B6
Writes the new graphic data of FIG. B7A into the new graphic database B7.

According to the ninth embodiment, when an existing graphic database is migrated to a new graphic database, graphic data with various resolution ratios can be mechanically migrated, so that the efficiency of database creation and the quality can be improved. Can be planned.

[0143]

As described above, according to the database maintenance apparatus of the present invention, management by documents can be stopped, data can be input mechanically, human operations can be reduced as much as possible, and input errors can be avoided. At the same time, the data processing time can be shortened, and a new database can be constructed without using a large recording medium for editing, so that the efficiency of database creation and the quality can be improved.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a plant database maintenance device according to a first embodiment of the present invention.

FIG. 2 is a configuration diagram showing an example of a database file provided in the plant database maintenance device of FIG. 1;

FIG. 3 is a configuration diagram showing an example of a data configuration file provided in the plant database maintenance device of FIG. 1;

FIG. 4 is a configuration diagram of a plant database maintenance device according to a second embodiment of the present invention.

FIG. 5 is a configuration diagram showing an example of a database file provided in the plant database maintenance device of FIG. 4;

FIG. 6 is a configuration diagram showing an example of a configuration data file provided in the plant database maintenance device of FIG. 4;

FIG. 7 is a configuration diagram of a plant database maintenance device according to a third embodiment of the present invention.

FIG. 8 is a configuration diagram showing a data flow in the plant database maintenance device of FIG. 7;

FIG. 9 is a configuration diagram of a plant database maintenance device according to a fourth embodiment of the present invention.

FIG. 10 is a configuration diagram showing a data flow in the plant database maintenance device of FIG. 9;

FIG. 11 is a configuration diagram of a plant database maintenance device according to a fifth embodiment of the present invention.

FIG. 12 is a configuration diagram showing an example of a data file in the plant database maintenance device of FIG. 11;

FIG. 13 is a configuration diagram of a plant database maintenance device according to a sixth embodiment of the present invention.

FIG. 14 is a configuration diagram showing an example of a data file in the plant database maintenance device of FIG. 13;

FIG. 15 is a configuration diagram of a plant database maintenance device according to a seventh embodiment of the present invention.

16 is a configuration diagram showing an example of a data file in the plant database maintenance device of FIG.

FIG. 17 is a configuration diagram of a plant database maintenance device showing an eighth embodiment of the present invention.

18 is a configuration diagram showing an example of a data file provided in the plant database maintenance device of FIG.

FIG. 19 is a configuration diagram showing a continuation example of data files provided in the plant database maintenance device of FIG. 17;

20 is a configuration diagram showing a further example of a data file provided in the plant database maintenance device of FIG. 17;

FIG. 21 is a configuration diagram of a plant database maintenance device according to a ninth embodiment of the present invention.

FIG. 22 is a configuration diagram showing an example of a data file provided in the plant database maintenance device of FIG. 21.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Data management key extraction means, 2 ... Database reading means, 3 ... Existing database, 4 ... Data management key conversion means, 5 ... Key information correspondence database, 6 ... Database field configuration conversion means, 7 ... Field correspondence file, 8 ... Database writing means, 9 New database, 10 Existing database example, 11 Key information correspondence database example, 12 New database example, 13 Existing database field configuration example, 1
4 Example of field configuration of new database, 15 Example of file corresponding to field, 16 Existing database A, 17 Existing database B, 18 Existing database C, 19 Data management key history database, 20
... data management key registration means, 21 ... data management key change means, 22 ... new database A, 23 ... data management key replacement means, 24 ... new database B, 25 ...
New database C, 26 ... related database data management key replacement means, 28 ... existing database configuration table,
29: Data management key history database configuration table, 30
... New database configuration table, 28a ... Existing database B configuration table, 30a ... New database B configuration table, 3
5: Existing plant database, 36: Data search means, 37: Data display means, 38: Data selection means, 39: Data creation means, 40: Terminal, 41: New database, 42: Existing plant screen information file example, 43 ... search result display example, 44 ... new plant screen information file example, 45 ... data management key, plant information file, 46 ... data management key, plant information file reading means, 47 ... related data information file, 48 ...
Related data information acquisition means, 49: data format editing / storing means, 50: data saving file, 51: data example according to the third embodiment, 52: information example of accumulated data, 53
... Example of related data information, 54 ... Example of new database file, 55 ... Existing plant I / O database, 56 ... I
/ O data search means, 57 read data file, 5
8. First I / O data management key selection / editing means, 59
... I / O data extraction file, 60 ... I / O database creation means, 61 ... New I / O database, 62 ... Existing plant I / O data configuration example, 63 ... Read data file configuration example, 64 ... Extraction data file configuration Example, 70
... existing plant I / O database, 71 ... I / O data search means, 72 ... plant database construction file, 73 ... second I / O data management key selection / editing means, 74 ... I / O database creation means, 75 ... New I
/ O database, 76: example of existing plant I / O data configuration, 77: example of database construction file configuration for plant, 78: example of new I / O database file configuration, 8
0: Existing screen file, 81: Existing screen file and reading means, 82: Macro division means, 83: Existing table, 84: Model data file, 85: Data allocation information file, 86: Data allocation means, 87: Output Table file, 88: Existing screen file example, 89: Existing table example, 90: Macro template table example, 91: Data allocation information table example, 92: Output table example, 95: Data reading / dividing means, 96: Existing object Database table configuration file, 97: Existing object database, 98: Field acquisition means, 99: Existing object database field configuration file, A0
... Divided database, A1 ... Field replacement means, A2
... Field conversion specification file, A3 ... New format rearranging means, A4 ... New database configuration file, A
5: data output means, A6: new database, A7: existing object database table configuration, A8: existing object database, A9: existing object database field configuration, AA: divided object database, AB: field conversion specification file, AC
... field data, AD ... sorting configuration file, A
E: converted data, AF: rearranged data, AG: new database, B1: resolution ratio calculation means, B2: resolution ratio database, B2A: example of resolution ratio data file, B3: existing graphic database, B3A: existing graphic data file B4: Graphic database reading means, B5: Graphic data conversion means, B6: Graphic database writing means, B7: New graphic database, B7A
... An example of a new graphic data file.

 ──────────────────────────────────────────────────続 き Continuing on the front page (72) Inventor Masakazu Sato 1 Toshiba-cho, Fuchu-shi, Tokyo Toshiba Corporation Fuchu Works Co., Ltd. (72) Atsushi Kawachi 2-24-24 Harumicho, Fuchu-shi, Tokyo 1 Inside System Technology Co., Ltd. (72) Inventor Hideo Nakajima 2--24, Harumi-cho, Fuchu-shi, Tokyo Toshiba System Technology Co., Ltd. (72) Inventor Masamitsu Fukada 2--24, Harumi-cho, Fuchu-shi, Tokyo 1 Toshiba System Technology Co., Ltd. (72) Inventor Kenji Iizuka 2-24-24 Harumi-cho, Fuchu-shi, Tokyo (72) Inventor Kiyono Kitajima 2-24 Harumi-cho, Fuchu-shi, Tokyo No. 1 Toshiba System Technology Co., Ltd. (72) Inventor Hideaki Yoshie Fuchu-shi, Tokyo 2-24-24, Mimachi 1 Toshiba System Technology Co., Ltd. (72) Inventor Hiroaki Tonoyama 2-24-24 Harumicho, Fuchu-shi, Tokyo F-term in Toshiba System Technology Corporation 5B075 ND06 ND20 ND20 ND23 ND34 QT03 UU40 5B082 GA07

Claims (9)

[Claims] 1. A data management key extracting means for extracting only an existing data management key from an existing database and outputting it to a key information correspondence database; a database reading means for reading all data of the existing database; and a database reading means. Data management key conversion means for converting an existing data management key of all the read data into a new data management key separately set in accordance with the existing data management key output to the key information correspondence database; A database field configuration conversion unit that converts the field configuration of the existing database converted by the data management key conversion unit to a field configuration of a new database by referring to a separately set field correspondence file; and conversion The according to the configuration of the field in the new database, writing the data in the existing database to a new database, database maintenance apparatus characterized by having a database write means for creating a new database. 2. A data management key registration means for extracting only an existing data management key from an existing database and registering it in a data management key history database, and separately setting the existing data management key registered by the data management key registration means Data management key changing means for changing to the data management key of the new database, and registering the data management key in the data management key history database; reading all data from the existing database, extracting only the existing data management key, Replace with a new data management key registered in the history database,
A data management key replacement means for creating a new database; a related database data management key replacement means for creating a new database by referring to existing data in a related database using an existing data management key and replacing with a new data management key; A database maintenance device comprising: a database changing unit that changes data of a database. 3. A data search means for collecting data corresponding to a specified search condition from a plurality of existing databases, a data display means for displaying data collected by the data search means, and a display by the data display means. A database maintenance device, comprising: a data selection unit for selecting necessary data from the selected data; and a data generation unit for generating a new database using the data selected by the data selection unit. 4. A data management key / plant information reading means for reading a data management key and plant information from a data management key / plant information file which is a new database obtained by the plant database maintenance device; and the read data. Based on the management key and the plant information, I / O
I / O information extracting means for extracting O information; and editing a data format using the I / O information;
4. The database maintenance device according to claim 3, further comprising a data format editing / storing unit for saving the edited data in a data saving file. 5. An I / O data search means for searching for I / O data of a plurality of existing databases and creating a read data file using the I / O data, and A first I / O data management key for selecting a data management key to be edited for constructing a new database from the read data file and creating an extracted data file in accordance with separately set editing contents; A database maintenance device comprising: an editing unit; and a database creating unit that creates a database based on data of the extracted data file. 6. I / O data retrieval means for retrieving I / O data of a plurality of existing databases and creating a database construction file using the retrieved I / O data, and new data from the database construction file. A second I / O for selecting a data management key to be edited for building a file, acquiring data of the selected data management key from an existing database, editing data contents, and creating I / O data O data management key selecting / editing means; and I / O database creating means for creating a new database based on the I / O data created by the second I / O data managing key selecting / editing means. A database maintenance device, characterized in that: 7. An existing screen file reading means for reading data of one screen from an existing screen file and repeating until the data reading is completed, and dividing the read data of one screen into macros of parts constituting the data. Macro dividing means for creating a screen table; a template data file of all macros used in a new database for the data of the existing screen table created by the macro dividing means; and a data allocation information file for each macro. And a data allocation conversion means for allocating the existing screen tables in the order of the existing screen tables and generating an output table file. 8. A data reading / dividing means for reading an existing object database, dividing the object format data into data configuration units according to the configuration definition of the existing object database table configuration file, and creating a divided database, and a field of the existing object database. A field data acquisition unit that acquires divided data in field configuration units based on a configuration file and converts the data into data for each field; and converts the field data digitized by the field data acquisition unit from an existing database according to a field conversion specification file. A field data replacement unit for replacing a field of a database; Therefore, a database comprising: a new format rearranging means for rearranging; and a data output means for outputting the result of the replacement and rearranging by the field data replacing means and the new format rearranging means to a new database. Maintenance equipment. 9. A resolution ratio calculation means for calculating a resolution ratio of an existing screen display device and a resolution ratio of a new screen display device and outputting it to a resolution ratio database, and a graphic database reading means for reading all graphic data from the existing graphic database. A graphic conversion means for converting coordinate data and scale data of the graphic data read by the reading means into new graphic data using a resolution ratio; and a new graphic database for converting the new graphic data created by the graphic conversion means. And a graphic database writing means for writing data into the database.