Netezza is an embedded and advanced analytics database. Netezza key features includes predict with more accuracy, deliver the predictions faster and respond rapidly to the any changes.
IBM Netezza Analytics advanced technology supports data warehousing and in-database analytics into a scalable, high-performance, massively parallel advanced analytic platform that is designed to work with petascale data volumes.
Below are the some of the Netezza Key features:
- Netezza bigdata appliance supports both, Business Intelligence and in-database advanced analytics.
- Lightning fast performance – scalable (10-100x) performance at petascale.
- Very Efficient even if being used by thousands of users at the same time. For now Netezza can supports connections to upto 2000 users
- Netezza’s streaming architecture based on FAST (FPGA Accelerated Streaming Technology)
- Simplified deployment for the scripts that are developed
- compatible with the most popular Business Intelligence and analytic tools such as informatica, datastage, Microsoft BI etc
- Netezza is based on PostgreSQL and support standard SQL, ODBC, JDBC, and OLE DB interfaces
- Netezza hosts are setup in high availability mode. Reliability and availability at 99,99% uptime level.
- It can process 2 TB of data per hour
- NPS supports high backup creating pace – over 4 TB of data per hour
Netezza Key Features – Other Specialties
- NPS is being used to process massive data. This tool comes with a specialized hardware (FPGA) powered with specialized software that manages the data such that, the data can be distributed between the snippet processing units/disks which allows in-house data processing.
- Netezza has separate CPU, disk storage and RAM for all its SPUs with a proprietary data filtering process using field-programmable gate arrays (FPGAs)
- To improve the loading performance, PK and FK constraints are not allowed. You can write procedures and functions if required.
Netezza is built for the analytics purpose, mainly supports OLAP model, as it can process millions of data in seconds and minutes.
Read:
- Netezza Architecture
- IBM Netezza Latest Version New Features
- Netezza Mako Features – Latest Netezza powered DWH Appliance