General discussion

Locked

Sybase or Oracle

By Mike P. ·
Which is a better database Sybase or Oracle? Please explain your reasoning if possible.

Thank you.

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Sybase or Oracle

by Charles Forchu In reply to Sybase or Oracle

Oracle is a better database than sybase. If you understand how oracle works, it has better stability than Sybase. I would prefer you run your oracle on NT Server with service pack 5.

Collapse -

Sybase or Oracle

by apatit In reply to Sybase or Oracle

I don't agree with a strict statement Oracle is better than Sybase. Best of all to compare equal classes of DB. Sybase SQL Anywhere is a mobile DB. Sybase has a good product as Sybase Enterprise Server.
We use Sybase SQL Anywhere 5.5 (already exists Sybase Anywhere Studio 7.0 - evolution of Ahywhere products). And that implement all our tasks. Basic advantages are: simple tastes for system resources, multiplatform, simultaneously supports 12 working databases 2 Gb of size, good integrated replication system. And, at last, most low price than Oracle products. This is not full list of advantages. You can see detailed information on Sybase corporative web-server www.sybase.com

Collapse -

Sybase or Oracle

by ha_florez In reply to Sybase or Oracle

Of course Oracle is a Better database in all the ways

Collapse -

Sybase or Oracle

by stefan.giuros In reply to Sybase or Oracle

I think there is not a definite answer, but in my opinion Sybase ASE 12.0 is a better product than Oracle. It has a powerful SQL engine, a good-balanced SQL syntax and features, Java-in-the-server, and it is easy to administer and tune. Besides, theprice is lower and the ct-lib interface is easy to use in client programs.

Stefan
stefan.giuros@connex.ro

Collapse -

Sybase or Oracle

by ha_florez In reply to Sybase or Oracle

Oracle is a DB for the entreprise, i work with 3 databases each with 10 GB of data, i don't have any problem when i'm quering the info, you need only to understand the estructure of the database, so i prefeer Oracle, i prefeer to pay more but i get quality not cuantity

Collapse -

Sybase or Oracle

by ha_florez In reply to Sybase or Oracle

What makes Oracle a Powerfull database is the partitioning features (what makes easy to manage penta bytes of data) and the parallel process (for dataware houses)and the Oracle can chage the way it works when you change the Parameter File and re start the database, that's make Oracle a best Database than Sybase

Collapse -

by stefan.giuros In reply to Sybase or Oracle

(1) 10 Gb of data? I presume I should be impressed, but my Sybase DB is 300 GigaBytes. And it works very fine.
(2) If you should restart the database when you change your parameter file, how can you ensure 24 x 7 availability? Or maybe with Oracle databases nobody expects such performance?
(3) I agree that we need quality first, but some managers use to compare 'price versus performance'. IMO Oracle has a very poor rate at this parameter.
(4) You say nothing about inner structure of the two systems. Client-server approach (Sybase) versus server-only approach (Oracle)?
(5) What about the Oracle's demand of hardware resources for doing a decent job?

Stefan

Collapse -

by ha_florez In reply to

i have an smalls DB, i work with Oracle for the features that sybase don't have like paralel query, partitioning of large objects, paralel server, if you have a well tune DB the demand of hardware is very little, you can change all the parameters ofthe database without restaring. You have to be serius Oracle is Better on all the way

Collapse -

Talk sense

by Andrew Prosser In reply to

What a strange thread! Obviously 'Florez' knows nothing about Sybase ASE as all these features are available. I have worked with Sybase, MS SQL Server and Oracle, all have their good and bad points. I have also done Admin courses for DB2 and Informix. I happen to prefer Sybase as that is the database I have used the longest and so know the best. All these evangelical 'wars' are ridiculuous, just get on with the job at hand!

Collapse -

Sybase or Oracle

by bplumlee In reply to Talk sense

Kudos to Andrew! I have used other DBMS systems and also prefer Sybase. Every system has its limitations. And we tend to like what we first learn. We should not limit our views and experiences due to a lack of knowledge. Don't knock what you don't know.

Back to IT Employment Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums