[Geocoding] Local Mirror of OSM Data...
Tom Hughes
tom at compton.nu
Fri Oct 23 18:11:43 BST 2009
On 23/10/09 18:05, Anthony wrote:
> By the way, I highly disagree with that statement. Maybe it's true if
> you're using MyISAM, but with any modern database with views, and
> triggers, and stored procedures, your core schema should be
> independent of implementation.
Well in theory maybe, just like in theory everybody would have their
databases fully normalised.
In the real world we don't all have infinite CPU time and I/O bandwidth
so sometimes we have to do some pre-computation to get the data in a
form where the queries we want to use can be efficiently processed.
In the case of OSM data for example it may often be advantageous to
create proper PostGIS geometries for objects so that spatial queries can
be efficiently resolved. I'm not sure it would be possible to write a
view to do that even if you wanted to - if you could it would be pretty
horrible and mind-blowing inefficient.
Tom
--
Tom Hughes (tom at compton.nu)
http://www.compton.nu/
More information about the Geocoding
mailing list