Why does Oracle beat out MySQL in database comparisons?

In my concern we are doing some small scale projects in Web designing and Web programming.

I am working as a DBD (database developer). I was often asked which database to use for my coming projects -- Oracle or MySQL. But we finalized to use Oracle Database.

I know this is an Oracle-related site, but I need your help to know why in the comparison of MySQL and Oracle, Oracle wins all the time (as per my concern). Can I get some details regarding this?

Eager to know your comments or suggestions regarding this.

    Requires Free Membership to View

    By submitting your registration information to SearchOracle.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchOracle.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

You can of course Google this question and get a ton of opinions and technical comparisons.

However, the answer really depends on the application and what you are looking for. Oracle, MS SQL Server and DB2 are the major players and are considered enterprise-class RDBMS systems. This means that they are better for larger, mission-critical applications. The primary reasons Oracle is chosen over MySQL in enterprise scenarios is because of its functionality, scalability and maturity.

Of course, all the bells and whistles of Oracle do not come cheaply, which is why MySQL is growing in popularity for small, non-critical applications. MySQL is still a relatively new player with less features and scalability and hence, at least in my opinion, better suited for small, non-critical applications.

This was first published in September 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.