Key Technology Research And Industrial Application Of Real-Time Database

Under the big data background,The industrial Internet is facing severe challenges,which cause the relation database has been unable to fit the performance requirements of mass data in the structure design and algorithm research level.Therefore,it is urgent to propose real-time database theory more practical,in order to solve the question of real-time data extraction,calculation,cache and a series of operations based on the large capacity data accumulation demand,which including data modeling,transaction scheduling,concurrency control,compression,serialization and database recovery technology.The paper not only discusses the basic theory and key technology of the real time database,but also puts forward the overall design process of the system.The main tasks are as follows:(1)Abstract protocol gateway,data formats and naming specifications are different because of the numerous underlying industrial communication protocols.To achieve transparent service layer data transmission,we must shield the underlying protocol differences.Therefore,based on the OPC protocol specification,the driver interface and the batch reading and writing interface are abstracted from the bottom device.(2)Data service,periodically polling the data of the lower machine.Each polling is compared with the cache object.If it changes,it will be extracted to the buffer area and archived regularly,otherwise,the data object will be discarded.When the data is cached,the early warning condition is judged,and the warning notification is sent to the client(visual component)according to the various types of conditions.(3)Visual components,the lower machine parameter variables must be synchronized to the visual interface.We must analyze the Tag packets through the custom protocol to communicate with the client and the client.The system is based on the object oriented language C# and WPF to complete the overall system architecture and module development.The advantage of WPF lies in the separation of front and rear ends.The simple and beautiful visualization primitive can be designed by using the powerful design tool Blend provided by Microsoft,and the code control of the back end is simplified by the attribute dependent data binding technology,which increase the development efficiency.C# inherits the good features ofC++ and Java,and the code hosting technology based on the.NET framework has a good platform portability.