Research and Design of Database for Distributed Bridge Data Acquisition System
In this paper,it is focused on the method about the distributional database backup system. The system consists of MySQL database backup system in the data gathering station and a client application procedure for MySQL database in monitor center. Under the condition of not increasing the equipment cost,the system can resolve the problem of the lost gathering data in the long time running gathering system,whose data backup always uses the single database system. According to the industrial machine hardware configuration and the sensor data characteristic,the distributional database essential entity model is established. The effective index and the backup strategy are designed by the actual demand and the practice. And the dual cycle buffer and multithread database interface solves the hard disk I/O speed bottleneck. The problem of the network transmission pressure that is caught by the great data capacity is relaxed by the data compression algorithm.
distributed database backup system composite indez database management strategy data compression.
Weidong Ye Shenglong Li
Department of Automation Science and Electrical Engineering,302,Beijing Aeronautics and Astronautics University,Beijing,China,100191
国际会议
2009 9th International Conference on Electronic Measurement & Instruments(第九届电子测量与仪器国际会议 ICEMI2009)
北京
英文
814-819
2009-08-16（万方平台首次上网日期，不代表论文的发表时间）