"In 2004, Wal-Mart had 500 terabytes of transactional data and was adding 107 transactions per day."
|
|
Compare Databases
| 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 |
|
