Oracle - what sort of database system is it? Is it for Unix?

[gupta at cai.com]

In article <10607 at pasteur.Berkeley.EDU>, mao at eden.Berkeley.EDU (Mike Olson) writes:
> In article <1991Jan29.152745.9028 at cs.odu.edu> aiko at cs.odu.edu (John K Hayes)
> asks regarding oracle:
> 
>> Does it run on VAX VMS?  
>> Can someone describe generally what Oracle is?
> 
> [...]
> do later releases of oracle include a query optimizer?  at what release
> level was one added?  and what (roughly) is the cost function used to
> pick a plan?  the last question is intended to discover whether oracle's
> query optimizer is less than, equal to, or greater than the standard
> optimizer that was designed for system r in the 1970's.
> 
> any oracle implementors out there?
> 					mike olson
> 					postgres research group
> 					uc berkeley
> 					mao at postgres.berkeley.edu

There is a comprehensive article in InfoDB (a magazine published by
Database Associates, Colin White - Editor) Fall 1990 (Vol 5 Num 3)
written by David McGoveran - Associate Editor, which compares the
optimizers of commercial RDBMSs  (CA-DB, DB2, Informix Online, Ingres
Oracle, Rdb/VMS, ShareBase, Sybase SQLServer, and Tandem NonStop SQL).
According to it, the Oracle optimizer doesn't even come close to the
other products on the market.  

Yogesh Gupta
Computer Associates.
(408) 922-2633