your favorite database for spatial temporal ?

Question

hi,

what is your favorite database for supporting of spatial temporal issues ?

sql server 2008 has data types for spatial temporal data. please post your experience with sql server 2008, oracle spatial, post gis .... .

licence cost does not matter here.

apps anything like that: Suppose that we are interested in monitoring a city to see whether, at any time, there is a region in which the number of suspects is larger than the number of police officers. This query involves retrieving the police officers and the suspects in each regions (two range predicates), grouping by each region to get the count of both groups, then performing a theta join to retrieve the regions with more suspects than police officers. Notice that in this case both police officers and suspects may be continuously moving.

thx and kind regards, jeff

Answer 1

Choice of database is one of the least of your problems.

The trick will be gathering updates to positions of whomever/whatever, getting those changes back to the DB, and disseminating the data. If you can do that, then just about any DB you listed will do its job. The range/bearing calculations then are a relatively trivial problem.