I'm not sure if this question is too broad, but here we go....
I'm interested to design a web application (side project), that queries DB for information and represents it in a network structure. Pretty broad right?! Let's narrow a bit.
DB can be any type (Oracle, MySQL, Giraph, etc). The criteria is to be able to reflect real time (1-2 second delay) of updated data (100G total size, and 1-2G change).
The data it'll store is of the form:
machine1, usage, location A, uptime
machine2, usage, location B, uptime
machine3, usage, location A, uptime
In the above example machines 1 and 3 will be connected b/c of the location.
Then the server side is Tomcat (can be other as well).
Lastly, front facing UI, I'm leaning towards JS.
Bottom line: I'm looking for design suggestion for the DB and how to represent the data. For the former, since it's such a small amount of data, any DB can carry that. For the latter the closest data visualization to my vision is Cytoscape.js.
Are there similar tools that support interactive network representation? The data is relational, but Giraph makes more sense.
What's your opinion?
I appreciate any design input.
Update: I did more reading, and vivagraphjs + neo4j is the strongest candidate thus far.