Re: SQL Server, Oracle or Informix

In article <94sa4c$vo9$1_at_nnrp1.deja.com>,   David Fitzjarrell <oratune_at_aol.com> wrote:
> In our last gripping episode "Jim Kennedy" <kennedy-family_at_home.com>
> wrote:
> > MS SQLServer doesn't run on Linux. Oracle does and probably Informix
 does.
> > Jim
> >
> > "Daniel Paz Cornes" <cornes_at_navegalia.com> wrote in message
> > news:3a7167c7$1_at_news...
> > > Hello:
> > >
> > > I'm looking for arguments to take a decission about what RDMBS to
 use for
 a
> > > GIS (Geographic Information System). Database has to store large
 objects
> > > like
> > > images, satellite photograph, digitalized maps...
> > > I estimate data volume will be about 10-15 Gbytes.
> > > Security and stability are important but not critical, we plan to
 use
 Linux
> > > or Win NT
> > > on Intel as platform. RAID controllers, etc...
> > >
> > > We are in doubt for SQL Server, Informix or Oracle.
> > >
>
> Since you are wanting to use geographical data you will want to
> seriously consider Oracle, especially since Oracle offers the Spatial
> Data Option which is designed for GIS data. I don't believe that
> Informix offers such an option, and, as Jim stated, SQL Server does not
> run on Linux. Your closest approximation to SQL Server would be
> Sybase, and I'm not certain it would run on Linux, either.
>
> David Fitzjarrell
> Oracle Certified DBA

Informix offers the Spatial Data Blade. Are you using ESRI products in your GIS? While both Oracle and Informix offer spatial data options, neither is necessary if you run ESRI's SDE (Spatial Database Engine) to talk with your RDBMS. Both Oracle and Informix will interface with SDE, and either would probably work just fine for your application. Sybase and SQL Server will also work with SDE, but Sybase may not run on Linux (as David indicated), and SQL Server definitely doesn't run on Linux. If I were you, I'd go with Oracle if you can afford it.

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 14:59:38 CST