MySQL is free and open source. Oracle is enterprise and expensive. However, plenty of large sites such as Facebook and Digg run perfectly fine on MySQL.
Oracle is used by larger organizations because of many reasons:
1. The ability to audit.
2. Oracle also has better user management and security for larger enterprises.
3. Enterprise-level management tools
MySQL is free, cheap to manage, efficient, fast, scalable, and open-source.
MySQL in being Open Source and free, and it has none of the design flaws that limit MySQL and Oracle some of the differences between MySql and Oracle are given below:
1)Oracle has row locking while MySQL only has table locking.
2)Oracle makes the most sense where you have huge volumes of complex datawhile MySQL is good for simple data,
3) Low end versions of MySQL and Oracle are free while high end versions of oracle are expensive.
4) Tables : MySQL supports more types of tables than Oracle, including MyISAM, MERGE, ISAM, innoDB, BDB and HEAP
5) Sequences : MySQL uses an AUTO-INCREMENT attribute assigned to a column when creating a table. . . The ability to start and increment sequence numbers values at the initial value within a group is a useful feature provided by MySQL that is not available in Oracle 9i database.
6) SQL Inserts : Unlike Oracle 9i database, MySQL allows INSERT statements with a VALUES clause to specify multiple sets of data to insert
7) Mysql is generally used by web application whereas Oracle is used by companies.
8) Mysql is easy as compared to Oracle.
Top 10 Difference between Oracle and Mysql ?
1. Oracle Support Pl-Sql(Procedural Language) in addition to Sql ,Mysql support only Sql
2. Oracle Provides lots of security features such as row lock while Mysql provide column.
3. Oracle requires username,password,profile validation at the time of logging while Mysql requires only username,password and host.
4. Oracle9i Database supports the use of temporary tables for an individual session, or global to all users.
5. Oracle is used for the large Enterprise .
6. Mysql is light,reliable and can connect to multi-Client Program.
7. facebook-The world 2nd number website drive on mysql.
8. MySQL does not support data partitions, and requires a server for each set of data files. Scalability is limited to the size of a single server. The limitations within MySQL of not supporting distributed databases is a serious roadblock in creating a high-performance, scalable database solution.
9. MySQL is an open source database, and is completely free.
10. Compare to Oracle, MySQL doesn't have Tablespace, Role management, snapshots, synonym and packages.
Oracle is used by larger organizations because of many reasons:
1. The ability to audit.
2. Oracle also has better user management and security for larger enterprises.
3. Enterprise-level management tools
MySQL is free, cheap to manage, efficient, fast, scalable, and open-source.
MySQL in being Open Source and free, and it has none of the design flaws that limit MySQL and Oracle some of the differences between MySql and Oracle are given below:
1)Oracle has row locking while MySQL only has table locking.
2)Oracle makes the most sense where you have huge volumes of complex datawhile MySQL is good for simple data,
3) Low end versions of MySQL and Oracle are free while high end versions of oracle are expensive.
4) Tables : MySQL supports more types of tables than Oracle, including MyISAM, MERGE, ISAM, innoDB, BDB and HEAP
5) Sequences : MySQL uses an AUTO-INCREMENT attribute assigned to a column when creating a table. . . The ability to start and increment sequence numbers values at the initial value within a group is a useful feature provided by MySQL that is not available in Oracle 9i database.
6) SQL Inserts : Unlike Oracle 9i database, MySQL allows INSERT statements with a VALUES clause to specify multiple sets of data to insert
7) Mysql is generally used by web application whereas Oracle is used by companies.
8) Mysql is easy as compared to Oracle.
Top 10 Difference between Oracle and Mysql ?
1. Oracle Support Pl-Sql(Procedural Language) in addition to Sql ,Mysql support only Sql
2. Oracle Provides lots of security features such as row lock while Mysql provide column.
3. Oracle requires username,password,profile validation at the time of logging while Mysql requires only username,password and host.
4. Oracle9i Database supports the use of temporary tables for an individual session, or global to all users.
5. Oracle is used for the large Enterprise .
6. Mysql is light,reliable and can connect to multi-Client Program.
7. facebook-The world 2nd number website drive on mysql.
8. MySQL does not support data partitions, and requires a server for each set of data files. Scalability is limited to the size of a single server. The limitations within MySQL of not supporting distributed databases is a serious roadblock in creating a high-performance, scalable database solution.
9. MySQL is an open source database, and is completely free.
10. Compare to Oracle, MySQL doesn't have Tablespace, Role management, snapshots, synonym and packages.
No comments:
Post a Comment