Design And Implementation Of MMDB SQL Parser Of DaTang Traffic Statistics Module

This thesis takes the traffic statistics system on the SP30iEx switchboard of DaTang as the research topic, through the systemic analysis, the total design and the detailed design, the applications of MMDB are developed in subsystem of the traffic statistics. As a result of the enhancing magnitude telephone flux, the insufficient handling ability of the Traffic statistic subsystem causes some questions, which had the very tremendous influence to the database stability. Aiming at above problem, the introduction of MMDB, implement of the SQL sentence analysis, thus data basic operation and database management function and so on in the memory are implemented.C language is used, and the codes are compiled and debugged by GCC and GDB in RedHat Linux 7.2.The main results are:The author first analyzes the principle of work of the SQL parser, and proposes the plan. SQL Parser implements INSERT, UPDATE, and SELECT, DELETE function in the memory. MMDB provides function similar to the database for the upper application. Through the analysis of MMDB module, the author designs the API (SQL sentence) between the primary data gathering module (application level) and MMDB. It carries on the analysis according to the different sentence, and implements the basic function of MMDB. The author tests the codes, and achieves the anticipated result. Finally, there is still much work to do. The research to the complex sentences, such as the multiple complex conditions, need be implemented.