Database for live mobile tracking [closed]

Question

I'm developing an app that allows to track a mobile device instantly (live) ... I need an of advice. The application must send the location to a webservice that in it's turn records the received data in a database.

What would be, in your opinion, the best way to store the location values?

I'm new in using bigdata and I'm afraid that simple sql requests wont be able to do the work properly ... I imagine if there is lot of users and each user send a request each 1sec I'll have issue with the database ...

An advice ? Thank you very much

Answer 1

I happen to work for an IoT\M2M company and we have been using SQL Server just fine for years... Much of the architecture is all event\transaction driven and process based on an \time\event\status and have denormalized the data for multi-purpose uses.

Now, ideally when you experience the type of growth that we have over the last few years with millions of connected devices your problem becomes one of carrier relations and how are you going to get better rates and roaming agreements from your carriers...

GPRS, SMS, Data... It all cost's but I digress. Your going to want to store LAT\LONG in datatypes of FLOAT. I think GOOGLE does it with a length of FLOAT(10,6)?

MySQL or Postgres Spatial with GIS extensions is another option.

Good Luck!