DB Table for Extended Conversation Statistics
Dustin Born edited this page 6 years ago

Introduction

The original DB table for conversation statistics does not incorporate UDP packets. Because all Membership Management messages utilize UDP, UDP packets have to be incorporated as well. To not mess any original functionality up, a new DB table for conversation statistics has been created that incorporates TCP and UDP packets.

The new DB table "conv_statistics_extended"

UDP conversations can have only one sent packet, which makes it impossible to compute any delays or average packet rates. Therefore, every conversation that consists of only one packet, has avgDelay, minDelay and maxDelay set to null and avgPktRate set to 1. The DB table consists of the following fields:

Field Name Description
ipAddressA IP Address of host A
portA The used port on host A
ipAddressB IP Address of host B
portB The used port on host B
protocol The used port on host B
pktsCount Number of packets exchanged
avgPktRate The average packet rate
avgDelay The average delay in the first three packets or null
minDelay The minimum delay in the first three packets or null
maxDelay The maximum delay in the first three packets or null
avgIntervalPktCount The average number of packets per communication interval
avgTimeBetweenIntervals The average time between two communication intervals
avgIntervalTime The average time of a communication interval
totalConversationDuration The total duration of a conversation

Note: A communication interval for a conversation is an interval in which no two messages/packets have a time difference of more than 10s. Therefore a connection can have one or more communication intervals.