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
Many people are quick to offer subjective opinions simply because they may be familiar with one system, but not with other one. In any discussion of these machines, it is essential to leave your personal preference and experience behind you, and discuss the pros and cons of each objectively. We as XDuce are organizing a workshop for Exadata Database Machine Administration. Connect here for more details and registrations: Exadata Machine Training
ReplyDeleteThank you for this comprehensive comparison! One great way to determine the most effective Data Warehousing solution for your company is by reading user feedback. You can find real user reviews for Teradata, Netezza, Exadata and all the other major Data Warehousing tools on IT Central Station: https://goo.gl/uJnUkc
ReplyDeleteThe IT Central Station user community ranked Exadata the #1 tool in Data Warehousing. This user writes, "What makes Exadata different than competitors is that it is not designed only for a specific application (as in SAP HANA), and is not only for a certain type of workload (as in Teradata)." You can read the rest of his review, as well as explore what others have to say about Oracle Exadata, here: https://goo.gl/5VTVYr
This is a very good content I read this blog, please share more content on MSBI Online Course Bangalore
ReplyDeleteThis blog very easily understandable. Thanks for sharing such an informative post with us. This is a nice post in an interesting line of content.
ReplyDeleteExadata Training in Bangalore