I have a question related to the historian databases. Here is our requirement. We need a historian database that is capable of collecting data from equipment at the rate of 1000 updates / sec on an average. And there will be one equipment for each historian database. Given this requirement, which is the best suited historian database for my requirement? I had looked at many options including OSISoft's PI System, Wonderware historian, Canary logger from canary labs, GE proficy, Iconic's hyperhistorian and so on. This link helped me: Historian Comparison
But the biggest problem I have is that these historians are highly scalable databases which means it can collect the whole factory data. So, using this for one equipment with say 500 datapoints might be overkill and expensive.
I am wondering if you guys can help me with the list of historian databases that can fit my need.