IBM Netezza Performance Server Valuable Features
IBM Netezza Performance Server is a cost-effective solution.
View full review »AT
Reviewer232198
Database Admin. Manager at a financial services firm with 1,001-5,000 employees
- 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.
Buyer's Guide
Data Warehouse
April 2024
Find out what your peers are saying about IBM, Oracle, Snowflake Computing and others in Data Warehouse. Updated: April 2024.
767,496 professionals have used our research since 2012.
GD
business650640
data governance manager at a computer software company with 1,001-5,000 employees
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.
View full review »SL
reviewer1925472
ASE at a retailer with 10,001+ employees
The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance.
View full review »A
Kumar V
Director at Priority Consulting Services
Row-secure tables, IBM Fluid Query, and others.
View full review »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.
View full review »LS
Leonardo Salvino
Business Intelligence Consultant at a tech services company with 51-200 employees
- 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
AS
Ariovaldo Santos
Senior Solution Architect at a tech vendor with 1,001-5,000 employees
It is extremely easy to use. The platform is very efficient and robust as well.
FP
solution306072
Business Unit technical Lead at a tech services company with 1,001-5,000 employees
- 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
KS
Kapil Sharma
Technical Lead at a financial services firm with 51-200 employees
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.
View full review »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.
View full review »SD
Santosh K Dash
Solution Lead at a tech company with 10,001+ employees
- 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.
View full review »- 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.
View full review »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.
View full review »- 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.
View full review »- 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.
View full review »The speed.
View full review »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).
View full review »Distribution (no index or partition), built-in analytics is a major advantange.
View full review »- Performance
- Simplicity
- Few things to worry about
Personally, I like the Compression and Partitioning features.
View full review »Distribution concurrency control.
View full review »- Performance
- Not complex to administer
Buyer's Guide
Data Warehouse
April 2024
Find out what your peers are saying about IBM, Oracle, Snowflake Computing and others in Data Warehouse. Updated: April 2024.
767,496 professionals have used our research since 2012.