The Facts – In Detail
In writing, Oracle claims a 10X or more performance improvement over its previous systems. Netezza already delivers up to 100x or more performance over conventional systems, of which Oracle is a prime offender. Companies such as Ahold, Epsilon, iBasis, NYSE Euronext, The Carphone Warehouse and Virgin Media have already realized the benefits.
Oracle’s one-to-many configuration of processor to disk - the Exadata nodes are organized with eight processor cores “sharing” 12 disk drives - is less efficient and with just 200 processors so they aren’t able to take advantage of parallelism to the same extent as Netezza. Netezza’s game-changing performance capability comes from our one-to-one mapping of processor to disk and the fact that we are massively parallel (nearly 1000 processors in our largest machine). Netezza has also put much more sophisticated processing capabilities into each of those 1,000 processors, or more suitably referred to as “intelligent storage nodes.”
As a first generation machine, Exadata is primitive and 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 Performance Server® (NPS®) 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 NPS 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 NPS 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.
For a more in-depth conversation, reach out to our hotline (North America: 703-918-4906; International: +44 (0)1270 879966) or join our community to see what enzees are saying.