The Real-time Database Development Research Based On The Commercial Database

With the combination between industrial manufacture and management becoming tightly, it is more and more necessary to realize the control and management integration. Real-time database is mainly used in the industrial process and commercial database takes the dominant place for the management. It results in the Phenomenal that different databases are used in the control and management field. That the two kinds of database are used in their own field does not only avoid the course for the control and management integration but also makes great waste of the resource. If the good combination between control and management is achieved and a new database can be designed with both the advantage of commercial database like strong function, easily using, good transplant and the real-time characteristic for manufacture control, it will played an inestimable role for the improving of the control and management integration process.This paper proposes a design scheme for real-time database by analyzing a very famous world-class real-time database called Industrial SQL Server based on main memory database (MMDB) technology and undamaged data compression algorithm. This design scheme includes three parts about real-time data arrangement module, MMDB design and undamaged data compression algorithm design. Real-time data arrangement module achieves the division for real-time data on the level of access priority by dependency matrix and access frequency and rationally arranges the real-time data in the main memory by arrangement function on the level of priority.The MMDB design realizes the whole MMDB design frame and the optimization for MMDB. This paper proposes a T-add tree optimization scheme for the solving of low efficiency of rotation in T tree and makes the efficiency of the visiting for real-time data improved. By the design of log, check point and reloading system the performance of transaction is improved and the safety of industrial manufacture is realized. The MMDB design in this paper does not only solve the real-time problem in the commercial database but also realizes the rise of the performance for commercial database.The data for industrial process mainly includes time label, quality code and value. These three data have their own characteristic in the data structure and data changes. This paper proposes a new synthesized compression algorithm by assorting the characteristic of the data based on the analyzing the undamaged data compression algorithm like Huffman coding, LZ series algorithm, RLE algorithm and so on. The algorithm realizes the compression for large number of data in high speed and high compression ratio in undamaged way .Compared with LZW undamaged algorithm, the experiment shows that the compression ratio and time of synthesized compression algorithm have great rises.