JPS58223840A - Data base controlling system of measurement and control system - Google Patents

Abstract

PURPOSE:To treat data for various types of sensors and controllers in the same way as the ordinary data without being conscious of the special properties of those data, by using them as just component elements of the data base of a system. CONSTITUTION:A processing program control part 9 transmits a request to a data base control part 10 where the data base is controlled. The part 10 reads out a data D', for example, through a record A, i.e., an index and along a link and sends it to the part 9. In the same way, the part 10 reads out the sensor data information of a sensor (a) which is written on a record E through a link and then transmits the data information to a processor 8. The processor 8 reads out the measured value of the sensor (a) connected to a process input/output device 6-1 of a slave station device 6 via a communication controller 3-1 and transmits it to the part 10.

Description

DETAILED DESCRIPTION OF THE INVENTION (1) Technical Field of the Invention The present invention relates to a database control method for measurement and control systems, particularly when various sensors and controllers are connected to a computer through communication lines and their status is read. This allows processing programs to be created without being aware of their special characteristics.

(2) Conventional technology and problems In measurement control systems, various sensors and controllers are placed in remote locations, connected to a computer via a communication line, and data from these sensors and controllers is read out. There is. Output data and control data from sensors and controllers.

Depending on the type, it may be a digital signal or an analog signal, and its data units vary widely, such as temperature in degrees Celsius, water depth in depth, and current in amperes. Therefore, it is necessary to process the measurement output of the sensor and the control output to the controller with full consideration of the hardware connection according to the characteristics of the sensor, controller, etc. For this reason, it was necessary to read measured values and send out control outputs using different logic using different programs for each sensor, controller, etc.

Even a simple change in hardware such as a sensor or a controller requires a change in the program itself, which often requires a large amount of man-hours, which is a problem in measurement control systems.

(3) Purpose of the Invention The purpose of the present invention is to improve the above-mentioned problems by making the data for various sensors and controllers a component of the system database, thereby making it possible to take into account the special nature of these data. An object of the present invention is to provide a database control method for a measurement/control system that allows data to be handled in the same way as general data without having to do so.

(4) Structure of the Invention In order to achieve this object, the measuring fist control of the present invention is implemented. In a measurement/control system having a data storage means for storing information and data, and a sensor and/or a controller,
A data reading means for reading data from the data storage means is provided, and measurement/control data information of the sensor and/or controller is stored in the data storage means, and the measurement/control data information is read out by the data reading means and based on this. The present invention is characterized in that data from the sensor and/or controller is processed by a processor to obtain data necessary for measurement and control.

(5) Embodiment of the Invention Before explaining the present invention in detail based on one embodiment, a database, which is a feature of the present invention, will be explained based on FIG.

In the present invention, sensor Z6. It also stores record information for a and controller b, and allows the processing program to access this record information in the same way as it accesses other data in the database, making it easy to handle data for senna and controller. It is.

That is, as shown in FIG.
, 6.7. The slave station devices 5 to 7 include a communication control device 5.
-0 to 7-0 are provided and are connected to the communication control devices 3-0 to 3-2 provided in the master station 1, respectively, and are also connected to the communication control devices 3-0 to 3-2 provided in the master station 1, and also to interfaces such as process input/output devices 5-1 to 7-1. A face is provided and connected to the sensor zOw''l controller b, etc.

Further, the slave station device 5 is provided with a memory 5-2, and the data storage device 2 is provided with recorders B, C, D, E, F, etc. that form a database.

These records A, B, C, etc. consist of a pointer part and a data part.The link status of the pointer part indicates the parent-child relationship between each record, and the actual data of each element is stored in the data part. In the database of the present invention, various sensor Z (Is6 and controller b data) connected via one communication line 4-0 to 4-2... can be logically combined.

Here, in FIG. 1, the measurement data of sensor α is not stored in the data section of record E linked to record B, but is connected via one communication line 4-1 as will be detailed later. The current value of sensor a is related as actual data, and record F linked to record C is sent as control data to controller b, which is also connected via communication line 4-2. Actual data is involved. Furthermore, sensor z0 is connected via communication line 4-0, and the pointer of record D indicates that record G, which is linked as a child of record D, exists in slave station device 5. It is being

The data structure for sensors and controllers written in records E-G includes pointers, flags, hardware addresses, data types, etc., as shown in Figure 2.
It is formed by effective data length, analog data conversion information, data unit system, etc.

Here, the pointer is required in the case of a trap 9 distributed database such as record G in the slave station device 5, and is formed by the station address of the slave station device 50 and the intra-station address of the sensor z0, and this station address and 4, which specifies the Senna connected to this slave station device 5 by the intra-station address.

The flag is identification data that indicates whether the record is associated with a sensor or controller. The hardware address is formed by the station address of the slave station device 6.70 to which the sensor α and controller b are connected via the communication line, and the unit address indicating the connection within the slave station device. The data type indicates whether the sensor or controller is a digital signal system or an analog signal system, and the effective data length indicates the data length at which each piece of data is valid on the hardware. Analog data conversion information is information on the scale conversion method for commonly used scales that is written in the analog data that is input and output from sensors and controllers. It shows ampere A for flow value, chi for humidity, tilt for water depth, degrees for angle, etc.).

Therefore, 9. For example, when reading the measurement data of sensor z0, first access the record person which is the index of the database, and from that pointer, read the sensor data information of record G in slave station device 5 via records B and D. Then, the error in the measurement data of sensor z0 is recognized. For example, information such as whether it is a digital type or an analog type, what the conversion data is, and what the data unit is, etc., is written. Then, the CPU separately reads out the measured value of this sensor zo,
The CPU can decode this based on the sensor data information and obtain the necessary measurement data.

Next, one embodiment of the present invention will be described based on FIG.

In the figure, the same reference numerals as in other figures indicate the same parts, 8 is a processor, 9 is a program control section, and 10 is a program control section for a database management system (hereinafter referred to as a database management section). In FIG. 3, for the sake of simplicity, only the communication control device 3-1 on the master station side is shown, and the others are omitted from the illustration.

Now, when a processing program requires data y and measurement data of sensor α for data processing, the processing program control unit 9 that executes the processing program transmits these requests to the database management unit 1o that manages and controls the database. do. In this case, the database management section 10 first traces the link via the record At-, which is an index, detects the position of the record d, reads out the data D', and sends it to the processing program control section 9. Separately, the database management unit 10 similarly recognizes that the sensor data information of the sensor α is written in the link record E. Thereby, the database management unit 10 reads out this sensor data information and transmits it to the process 8.

Based on this, the processor 8 reads the measured value of the sensor α connected to the process input/output device 6-1 of the slave station device 6 via the communication control device 3-1, and records this as the record E.
Based on the sensor data information obtained, necessary digital data is calculated and sent to the database management unit IO. The database management unit 1o sends this to the processing program control unit 9 that is the source of the access request. In this way, the processing program can obtain the data of sensor a in exactly the same way as, for example, data U stored in the database.

Next, a second embodiment of the present invention will be described with reference to FIGS. 4 to 6.

FIG. 4 shows the overall configuration of the centralized database for the measurement control system, FIG. 5 shows the record structure for sensors and controllers, and FIG. 6 is a configuration diagram of a second embodiment of the present invention.

In the example shown in FIGS. 4 to 6, the sensor a and the controller b are connected through the process input/output devices 13 and 14 of the master station 11. Sensor data information for sensor a is written in record E, and controller data information for controller b is written in record F. The record structure of each of these data information is as shown in Figure 5.
pointer.

Flags, hardware addresses, data types.

The effective data length, analog data conversion information, data unit system, etc. are also formed and are the same as in FIG.

Now, when the processing program requests data D and information about sensor a, the processing program control section 16 transmits this to the database management section 17. As a result, the database management section 17 reads the data D from the database formed in the data storage device 12 and sends it as is to the processing program control section 16, as in the case of FIG.

Separately, the database management W517 recognizes that the sensor data information of the sensor α is written in the twist record E in a similar link. The database management unit 17 reads this and sends it to the processor tsK. Based on this, the processor 15 reads out the measurement data of the sensor α via the process input/output device 13, and uses this as the above data obtained from... It creates desired data based on the server data information and sends it to the database management section 17. The database management section 17 sends this to the processing program control section 16. In this way, the processing program processes the desired data D.
In addition, in Figures 2 and 5, each piece of information other than the hardware address is stored as data indicating the parent-child relationship in the data structure instead of being stored in one record. It may be stored in the .

(6) Effects of the Invention According to the present invention, data from various sensors and controls can be read as one component of the database of the measurement/control system in the same way as other data.

Based on this, data required by the processing program can be obtained. Therefore, processing programs can be created without being aware of the special characteristics of digital signals, analog signals, foot measurement/control units, etc. of sensors and controllers, so data processing in the measurement/control system can be made more efficient.

[Brief explanation of the drawing]

Figure 1 is a configuration diagram of a database used in an embodiment of the present invention, Figure 2 is a record structure for sensors and controllers, Figure 3 is a configuration diagram of an embodiment of the present invention, and Figure 4 is a measurement and Overall configuration of centralized database for control system, Part 5
The figure shows the record structure for the sensor and controller, and FIG. 6 is a block diagram of another embodiment of the present invention. In the figure, 1 is a master station, 2 is a data storage device, 5 to 7 are slave station devices, 8 is a processor, 9 is a processing program control unit, and 10
is a program control unit for a database management system, 11
12 is a data storage device, and 13 and 14 are process input/output devices. Patent Applicant: Fujikan Co., Ltd. Representative Patent Attorney Akira Yamatani

Claims (1)

[Claims] (1) In a measurement/control system having a processor, a data storage means for storing data, a sensor, and/or a controller, a data reading means for reading out data from the data storage means is provided, and the data storage means is provided with a measurement/control means for the sensor and/or the controller. Control data information is stored, the measurement/control data information is read out by a data reading means, and based on this, sensor and/or controller data is processed by a processor to obtain data necessary for measurement/control. Features a database control method for measurement and control systems.