Need help in computing and reporting data, which is collected every minute for each database. First column is Server name, Second column is Time having format(+%Y-%m-%dT%H:%M:%S%z), Third column is Database name and Last column is amount of MB/sec performed by each database.
Snippet of data:
server01: 2015-06-01T12:40:03-04:00 DB101 10 MB/sec
server01: 2015-06-01T12:40:03-04:00 DB202 5 MB/sec
server01: 2015-06-01T12:40:03-04:00 ASM 2 MB/sec
server01: 2015-06-01T12:40:03-04:00 MYDB101 2 MB/sec
server01: 2015-06-01T12:40:03-04:00 MYDB202 5 MB/sec
server01: 2015-06-01T12:40:03-04:00 _OTHER_DB_ 30 MB/sec
server01: 2015-06-01T12:41:03-04:00 DB101 3 MB/sec
server01: 2015-06-01T12:41:03-04:00 DB202 4 MB/sec
server01: 2015-06-01T12:41:03-04:00 ASM 2 MB/sec
server01: 2015-06-01T12:41:03-04:00 MYDB101 9 MB/sec
server01: 2015-06-01T12:41:03-04:00 MYDB202 7 MB/sec
server01: 2015-06-01T12:41:03-04:00 _OTHER_DB_ 50 MB/sec
server02: 2015-06-01T12:40:03-04:00 DB101 90 MB/sec
server02: 2015-06-01T12:40:03-04:00 DB202 9 MB/sec
server02: 2015-06-01T12:40:03-04:00 ASM 2 MB/sec
server02: 2015-06-01T12:40:03-04:00 MYDB101 3 MB/sec
server02: 2015-06-01T12:40:03-04:00 MYDB202 1 MB/sec
server02: 2015-06-01T12:40:03-04:00 _OTHER_DB_ 90 MB/sec
server02: 2015-06-01T12:41:03-04:00 DB101 1 MB/sec
server02: 2015-06-01T12:41:03-04:00 DB202 4 MB/sec
server02: 2015-06-01T12:41:03-04:00 ASM 2 MB/sec
server02: 2015-06-01T12:41:03-04:00 MYDB101 7 MB/sec
server02: 2015-06-01T12:41:03-04:00 MYDB202 7 MB/sec
server02: 2015-06-01T12:41:03-04:00 _OTHER_DB_ 55 MB/sec
And I want to report it in two ways as shown below, please note that I am not bothered about grouping at Server names, Its just grouping MB/sec for each Database name and I want to do it at Minute and Hour level.
Sample of Required output:
Frequency Minute:
collectionTime DB101 DB202 ASM MYDB101 MYDB202 _OTHER_DB_
2015-06-01T12:40:03-04:00 100 14 4 5 6 140
2015-06-01T12:41:03-04:00 4 8 4 16 14 105
Frequency Hour:
collectionTime DB101 DB202 ASM MYDB101 MYDB202 _OTHER_DB_
2015-06-01T12:00:00-04:00
2015-06-01T13:00:00-04:00
Please help me in this requirement, I am still learning perl programming, would be thankful if someone can help me here