Representation and Visualisation of Wireless Network Status Information with SQL DB

Abstract

Monitoring an active communications network, diagnosing faults, and gathering statistics for administration and fine tuning are all significant aspects of network management in the market. Fortunately, leveraging the simple network management protocol SNMP, an application layer protocol assists network engineers in performing activities on the network for gathering statistics and extra information. Several requests are offered by the protocol to perform the necessary network queries. The thesis implementation's main goal is to track managed devices, such as network interfaces. Using the SNMP protocol, the software can track in/out traffic and record the returned data in a sqlite3 database. Furthermore, the software creates a plot by displaying a performance chart based on the stored data. More scenarios can be explored since the program performs the functionality using the object identifier (OID) from the management information basen(MIB). A live table is included in the software user interface, in addition to the database, to store information collected from the three primary SNMP requests. The request action sends APIs to the managed device, and the data is collected and displayed in the graphical interface.