Analyse And Design Of The Monitor Module In Billing Database

In this thesis, proposing the method of Network Sniff technology using to the monitor module of billing database system in Kunming telecom. It will be the practice basic and technology support in the going deep into the research of network security and network monitor in future.First, we introduce the background and definition of the Network Sniff technology, the excellence and shortcoming of the Network Sniff technology in network. Discussing the core of telecom billing system which is Oracle database, including the running condition, monitoring actuality and the existing problem of database at present. For resolving these problems, we base on the operation object of telecom billing system database in Kunming telecom, applying the sniff technology to capture the packet which put in and out to database server. Through analyzing the operation, status and the network environment, we realize the purpose of monitoring to billing system database. Because of using another PC to realize to monitor the network of database server, but not require the database server's intervening, Doing like this for making the database server loading lighter in busyness operation now. It will enhance the security and won't affect the capability of the database server.At the same time, we introduce the theory of Network Sniff technology and the method, principle of analyzing the IP network datagram. Analyzing the correlative datagram structure and communication flow in the environment of TCP/IP network. In the realization, we used the Winpcap function to capture the datagram in network, resolved and reverted the datagram after capturing them with the layer method. Through stating and analyzed the datagram, we realize to the target of monitoring to the network.There are two important parts advanced in this thesis:In the first part (chapter 1-3), Expounding to the appearance background of network sniff technology, and the status of network safety and network database monitor. Analyze the monitor of billing database system, and advance to use network sniff technology to monitor the system of billing database.The second part (chapter 4-5) researched to the technology and theory of network sniff, analyzed to the survey of network safety and the excellence and shortcoming of network sniff technology in these days,. We realized to capture the network datagram through the network sniff technology. Narrating how to realize to resolve and revert the datagram which was captured through the layer method. Analyze and know to the TCP/IP protocol, then resolved and reverted the datagram which we captured with network sniff technology, through using TCP/IP protocol basic. We designed the whole project flow detailed, base on the datagram, we may develop various application program software, realized to monitor and analyze to database network and communication of the billing system. Summarizing the result of research, and prospecting the research in future.