Relational or NoSQL for monitoring data and time related queries?
I am considering data backend for the monitoring system I am building. It
will receive regular reports from multiple users. I would get record from
each user agent every 5s. The system would analyze the data and calculate
statistics over it. The statistics are the value for a user. He should be
able to view them live or they could be pre-calculated on regular basis.
The system would require mostly time related queries. Most of the data
would be read only. I want to easily scale in the number of users. I would
also like to make cross analyses over the data of all users.
Which data backend would you recommend? Relational or some NoSQL
alternative? Do you have any experience with temporal databases? Is there
anything dedicated for such system?
I used relational database in similar systems before and I wasn't very
happy with them. I found time based queries in SQL cumbersome. I
investigated MongoDB but I am not quite sure if it matches my needs.
No comments:
Post a Comment