R & D Design, Real-time Database Model Based On The Ethernet Industrial Control Network

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.