1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Difference between Mysql and Oracle Database

Discussion in 'Databases' started by varul, Dec 1, 2009.

0
  1. #1
    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?
     
    varul, Dec 1, 2009 IP
  2. ebookbusiness

    ebookbusiness Member

    Messages:
    41
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #2
    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.
     
    ebookbusiness, Dec 3, 2009 IP
  3. webmaster8757

    webmaster8757 Member

    Messages:
    69
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    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.
     
    webmaster8757, Dec 7, 2009 IP
  4. OracleLover

    OracleLover Member

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #4
    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
     
    OracleLover, Dec 10, 2009 IP
  5. denverrusell

    denverrusell Active Member

    Messages:
    537
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    60
    #5
    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.
     
    denverrusell, Dec 10, 2009 IP
  6. checkblog

    checkblog Well-Known Member

    Messages:
    1,212
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    128
    #6
    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 :)
     
    checkblog, Dec 11, 2009 IP
  7. sippsin

    sippsin Active Member

    Messages:
    237
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    63
    #7
    Whatever differences are there, both are now with Oracle ! :)
    MySQL went to Oracle's hands when they Bought Sun
     
    sippsin, Dec 30, 2009 IP
  8. h_al

    h_al Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    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).
     
    h_al, Jan 2, 2010 IP
  9. aishaarora

    aishaarora Member

    Messages:
    262
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    26
    #9
    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
     
    aishaarora, Dec 1, 2010 IP
  10. iama_gamer

    iama_gamer Active Member

    Messages:
    404
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #10

    MySql does offer row locking in InnoDb
     
    iama_gamer, Dec 4, 2010 IP
  11. alexanime

    alexanime Peon

    Messages:
    39
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    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.
     
    alexanime, Dec 5, 2010 IP
  12. raouf45

    raouf45 Member

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #12
    thank you thank you
     
    raouf45, Dec 10, 2010 IP