Step 1: add two new fields to Configuration Table: GoodThreshold and MediumThreshold (table description attached)
Step 2: Create table Graph. Description attached. (Also add IPv6 field)
Step 3: from table HTTPResponse, summarize to 1 entry in table Graph for each 5 minute span.
That is, if HTTPResponse table has 15 entries between 9:00 and 9:05, then those will be summarized into Graph table.
The "good", "medium" and "bad" should be according to the new threshold values that you just added to Configuration.
That is, if there are 3 values in the "difference" field of HTTPResponse that are under 100,000 (the value of the matching GoodThreshold in Configuration), then the value of "Good " in the Graph table would be 3.
The values in the Medium would be the fields that are between the "goodThreshold" and the "badThreshold"
The values in the "Bad" field of Graph table would be all the values of "difference" that are greater than the "MediumThreshold".
1. Graphs should be different for IPv4 and IPv6
2. The whole package can run under IIS, Tomcat or Apache.
3. The visualisation should refresh every 5 minutes. Have a parameter to do the refresh so if we want to do every 10 minutes, it will work.