Comparison Netezza vs. Oracle vs. Teradata by DB-Engines

Name	Netezza (Also called PureData System for Analytics by IBM)	Oracle	Teradata
Description	Data warehouse and analytic appliance	Widely used RDBMS	DBMS mainly used for data warehousing
Database model	Relational DBMS	Relational DBMS	Relational DBMS
DB-Engines Ranking (measures the popularity of database management systems)	Score     19.86 Rank      #29   Overall   #17 Relational DBMS	Score  1374.88 Rank   #1 Overall                  #1 Relational DBMS	Score 78.37 Rank  #12 Overall       #8 Relational DBMS
Website	www.ibm.com/­software/­data/­netezza	www.oracle.com/­database/­index.html	www.teradata.com
Technical documentation		docs.oracle.com/­en/­database	www.info.teradata.com
Developer	IBM	Oracle	Teradata
Initial release	2000	1980	1979
Current release		12 Release 2 (12.2.0.1), March 2017
License (Commercial or Open Source)	commercial	commercial (restricted free version is available)	commercial
Cloud-based (Only available as a cloud service)	no	no	no
Implementation language		C and C++
Server operating systems	Linux (included in appliance)	AIX HP-UX Linux OS X Solaris Windows z/OS	Linux
Data scheme	yes	yes	yes
Typing (predefined data types such as float or date)	yes	yes	yes
XML support (Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT)		yes
Secondary indexes	yes	yes	yes (special 'join index' to physically pre-join tables)
SQL (Support of (almost entire) SQL standard (DML, DDL and DCL statements))	yes	yes	yes
APIs and other access methods	JDBC ODBC OLE DB	ODP.NET Oracle Call Interface (OCI) JDBC ODBC	.NET Client API JDBC JMS Adapter ODBC OLE DB
Supported programming languages	C C++ Fortran Java Lua Perl Python R	C C# C++ Clojure Cobol Delphi Eiffel Erlang Fortran Groovy Haskell Java JavaScript Lisp Objective C OCaml Perl PHP Python R Ruby Scala Tcl Visual Basic	C Cobol Java (JDBC-ODBC) PL/1 Python R
Server-side scripts (Stored procedures)	yes	PL/SQL (also stored procedures in Java possible)	yes
Triggers	no	yes	yes
Partitioning methods (Methods for storing different data on different nodes)	Sharding	horizontal partitioning (with the optional Oracle Partitioning)	Sharding (shared nothing architecture)
Replication methods (Methods for redundantly storing data on multiple nodes)	Master-slave replication	Master-master replication Master-slave replication	Master-master replication
MapReduce (Offers an API for user-defined Map/Reduce methods)	yes	no (can be realized in PL/SQL)	no
Consistency concepts (Methods to ensure consistency in a distributed system)		Immediate Consistency
Foreign keys (Referential integrity)	no	yes	yes
Transaction concepts (Support to ensure data integrity after non-atomic manipulations of data)	ACID	ACID (isolation level can be parameterized)	ACID
Concurrency (Support for concurrent manipulation of data)	yes	yes	yes
Durability (Support for making data persistent)	yes	yes	yes
In-memory capabilities (Is there an option to define some or all structures to be held in-memory only)		yes (Version 12c introduced the new option 'Oracle Database In-Memory')	yes
User concepts ( Access control)	Users with fine-grained authorization concept	fine grained access rights according to SQL-standard	fine grained access rights according to SQL-standard

I hope you all have enjoyed reading this article. Comments are welcome....