Re: [ILUG] Drop in replacement for Ingres Database?

From: Conor Daly (conor.daly at domain met.ie)
Date: Fri 13 Sep 2002 - 15:20:21 IST


On Fri, Sep 13, 2002 at 11:45:47AM +0100 or thereabouts, Niall O Broin wrote:
> On Fri, Sep 13, 2002 at 08:44:42AM +0100, Conor Daly wrote:
>
> > Yeah, I know there isn't one but IIRC, postgresql is based on the ingres
> > product. Does anyone know how similar it is, are there sensible UIs out
> > there for it, is it scaleable to something like 8-16Gb of data with a few
> > tables >2Gb in size?
> >
> > I'm in a situation where we're getting gouged by Computer Associates for
> > licenses for the next three years and we're thinking about Oracle as a
> > replacement for 20% of the cost. However, it's going to take about 1 year
>
> My God - you are really getting gouged if you can consider putting Oracle in
> to save 80% of your expenditure.
 
It's mostly about licensing methods. Ingres licenses are purely server
based at this stage: unlimited users but big lumps of money per processor
on the server.

Oracle have two methods: Per processor or per user:

Per processor standard edition is about EUR16k Enterprise is about EUR38k
per user standard edition is about EUR350 Enterprise is about EUR850

standard edition has a min of 5 users and would need to be up to 100 users
to match the per processor cost. We reckon on having about 25 users thus
costing 20% of the price quoted by ingres. Admittedly, we haven't yet
pinned down whether the standard edition would come with all the tools we
need (eg. interactive SQL querying, forms based querys, embedded sql libs
for both C and Fortran) so I'm not clear on the pricing just yet...

> > to port our applications over to the Oracle setup and I was (probably
> > foolishly) thinking we could drop postgresql in as a quick replacement
> > given its ancestry...
>
> At this stage, Postgres is probably as closely related to Ingres as you are
> to a bonobo (98% of DNA or so) but the differences are . . . . noticeable.
> But if you're considering a switch to a new platform, a little before the
> license gougers came knocking might have been good :-)
 
Um yeah, we're into ingres for at least the next three years. That should
give us ample time to come up with a replacement (eg. 8 months for the IT
steering committee to agree that a switch is desireable, 16 months for the
Public Procurement Procedure, 5 months to decide that we should ask the IT
steering committee to approve a change and the last 2 months to port the
applications 'cos I'm going to take 5 months holidays after all that!)

Conor

-- 
Conor Daly 
Met Eireann, Glasnevin Hill, Dublin 9, Ireland
Ph +353 1 8064276 Fax +353 1 8064247
------------------------------------
bofh.irmet.ie running RedHat Linux  3:05pm  up 1 day,  3:48,  3 users,  load average: 0.00, 0.00, 0.00
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept 
for the presence of computer viruses.
**********************************************************************


This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:18:50 GMT