oracle mysql comparison

XXXX Industries Limited

Databasecomparison

Oracle x MySql

Oracle(Since 1977)

Produced and marketed by Oracle Corporation

Larry Ellison and his friends started the consultancy Software Development Laboratories (SDL) in 1977 1979 - Oracle release 2

1983 - Oracle release 3






1998 - Oracle release 8i

2001 - Oracle release 9i

2003 - Oracle release 10g

2007 - Oracle release 11g

http://en.wikipedia.org/wiki/Oracle_Corporation

http://en.wikipedia.org/wiki/Larry_Ellison

Oracle Corporation is an American multinational computer technology corporation headquartered in Redwood City, California, The United States.

The company specializes in developing and marketing computer hardware systems and enterprise software products – particularly its own brands of database management systems.

Oracle is the third-largest software maker by revenue, after Microsoft and IBM

Oracle (Now)

http://en.wikipedia.org/wiki/Multinational_corporation

http://en.wikipedia.org/wiki/Redwood_City,_California

http://en.wikipedia.org/wiki/Computer_hardware

http://en.wikipedia.org/wiki/Enterprise_software

http://en.wikipedia.org/wiki/Oracle_Database

http://en.wikipedia.org/wiki/List_of_the_largest_software_companies

http://en.wikipedia.org/wiki/Microsoft

http://en.wikipedia.org/wiki/IBM

MySQL is a powerful and the most popular Open Source Software relational database management system (RDBMS) that uses SQL (Structured Query Language).

MySQL is named after co-founder Monty Widenius's daughter, My .

MySQL is officially pronounced "My esquel".

It is popular for web applications.

Previously, MySQL was developed, distributed, and supported by MySQL AB then acquired by Sun Microsystems. And now since January 2010 accquired by Oracle Corporation.

http://en.wikipedia.org/wiki/File:MySQL.svg

MySQL Development History

- MySQL was first released internally on 23 May 1995- Windows version was released on January 8, 1998 for Windows 95 and NT- Version 3.23 release January 2001- Version 4.0 release March 2003- Version 4.1 release October 2004- Version 5.0 release October 2005- Sun Microsystems acquires MySQL AB on 26 February 2008

- Version 5.1 release 27 November 2008 - Oracle acquired Sun Microsystems on 27 January 2010- Version 5.5 release December 2010 - Current Generally Available Release: 5.6.10, 5 February 2013


ORACLE: Different Types of DB

Enterprise Edition:

Most Powerful, with a vast array of tools and features for the large corporation

Standard Edition:Oracle SE contains the basic database management functions for small- and

medium-sized shops at a far lower cost than the EE.

Standard Edition one:Oracle SEO is specially-priced for single CPU servers used by small businesses.

Express Edition:

Entry-level, small-footprint database to develop, deploy, and distribute .

Different Types of DB

MySQL Community ServerMySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.

MySQL Enterprise EditionCommercial customers have the flexibility of choosing from multiple MySQL Editions to meet specific business and technical requirements.

Difference between the community edition and the enterprise edition is added support and tools. The server itself is the same, but the enterprise edition gets updated more frequently and it is stable with quick bug fix support.

MySQL is used in many high-profile, large-scale World Wide Web products, including Wikipedia,Google(though not for searches), Facebook,Twitter,Flickr,Nokia.com and YouTube.


Sr. No.

Features/Functionality

Oracle MySQL

1 Strengths Aircraft carrier database capable of running large OLTP and VLDBs.

Price/Performance Great performance when applications leverage architecture.

2 Database Products

Enterprise ($$$$)Standard ($$)Standard One ($)Express (Free) - up to 4GB

Enterprise ($) – supported, more stable.Community (free)

3 Application Perspective

More you do in the database the more you will love Oracle with compiled PL/SQL, XML, APEX, Java, etc.

Web applications often don’t leverage database server functionality. Web apps more concerned with fast reads.

4 Administration Requires lots of in-depth knowledge and skill to manage large environments. Can get extremely complex but also very powerful.

Can be trivial to get it setup and running. Large and advanced configurations can get complex.

Oracle versus MySQL Features/Functionality


Sr. No. Features/Functionality

Oracle MySQL

5 Popularity Extremely popular in Fortune 100, medium/large enterprise business applications and medium/large data warehouses.

Extremely popular with web companies, startups, small/medium businesses, small/medium projects.

6 Application Domains

Medium/Large OLTP and enterprise applications. Oracle excels in large business applications.Medium/Large data warehouse

Web (MySQL excels)Data WarehouseGamingSmall/media OLTP environmnets

7 Development Environments(most common)

1) Java2) .NET3) APEX4) Ruby on Rails5) PHP

1) PHP2) JAVA3) Ruby on Rails4) .NET5) Perl

8 Database Server(Instance)

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 Instance stores global memory in mysqld background process.User sessions are managed through threads.



Oracle MySQL

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

Made up of database schemas.

10 Partitioning $$$ with lots of options Free, basic features

11 Replication $$$, lots of features and options. Much higher complexity with a lot of features. Allows a lot of data filtering and manipulation.

Free, relatively easy to setup and manage. Basic features but works great. Great horizontal scalability.

12 Transactions Regular and Index only tables support transactions.

InnoDB and upcoming Falcon and Maria storage engines

13 Backup/Recovery Recovery Manager (RMAN) supports hot backups and runs as a separate central repository for multiple Oracle database servers.

No online backup built-in.



Oracle MySQL

14 Export/Import More features. Easy, very basic.

15 Data Dictionary (catalog)

Data dictionary offers lots of detailed information for tuning. Oracle starting to charge for use of new metadata structures.

Information_schema and mysql database schemas offer basic metadata.

16 Management/Monitoring

$$$$, Grid Control offers lots of functionality. Lots of 3rd party options such as Quest.

$, MySQL Enterprise Monitor offers basic functionality. Additional open source solutions. May also use admin scripts.

17 Storage Tables managed in tablespaces. ASM offers striping and mirroring using cheap fast disks.

Each storage engine uses different storage. Varies from individual files to tablespaces.

18 Stored Procedures Advanced features, runs interpreted or compiled. Lots of built in packages add significant functionality. Extremely scalable.

Very basic features, runs interpreted in session threads. Limited scalability.

Summary

ORACLE

Very Powerful DB

For OLTP, VLDBs

Price: $$$$

Ease of Use: Many Features

Performance: Very High

Good / ok Performance

For Web, Small-Mid Appl.

Price: 0 to $

Ease of Use: Limited Features

Performance: Good / Ok


Thank You

The End

[email protected]

oracle mysql comparison

Technology