The Facts – In Detail
In writing, Oracle claims a 2X or more performance improvement for its latest version of Exadata over its previous Exadata system. Netezza already delivers up to 100x or more performance over conventional systems, of which Oracle is a prime candidate. Companies such as Ahold, Epsilon, iBasis, NYSE Euronext, The Carphone Warehouse and Virgin Media have already realized the benefits.
Exadata is limited to carrying out simple SQL projection operations within the storage. The bulk of processing is still carried out in the database itself and, as a consequence, costly amounts of raw, unprocessed information are sent to the SMP host processors in the database machine for further processing. By comparison, the Netezza TwinFin™ system typically performs well over 95% of all of the work required to complete a given query response within the massively parallel array of 1,000 intelligent storage nodes, adding to the performance benefit.
All of the above leads to higher performance in the TwinFin system. While Netezza makes claims of 100x performance gains, it is not uncommon to see performance differences as large as 200x to even 400x or more when compared to existing Oracle systems. Oracle’s 10x performance claim is weak in comparison.
Oracle processes SQL queries. With Netezza’s OnStream™ capabilities, we have "opened up" our patented streaming architecture so that developers can exploit the same massively parallel processing that we do for high-performance, non-SQL, advanced analytics. The TwinFin system is fully extensible, and complex user-defined functions can be executed within Netezza’s massively parallel storage array. A sophisticated programmer’s workbench allows functions to be written quickly and easily with the massively parallel considerations being handled automatically by Netezza. Netezza customers all over the world are benefitting from this, which results in game-changing breakthroughs in performance even over an already high-performing vanilla Netezza implementation. Today, there are over 100 partners who have written advanced analytics functions for risk simulation, dynamic re-pricing for telecommunications, customer scoring and complex transformational logic, fuzzy name matching for intelligence and fraud detection and others, that take advantage of this capability.
Netezza is supplied as a single system ready-to-go in less than two days. This has a significant impact on time to value (TTV) which is important in today’s economy. In contrast, the Database Machine is supplied by two different companies, dispatched piecemeal on separate days. When all the parts arrive on site, you can request an engineer to come and set it all up. As a piecemeal solution, implementation is no different to that of a regular Oracle set-up: time consuming, expensive, inefficient and painfully slow.
Because Netezza’s ANSII standard SQL RDBMS was designed to run Netezza’s unique hardware architecture, it does not need the complex performance tuning mechanisms that you find in Oracle. This results in administrators of the system and the database having to deal with and maintain, literally, thousands fewer objects in the system. As a consequence, a key aspect of Netezza is simplicity. Netezza systems are pre-installed, pre-built, pre-configured, require minimal administration and run orders of magnitude faster than Oracle.
But don't just take our word for it – take our Netezza TestDrive or join our community to see what enzees are saying.
