Re: is Oracle technically better than Ingres ?

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0407280537.3b00e3e2_at_posting.google.com>...
> michaelnewport_at_yahoo.com (michael newport) wrote in message news:<63b202d.0407260216.34497df7_at_posting.google.com>...
> > Dear friends of database(s),
> >
> > After 13 years of Ingres, I am now using Oracle.
> >
> > But is Oracle technically better than Ingres.
> >
> > I would be much obliged if anyone could shed some light on the above
> > question.
> >
> > It would also be helpful if you could 'please' keep your comments on a
> > technical level.
> >
> > Regards
> > Michael Newport
>
> Michael, I have never worked directly with Ingres, but we had the
> database here once and the two developers who worked with it liked
> Oracle much better. Running the same applications against Oracle
> provided more up time and required less database related maintenance.
>
> Oracle has advanced greatly since then. There are two different
> independent consulting reports that state that Oracle 10g is easier to
> manage than SQL Server.
>
> I have wroked with Oracle, SQL Server, DB2 UDB, and mySQL. I like
> Oracle better than the others. I second, Ed's suggestion to look or
> better yet read the Concepts manual. It is the place to start with
> Oracle.
>
> HTH -- Mark D Powell --

The July 19, 2004 issue of InformationWeek p 46 mentions that after a decade of neglect by CA who had put their attention on Jasmine that CA is showing renewed interest in marketing Ingres. The title of the short article is CA goes open source with Ingres database. The implication is that CA has a lot of work to do to catch up to other relational database products.

But how good a database is for you depends a lot on the features you need. Oracle contains a lot of features that many sites do not use, but if you need analytical functions then Oracle has them. If you have very large tables then Oracle has partitoned tables and indexes. With a warehouse operation you might need/benefit from bitmap indexes.

If you really want to compare databases you have to make a list of features you need/want and then list what each database offers.

HTH -- Mark D Powell -- Received on Wed Jul 28 2004 - 22:25:29 CEST