• What are the advantages of MySQL in comparison to Oracle?

    Answered

    What are the advantages of MySQL in comparison to Oracle?

    Silver Member Asked on May 27, 2016 in MYSQL.
    Add Comment
  • 6 Answer(s)
    Best answer
    Features/Functionality MySQL Oracle
    Strengths Price/Performance Great performance when applications leverage architecture. Aircraft carrier database capable of running large OLTP and VLDBs.
    Database Products Enterprise ($) – supported, more stable.

    Community (free) – more leading edge.

    Enterprise ($$$$)

    Standard ($$)

    Standard One  ($)

    Express (free) – up to 4GB

    Application Perspective Web applications often don’t leverage database server functionality. Web apps more concerned with fast reads. More you do in the database the more you will love Oracle with compiled PL/SQL, XML, APEX, Java, etc.
    Administration Can be trivial to get it setup and running. Large and advanced configurations can get complex. Requires lots of in-depth knowledge and skill to manage large environments.  Can get extremely complex but also very powerful.
    Popularity Extremely popular with web companies, startups, small/medium businesses, small/medium projects. Extremely popular in Fortune 100, medium/large enterprise business applications and medium/large data warehouses.
    Application Domains

    (most popular)

    Web (MySQL excels)

    Data Warehouse

    Gaming

    Small/medium OLTP environments

    Medium/Large OLTP and enterprise applications.  Oracle excels in large business applications (EBS, Siebel, PeopleSoft, JD Edwards, Retek, …)

    Medium/Large data warehouse

    Development Environments

    (most common)

    1) PHP

    2) Java

    3) Ruby on Rails

    4) .NET

    5) Perl

    1) Java

    2) .NET

    3) APEX

    4) Ruby on Rails

    5) PHP

    Note: Oracle focusing on Java for next generation business applications.

    Database Server

    (Instance)

    Database Instance stores global memory in mysqld background process.

     

    User sessions are managed through threads.

    Database instance has numerous background processes dependent on configuration.  System Global Area is shared memory for SMON, PMON, DBWR, LGWR, ARCH, RECO, etc.

     

    Sessions are managed through server processes.

    Database Server

    (Physical Storage)

    Made up of database schemas.

    Each storage engine stores information differently.

    Common storage engines:

    MYISAM – stores data in .FRM, .MYD and .MYI files.

    InnoDB – stores data in a common tablespace or individual tablespaces per table.

     

    Binary logs are used for point-in-time recovery

    Uses tablespaces for system metadata, user data and indexes. Common tablespaces include:

    SYSTEM

    SYSAUX

    USER DATA

    USER INDEXES

    TEMPORARY

    UNDO

    Redo and archive log files are used for point in time recovery.

    Tables Tables use storage engines.  Each storage engine provides different characteristics and behavior. A few tables with tons of features.
    Partitioning Free, basic features $$$ with lots of options
    Replication Free, relatively easy to setup and manage. Basic features but works great.  Great horizontal scalability. $$$, lots of features and options.  Much higher complexity with a lot of features.  Allows a lot of data filtering and manipulation.
    Transactions InnoDB and upcoming Falcon and Maria storage engines Regular and Index only tables support transactions.
    Backup/Recovery No online backup built-in.

    Replication

    OS Snapshots

    InnoDB Hot Backup

    Recovery Manager (RMAN) supports hot backups and runs as a separate central repository for multiple Oracle database servers.
    Export/Import Easy, very basic. More features.
    Data Dictionary (catalog) Information_schema and mysql database schemas offer basic metadata. Data dictionary offers lots of detailed information for tuning. Oracle starting to charge for use of new metadata structures.
    Management/Monitoring $, MySQL Enterprise Monitor offers basic functionality.

    Additional open source solutions.

    May also use admin scripts.

    $$$$, Grid Control offers lots of functionality.

    Lots of 3rd party options such as BMC, Quest, Embarcadero and CA.

    Storage Each storage engine uses different storage. Varies from individual files to tablespaces. Tables managed in tablespaces.  ASM offers striping and mirroring using cheap fast disks.
    Stored Procedures Very basic features, runs interpreted in session threads.  Limited scalability. Advanced features, runs interpreted or compiled. Lots of built in packages add significant functionality.  Extremely scalable.
    Silver Member Answered on May 27, 2016.
    Add Comment
    1. MySQL is a free, fast, reliable, open source relational database while Oracle is expensive, although they have provided Oracle free edition to attract MySQL users.
    2. MySQL uses only just under 1 MB of RAM on your laptop while Oracle 9i installation uses 128 MB.
    3. MySQL is great for database enabled websites while Oracle is made for enterprises.
    4. MySQL is portable.
    Silver Member Answered on May 27, 2016.
    Add Comment

    The major differences found when looking at MySQL vs. Oracle start with the operating systems they work with. MySQL works with:

    • Windows
    • Mac OS X
    • Linux
    • UNIX
    • z/OS
    • BSD
    • Symbian
    • AmigaOS

    Oracle works with most of these operating systems, but it doesn’t work with BSD, Symbian or AmigaOS.

    Another major difference is found in the indexes used by both. MySQL uses:

    • Full-text
    • Hash
    • R-/R+ Tree

    Oracle uses more indexes than just these three including Bitmap, Expression, Partial and Reverse.

    Other major differences include:

    • MySQL supports Java, while Oracle doesn’t
    • MySQL provides on-site and phone support, while Oracle only provides Forums support
    • Oracle works with both dynamic and static systems, while MySQL only works with static
    • MySQL is free, while Oracle is purchase

    Other differences are found between the two, as well, but these differences are the most glaring.

    Silver Member Answered on May 27, 2016.
    Add Comment

    Summary Feature Comparison

    The following table includes information about the Oracle, MySQL, and SQL Server databases and how they compare.

    Feature

    Oracle

    MySQL

    SQL Server

    Interface

    GUI, SQL

    SQL

    GUI, SQL, Various

    Language support

    Many, including C, C#, C++, Java, Ruby, and Objective C

    Many, including C, C#, C++, D, Java, Ruby, and Objective C

    Java, Ruby, Python, VB, .Net, and PHP

    Operating System

    Windows, Linux, Solaris, HP-UX, OS X, z/OS, AIX

    Windows, Linux, OS X, FreeBSD, Solaris

    Windows

    Licensing

    Proprietary

    Open source

    Proprietary

    Oracle

    History

    IBM was the first company to develop a RDBMS, however, Oracle Corporation made history in 1980 by releasing its RDBMS, Oracle, for commercial use. Just a few years later the company would release a version of its system for IBM computers. Since its exhibition to the RDBMS market, Oracle has consistently led the way. According to Gartner, Oracle owned nearly 50% of the RDBMS market in 2011. In addition to opening up the commercial market for RDBMS, the Oracle Corporation also was the first company to develop a commercial-level version of SQL that was designed to manipulate data in a RDBMS using (at that time) queries and joins.

    Features

    The first “real” release of the Oracle RDBMS was Oracle 2. This system supported only basic SQL features, and it was written in an assembly language. The following year, and for the next 10 years or so, Oracle Corporation released updates to its flagship database. Probably one of the reasons the Oracle RDBMS has managed to remain at the top of mighty RDBMS is linked to its product updates that are closely tied to changes in the market. Database buzzwords such as “scalable”, “programmable”, “distributed”, and “portable” are also tied to Oracle release. For example, in 1985 support for a client-server model was added in anticipation of a growing acceptance of network communication. As the Internet paved the way for the Digital Era, the Oracle RDBMS was updated to include a native Java virtual machine (JVM).

    Oracle Database 12c is the most recent release of the RDBMS, and it includes the following features:

    • New data redaction to enhance security of sensitive data

    • Introduction of Oracle Advanced Analytics platform

    • New database handling for archiving Flash Data Archive (FDA)

    • Support for integrating with operating system processor groups

    • Support for data pump for database consolidation

    • Several enhancements to Oracle Application Express, a rapid-development tool that allows users to develop Web apps using SQL and/or PL/SQL.

    • Advanced network compression to enhance performance

    If you’re interested in how you code with Oracle SQL, an introduction to Oracle SQL course can provide the basics of the language.

    SQL Server

    History

    Microsoft SQL Server entered the RDBMS market as a serious competitor in the mid 1990s when Microsoft purchased it from Sybase, and then released version 7.0.  The companies originally worked together to develop the platform to run on the IBM OS/2 platform. However, Microsoft eventually developed its own operating system (Windows NT), and wanted to work solo to create a database management for it. It would take several years for the Microsoft and Sybase to completely sever their ties. Sybase eventually changed it’s product name so that it would be completely different from the product sold to Microsoft. Microsoft SQL Server version 4.2 was the initial release.

    Features

    In 2000, Microsoft released SQL Server 2000. The release was a significant milestone for the company because it marked the first release of the product where the original Sybase code was completely replaced. In the same vein as Oracle Corporation, Microsoft has attempted to enhance SQL Server to keep up with changing technology. SQL Server 2005 is an example. The eXtensible Markup Language (XML) received stamp of approval from W3C and started gaining ground in the late 1990s. One of the major new features of SQL Server 2005 was support for XML data. Other notable features of the flagship product include the introduction of SQL Server Always On (data management technology to decrease user downtime), support for structured and semi-structured data, enhanced compression, and several add-ons to support other products on the market. SQL Server 2012 was proclaimed as the last release to include native support for OLE. ASQL Server 2012 essentials course can offer more information about this platform and how to use it.

    SQL Server 2014 is the latest release of SQL Server and includes the following features:

    • Introduction of In-Memory Online Traction Processing (OLTP), an embedded feature that allows sophisticated database management to enhance performance

    • New solutions to handle disaster recovery

    • Updated version of SQL Server Data Tools for Business Intelligence (SSDT BI)

    MySQL

    History

    There are two unique aspects of MySQL in comparison to Oracle and SQL Server: it was not originally developed for commercial use and it is an open source database. The database platform was a happenstance as the individuals who developed it started out trying to use mSQL to interface with their database tables, and decided they needed a much more powerful interface. The initial phase of MySQL used an API leveraged from mSQL, enhancements that increased speed considerably, and other features that included the InnoDB storage engine, full text search, portability, and internationalization.

    Another difference of the MySQL platform in comparison to the other two is that it is open source. The Digital Age spawned a movement in software development collaboration that has blossomed into a competitive market for databases and other software. According to market reports, there is an excess of 10 million installations of MySQL, which indicates it is quickly moving into the enterprise space.

    The ownership of MySQL has transitioned from the product’s humble beginnings. The two most notable acquisitions are (1) in 2008 when Sun Microsystems acquired MySQL AB, the company that created MySQL, and (2) in 2010 when Oracle acquired Sun Microsystems.

    Features

    Oracle and SQL Server are considered tools that favor users with large enterprise systems, while MySQL is considered a tool that appeals most often to individuals interested in managing databases associated with their websites. As with Oracle and SQL Server, MySQL has released updates to its software just about every year. The original version was developed in the mid 1990s. The most notable changes to MySQL was in 2010, the time of the last acquisition in 2010. The enhancements to this release (GA release 5.5) included semisynchronous replication, custom partitioning, improved support for SMP and updates to the InnoDB I/O subsystem. If you are just learning about MySQL, you may be interested in learning more details about it. A MySQL database for beginners course is a good place to start your education.

    Conclusion

    This comparison shows just how close the databases are in three key areas. Considering your unique situation is probably more relevant for deciding which one to implement than determining which one is best.

    Silver Member Answered on May 27, 2016.
    Add Comment

    This chapter compares the MySQL database and the Oracle database. It includes the following sections:

    • Database Security
    • Schema Migration
    • Data Types
    • Data Storage Concepts
    Silver Member Answered on May 27, 2016.
    Add Comment

    MySql has many advantages in comparison to Oracle.

    1 – MySql is Open source, which can be available any time

    2 – MySql has no cost of development purpose.

    3 – MySql has most of features , which oracle provides

    4 – MySql day by day updating with new facilities.

    5 – Good for small application.

    6 – easy to learn and to become master.

    7 – MySql has a good power these days.

    even though MySql having so many advantages, Oracle is best database ever in Software development.

    Silver Member Answered on May 27, 2016.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.