CN1175367C

CN1175367C - Method for real time collecting DCS data to computer web

Info

Publication number: CN1175367C
Application number: CNB011352434A
Authority: CN
Inventors: 王永昌; 徐守奎; 张小兵
Original assignee: Qilu Petrochemical Co of Sinopec
Current assignee: China Petroleum and Chemical Corp
Priority date: 2001-12-12
Filing date: 2001-12-12
Publication date: 2004-11-10
Anticipated expiration: 2021-12-12
Also published as: CN1426001A

Abstract

The present invention provides a method for collecting DCS data into a computer network in real time. The present invention comprises a DCS and a server which is provided with a real-time data base. The present invention is characterized in that a DCS interface is additionally installed, the data communication and access of the DCS and the server by the network can be realized by setting protocols, and a plurality of DCS are collected and screened in real time by driving the real-time data base. The data in the data base are automatically updated, the DCS data are collected into the computer network in real time in a remote mode, and then the data are processed and analyzed in order to be decided and used by managers. The present invention solves the defects that an original decision manager needs arriving at DCS sites point for point in order to know the practical production situation, the consumption of human and material resources is large, and the efficiency is low. The present invention also breaks the costly monopolistic conjuncture of the original data interface of the DCS, the project investment is reduced, and the service performance is better.

Description

The DCS real time data acquisition is gone into the method for computer network

Affiliated technical field

The invention provides a kind of DCS real time data acquisition and go into the method for computer network, especially relate to a kind of remote collection method that is applied to petrochemical enterprise DCS data.

Background technology

DCS is meant Distributed Control System (DCS), is used for Industry Control.It comprises historical station, engineer station and a plurality of workstation from becoming a cover system, gather the data of each workstation among each DCS in real time, must set up the data-interface of DCS.The ASPEN company of exploitation INFOPLUS21 real-time data base has developed the data-interface of most of DCS at present, TDC3000 as HoneyWell company, MOD300 of ABB AB or the data-interface of OCS, it can realize long-range the DCS real time data acquisition being gone into computer network, process analysis then, use for the decision-making management personnel, for in time making correct traffic order according to the variation of actual conditions, decision-making commander department lays the first stone, but a cover DCS need join an interface, about 2.4 ten thousand dollars of each interface (at present domestic also have do interface routine, about about 30,000 yuans of every interface), cost an arm and a leg, investment is big, and do not have source program, can not carry out corresponding secondary development as required; If do not realize long-range the DCS real time data acquisition being gone into computer network, the decision-making management personnel will understand the production actual conditions just to be needed---go deep into the DCS scene, that manpower and materials expend is many, efficient is low.

Summary of the invention

The purpose of this invention is to provide and a kind ofly can overcome above-mentioned defective, the long-range method of the DCS real time data acquisition being gone into computer network of price energy low, favorable working performance.

Comprise DCS, the server of real-time data base is installed, it is characterized in that: set up a DCS interface, make DCS and server realize data communication, visit by network by agreement is set, following steps are specifically adopted in data acquisition:

1., the image data cycle is set, pick up counting;

2., judge whether the time of image data: be less than, continue timing; Arrived, carried out next step;

3., utilize the special number of the account of each DCS to log on corresponding D CS, reading of data automatically;

4., the data that read are screened;

5., real-time data base is according to data in the automatically updating data database that reads, realize long-range the DCS real time data acquisition being gone into computer network.

Described DCS real time data acquisition is gone into the method for computer network, and the server that real-time data base is installed can be networked with many DCS, have only historical station that gateway is set among each DCS, and restriction is to the write-back function of the service data of DCS.

Described DCS real time data acquisition is gone into the method for computer network, real-time data base adopts the INFOPLUS21 real-time data base, utilize the data base link of SQLnet, ODBC and INFOPLUS21 in the INFOPLUS21 server, the result who uses the SQLplus statement directly will inquire about delivers in the INFOPLUS21 database.

Described DCS real time data acquisition is gone into the method for computer network, and DCS can be the TDC3000 of HoneyWell company, the MOD300 or the OCS of ABB AB.

The present invention compared with prior art, by being set, agreement make DCS and server connection realize communicating with one another, visiting of data for network, and the driving real-time data base carries out real-time collection, screening to a plurality of DCS, automatically data in the new database more, by computer network is long-range the DCS control data is collected real-time data base in real time, thereby reached monitoring to execute-in-place, whole device production dynamically comes into plain view, arrange production, in time find that for scientific and reasonable operation troubles lays the foundation, and cheap, very high economic benefit and social benefit are arranged.

Description of drawings

Fig. 1 is a wiring diagram of the present invention;

Fig. 2 is a workflow diagram of the present invention;

Embodiment

Server 1 all adopts the ICP/IP protocol networking with a plurality of DCS, realize communicating with one another, visiting of data, the real-time data base that is installed in wherein adopts the INFOPLUS21 real-time data base, utilize the data base link of SQLnet, ODBC and INFOPLUS21 in the INFOPLUS21 server, the result who uses the SQLplus statement directly will inquire about delivers in the INFOPLUS21 database.Each DCS comprises a historical station, an engineer station and a plurality of workstation, wherein has only historical station that gateway is set among each DCS, and limits the write-back function to the DCS service data, thereby guarantees the security of DCS control, prevents the influence of fortuitous event to DCS.Wherein the DCS system is ABB OCS V1.6/3.

Configuration and step are as follows:

SQLnet------------------------------------is installed on the INFOPLUS21 server, Oracle-for-win9X/NT is installed.

Configuration SQLnet parameter: Alias----------HOHP-SQLNET

Connected host name------------10.110.69.15

Communications protocol-------------------TCP/IP

Database routine name---------------advantdb

ODBC definition: driver-------------------Oracle73V2.5

DSN-----------------HOHP-ODBC

SQL ^*Net connects string--------------HOHP-SQLNET

INFOPLUS21 data base link definition: enter INFOPLUS21-SQLplus → Tables → Database-Links → Add-Link configuration parameters

Data-Source----------HOHP-DL

User-Name------------***

Password：***

Definition of data query note: CIM-VRDS-QR

Define dispatching cycle: enter Infoplus21 Administrator, select QueryDef, revise the parameter of query note.

After setting is finished, Infoplus21 will automatically, regularly pass through the INFOPLUS21 data base link according to the dispatching cycle that defines among the QueryDef, utilize ODBC that real time data is sent in the real-time data base, and the real-time acquisition step of data is:

1., be provided with per 2 minutes and gather a secondary data, pick up counting;

3., utilize the special account number of each DCS to log on visit corresponding D CS automatically, read the data of each point;

4., according to demand the data that read are screened;

5., real-time data base is according to original data in the automatically updating data database that reads, realize long-range the DCS real time data acquisition being gone into computer network.

Claims

1, a kind of DCS real time data acquisition is gone into the method for computer network, comprise DCS, the server of real-time data base is installed, it is characterized in that: set up a DCS interface, make DCS and server realize data communication, visit by network by agreement is set, following steps are specifically adopted in data acquisition:

1., the image data cycle is set, pick up counting;

4., the data that read are screened;

2, DCS real time data acquisition as claimed in claim 1 is gone into the method for computer network, it is characterized in that: the server that real-time data base is installed can be networked with many DCS, have only historical station that gateway is set among each DCS, and restriction is to the write-back function of the service data of DCS.

3, DCS real time data acquisition as claimed in claim 1 is gone into the method for computer network, it is characterized in that: real-time data base adopts the INFOPLUS21 real-time data base, utilize the data base link of SQLnet, ODBC and INFOPLUS21 in the INFOPLUS21 server, the result who uses the SQLplus statement directly will inquire about delivers in the INFOPLUS21 database.

4, DCS real time data acquisition as claimed in claim 1 is gone into the method for computer network, it is characterized in that: DCS can be the TDC3000 of HoneyWell company, the MOD300 or the OCS of ABB AB.