MJ Singh

Hi All, I am working on finalizing the database for IoT enables devices and expect to get approx 200000 records/s from all the devices. These records need to be stored and aggregated values need to be displayed on the portal. We will be storing 2 years of data and each record size is 1 KB. My database should support group by, order by, sum, etc i.e. most of the aggregation features. I have done some analysis and really need help opting for the best database for my use case.

Could you please suggest something which would be the best fit for my use case?