RE: Informix, SQL Server or Oracle
Have you ever worked with O_~!@#$. OPS full install > 2.5 Gig with more than
45000 files. {Excluding data or install CD files}. Just to get backup
working, what a mission. No easy ontape, but use scripts, RMAN, Legato or
just leave it and start searching for a Informix job. Cant even do a "load
from file insert into table". Must use a tool to do this.
With O you need 2 DBA's to do the same job as one Informix DBA. SQL server
get the blue screen of death, and fired.
With Informix it is much easier to handle RAW {Even with 2Gig chunks}. O...
use something like LSM or Veritas. {Again extra money}
Platform Inf and O on just about any OS. Wont touch SQL server. Stay away
from NT that still tries to do what Unix did 10 years ago.
Remember no RAID5.
-----Original Message-----
From: The Siebrands [mailto:siebrand@bigpond.com]
Sent: Monday, 29 January, 2001 1:48 PM
To: informix-list@iiug.org
Subject: Re: Informix, SQL Server or Oracle
Having implemented a GIS both on Informix and Oracle, I would choose
Informix every time. The ease of configuration, loading data and the speed
of GIS queries, Informix won every time.
We used the GIS for mapping and 3D modelling of our ore bodies.
Cheers
Hans
Gigi M John <gigijohn@omantel.net.om> wrote in message
news:94sfl5$dqb1@OM9.omantel.net.om...
> Hi
> I am working in a organization using 3 database environment namely
> Oracle, Informix and SQL Server.
> I am familiar with these 3 database environment. What I found is
> (In order of 1st, 2nd, 3rd )
>
> 1) Fastest Implementation is
> 1) Informix ,2) SQL Server, 3) Oracle
> 2) Transferring of Data (or Migration) between Different
> Databases - 1) Informix 2) SQL Sever 3) Oracle
> 3) Data Retrieval
> - 1)Informix 2) SQL Server and Oracle Almost Same
> 4) Implementation of Blob Objects - 1) Informix
2)
> SQL Server and 3) Oracle
> (Storing of Graphical object like Photos, Scanned
> Images etc.)
> 5) Security - 1)
> Oracle 8i 2) SQL Server and Informix Almost Same
> 6) Auditing - 1)
> Oracle 8i 2) SQL Server 3) Informix
> 7) Easy Database Administration - 1) Informix 2)
> SQL Server 3) Oracle
> 8) Easiest tools Available at the Time of Database
> Structure Creation - 1) SQL Server 2) Informix 3) Oracle
> 9) *RAW Hard disk Partition Utilization - 1)
> Informix 2) Oracle
> and Easy Implementation
> * RAW Disk Partition Will be managed by the Database
> Server Itself , Not by the Operating System will enhance the
> Speed of Data Retrieval)
> 10) Platform Availability -
SQL
> SERVER IS NOT AVAILABLE OTHER THAN NT/ALPHA
>
> Regards
>
> GIGI M John
>
> Daniel Paz Cornes <cornes@navegalia.com> wrote in message
> news:3a71afc1@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.
> >
> > Thanks in advance.
> >
> > Daniel Paz,,
> >
> >
> >
>