摘要
近年来,管控一体化已成为石化企业提高自身管理水平和生产效率的一种趋势。本文以吉化化肥厂为实例,从理论和实践两方面讨论了管控一体开发过程中的相关技术问题。
在这篇文章里我们采用多层分布式的方式进行系统的开发,利用Delphi5.0语言开发数据的采集、存储和应用。采用专用服务器HP Server作为过程数据服务器,利用OLE-DB这种接口技术,从DCS的ORACLE数据库中读取组态信息。利用OLE从DCS的内存实时数据队列读取生产系统实时生产数据并将其保存至SQL SERVER数据库中,利用SQL SERVER中的数据进行管理信息系统的开发。
本管理信息系统,重点实现厂内及各部门的生产运营、设备维护、安全运行等关键业务,采用先进的管理、统计、分析手段,优化生产流程,减少消耗,为各级领导提供生产决策重要的数据,为提高生产效率服务。
本系统主要包含有:物资管理子系统、安全监察管理子系统、生产运行管理子系统、财务管理子系统、综合查询子系统等。
In recent years, CMS (Control Integrated Management System) has become the development trend for petrol chemical enterprise to improve their producer's efficiency and management level . This paper uses JILIN Chemical Fertilizer Factory as an example, discusses some techniques about developing a CIMS from theory and practice two sides.
In this thesis , we adopt mutilayer distributed way to develop the system , and HP Server called process data server is used as database server and application program server. Delphi5.0 is used for collection , storing and applying the real time data. The industrial computers exchange real-time data with DCS ( Distributed Control System ) Oracle database through OLE-DB, then store them in SQL SERVER database for MIS ( Management Information System ) and get the configure information from DCS' real queues.
This management system mainly realizes manufacturing running , equipment maintaining and securing functioning etc. the key business between the different departments in the factory ; adopts advanced management , counting , analyse methods to optimize manufacturing flow, reduce
consuming ; provide some important data for the different levels leader's to make decisions to improve manufacturing efficiency.
This system includes: material management sub-system,
security supervision sub-system, financial management
sub-system, comprehensive consulting sub-system.
引文
(1) 闪四清.SQL Server7.0系统管理和应用开发指南.清华大学出版社,2000.2
(2) [美]Rick Sant s Angelo. NT Server系统管理员指南.清华大学出版社,1998.5
(3) [台]李维.Delphi 5.X分布式多层应用系统篇.机械工业出版社,2000.4
(4) 新智工作室.Delphi 5数据库编程.电子工业出版社,2000.9
(5) [美]James R. Croff, Paul N. Weinberg.关系数据库SQL使用指南(LAN Times Cuide to SQL).学苑出版社,1995.10
(6) [美]Carol HcCullough-Bieter.轻松学用Oracle 8I.电子、工业出版社,1999.11
(7) [美]Leonid Braginski, Matthew Powell. Internet Information Server 4.0使用大全.人民邮电出版社,1998.12
(8) 张光学.史美林.计算机操作系统教程.清华大学出版社,2000.1
(9) 赵春泉.Microsoft。Microsoft Windows NT Workstation 4.0 资源手册 科学出版社,1998.5.
(10) Wiederhold, Glo DataBase Design (Second Edition MCGraw-Hill Computer Science Series). MC Graw-Hill Book Company. 1983.1
(11) Honeywell IAC Coursware. Course NO:T5722 GUS/HPM IMP(2). Honeywell INC. Industrial Automation and Control Automation College.
(12) Honeywell IAC coursware. Course NO:T5722 GUS/HPM. IMP(1).Honeywell. INC. Industrial Automation and Control Automation College.
(13) ActiveX控件参考手册 科学出版社 赵军所译
(14) 三层体系的客户机/服务器,计算机应用 陈学威 陈凌云 2001.1