Question: Java CSV file help Input A file named bandwidth.csv , containing the Bandwidth information for a set of Network Interfaces. A Network Interface is identified

Java CSV file help

Input

  • A file named bandwidth.csv, containing the Bandwidth information for a set of Network Interfaces. A Network Interface is identified by the couple [server, network interface name]
  • A file named netbitrate.csv, containing the Network Bit Rate registered for the same set of Network Interfaces over a period. A Network Interface is identified by the couple [server, network interface name]

You are asked to develop a small procedure that, given the two CSV files, calculates the Network Bandwidth Utilization for every line in the netbitrate.csv file. The Network Bandwidth Utilization of an interface is calculated as the Network Bit Rate divided by its Bandwidth. The procedure needs to print the results on the standard output according to the following format:

Timestamp | Server | Network Interface | Network bit rate / Bandwidth

Hint: Please ensure that your solution considers floating point numbers

File: bandwidth.csv

Server, InterfaceName, Bandwidth

server1,eth0,10

server1,eth1,20

server2,eth0,10

File: netbitrate.csv

Timestamp, Server, InterfaceName, NetBitRate

2019-07-08 21:53:27,server1,eth1,100

2019-07-06 23:10:54,server1,eth0,200

2019-05-10 03:36:22,server2,eth0,150

2019-01-14 13:14:51,server2,eth0,50

2019-05-01 19:47:33,server1,eth1,80

output:

Java CSV file help Input A file named bandwidth.csv, containing the Bandwidth

2019-07-08 21:53:27 serveri ethi 5.0 2019-07-06 23:10:54 serverl etho 20.0 2019-05-10 03:36:22 server2 etho 15.0 2019-01-14 13:14:51 server2 etho 5.0 2019-05-01 19:47:33 serverl ethi 4.0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!