The world wide using databases are Mysql and Oracle databases. Both are relational databases. But most of the large scale projects are developed in Oracle database. Why this preference has given to Oracle database? And what are all the differences between them?
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.
Some more 1. Tables : MySQL supports more types of tables than Oracle, including MyISAM, MERGE, ISAM, innoDB, BDB and HEAP 2. 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. 3. SQL Inserts : Unlike Oracle 9i database, MySQL allows INSERT statements with a VALUES clause to specify multiple sets of data to insert
i am vb6 and c# programmer i'm using mysql. I like the feature of mysql and ability to handle data. mysql is easy to manage and design a table and you can query many table.
There is a huge difference. Mysql is generally used by web application whereas Oracle is used by companies. Mysql is easy as compared to Oracle. Ample tutorial resources available for Mysql but no for Oracle Both are now owned by the same company, as Oracle purchased sun microsystem
Whatever differences are there, both are now with Oracle ! MySQL went to Oracle's hands when they Bought Sun
They are both (unfortuantely) owned by the same compay, Oracle. In brief, both are used in different domains. MySQL is famous in web (where MySQL really excels) and small/medium OLTP environments. On the other hand, Oracle excels in large business applications (large OLTP and enterprise applications).
Oracle use mysql for handling database. Oracle requires more setup requirements than mySQL. MySql is a query language where as Oracle is a development tool in which you can made forms, can generate reports. Oracle is user friendly a layman can use it while mySQl is used by professionals
it is like comparing a ferrari with a fiat. You can do that. To understand the differences you must know the database theory. Oracle (mysql belongs to oracle by the way) supports the best concurrency algorithms, the best storage engines, the best query optimizers etc. MySQL is just free and good for what it is made for.