IT Dimensions
"In 2004, Wal-Mart had 500 terabytes of transactional data and was adding 107 transactions per day."

Compare Databases

Product IBM DB2 8.2 Express Edition Microsoft SQL Server 2005 MySQL V5.0 Oracle 10g Release 1 Standard Edition
Price Per CPU, unlimited users $8106, or, per server $1037.84 plus $206.24 per user Standard edition $1,400 $0 without support, commercial license $495 - $175 per license depending on number of copies. Per CPU (unlimited users) $19,814 (+ software update and support of $4,358.97 per annum), or per named user $396 (minimum of 5 users) (+ $87.18 per user for software update and support per annum)
Number of CPUs supported Maximum of two 4 -standard,
1 -express
Unlimited (dependent on OS/hardware) Maximum of 4 -cores
Maximum buffer pool memory size Around 3.5GB 1GB Limited by OS. MySQL utilizes multiple buffer pools for different purposes, each individually tunable. Restricted to the hardware size
Maximum database size Theoretical limits: 512GB per table space, maximum 32768 tablespaces, practical limit would be smaller 4GB -express, other editions no limit OS limited Restricted to the hardware size but indicative values are: Win 32-bit: 2.75GB or 64GB with memory extensions. Theoretical limit 140TB.
Hardware requirements (recommended, CPU, RAM, Disk) Recommended for 50GB to 250GB of data: 100GB to 500GB of disk space, 3GB to 4GB RAM per CPU, One or more 2.5GHz CPUs 1 GHZ processor, 512 MB, 425 MB disk space recommended Anything from for instance 64MB Flash card + 16MB RAM for embedded boxes, to multi-CPU multi-GB environments. 1 GB RAM, 2GB Hard Disk space for Database.
OS supported Windows, Linux Windows XP, Windows 2000+ Any Unix, Linux, Windows, NetWare and Mac OSX. Windows, Linux, Solaris, HP OpenVMS, Mac OS, AIX, IBM z/OS, HP Unix
Computing Cluster Support No No Yes Yes
ANSI SQL Compliant Yes Basic Extended subset of SQL-99, plus SQL-99 and SQL:2003 features. Yes
Memory Management (auto) Manual/auto Yes Yes Yes
Server managed backup and recovery Yes Yes Yes No
Multiple block size support Yes, 4,8,16,32K Page No Yes, with recompile. Yes
Triggers (eg before, after, instead, DB event) No cascade before, after, instead of, insert , delete , update Yes Yes Yes
Stored procedures Yes Yes Yes Yes
Index types supported Type1, Type2, Clustering, Multi Dimensional Clustering, spatial index with spatial extender Btree, XML Dependent on storage engine and column type used: Btree, Rtree, Hash, T-Tree, FULLTEXT. B-Tree, Bitmap, Function-Based, Partitioned
Array support? Yes Yes Yes VARRAYS Supported
User defined functions (list) Yes Yes Yes N/A
Column name length 30 128 64 30
Index name length 128 128 64 30
Table name length 128 128 64 (>512 for aliases inside queries) 30
Constraint name length 18 128 As column names 30
Max char() size 254 8000 1048543 Column size-2000, Variable size-32767
Max varchar() size 32762 2GB 1048543 Column size-4000, Variable size-32767
Max columns per table 1012 for 32K page table 1024 3398 1000
Max table row length 32772 for 32K page table none 65534 + any text/blob cols up to 4GB each Unlimited
Max columns per index 16 16 16 Bitmap-30, Others-32
Max indexes per table 32622 or storage limit 249 non clustered, 1 clustered 64 (128 with recompile) Unlimited
Max nested stored procedure levels 16 32 Limited only by thread stack (OS/configurable) 254 (Unlimited subqueries in the FROM clause of a top-level SQL query)
Password Management Yes yes Yes Yes
Native Data Encryption Yes Yes Yes Yes
Auditing Features Yes Yes Yes Yes
Java Yes Yes Yes Yes
JDBC Yes Yes Yes Yes
XML Yes Yes Yes Yes
ODBC Yes Yes Yes Yes
OLE DB.NET & ODBC.NET ODBC.NET Yes Connector/Net Yes

© 2020 IT Dimensions, Inc. All Rights Reserved.
Call us: 1-718-777-3710 | Astoria | New York
Data Quality