|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: GISList: Microsoft SQL Server Vs Oracle Spatial9i |
| Date: |
12/11/2002 10:04:10 AM |
| From: |
Robert Heitzman |
|
|
>>Sure. The fundamental architectural mistake is to embed the "spatial"
>>functionality within the DBMS. That means all geoprocessing is
>>bottlenecked
>>by the centralized DBMS. If you have 100 users who want to do
>>geoprocessing, basically every one of those 100 users is time-sharing the
>>central DBMS and the server that runs it.
>
>Oh, I neglected to point out that this is more than a bit of a strawman,
>since all the desktop client software for existing spatial databases uses
>them essentially as a bit bucket (with spatial indexing) and do almost all
>their geoprocessing on the client, just like you say they should. The
>advantage of the standards compliant spatial database is how easy it is to
>tie traditionally non-spatial applications to spatial intelligence. Like a
>simple web form (no map required) which calculates the correct polling
>station to go to given a postal code as input. Or a trigger-induced
>geocoder (add a trigger to an address table to stick lat/lon coordinates
>next to newly inserted addresses). There are lots of examples. As GIS
>people we tend to think the spatial world begins and ends with our
>desktops. It doesn't.
>
I think this is a key point to the discussion - what is the intended purpose
of the spatial data being stored in the database.
If the data is a repository for a GIS system Dimitri's points are right on
for 99+% of GIS installations.
If the DB is a backend to a spatially-dumb application then a spatially
enabled DB is a great thing.
There are exceptions of course. If you design your GIS "system" such that
you have a huge amount of data that can only be maintained if you subset
into the whole then a spatially smart DB has an advantage. Ditto if you
would like to allow multiple users to maintain the same "layer" at the same
instance in time.
So, both methods have there place.
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
To unsubscribe, write to gislist-unsubscribe@geocomm.com
________________________________________________________________________
GeoCommunity GeoBids - less than $1 per day!
Get Access to the latest GIS & Geospatial Industry RFPs and bids
http://www.geobids.com
Setup a GeoCommunity Account and have access to
the GISDataDepot DRG & DOQQ Catalog
http://www.geocomm.com/login.php
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
