Not sure how "real-time" you need it to be, but this software might fulfill some aspects of what you're looking for. The database consolidates every 5 minutes or so, so it's pretty real-time.
This is what we use for traffic and security alert trends:
http://manageengine.adventnet.com/products/firewall/