IBM Software Information Management

Data Sheet

IBM Netezza 1000

High-performance business intelligence and advanced analytics for the enterprise
Our approach to data analysis is patented and proven. Minimize data movement, while processing it at physics speed. Do this in parallel, on a massive scale. Inside an easy-to-use data warehouse appliance. Extremely fast. At a low cost. And let our customers run BI and advanced analytics that were previously impossible or impractical. IBM Netezza 1000 is a purpose-built, standards-based data warehouse appliance that architecturally integrates database, server, storage and advanced analytic capabilities into a single, easy-to-manage system. The IBM Netezza 1000 appliance is designed for rapid and deep analysis of data volumes scaling into the petabytes, delivering 10-100x performance improvements at a fraction of the cost of other options available from traditional vendors.

The analytics conundrum

Deep, sophisticated analytics on volumes of historical data are the lifeblood of enterprises in an Intelligent Economy, giving them an edge over the competition. However, most organizations have to make a choice between data volume and analytic complexity due to the limitations of their technology infrastructure. Most analytics performed on large data are relatively simple. The infrastructure, based on traditional database and storage technology, gets easily overextended just keeping up with the growth in user and data volumes, leaving no room to accommodate the increasing analytic complexity. With IBM Netezza data warehouse appliances, organizations no longer have to make a choice between data volume and analytic complexity. IBM Netezza appliances are scalable, massively parallel systems that allow customers to crunch through enormous data volumes, with large numbers of users asking questions of the data that could not even be contemplated before.

Performance, simplicity, value

IBM Netezza 1000 is designed specifically for running complex analytics on very large data volumes, orders of magnitude faster than competing solutions. It delivers the proven performance, value and simplicity organizations need to dive deep into their data.

IBM Software Information Management

Data Sheet

Performance

IBM Netezza 1000 Highlights:

Powerful platform for unifying business intelligence and advanced analytics Scalable Performance 10-100x complex analytics and BI performance at peta-scale Support for thousands of users and complex mixed workloads Flexible embedded analytic platform (IBM Netezza Analytics) technology supports multiple languages (C/C++, Java, Python, Fortran), frameworks (Hadoop) and tools (IBM SPSS, R, SAS) Simplified analytic development out-of-the-box parallelized analytics and modules; no need for parallel programming Blade-based streaming architecture utilizing IBMs patented data filtering using Field Programmable Gate Arrays (FPGAs) Appliance simplicity easy to deploy and manage; dramatically simplifies your data warehouse and analytic infrastructure Compatible with market-leading analytic and BI tools, applications and infrastructure Industry-standard interfaces (SQL, ODBC, JDBC, OLE DB) Enterprise-class reliability and availability more than 99.99% uptime Green low power and cooling requirements in a compact footprint Fast load speeds more than 4 TB/hour Fast backup rates high-speed backup and restore at data rates of more than 4 TB/hour

The IBM Netezza 1000 systems orders-of-magnitude performance advantage over other analytic options comes from its unique asymmetric massively parallel processing (AMPP) architecture that combines open, IBM blade servers and disk storage with IBMs patented data filtering using Field Programmable Gate Arrays (FPGAs). This combination delivers blisteringly fast query performance on highly complex mixed workloads supporting tens of thousands of BI and data warehouse users, sophisticated analytics at the speed of thought, and scalability to petabytes of data. IBM Netezza 1000 brings analytics to the data, so modelers and quantitative teams can operate on the data directly inside the appliance instead of having to offload it to a separate infrastructure and deal with the associated data preprocessing, transformation and movement. They can not only build their models using all the enterprise data, but also iterate through different models much faster to find the best fit. Once the model is developed, it is seamless to execute against the relevant data in the appliance. The prediction and scoring can be done right where the data resides, inline with other processing, on an as-needed basis. Users can get the results of prediction scores in near real-time, helping operationalize advanced analytics and making it available throughout the enterprise.

Simplicity
The simplicity and ease of development and deployment is what truly sets IBM Netezza 1000 apart. IBM Netezza 1000 delivers high performance out of the box, with no indexing or tuning required. As an appliance, all of the integration of hardware, software and storage is done for you, leading to shorter deployment cycles and faster time to value for BI and analytic initiatives. The appliance is delivered ready-to-go for immediate data loading and query execution and integrates with leading ETL, BI and analytic applications through standard ODBC, JDBC and OLE DB interfaces. IBM Netezza 1000 simplifies analytics dramatically by consolidating all analytic activity in the appliance, right where the data resides. Moving analytics to IBM Netezza 1000 is straightforward with IBM Netezza Analytics, IBM Netezzas embedded analytic platform delivered with every appliance. IBM Netezza Analytics supports a breadth of analytic tools and programming languages, and is delivered with a library of in-database analytic functions that execute analytics in parallel while hiding the complexity of parallel programming from developers. IBM eliminates complexity at every step so you can redirect valuable resources to the initiatives that will actually impact the bottom line.

IBM Software Information Management

Data Sheet

Value
As a commodity based appliance, IBM Netezza 1000 is a low TCO analytic option. But its value goes beyond the initial low purchase price. The IBM Netezza appliance requires minimal ongoing administration, both in internal resources as well as implementation costs, for an overall low total cost of ownership. The performance and scalability of IBM Netezza appliances is available out-of-the-box, without requiring tuning, indexing, aggregations, etc. IBM offers your company fast time to value for important BI and analytic initiatives, which will have a positive impact on your bottom line. With IBM on board, your organization is armed with more accurate intelligence to react quickly and accurately to any opportunities or threats the market may present. At a time when companies need to be as agile as possible to react to changing market conditions and growing analytic demands, an uncomplicated, easy-to-install system that runs blisteringly fast and analyzes peta-scale data makes a lot of sense.

How is this possible?

Patented streaming architecture
IBM Netezza 1000 adheres to IBMs basic principle of moving processing close to the data. Each IBM Netezza 1000 appliance contains multiple Snippet Blades or S-Blades, where SQL query code segments (or snippets) and complex analytic processes are executed. The S-Blades are intelligent processing nodes that make up the massively parallel processing engine of the appliance. Each S-Blade is an independent server that contains powerful multi-core Intel CPUs, IBM Netezzas unique multi-engine FPGAs and gigabytes of RAM all balanced and working concurrently to deliver peak performance.

IBM Software Information Management

Data Sheet

IBM Netezza 1000 Data Warehouse Appliance

DISK ENCLOSURES
Slice of User Data Swap and Mirror Partitions High-Speed Data Streaming

IBM Netezza 1000 uses Field Programmable Gate Arrays (or FPGAs) which have been programmed specifically to handle large volumes of data very efficiently. These FPGAs filter out extraneous data as fast as it streams off the disk. This removes I/O bottlenecks and frees up downstream components such as the CPU, memory and network from processing unnecessary data, creating a significant turbocharger effect on system performance.

SMP HOSTS
SQL, Query Plan, Optimize, Admin

SNIPPET BLADES

(S-BLADES)

Processor & Streaming DB logic High-performance database engine, complex analytic processing, streaming joins, aggregations, sorts, etc...

Analytic complexity is performed in powerful multicore CPUs, where database primitives and complex analytics are executed on the filtered data stream. Analytic tasks are run as independent processes operating on data streams on each S-Blade. The IBM Netezza Analytics platform harnesses the power of all the computational cores in the appliance to offer significant performance and scalability for advanced analytics,while presenting an abstracted view to simplify their deployment.

IBM Software Information Management

Data Sheet

IBM Netezza data warehouse appliance specifications IBM Netezza 1000 IBM Netezza 1000-3
1 3 24 8 2,820 9,600 453.6 202 101.6 64.8 200-240VAC 50/60Hz, Single Phase 16 A

Single Rack Systems

Multiple Rack Systems

IBM Netezza 1000-6

1 6 48 16 3,960 13,500 589.7 202 101.6 64.8 200-240VAC 50/60Hz, Single Phase 24 A 1 12 96 32

IBM Netezza 1000-12

2 24 192 64 7,400 25,500 907.2 202 101.6 64.8

2 Racks

3+ Racks

Racks S-Blades CPU Cores User Data in TB (Uncompressed) Power/Rack (Watts maximum/rack) Cooling/Rack - BTU/Hour Weight/rack kg Height/rack cm Depth/rack cm Width/rack cm Power

3-10 # Racks x 12 # Racks x 96 # Racks x 32 7,000 24,000 907.2 202 101.6 64.8 200-240VAC 50/60Hz, Single Phase 48 A 200-240VAC 50Hz, 3-Phase WYE 24A 200-240VAC 60Hz, 3-Phase Delta 32A 2

7,635 26,100 907.2 202 101.6 64.8

200-240VAC 50/60Hz, 200-240VAC 50/60Hz, Single Phase 48 A Single Phase 48 A 200-240VAC 50Hz, 3-Phase WYE 24A 200-240VAC 60Hz, 3-Phase Delta 32A 200-240VAC 50Hz, 3-Phase WYE 24A 200-240VAC 60Hz, 3-Phase Delta 32A 2

Drops/Rack Safety Emissions

2 UL/CSA/EN60950

FCC Part 15, ICES-003, AUS/NZ C-Tick, VCCI and EN55022 Class A; European Immunity: EN55024

Additional IBM models include: IBM Netezza 1000-18, IBM Netezza 1000-24, IBM Netezza 1000-36, IBM Netezza 1000-48, IBM Netezza 1000-72, IBM Netezza 1000-96, IBM Netezza 1000-120. The model number indicates the number of S-Blades in the appliance.

Software
Operating System: Red Hat Linux Advanced Server 5.3 Supported APIs: SQL, OLE DB, ODBC 3.5, JDBC V 3.0 Type 4 SQL Standards: SQL-92 compliant, with SQL-99 extensions Programming Languages: Java, Python, R, Fortran and C/C++ IBM Netezza Analytics: In-Database Analytics, R, Matrix, Hadoop Spatial , High-Speed Load/Unload: Interoperable with ETL and EAI tools at rates higher than 3 TB/hour Backup & Restore: Interoperable with IBM Tivoli, EMC Legato and Veritas, at rates higher than 4 TB/hour Database Portability: From IBM DB2, Informix, Microsoft SQL Server, MySQL, Oracle, Red Brick, Sybase IQ, Teradata Additional Tools: Windows and web-based DB Admin GUI; CLI and highspeed loading/unloading for AIX, HP-UX, Linux, Solaris and Windows

The IBM solutions portfolio for the IBM Netezza family of data warehouse appliances is supported by a wide range of marketleading business partners including: complementary technology partners, resellers, systems integrators, and service providers. Some of our strategic partners include SAP Business Objects, SAS Institute, MicroStrategy, and NEC. For a complete list or to find out if a particular company or solution is part of our program, please visit www.netezza.com/partner.

About IBM Netezza

IBM Netezza pioneered the data warehouse appliance space by integrating database, server and storage into a single, easy to manage appliance that requires minimal set-up and ongoing administration while producing faster and more consistent analytic performance. The newest data warehouse appliance, the IBM Netezza 1000, simplifies business analytics dramatically by consolidating all analytic activity in the appliance, right where the data resides, for blisteringly fast performance. Visit netezza.com or thinking.netezza.com to see how our data warehouse appliance eliminates complexity at every step and allows you to drive true business value for your organization.

About IBM Data Warehousing and Analytics Solutions

IBM provides the broadest and most comprehensive portfolio of data warehousing, information management and business analytic software, hardware and solutions to help customers maximize the value of their information assets and discover new insights to make better and faster decisions and optimize their business outcomes.

For more information

To learn more about the IBM Data Warehousing and Analytics Solutions, please contact your IBM sales representative or visit http://www.ibm.com/software/data/netezza/

Copyright IBM Corporation 2011 IBM Corporation Software Group Route 100 Somers, NY 10589 U.S.A. Produced in the United States of America May 2011 All Rights Reserved IBM, the IBM logo, ibm.com and Netezza are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol ( or ), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at Copyright and trademark information at ibm.com/legal/ copytrade.shtml Microsoft and SQL Server are trademarks of Microsoft Corporation in the United States, other countries or both. Other company, product and service names may be trademarks or service marks of others. Please Recycle

IMD14378-USEN-00