I am working on a project. I will need to live track 10.000 vehicle. Every second each vehicle send his localization. So Every second I will need to save 10.000 record. At the end of the day will have save 10.000 * 86.400(second/Day) = 864.000.000 record.
With the Data for each vehicle, we will like to be able to export between two date all the localization Data in GPX format, so it can be upload on GoogleMap or other similar tools.
I have supposed that the time between two Gps fix was one second. That seem to not be true.
So I have tried to find the average time between two GPS fix (average Time for GPS listening to send two localization). I wasn't able to find clear answer. I was only able to find information on the Time-to-First-Fix, knowing the answer will help me.
Because the quantity of data may be big I wonder if I should use a NoSQl DataBase? Or do you think relationship data base is enougth?