comparison between two DBMS software

MySQL

Oracle

Architecture

Relational Model

Relational Model

Operating System

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

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

Price

$0

$180

Specifications

Type System

• Dynamic
• Static

• Dynamic
• Static

Architecture

Relational Model

Relational Model

Software License

• GPL
• Proprietary

• GPL
• Proprietary

Operating System

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

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

Interface

• GUI
• SQL

• GUI
• SQL

Specifications

Access Control

• Audit
• Brute-force Protection
• Enterprise Directory Compatibility
• Password Complexity Rules
• Patch Access
• Resource Limit
• Run Unprivileged
• Security Certification
• Native Network Encryption

• Audit
• Brute-force Protection
• Enterprise Directory Compatibility
• Password Complexity Rules
• Patch Access
• Resource Limit
• Run Unprivileged
• Security Certification
• Native Network Encryption

Indexes

• Bitmap
• Expression
• Partial
• Reverse
• Full-text
• Hash
• R-/R+ Tree

• Bitmap
• Expression
• Partial
• Reverse
• Full-text
• Hash
• R-/R+ Tree

Partitioning

• Composite (Range + Hash)
• Hash
• List
• Range

• Composite (Range + Hash)
• Hash
• List
• Range

Other Objects

• Data Domain
• Cursor
• External Routine
• Function
• Procedure
• Trigger

• Data Domain
• Cursor
• External Routine
• Function
• Procedure
• Trigger

Tables and Views

• Materialized Views
• Temporary Table

• Materialized Views
• Temporary Table

Deployment Model

• On Premise

• On Premise

General Features

Database Capabilities

• Common Table Expressions
• Except
• Intersect
• Parallel Query
• Windowing Functions
• Blobs and Clobs
• Inner Joins
• Inner Selects
• Merge Joins
• Outer Joins
• Union

• Common Table Expressions
• Except
• Intersect
• Parallel Query
• Windowing Functions
• Blobs and Clobs
• Inner Joins
• Inner Selects
• Merge Joins
• Outer Joins
• Union

Features

• Java Support
• ACID
• Referential Integrity
• Transactions
• Unicode

• Java Support
• ACID
• Referential Integrity
• Transactions
• Unicode

Technical Support

Support Features

• Forums
• On-site
• Phone

• Forums
• On-site
• Phone

Data Types

Integer

• BIGINT (64-bit)
• INTEGER (32-bit)
• MEDIUMINT (24-bit)
• NUMBER
• SMALLINT
• TINYINT (8-bit)

• BIGINT (64-bit)
• INTEGER (32-bit)
• MEDIUMINT (24-bit)
• NUMBER
• SMALLINT
• TINYINT (8-bit)

Floating Point

• BINARY_DOUBLE
• BINARY_FLOAT
• DOUBLE (64-bit)
• FLOAT

• BINARY_DOUBLE
• BINARY_FLOAT
• DOUBLE (64-bit)
• FLOAT

Decimal

• DECIMAL
• NUMERIC

• DECIMAL
• NUMERIC

String

• NCHAR
• NVARCHAR
• TEXT
• CHAR
• VARCHAR

• NCHAR
• NVARCHAR
• TEXT
• CHAR
• VARCHAR

Additional Data Types

Boolean

• BIT
• Unknown

• BIT
• Unknown

Binary

• BFILE
• BINARY
• LONGBLOB
• LONGRAW
• MEDIUMBLOB
• RAW
• TINYBLOB
• VARBINARY

• BFILE
• BINARY
• LONGBLOB
• LONGRAW
• MEDIUMBLOB
• RAW
• TINYBLOB
• VARBINARY

Date/Time

• DATETIME
• YEAR
• DATE
• TIMESTAMP

• DATETIME
• YEAR
• DATE
• TIMESTAMP

Other

• AUDIO
• DICOM
• ENUM
• GIS data types
• IMAGE
• SET
• SPATIAL
• VIDEO
• XMLTYPE

• AUDIO
• DICOM
• ENUM
• GIS data types
• IMAGE
• SET
• SPATIAL
• VIDEO
• XMLTYPE

Database Size Limits

Max Blob/Clob Size

4 GB

Unlimited

Max DB Size

Unlimited

Unlimited

Max Table Size

MyISAM storage limits: 256TB; Innodb storage limits: 64TB

4 GB

Max Column Name Size

64

30

Max Row Size

64 KB

8KB

Max Columns per Row

4096

1000

Data Type Limits

Max DATE Value

9999

9999

Max CHAR Size

64 KB (text)

4000 B

Max NUMBER Size

64 bits

126 bits

Min DATE Value

1000

-4712

Price

Price

$0

$180

Upgrade Price

0

–

Purchase Page

Purchase Page (shop.oracle.com)

Purchase Page (shop.oracle.com)

Contact Information

Address

–

Oracle Corporation 500 Oracle Parkway
Redwood Shores, California 94065
United States

Website

MySQL (mysql.com)

Oracle (oracle.com)

Contact Link

Contact Link (mysql.com)

Contact Link (oracle.com)

Phone

1 (866) 221-0634

1 (800) 392-2999

MySQL

Oracle

Thanks for voting! Looks like 32% of visitors agree with you.

Vote

 

Your Choice

68%

 

32%