基于Ethernet工业控制网络实时数据库模型研究与开发设计

【作者】 程晓辉；

【导师】 郝晓弘；

【作者基本信息】 兰州理工大学 ， 电力电子与电力传动， 2004， 硕士

【摘要】 基于Ethernet网络的CIMS (Computer Integrate Manufacture System)系统的设计是一个复杂的工程，也是一个艰巨的挑战。其中，实时数据库是CIMS系统的基础，是管理、控制一体化的核心技术。本文通过研究实时数据库的原理，分析实时数据库技术，利用VB语言作为开发工具，完成系统设计的部分源代码。 实时数据库系统的设计包括以下几个部分，整体模型、点组态结构、报警处理、历史数据库、统计数据库、客户服务器通信、应用程序编程接口以及用户管理的设计。本文主要论述了点组态结构、实时数据库、历史数据库以及用户管理的设计与实现，并提出了基于COM技术设计历史数据库对其他客户应用的访问接口。 该系统软件的设计参考了国内外几个比较著名的组态软件产品，如国外Wonderware公司的Industrial SQLServer、AspenTech公司的实时数据库系统InfoPlus.21和国内的大庆金桥信息技术工程有限公司的ConRTDB等，以此为基础，融入了自己的新特色：1．利用VB强大、高效的界面生成能力以及基于对内存、硬件编程的特点和SQL Server数据库为基础开发本系统；2．提出了采用关系数据库和文件管理系统及内存数据库实现对不同访问要求的数据的存储和管理，既保证了数据的共享性、独立性、安全性、完整性，又节约了内存，保证系统的响应速度；3．使用面向对象的技术设计数据结构，利用直接内存访问技术设计实时数据库，历史数据库建立在结构化存储技术之上，基于COM技术设计历史数据库对其他客户应用的访问接口，满足了数据存储和数据共享的要求。4．实时数据库系统以DLL形式存在，有利于其它编程语言实现的ActiveX动画构件访问实时数据库。 该系统整体框架性的实现，为继续该课题的研究与开发打下了坚实的基础。更多还原

【Abstract】 The design of CIMS(Computer Integrate Manufacture System) based on Ethernet is a complex engineering, It’s also an arduous challenge. Thereinto, RTDBS(Real-Time Database System) is the base of CIMS, It is the kernel technology of management and control system. The paper mainly discusses how to design the whole frame and the realization means of medium and small configuration software of industrial control, and also provides part source code based on Visual Basic 6.0.The whole system can be devided into several parts: unitary model tag instrument input and output of the systems alarm processs historic database Statistic databases communications between client and server application programme interface and consumer management. The paper mainly design and implement the tag instruments historic database Statistic database and real-time database, and put forward designing the database based on COM in the industrial control system.The design of the system software refers to several domestic and overseas products, such as Industrial SQLServer(USA’s Wonderware company) InfoPlus.21( AspenTech company) and ConRTDB(Beijmg Jinqiao company) and so on, on such a base, We increase our own characteristic: Firstly, Using VB language and SQL Server database to program, making good use of VB’s strong and high-efficient ability and good function to manipulate the EMS memory and hardware to increase graphics interface. Secondly, the paper puts forward using relation databases file management system and memory database to realize the different data storage and management. In this way, the data can be kept the properties as sharing independency security and integrity. At the same time, it can save the memory room and ensure the response the speed; Thirdly, the Object-Oriented technology is applied in the design of the data structure, the real-time database is designed by the Direct Memory Address technology; an interface of the historical database to other client application is designed on the COM technology. All of this can reach the data storing and sharing requirement. Fourthly, real-time database system exists in DLL, the ActiveX Movie component can access real-time database system.The realization of the whole frame set up a good basic to continue this project’s research and development.更多还原