Design And Implement Real-time Database And Transaction Scheduling Algorithm Research

Real-time database system is a particularly important part of industrial controlsystems. Real-time database systems can manage all real-time data of industrial controlsystems, and are equipped with massive data throughput and high-speed data processingcapabilities. Real-time database provides a data center for the entire control system soas to ensure the stable operation of the entire control system.According to the practical demands of industrial production, a well-structuredreal-time database system is designed and developed to serve as the data link betweenthe monitoring configuration software and industrial control system, and to provideefficient data support for the entire operation of the control system. Meanwhile, thecomponent-type modules are employed to construct the system in order to ensure theindependence among individual modules, which is suitable for system optimization andupgrading. The data storage model uses a three-layer structure as well as the data buffermechanism. This design can not only ensure the accuracy of the data storage, but alsoreduce the frequency of disk reading and writing, which can significantly reduce thesystem resource usage. The real-time scheduling is achieved with the aid ofpriority-based scheduling strategies, which can ensure the implementation of thetransaction. Moreover, the OPC protocol is used to realize the functions of dataexchange and event alarm.Based on the software system, the real-time scheduling algorithm is adopted tofacilitate the realization of real-time scheduling. By the analysis and implementation ofthe real-time scheduling algorithm, the efficiency and rationality of the scheduling arefurther improved. In this way, both the correct real-time scheduling and effectiveimplementation of the transaction can be easily achieved and carried out.The system uses the Visual C#as the programming language to build each functionmodule. C#inherits the advantage of the C/C++, and can meet the demand ofcomponent-type structure, and thus is suitable for the system development. Besides, it isa good support for the upgrading of software.Finally, a test is conducted for the entire system and algorithms. The test resultsand problems encountered are analyzed, and the solutions are presented, whichhighlights the future research.