Netezza
How can your business unlock the enormous value stored in the mountains of data you possess? This is the question the Netezza partnership with Fuzzy Logix seeks to answer. Without a doubt it all begins with a robust hardware platform, the ability to leverage quantitative models to analyze large sets of data, and a way to present the results in an easy to understand and actionable format. By marrying the Netezza platform with Fuzzy Logix’ quantitative models and web-based solutions, together we provide turn-key solutions capable of handling infinitely large amounts of data while eliminating the need for long, capital intensive development projects. Problem solved. Opportunity realized.
For companies adopting the Netezza platform who have existing quantitative models, Fuzzy Logix also provides consultative services that leverage our vast array of technical and modeling experience to help you optimize your existing models and add new capabilities. These services leverage our technology while also making the most of our human capital in support of your existing team.
DB LYTIX™ and Netezza
Massively parallel architecture and access to a bit of “secret sauce” allow DB Lytix™ to run amazingly fast on the Netezza platform. The reason for this incredible performance can be understood after exploring a bit of the Netezza lexicon.
AMPP™(SMP and MPP) and SPUs
Netezza’s AMPP™(Asymmetric Massively Parallel Processing) architecture marries a SMP (Symmetric Multiprocessing) host with MPP (Massive Parallel Processing). As programs are executed, the host compiles the code and distributes queries across individual SPUs (Snippet Processing Units) to run in parallel. Once distributed, the SPUs perform the processing. When the processing is complete, the SMP host aggregates the results. The SPU is a complete computer with a processor, disk storage, memory and a key piece of the “secret sauce” of Netezza. By using the combination of SMP Host and SPUs, parallelized SQL queries execute with blazing speed.
“Secret Sauce” – the FPGA
Another acronym introduced by Netezza to the data warehouse world is FPGA (Field Programmable Gate Array). FPGAs are semiconductor chips that can be programmed and have been used for a wide variety of applications for many years. Netezza is the first company to leverage their power to process streaming data in a data warehouse appliance. In traditional systems, all the data for a query is moved and then the “where” clause is processed. With Netezza, instead of moving a huge set of data, the FPGA processes the “where” clause as data streams off of the disk, so only the data needed for processing is moved to the next step.
UDx (UDF and UDA)
To access the power of the architecture, Netezza allows users to write UDFs (User Defined Functions) and UDAs (User Defined Aggregates) – both known as UDxs. UDA’s return one value for multiple rows, whereas UDF’s return one value per row. UDA’s and UDF’s can be accessed through simple SELECT statement and UDF’s can be embedded within UDA’s and UDF’s. Also, it is possible to embed UDA’s within UDF’s as arguments and vice versa.
With UDxs, Netezza allows you to write processing logic, such as data mining algorithms, to the SPUs. Netezza calls this OnStream™processing. By implementing this and other technologies, Netezza achieves speeds which are 10-100 times faster than traditional solutions.
While it is possible to create your own UDxs, Fuzzy Logix DB Lytix™ software package contains hundreds of prebuilt math, statastic, data mining and financial models.
(AMPP™+ SPUs + FPGA + UDx) + DB Lytix™ = Stunning performance
By combining the Asymmetric MPP™architecture with SPUs and FPGAs, and then giving access to the SPUs via UDAs and UDFs, Netezza gives users a strong platform to achieve very high processing performance.
Pairing the platform with the DB Lytix™ library leverages the architecture of Netezza to its fullest extent and delivers results with stunning speed and accuracy.
About Netezza
With the invention of data warehouse appliances, Netezza revolutionized and simplified analytics for companies drowning in data and struggling to find the processing speed and power to analyze and understand what it all meant.
Today, Netezza is the data warehouse appliance leader, combining storage, processing, database and analytics into a single system that delivers 10-100x the performance, at half the cost and one-third the power of other approaches. Think of it as a Ferrari, with the price and efficiency of an economy car.
With hundreds of customers including Amazon.com, Nationwide, Neiman Marcus, Orange UK, The Sherwin-Williams Company, Virgin Media and more, and offices worldwide, Netezza (NYSE Arca: NZ) is a proven solution to the rising costs and complexity of data warehousing and analytics. Our impressive ecosystem of global partners and an expansive list of system integrator, reseller and Netezza Developer Network partners worldwide, including Fuzzy Logix, means our customers can rest assured that Netezza will live comfortably within any existing infrastructure they have in place.
Please contact us to discuss how our solutions improve business performance.
![]()



