[comp.databases] Oracle vs Ingres

davidg@uns-helios.nevada.edu (DAVID GONZALES) (08/17/90)

We are currently planning on purchasing either Oracle or Ingres to run
on a Sun SparcStation. Anyone care to comment on one or both of these products?

Thanks,

David A. Gonzales
UNLV/ERC

bin@primate.wisc.edu (Brain in Neutral) (08/18/90)

From article <1927@unsvax.NEVADA.EDU>, by davidg@uns-helios.nevada.edu (DAVID GONZALES):
> We are currently planning on purchasing either Oracle or Ingres to run
> on a Sun SparcStation. Anyone care to comment on one or both of these products?

You will probably find working with the product (either one) satisfactory,
and working with the company a nightmare (either one).

Paul DuBois
dubois@primate.wisc.edu

pcm@bby.oz (Paul C. McLeish) (08/22/90)

In article <1927@unsvax.NEVADA.EDU> davidg@uns-helios.nevada.edu (DAVID GONZALES) writes:

   We are currently planning on purchasing either Oracle or Ingres to run
   on a Sun SparcStation. Anyone care to comment on one or both of these products?

One has a simple forms package and one is a simple forms package.

Its has been rumored that the best platform for Oracle is a slide
projector.


--
------------------------------------------------------------------------------
Paul McLeish, Burdett Buckeridge & Young Ltd, Melbourne, Australia
Internet: pcm@melba.bby.oz.au    non-MX: pcm%melba.bby.oz@uunet.uu.net
Uucp: {uunet,mnetor,pyramid,ubc-vision,ukc,mcvax,...}!munnari!melba.bby.oz!pcm
Phone: +61 3 614 8922
Fax: +61 3 614 8742

     "It takes 3 pigs with dermatitis to make one packet of pork scratchings"
			Who Dares Wins

lance@unigold.UUCP (Lance Ellinghouse) (08/24/90)

In article <1927@unsvax.NEVADA.EDU>, davidg@uns-helios.nevada.edu (DAVID GONZALES) writes:
> 
> 
> We are currently planning on purchasing either Oracle or Ingres to run
> on a Sun SparcStation. Anyone care to comment on one or both of these products?

Well, 
  I have used both on SCO Xenix(Oracle) and SCO UNIX(Ingres).
Oracle is a good product, but it has some major flaws in my eyes:
	1) Very Slow
	2) Very few DBA utilities
	3) SQL*Forms is not very flexable and has bugs

Ingres is a good product also, and I prefer it over Oracle now that
I am using it. Some of its features are:
	1) Much faster than Oracle
	2) Ability to monitor HOW the Query Execution Plan is
		put together (thus able to tweek the search routines
		a little more than Oracle)
	3) Many DBA utilities and much better thought out
	4) Their Forms routines are GREAT! Both under ESQL and
		as standalone Forms used by their routines.

Ingres seems like a product that was much better thought out. Also, they 
optimize it for each hardware/software platforms (unlike Oracle) so you 
will get a product that is much faster and easier to setup.

Just my $0.02. 

Lance Ellinghouse
UNIGOLD
E-mail: hermix!unigold!lance@anes.ucla.edu

anderson@well.sf.ca.us (David E. Anderson) (08/24/90)

In article <PCM.90Aug22123317@bottle.bby.oz> pcm@bby.oz (Paul C. McLeish) writes:
>In article <1927@unsvax.NEVADA.EDU> davidg@uns-helios.nevada.edu (DAVID GONZALES) writes:
>   We are currently planning on purchasing either Oracle or Ingres to run
>   on a Sun SparcStation. Anyone care to comment on one or both of these products?
>One has a simple forms package and one is a simple forms package.
Wrong on both counts...

********************************************************************************
David E. Anderson, Redwood City, CA    (415) 592-1101       
Independent Database Consultant (formerly with Oracle kernel Support Group)
UUCP:  {uunet,pacbell}!well!anderson    Oracorp mail: unix:well!anderson
********************************************************************************
First learn your horn and all the theory.
Next develop a style. Then forget all that
and just play.          Charlie Parker [?]

kbittner@oracle.uucp (Kurt Bittner) (08/27/90)

In article <39@unigold.UUCP> lance@unigold.UUCP (Lance Ellinghouse) writes:
>In article <1927@unsvax.NEVADA.EDU>, davidg@uns-helios.nevada.edu (DAVID GONZALES) writes:
>> 
>> 
>> We are currently planning on purchasing either Oracle or Ingres to run
>> on a Sun SparcStation. Anyone care to comment on one or both of these products?
>
>Well, 
>  I have used both on SCO Xenix(Oracle) and SCO UNIX(Ingres).
>Oracle is a good product, but it has some major flaws in my eyes:
>	1) Very Slow
>	2) Very few DBA utilities
>	3) SQL*Forms is not very flexable and has bugs
>
>Ingres is a good product also, and I prefer it over Oracle now that
>I am using it. Some of its features are:
>	1) Much faster than Oracle
>	2) Ability to monitor HOW the Query Execution Plan is
>		put together (thus able to tweek the search routines
>		a little more than Oracle)
>	3) Many DBA utilities and much better thought out
>	4) Their Forms routines are GREAT! Both under ESQL and
>		as standalone Forms used by their routines.
>

I am curious: is your Oracle experience with v5 or v6?  My experience with
Oracle v6 under Xenix has been very good - much faster than v5.  Also the
DBA utility, SQL*DBA, provides a HUGE amount of tuning information.  Also,
there is support for an DB2-compatible EXPLAIN facility (should address your
point #2 under Ingres).  As for Ingres point #4, SQL*Forms v3 (beta on Xenix
and SCO UNIX) should cause you to reconsider Oracle point #3.

Sorry for the plug, but your evaluation comments, however valid, are based on
a two-year old, obsolete product.  My comments are in the interest of comparing
apples to apples.

Kurt Bittner
Staff Tech Specialist
Oracle Corp.

My opinions are solely my own (who else would want them?).

anderson@well.sf.ca.us (David E. Anderson) (12/05/90)

In article <1990Dec2.080257.21343@odi.com> dlw@odi.com writes:
>In article <5550@avocado20.UUCP> palat@motcid.UUCP (Mohan Palat) writes:
>
>	   Oracle uses an unusual process architecture (in UNIX). Several 
>	   processes have to be started up before one can even access a 
>	   database. Ingres does not require any such initialization. 
>
>Is this really a practical drawback to Oracle?  That is, can't the
>startup of these processes be arranged to be completely transparent
>and automatic?
Of course the processes can be started automatically.  That is standard 
practice for Unix software and standard for Oracle and Ingres and Sybase and ...
********************************************************************************
David E. Anderson, Redwood City, CA    (415) 592-1101       
Independent Database Consultant (formerly with Oracle kernel Support Group)
anderson@well.sf.ca.us 
********************************************************************************
First learn your horn and all the theory.
Next develop a style. Then forget all that
and just play.          Charlie Parker [?]