I'm starting to design a geo tracking system and I would apreciate any suggestions regarding DB structure. Database should log points, directions, speed and track
A:
When thinking about database design, it's usually best to list out the types of queries that you will want to perform and how often you will perform them. The table structures will usually fall out of that.
It's hard to recommend a design when you only give a 1 sentence description.
Frank Krueger
2010-01-30 18:23:28
Ok, that's true, but I hoped to get some advice how it is best to store spatial data
Sergej Andrejev
2010-01-30 18:29:37
The database I will be using will be MSSQL. It too has support for spatial data. But I'm asking how to design database to be able to store points, paths (connected points), direction, be able to replay path. In other words I need an advice how to design GPS tracking database
Sergej Andrejev
2010-01-31 13:31:46