topic Re: oracle vs sybase in Operating System - HP-UX

oracle vs sybase

SM_3 — Tue, 08 Jan 2008 16:23:24 GMT

Hello

Can someone explain the main way in which oracle works on unix compared to sybase, please?

It's just that I heard a DB admin speak of the the 2 are fundamentally different and wanted a 3rd opinion from another db admin.

Have already googled this question...

thanks

Re: oracle vs sybase

Frank de Vries — Wed, 09 Jan 2008 08:37:10 GMT

Indeed that is true.
The sql engine is constructed differently,
the interfaces are different.
Even the terminology are different.
A definition of a segment and tablespace in Oracle are not the same for Sybase.

Apart from that they are both databases,
that is to say they serve a similar purpose,
that is to store data, and deal with data integrity and have rollback and redo facilities, albeit differently implemented.

Hope that clears the fog a bit...

Re: oracle vs sybase

Srikanth Arunachalam — Wed, 09 Jan 2008 09:44:27 GMT

Hi,

I have used both Sybase and Oracle. Both Sybase and Oracle are RDBMS and they do not differ much as far as RDBMS concepts are concerned. Since they are different product, they exhibit different features. You may use the following link to identify the difference between Oracle and Sybase.

http://www.rocket99.com/sybase/syb_vs_ora.html

Thanks,
Srikanth