GISCafe
   >> GIS Tools
Thread views: 91700 View all threadsNext thread*Threaded Mode

Dank
(Stranger )
08/10/01 05:58 AM
Oracle Spatial vs. SQL/SDE Report this article as Inappropriate to us !!!Login to Reply

I'm needing some information about the pros and cons of using Oracle Spatial vs. using SDE with SQL 2000. All information will be helpful including any about using Smallworld with Oracle Spatial. Thanks.



gisdev
(Stranger )
11/01/01 08:27 AM
Re: Oracle Spatial vs. SQL/SDE new [re: Dank]Report this article as Inappropriate to us !!!Login to Reply

I think maybe oracle spatial+SDE is better.



SVS
(Stranger )
11/02/01 07:29 PM
Re: Oracle Spatial vs. SQL/SDE new [re: gisdev]Report this article as Inappropriate to us !!!Login to Reply

Can you offer reasons why you think that Oracle + SDE is better?



agodfrin
(Stranger )
07/17/02 05:23 AM
Re: Oracle Spatial vs. SQL/SDE new [re: Dank]Report this article as Inappropriate to us !!!Login to Reply

Major point (IMO) in favor of Oracle Spatial is that most (all ?) of the commercial GIS tools support Oracle Spatial. This means that customers can choose and combine the tools that suit them best for the task at hand. Note that ArcSDE can also use Oracle Spatial together with its own binary storage format.
Also Oracle runs on most platforms (Unix, Linux, W2K, ...).

Albert



pml
(Stranger )
08/25/02 05:45 PM
Re: Oracle Spatial vs. SQL/SDE new [re: agodfrin]Report this article as Inappropriate to us !!!Login to Reply

I think I can help here if you have not resolved this yet. When you use Oracle with the "standard" storage format(not spatial), the performance should be better. But as mentioned before, oracle spatial type storage can be used by more than ArcSDE. Oracle spatial type storage does not store your data in a binary format which drops the perfomance slightly.
Hope this helps and good luck.



Edwin
(Stranger )
09/02/04 06:49 PM
Re: Oracle Spatial vs. SQL/SDE new [re: Dank]Report this article as Inappropriate to us !!!Login to Reply

Don't use Oracle Spatial with SDE it is better to use just Oracle Spatial and then you are not stuck with ESRI as a client and go for a real enterprise solution involving different GIS apps which allows you better interoprability, also it is a lot cheaper. MapInfo, Cadcorp SIS, GeoMedia all link to Oracle Spatial direclty and using SDE on Oracle will not allow these to use access it unless it is set up in a specific way which is a pain and does not add anything to the functionality.




View all threadsNext thread*Threaded Mode
Jump to

 

Trimble
CADalog.com - Countless CAD add-ons, plug-ins and more.



Internet Business Systems © 2016 Internet Business Systems, Inc.
595 Millich Dr., Suite 216, Campbell, CA 95008
+1 (408)-337-6870 — Contact Us, or visit our other sites:
AECCafe - Architectural Design and Engineering EDACafe - Electronic Design Automation TechJobsCafe - Technical Jobs and Resumes  MCADCafe - Mechanical Design and Engineering ShareCG - Share Computer Graphic (CG) Animation, 3D Art and 3D Models
  Privacy Policy