|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: GISList: Microsoft SQL Server Vs Oracle Spatial9i |
| Date: |
12/10/2002 03:16:05 AM |
| From: |
Mark Prins |
|
|
Citeren Raghavendran <srg@immcoinc.com>:
> Dear Geo Community:
>
> I am in the process of migrating data associated with utilities
into a
> GIS
> platform.
>
> The utility data is so dynamic in nature that we decided to go
for a
> database to store them like Oracle Spatial, Microsoft SQL
Server etc.
>
> But I am in fix as to deciding on the pros and cons of going
after each
> system.
>
Note that you are talking about two entirely different solutions
here. One being an enterprise class spatially enabled relational
database (oracle spatial) the other a sub-enterprise class
regular relational database. It would make more sens if you
compared spatially enabled databases (oracle spatial,
postGIS, ...).
The regular spatial database will allow you to store spatial data
in a vendor specific (closed) manner - generally as a BLOB
(optianally using a middleware such as SDE) while afore mentioned
spatial databases implement the open OGC standards: thus not
locking you down to a specific desktop GIS or middleware database
extension.
Also there is nothing wrong with file based storage if you can do
without multi-user read/write access to the dataset.
Mark
-
Mark C. Prins
Spatial Fusion Specialist
______________________________________________________
CARIS Geographic Informations Systems BV
CARIS BV Support: support@caris.nl
CARIS BV Marketing/Sales: sales@caris.nl
tel. +31413296010
fax. +31413296012
WWW Marine: http://www.caris.nl
WWW Spatial Components : http://www.spatialcomponents.com
Mgr. van Oorschotstraat 13, 5473 AX Heeswijk
PO.box 47, 5473 ZG HEESWIJK-DINTHER
the Netherlands
_____________________________________________________________________
Zon Breedband Family, 2 keer zo snel als alle andere ADSL aanbieders.
Voor maar 34 euro per maand.
Bestel nu op www.zonnet.nl/breedband en krijg het modem gratis.
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!
|
