IBM Netezza Performance Server is a cost-effective solution.

• It is hands-off when everything works well. 
• We are able to execute very complex queries.
• It has good performance.

• Elimination of space management with less time spent on capacity planning
• Push down optimization through the use of FPGA to limit data at the storage layer
• The concept of an appliance where everything is pre-built (storage, hardware, database and OS) and the support for each of these components is through one vendor.

High performance RDBMS appliance optimized for data warehousing and enterprise reporting. Very simple to manage huge volumes of data without having to worry about indexing and partitioning. Automated compression of tables without any custom scripting or manual intervention. Achieved almost 3x compression effortlessly which meant that 12 TB of data compressed into around 4 TB.

The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance.

Row-secure tables, IBM Fluid Query, and others.

Netezza partitions all database objects across all available SPU’s. With traditional RDBMS systems, partitioning database objects requires a lot of planning and configuration. Netezza, only requires to develop a partitioning scheme. This eliminates several steps in the process, vastly simplifies performance tuning leading to very high performance.

As the system is preconfigured, the site level configuration required is minimal. Eliminates the need for a separate SAN.

• Distributed querying
• Seamless concurrency
• Fast loading
• High velocity analytics

It can run heavy CPU queries really fast, and this is valuable.

• Easy Deployment
• No Indexes
• Extremely fast to respond queries with high amount of data
• Data distribution based on hashtable concept
• Zonemap
• Easy to migrate data

It is extremely easy to use. The platform is very efficient and robust as well.

• The ability to load data very quickly
• SQL is 100% ANSI compliant
• Queries run very fast and require no hints (Oracle)
• No space management
• Tuning SQL is generally pretty easy

Being an appliance, the best features are its analytics and the performance level.

The underlying hardware that IBM provides with this appliance is made for a specific purpose, to serve performance on a large amount of data, and to do analytics as well. It is faster, when you compare it to any other product, like Hadoop or DXC Hadoop or Presto on AWS. It's made for a specific purpose and it serves that very appropriately.

IBM PureSystems or NPS has a patented NDAC or Netezza data accelerator card inside each of the SPUs (Snippet Processing Arrays). The SPUs act as individual processors that share part of a query. This helps in high-speed parallel processing of big data volumes. Querying a large data volume takes just a few seconds to minutes, if it is done right.

• Zonemap features
• AMPP (SMP+MPP ) architecture
• High availability
• Field-Programmable Gate Arrays (FPGAs)

The performance is most important to me, and it helps our ability to make business decisions quickly.

• The speed of the MPP platform
• The ability to load large amounts of data in very short order
• The fact that the hardware and software are designed to work together and are supported in unison by IBM

• Lots of space
• Implicit compression
• High Availability with multiple redundancy

We use Aginity to access Netezza database. We really like the way we can dominate the physical distribution of the data hence know how to improve the performance of the query. Netezza on its own is very fast which makes our life easier to run huge queries for analytics.

With a field-programmable gate array, it has the capabilities to do arithmetic calculations at memory level. Also, the cost-based analysis of query by optimization, it makes query execution faster and provides enough scope to DBA to improve queries.

• Scalability
• User friendly
• Always innovative

• Supports both business intelligence and advanced analytics
• Efficient even if being used by thousands of users at the same time
• Streaming architecture based on blades
• Compatible with the most popular business intelligence and analytic tools
• Standard SQL, ODBC, JDBC, and OLE DB interfaces

The ability to support a lot of complex queries to analyze rather big data sets at the same time is a valuable feature for us.

• Ease of use
• Lack of performance problems for analytics and massive data systems
• Integration with Linux-based ETL and data streaming technologies
• Integration with distributed computing platforms

The most valuable feature would be the fact that it has been running for awhile in an appliance format. The appliance format may be the best part.

The speed.

Cross-database writing and more UDFs.

Netezza NPS 7.1 has added a feature of SET CATALOG

This also allows users to run GROOM, GENERATE STATISTICS etc. in the block as a single execution (auto commit).

Distribution (no index or partition), built-in analytics is a major advantange.

• Performance
• Simplicity
• Few things to worry about

Personally, I like the Compression and Partitioning features.

Distribution concurrency control.

1. Performance
2. Not complex to administer