Elasticsearch?
It is a beast* to run but it may be better suited to store "100 data points" and allow ad-hoc queries that an RDBMS.
The complete stack includes Logstash, which can be used to feed data into the search engine and Kibana, a graphical webbased front end that can be used to visualize things in various ways, including plotting on a map.
(The price is that it isn't really suited to producing traditional n-level text reports.)
* It is Java, so the more RAM, the happier it is. It is designed from the ground up to be a distributed system, so it needs to be detuned if run on a single box or it will eat it alive. That said, I have it running on a 2GB P4 based host and although sluggish, it is functional.
The complete stack includes Logstash, which can be used to feed data into the search engine and Kibana, a graphical webbased front end that can be used to visualize things in various ways, including plotting on a map.
(The price is that it isn't really suited to producing traditional n-level text reports.)
* It is Java, so the more RAM, the happier it is. It is designed from the ground up to be a distributed system, so it needs to be detuned if run on a single box or it will eat it alive. That said, I have it running on a 2GB P4 based host and although sluggish, it is functional.
