Criteria
|
Appliance Name
| |||
Netezza
|
Teradata
|
Exadata
| ||
Architecture Highlights
|
Scalability, Parallelism
|
Scalability, Parallelism
|
Scalability, Parallelism
| |
Parallelism Concept
|
AMPP1
|
SMP2 & MPP3
|
MPP
| |
Hardware
|
HP
|
NCR
|
HP Proliant DL180 G5
| |
Network Interface
|
Gigabit Ethernet (1 GB/sec)
|
BYNET
|
InfiniBand (16 GB/sec)
| |
Software
|
OS
|
Linux (Redhat)
|
Windows, Linux and NCR UNIX
|
Oracle
|
RDBMS
|
Porstgre based
|
Teradata Database
|
Oracle
| |
Query Processing
|
Managed by
|
Hardware
|
Virtual Process (Software)
|
RDBMS Software
|
Key Processing Unit
|
FPGA4
|
VPROC5 (AMP6)
|
as Oracle
| |
Executed
|
completely in Disk
|
virtually in disk
|
Both in Disk and Database server
| |
Scalability
|
Linear Scalable
|
Linear Scalable
|
Linear Scalable
| |
Failover
|
Built-in
|
Built-in
|
Built-in
| |
Availability
|
Built-in
|
Built-in
|
Built-in
| |
Usage of Index
|
Not used
|
Extensively used
|
moderately used
| |
ETL7
|
ELT8
|
ETL
|
ETL
| |
Migration Effort
|
High as new architecture
|
High as new architecture
|
Comparatively less effort
| |
Administration
|
Less
|
Less
|
More than Netezza and Teradata
| |
1- Asymmetric Massively Parallel Processing
2- Symmetric Multi Processing
3- Massively Parallel Processing
4- Field Programmable Gate Array
5- Virtual Processor
6- Acess Module Processor
7- Extract, Transformation, Load
8- Extract, Load, Transformation