JPH07319911A - Device for preparing document data base definition information - Google Patents

Abstract

PURPOSE:To reduce work load and to interactively and visually prepare definition information by transferring required data from a displayed plant data table to a definition table by a rag and drop operation. CONSTITUTION:This document data base definition information preparing device is provided with a display 2 for displaying a plant data table 5 for storing a measured value indicating the operation state of a plant equipment and a document data base definition table 6 for defining the format of a document based upon data stored in the table 5. The operator drags necessary data to be used for a document in the table 5 displayed on the display 2 by the use of a mouse 4 and drops the dragged data on a prescribed position in the table 6. Thereby, the dragged data are transferred to a position on which a mouse button of the mouse 4 is released. Thus, the table 6 can be simply, interactively and visually prepared by this working without generating many input misses.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a form database definition information creating apparatus for creating a form database definition table necessary for creating a form output format in a plant monitoring control system.

[0002]

2. Description of the Related Art FIG. 6 is a schematic diagram showing the structure of a conventional form database definition information creating apparatus. In the figure, 1 collects data from each plant (not shown) and creates a form from the data. It is a form database definition information creating apparatus having a function to perform, and a form database definition information creating function for defining form data. Reference numeral 2 is a display of the form database definition information creating apparatus 1, and 3 is a keyboard for receiving an input from the creator of the form database definition information. Reference numeral 5 is a plant data table displayed on the display 2, which is made up of various data from each plant (not shown). Reference numeral 6 is a form database definition table created based on the plant data table 5 and displayed on the display 2.

FIG. 7A is a schematic diagram showing a display example of the plant data table 5 described above, and FIG. 7B is a schematic diagram showing a display example of the form database definition table 6. First, in FIG. 7A, the plant data table 5 is a database that configures information about a plurality of plants in a tabular form, with various information of each plant as one row (record). The data in each row consists of four items.

7A is an item (field) forming each line
The name, 7B is an identification number indicating the order of data, 8 is a station number for identifying a plurality of plants, the data type indicating whether the data is analog, digital, or pulse, and the data on the transmission line. A process tag number representing all information of each plant such as a record number, 9 is a signal name (for example, temperature) indicating the state of each plant, and 10 is a unit of symbol name (for example, in case of temperature, ° C) is there.

Next, in FIG. 7 (b), the form database definition table 6 is a database in which various kinds of information of each form are set as one line (record) and information regarding a plurality of forms is formed in a tabular format. 11A is the name of the item (field) that constitutes each line, and the data of each line consists of five items. 11B is a log tag indicating the order of logs (forms), 12 is the type of data and the identification number 7B.
Represents a logical address, 13 is a process tag number created based on the process tag number 8, 14 is a signal name created based on the signal name 9, and 15 is a unit 10
It is a unit created based on.

Next, the operation will be described. To create the form database definition table 6, the flowchart shown in FIG. 8 is executed. In FIG. 8, first, in step ST1, the creator views all the data in the plant data table 5 displayed on the display 2. Next, in step ST2, the data required for creating the form is searched. In step ST3,
The creator considers the type of data based on the contents of the process tag number 8 of the data retrieved in step ST2, and further considers the logical address 12 in combination with the identification number 7B.

In step ST4, the creator uses the keyboard 3 to input the above-mentioned logical address 12 into the form database definition table 6, and at the same time, process tag number 8, signal name 9, unit 10
, Process tag number 13, signal name 1 respectively
Transcribe to 4, unit 15. By this work, the form database definition table 6 is created.

[0008]

Since the conventional form database definition information creating apparatus is configured as described above, it is necessary to manually input data from the keyboard, and it takes time for the input work and the input operation is performed. There was a problem of making mistakes. Also, since the plant data table is not organized by data type,
If you need to input after checking the type of data by looking at the collectively displayed data table, and if you need data that meets certain conditions, the creator himself can display it on the display 2. There is a problem in that it is very troublesome to search for it from the plant data table 5 displayed on the screen and input it.

The present invention has been made to solve the above problems, and can reduce the operation of inputting from the keyboard and the work load of the creator searching for data, and can interactively and visually form the form database. The purpose is to obtain a form database definition information creation device capable of creating definition information.

[0010]

According to a first aspect of the present invention, there is provided a form database definition information creating apparatus, which comprises a pointing device for designating data displayed on a display means, and a plant data table displayed on the display means. The desired data is transferred to the form database definition table by a drag and drop operation.

In the form database definition information creating apparatus according to the second aspect of the present invention, a menu screen for selecting the data type is displayed, and the data type selected on the menu screen in the plant data table is displayed. A display means for displaying only the matching data is provided.

In the form database definition information creating apparatus according to the third aspect of the present invention, a condition setting screen allowing the input of a search condition is displayed, and a search specified in the condition setting screen in the plant data table is displayed. The display means is provided for displaying only the data that matches the conditions.

[0013]

In the form database definition information creating apparatus according to the first aspect of the present invention, the desired data in the plant data table is transferred by dragging and dropping onto the form database definition table by operating the pointing device. The work load is reduced, and form database definition information is created interactively and visually.

The form database definition information creating apparatus according to the second aspect of the present invention displays a menu screen allowing selection of data types, and matches the data type selected on the menu screen in the plant data table. Since only the data is displayed on the display means, the data to be selected is limited, the work load is reduced, and the form database definition information is created interactively and visually.

In the form database definition information creating apparatus according to the third aspect of the present invention, the control means displays the condition setting screen allowing the search condition to be input, and the condition setting screen in the plant data table is instructed. Since only the data matching the search conditions are displayed on the display means, the data to be selected is limited and the work load is reduced.
Form database definition information is created interactively and visually.

[0016]

【Example】

Example 1. An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a schematic diagram showing a configuration of a form database definition information creating apparatus according to an embodiment of the invention of claim 1.
The corresponding parts shown in FIG. 6, which is a conventional technique, are designated by the same reference numerals and the description thereof is omitted. In the figure, reference numeral 4 denotes a mouse (pointing device) used for designating the data displayed on the display (display means) 2 and a function designation area when creating the form database definition information. The display formats of the plant data table 5 and the form database definition table 6 are also the same as those shown in FIGS. Further, the form database definition information creating apparatus 1 has a CP (not shown).
U (central processing unit; control means) is built in, and the C
The PU controls the display 2, the mouse and the like and various controls.

Next, the operation will be described. To create the form database definition table 6, the flowchart shown in FIG. 2 is executed. In FIG. 2, first, in step ST5, the creator finds in the plant data table 5 displayed on the display 2 the data necessary for using the form. Next, in step ST6, the cursor is moved to an arbitrary position on one line of the required one line of data, and the line is dragged with the mouse 4. That is, the mouse 4 is moved while pressing the mouse button provided on the mouse 4.

Then, in step ST7, the data is dropped by the mouse 4 at a predetermined position in the form database definition table 6. That is, at a given position,
Release the mouse button on mouse 4. As a result, step S
The data dragged at T6 is transferred to the position at the time when the mouse button was released (drag and
drop). By this work, the form database definition table 6 is created easily, interactively, and visually with few input errors.

Example 2. Next, a second embodiment of the present invention will be described with reference to the drawings. FIG. 3A is a schematic diagram showing a display example of the plant data table 5 according to an embodiment of the invention of claim 2, and FIG. 3B is a menu window that can be selected for each type of data according to the embodiment. It is a schematic diagram which shows a display example. In the first embodiment described above, in step ST5 shown in FIG. 2, when searching for necessary data, the plant data table 5 shown in FIG. On the other hand, the second embodiment is characterized in that the data in the plant data table 5 is displayed for each type of data so that necessary data can be easily searched for.

In FIG. 3A, 18 A is a function execution instruction area displayed above the plant data table 5. In the second embodiment, the function name "display type" is displayed in the function execution instruction area 18A. When the mouse 4 is clicked, the function name is displayed.
The menu window shown in is displayed. Also, FIG.
In (b), 18B is a menu window (menu screen) for selecting the type of data to be displayed on the display 2 as the plant data table 5. In the menu window 18B, when the function execution instruction area 18A is clicked by the mouse 4,
It is displayed at a predetermined position on the display 2.

Next, 18C, 18D, 18E, and 18F are item name areas in which item names indicating options of the menu window 18B are displayed. In the item name area 18C, "display only analog data", items are sequentially displayed. "Display only digital data" in the name area 18D, "Display only pulse data" in the item name area 18E, and the item name area 1
“Batch data display” is displayed on the 8th floor. With the mouse 4, the item name areas 18C, 18D, 18E, 18
When any one of F is clicked, only the type of data corresponding to the clicked item name is displayed in the plant data table 5 shown in FIG.

Next, the operation will be described. In order to create the form database definition table 6, first, the creator clicks the display type 18A shown in FIG. 3A with the mouse in order to display the required data type on the plant data table 5. If you click the display type 18A,
The menu window 18B shown in FIG. 3A is displayed on the display 2. The creator is the menu window 1
Click the desired item name of 8B with the mouse 4. For example, the creator may enter the item name 18C in the menu window 18B.
When (“Display only analog data”) is clicked with the mouse 4, only analog data is displayed in the plant data table 5.

Alternatively, the creator may select the menu window 1
When the item name 18D of 8B (“display only digital data”) is clicked with the mouse 4, only pulse data is displayed in the plant data table 5.

When the item name 18F (“collective data display”) of the menu window 18B is clicked with the mouse 4, all the data are collectively displayed in the plant data table 5. From the data displayed as the plant data table 5 on the display 2, the creator follows a procedure similar to that of the first embodiment described above, that is, drags and drops a predetermined position in the form database definition table 6 in FIG. Post to.

As described above, in the second embodiment, since only the data of the type selected by the creator is selectively displayed on the display 2 and the necessary data is selected from the data, the data can be easily stored. It can be searched for and the form database definition table 6 can be easily created.

Example 3. Hereinafter, an embodiment of the present invention will be described with reference to FIG.
Will be described. FIG. 4 is a block diagram showing a configuration of a communication system of plant equipment according to an embodiment of the invention of claim 3. In the figure, 19 is a plant facility that is monitored and controlled. 20, 20, ..., 20 are plant facilities 19
A station that sends data from a plant controller (not shown) that performs various controls and monitoring, 21 is a transmission device for exchanging plant data, and 22 is a form created from data sent via the transmission device 21. It is a form creation device for doing.

Reference numeral 23 is a form database definition information creating device for defining a database for creating a form by the form creating device 2. 24A is station 2
It is a station number consisting of a two-digit number attached to each station 20 to identify each 0. The station number 24A is assigned to the upper two digits of the process tag number 8.

Next, FIG. 5 (a) is a schematic view showing a display example of the plant data table 5 according to an embodiment of the invention of claim 2, and is the same as the corresponding portion shown in FIG. 6 showing the prior art. The reference numerals are given and the description thereof is omitted. In addition, FIG.
FIG. 6 is a schematic diagram showing a display example of a search condition window for searching for data to be displayed in the plant data table 5. In FIG. 5A, 25A is a function execution instruction area displayed above the plant data table 5. In the function execution instruction area 25A, in the third embodiment,
The function name "Search" is displayed,
When the mouse 4 is clicked, the search condition window shown in FIG. 5B is displayed.

Further, in FIG. 5B, reference numeral 25B is a search condition window (conditions) for inputting search conditions when narrowing down the data to be displayed on the display 2 as the plant data table 5 shown in FIG. 5A. (Setting screen)
Is. 25C is a type area in which a type serving as a search condition is input when narrowing down the data to be displayed in the plant data table 5, and the "type" input by the creator is displayed in the type area 25C.

The process tag number is 8,
The signal name 9 or the unit 10 can be selected. Also,
25D is a character string area in which a character string to be searched for the type displayed in the type area 25C is input by the creator, and the character string area 25D is similar to the type area 25C. , "Character string" entered by the creator is displayed.

Next, the operation will be described. To create the form database definition table 6, first, in order to display only the data satisfying a certain condition on the plant data table 5, the creator clicks the search 25A shown in FIG. When the search 25A is clicked, the search condition window 25B shown in FIG. 5B is displayed. Here, the cursor is moved to the type area 25C.
Then, after inputting any one of the process tag number 8, the signal name 9, and the unit 10 which are the items of the plant data table 5 from the keyboard 3, the cursor is moved to the character string area 25D and the character string to be searched for is input to the keyboard 3 Enter from.

For example, in the plant equipment 19, when it is desired to display only the data coming from any one of the stations 20 on the plant data table 5, the type to be searched is set as "process tag number" and the desired character string is searched. Enter the station number 24A. At this time, a wild card may be used for the character string. As a result, only the data that matches the search condition is displayed in the plant data table 5 on the display 2.

For example, the desired station number 2
If 4A is "01", process tag number 24
In the search using A, if "01 *" is specified by a wild card, only the data transmitted from the station 20 of that station number can be displayed on the plant data table 5. Similarly, other search conditions such as the signal name 9 and the unit 10 can be searched.

The creator obtains the required data from the data displayed as the plant data table 5 on the display 2 by the same procedure as in the first embodiment described above, that is, according to the flowchart shown in FIG. Is selected and is transferred to a predetermined position in the form database definition table 6 by dragging and dropping.

As described above, in the third embodiment, since only the data related to the station number designated by the creator is selectively displayed on the display 2 and the necessary data is selected from the data, the data can be simplified. And the form database definition table 6 can be easily created.

Example 4. Moreover, each search item is arbitrarily combined to obtain a logical sum (OR) and a logical product (AN) of each item.
D) etc. can be searched, and only the data satisfying all the conditions are displayed in the plant data table 5 on the display 2.
May be displayed on the screen. In this way, by finely setting the search conditions, the data can be searched more easily, and the form database definition table 6 can be easily created.

[0037]

As described above, according to the invention of claim 1, a pointing device for transferring desired data from the plant data table displayed on the display means to the form database definition table by drag and drop operation is provided. Since it is configured to be provided, there is an effect that an input error and a work load can be reduced and the form database definition table 6 can be easily created.

According to the second aspect of the present invention, the menu screen for selecting the data type is displayed, and only the data in the plant data table that matches the data type selected on the menu screen is displayed. Since it is configured to have a display means that can be selected, the necessary data is selected from the types of data selected by the creator, so data can be easily searched, and input errors and work load are reduced. In addition, the form database definition table 6 can be easily created.

According to the third aspect of the present invention, the condition setting screen that allows the search conditions to be input is displayed, and only the data in the plant data table that matches the search condition designated on the condition setting screen is displayed. Since the data is displayed on the display means, the data to be selected is limited, the work load is reduced, and the form database definition information can be created interactively and visually.

[Brief description of drawings]

FIG. 1 is a schematic diagram showing a configuration of a form database definition information creating apparatus according to an embodiment of the invention of claim 1.

FIG. 2 is a flow chart showing a procedure for creating a database definition table 6 according to an embodiment of the invention of claim 1;

FIG. 3 is a schematic diagram showing a display example of a plant data table 5 and a menu window for selecting a data type to be displayed in the plant data table 5 according to an embodiment of the invention of claim 2;

FIG. 4 is a block diagram showing a configuration of a communication system of plant equipment according to an embodiment of the description of claim 3;

FIG. 5 is a schematic diagram showing a display example of a plant data table 5 and a search condition window for searching for data to be displayed in the plant data table 5 according to an embodiment of the invention of claim 2;

FIG. 6 is a schematic diagram showing a configuration of a conventional form database definition information creation device.

FIG. 7 is a schematic diagram showing a display example of a plant data table 5 and a form database definition table 6 of a conventional form database definition information creating apparatus.

FIG. 8 is a flowchart showing a procedure for creating a form database definition table 6 of a conventional form database definition information creating apparatus.

[Explanation of symbols]

1 form database definition information creation device, 2 display (display means), 4 mouse (pointing device), 5 plant data table, 6 form database definition table, 18B menu window (menu screen), 25B search condition window (condition setting screen) .

Claims (3)

[Claims] 1. A display means for displaying a plant data table that holds measured values representing operating states of plant equipment, and a form database definition table that defines a form format based on the data of the plant data table. In the form database definition information device, drag and
A form database definition information creating apparatus comprising: a control unit that transfers desired data from the plant data table displayed on the display unit to the form database definition table in response to a drop operation. 2. The control means displays a menu screen on which the data type can be selected on the display means, and searches the plant data table for data matching the data type selected on the menu screen. Then
The form database definition information creating apparatus according to claim 1, wherein only the data that matches the data type is displayed on the display means. 3. The control means displays a condition setting screen on which the search condition can be input on the display means,
2. The form according to claim 1, wherein the plant data table is searched for data matching the search condition designated on the condition setting screen, and only the data matching the search condition is displayed on the display means. Database definition information creation device.