DCS系统中数据库设计与访问实现

 http://www.chinalww.com.cn
中国论文网

DCS系统中数据库设计与访问实现 vb+sql 2000 

源程序+15500字论文（300元）

摘  要

本造气DCS控制系统以固定床间歇气化工艺为基础，以煤为原料进行汽化，气化过程分为吹风和制气两个阶段。作为氨合成的半水煤气是以氧气和蒸汽作为气化剂的制得的气体. 吹风是放热反应，它的目的是使炭层积蓄热量，为制气提供高温的反应条件；制气是吸热反应，它的目的是蒸汽和赤热的炭反应，制成合成氨生产所需要的一氧化碳和氢。
造气炉的最佳状态应是气化层在一定位置上温度均匀地逼近灰容点，但又不发生粘结成大块的长期稳定的生产状态, 操作过程中，对气化层温度、位置、厚度均匀性的判断分析是一项很复杂、难度极大的工作，需要通过诸多因素的变化，如炉上温度、炉下温度、气体成分、料层阻力、料层高度、灰渣情况等综合分析，并结合原料的物理化学特性仅能做出初步定性判断。
数据库的组织是构造本系统非常重要的一环，制作过程中实时采集的各项数据都需要及时存入数据库并加以调用，数据库的建设需满足数据库设计的基本要求。简洁、结构明晰的表结构对数据库的设计是相当重要的。规范化的表结构设计，在以后的数据维护中，不会发生插入（insert）、删除（delete）和更新（update）时的异常。反之，数据库表结构设计不合理，不仅会给数据库的使用和维护带来各种各样的问题，而且可能存储了大量不需要的冗余信息，浪费系统资源。
根据用户的要求完成某些功能。一个功能比较完善的系统应该能处理在程序运行时所遇到的错误。如果程序在错误处理上做得不好，可能在程序运行的某一环节或出现某种情况时导致程序运行停止，这样的程序用户不会欢迎的。

关键词：DCS控制系统，数据库技术，数据库设计，功能实现

 

ABSTRACT

The gas manufacturing DCS control system based on fixed-bed intermittent gasification process. It takes the coal as Raw materials to vaporize. The gasification process is divided into two stages as blowing and making gas. The gas semi-synthetic which use for Synthesis ammonia gas is take water vapor and oxygen as gasifying agent. Blowing is an exothermic reaction. Its purpose is to make carbon layer to save energy to provide a high-temperature reaction conditions for gas making. Gas making is an endothermic reaction. Its purpose is red hot steam and carbon reaction, produce carbon monoxide and hydrogen which are necessary for ammonia producing.
The best state-gasification about gas furnace is the long-term stability of the state of production that the temperature of gasification layer in a certain position approaching to gray capacity points uniformly without bond to chunks. In the process of operation, the judgment analysis about gasification temperature, location, the thickness uniformity is a very complex and extremely difficult task, requiring adoption of many factors, such as the temperature furnace, furnace temperature, gas composition, and layer resistance, layer height of the ash comprehensive analysis, combining the physical and chemical properties of raw materials to make preliminary qualitative judgment.
The organization of the database structure is a very important part of the system. The real-time data which acquire in the production process timely need to deposit into the database and be called. Database building in database design should meet the basic requirements. A Concise, clear structure database is very important to the design of the database. Standardization of table design, in the future data maintenance, will not come out the anomalies when be inserted (insert), remove (delete) and update (update). Instead, if the database table design is unreasonable, not only produce all kinds of problems in the use and database maintenance process, but also store a lot of redundant information, waste system resources.
We design this system according to the user's requirements to complete certain functions. A system which its function is relatively perfect should be able to handle mistake faced in procedures. If the error handling procedures are not done well, will be make the process stop at a certain sector or in a certain situation. Such a procedure would not be welcomed by the users.

Keywords: DCS control systems, Database technology, Database design, function realization

 

 

目 录

第1章  绪论 1
1.1系统开发背景 1
1.2系统开发的相关技术介绍 2
1.2.1 Visual Basic技术简介 2
1.2.2 SQL Server 2000 系统简介 3
1.2.3数据库技术的发展及SQL语言简介 4
1.2.4本系统中 vb访问数据库的方法 4
第2章 数据库技术的简介 6
2.1数据库技术的产生与发展 6
2.2数据库技术的研究领域 8
第3章  数据库设计 9
3.1 设计前的准备 9
3.2  数据库的设计 9
3.2.1数据库设计步骤 9
3.2.3数据库概念设计 9
3.2.4 数据库逻辑设计 17
第4章  主要功能的设计与实现 25
4.1概要设计 25
4.2实现思想 25
4.3详细功能实现 26
4.3.1 班信息设置的实现 26
4.3.2 信息公布的实现 30
4.3.3 电话号码簿的实现 31
4.3.4上月数据删除的实现 33
4.3.5工艺指标修改的实现 35
结 论 38
参考文献 39
致  谢 40