Research And Optimization On The Buffer Management Of Flight Inforamtion Database

Flight analysis DBMS stores the data of chinese aviation inforamtion, which is especially secret and important and is planned to be transfered to the domestic DBMS in the foreseeable future. Buffer management is the bottleneck of our flight analysis DBMS as it dominates the IO behavior. In this article, we trace and analyze the buffer sequence of the flight analysis DBMS and confirm that the traditional buffer strategies, like LRU, MQ and etc.,perform poor in the scene. Based on the analysis of the visitorial characteristic, we propose two optimizations to the buffer strategy, called Fixed Access and Dynamic Access In brief, the Fixed Access strategy pins some dimension relations in the buffer so that it avoids the performance loss of the reduplicative10request for them, when the Dynamic Access strategy optimizes the visit sequence of the data table according to the pages in the buffer dynamically. Experiments show the two strategies outperform the traditional buffer strategies and release the10pressure of the server. In the long run. We hope our research is instructive to the design of the buffer management of the domestic DBMSs and reduce the exposure of the localization of the aviation information system.