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.
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.
Dig Deeper on Oracle competitors and market analysis
Related Q&A from Michael Hillenbrand
Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading
Expert Michael Hillenbrand discusses whether Linux certification is necessary for a job in Oracle. Continue Reading
An Oracle user asks who should do the source-to-target mapping in a company--the Business Analyst or Data Architect. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.