Design And Implementation Of Database Based On SNMP In The MAU Network Management System

With the rapid development of the digital technology, network technology andInternet business, Radio and television network suffered a very big challenge.The currentnetwork of radio and television has been unable to meet the users. In order to improve thecompetitiveness, the administration of radio and television is reconstructing the cablenetwork. MAU(Multiple Access Unit) is the broadband access equipment that meets theradio and television network’s reconstruction, which is composed of ONU(OpticalNetwork Unit), optical receiver and the active EOC(Ethernet Over Cable). MAU canreceive CATV signal and IP data signal at the same time, and output the mixed-signal tocoaxial cable network, then match up with the active EOC terminal equipment as the lastmile high-speed Internet access solution. MAU integrated services include data services,video services, water meter services, gas meter services, ammeter services and so on. Withthe rapid increase in user and business, a very urgent problem appears that how to keep thesafety and effectiveness of data, and improve the efficiency of the management of data.This thesis is based on the project of MAU network management system, in this thesis Iresearch the database design and implementation.The thesis first base three mature network management technology, consider the datacharacteristic of MAU network management system, and build a system architecture thatbased SNMP network management technology. Then introduce the MySQL database anddesign method of the database, implement the process of the database by alarmmanagement achievement. In the database interface design, the traditional JDBC-baseddatabase access patterns have time-consuming and low efficiency problem, used databaseconnection pool technology, improve the system function and accelerate the speed of useraccess. At the same time, study the method of database backup and recovery, when thedatabase happen disaster, it can still ensure data security and reliability.Finally, write server application for the database data security, data integrity andconnection pool property to test the database, the test results show that design of databaseto achieve the desired results.