0
Most people who select oracle over mysql are doing so for a variety of reasons, not one specific feature. Price is usually the most important factor. MySQL is free, and that's why many people choose to use it. Oracle is time-tested/proven, and that is why many people choose it.
However, many corporations purchase volume licenses and so the cost of adding an new database/user to an oracle database is not as much as it would be to start your first implementation.
Reasons to use oracle instead of MySQL:
1.Oracle has many built in functions such as decode that make some queries easier to build.
2. Oracle is a private company, and some people argue this means that they will deliver releases/fix defects/etc more regularly, since they rely on the income to survive.
3. Oracle has PL/SQL, a built in language that is very powerful. You can also have java stored procedures, this is much more powerful then what MySQL offers.
4. Oracle has support for sequences, MySQL does not.
5. Mysql does not support table snapshots
6. Oracle can be customized and tuned, much more then MySQL can.
7. Oracle provides Hot Backup/Standby facility, Mysql provides this facility only for selected engines.
8. Oracle provides Clustering Mechanism, where as MYSql does not.
9. Oracle Provides two way replication, Mysql provides only one-way replication.
10. Oracle provides DB links to connect to a remote oracle server.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Why did Google change their database from Oracle to MySQL?
Google don't use Oracle or MySQL, they use their own database software known as Bigtable.
Who invented mysql?
oracle corporation
Whose product is mySql?
mysql is oracle product when its purchased from sun microsystem
Can you use mysql instead of sql as backend?
Assuming you have MySQL installed on your server then yes.
Two Database programs in the market?
MYSQL and Oracle.
Which organization developed MySQL?
MySQL was developed by Oracle and is named after co-founder Michael Widenius's daughter, My.
Is MySQL a server?
MySQL is an open source relational database management system based on SQL queries. It was developed by the Swedish company MySQL AB and is now a subsidiary of Oracle Corporation. Your could use a MySQL Client, for example dbForge Studio for MySQL, to install and connect to MySQL Server as a first steps to get started with MySQL.
What are four database programs?
Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.
What is use of c language in real life?
Writing programs in it. Some of them are: linux, windows, bash, Oracle, MySql, Apache
What are the different types of databases available?
sql db2 oracle mysql
What are the 5 different types of databases?
Relational databases: Organize data into tables with rows and columns. NoSQL databases: Designed for large volumes of unstructured or semi-structured data. Object-oriented databases: Store data as objects. Graph databases: Optimal for data with complex relationships. In-memory databases: Data stored in RAM for faster access.
What are 5 different types of databases?
sql db2 oracle mysql
