Introduction
The real-time database system is the supporting software for the development of real-time control systems, data acquisition systems, and CIMS systems. In the process industry, a large number of real-time database systems are used for control system monitoring, advanced system control and optimization control, and real-time data services and multiple data management functions are provided for enterprise production management and scheduling, data analysis, decision support and remote online browsing . Real-time database has become the basic data platform of enterprise informatization, which can directly collect and obtain various data in the process of enterprise operation in real time, and transform it into public information that is effective for various businesses, and meet the requirements of enterprise production management, enterprise process monitoring, and The need for real-time information integrity, consistency, and security sharing between business management and management can build a bridge of information communication between enterprise automation systems and management information systems. Help the various professional management departments of the enterprise use these key real-time information to improve the operational efficiency of production and sales.
An important feature of real-time databases is real-time, including real-time data and real-time transactions. Real-time data is the update cycle of on-site IO data. As a real-time database, the real-time data cannot be ignored. The real-time performance of general data is mainly restricted by field equipment, especially for some older systems. Transaction real-timeness refers to the speed at which the database processes its transactions. It can be event trigger mode or timing trigger mode. Event triggering means that the event can be scheduled immediately once it occurs. This type of event can be processed immediately, but it consumes system resources; while timing triggering is to obtain the scheduling right within a certain time range. As a complete real-time database, in terms of system stability and real-time performance, two scheduling methods must be provided at the same time.
For different types of companies in different industries, real-time database data sources are also different. Generally speaking, the main sources of data are DCS control system, control system established by configuration software + PLC, data acquisition system (SCADA), relational database system, direct connection to hardware equipment and data manually entered through man-machine interface. According to the collection method, it can be divided into: standard OPC method that supports OPC protocol, standard DDE communication method that supports DDE protocol, standard MODBUS communication method that supports MODBUS protocol, ODBC communication method through ODBC protocol, proprietary communication written through API Way, by writing the proprietary protocol drive method of the device, and so on.
Role
For modern industrial enterprises, how to enable decision makers to view production process data at any time so as to quickly make more flexible business decisions is the key to enterprise informatization construction , Among the resources that MES pays attention to, production process information is still an important resource. If the problem of real-time and effective upload of production process information cannot be solved, it will still not be able to fully utilize and protect the investment in MES and ERP management systems.
The core of the enterprise MES is the real-time historical database. The historical data of the factory is very valuable to the company. The core of the real-time database is the data archive management, which collects and stores thousands of points related to the process. Data, years of experience in applying historical database management tells us that it is difficult to know which data is necessary for future analysis. Therefore, saving all the data is the best way to prevent the loss of the required information. In addition, to improve the product, it is necessary to have information about the related materials and understand the current and past operating status. The real-time database collects and stores process information to guide process improvement, reduce materials, and increase output. The real-time database adopts today’s advanced parallel computing technology and distributed system architecture to efficiently compress real-time and quasi-real-time data and long-term historical storage. At the same time, it provides high-speed real-time and historical data services for enterprise managers to provide timely, Comprehensively grasp the production and sales situation, improve resource utilization and production reliability, thereby enhancing the core competitiveness of the enterprise.
The real-time database provides end users with fast and efficient factory information. Because the real-time data of the factory is stored in a unified database, everyone in the factory can see and analyze the same information no matter where they are. Information, client applications can make it easy for users to implement management at the factory level, such as process improvement, quality control, and failure preventive maintenance. Through the real-time database, application programs such as product planning, maintenance management, expert system, laboratory information system, simulation and optimization can be integrated, which can play a role as a bridge between business management and real-time production.
Related
The advantages and disadvantages of a real-time database system are mainly reflected in whether the functions it provides are complete, whether the system performance is superior, whether it can complete effective data access, various data Operation, query processing, access method, integrity check, guarantee related transaction management, transaction concept, scheduling and concurrency control, execution management and access control, security inspection.