The most valuable features of this solution are robustness and support.

Currently, we are using Netezza to the utmost. We first used it for our data warehouse. Then we moved on to doing analytics. Also, we are now doing some packages on it. Currently we are using it for multiple purposes, but, mostly it's used for reporting.

It is a back end for our SSIS, MicroStrategy,, Tableau. All of these are connecting to get the data. To do so we are also using our analytics which is built on the data.

ARULES() function is the fastest implementation of the associations algorithm (a priori or tree) I have worked with. In comparison with the R associations package, it is +1000x faster. The issue with the R implementation, and R in general, is that the functions do not work on large sets of data. R would generate a 100,000 x 100,000 element matrix for some of the arules runs we do – very, very inefficient programming.

The appliance is quite quiet.

The need for administration involvement is quite limited on the solution.

• Its ability to process and query large amounts of structured data.
• Low administrative support in terms of query optimization and indexing support. Indexing and data partitioning is built into the firmware.
• Data compression. It was relatively impressive. I think at some point we were getting 4:1 compression if not more.

Its query performance and speed.

The most valuable feature is the performance.

There is less administrative work and you won't need more than one or two administrators.

Upgrading is very good, the IBM support is very good, migration, and the migration commands are also very good and easy.

We're using several databases, about 1000, and we create lots of queries and run them from different places and from different processes. Both for the processing database and analytic database, we're using queries. It's easy to upload and download the data using the cloud or mobile storage architecture on our site. The solution offers very good management.

For me, as an end-user, everything that I do on the solution is simple, clear, and understandable.

The performance level the solution offers is very good.

The Java encoded integrators are good.

• Speed
• storage
• RAM

all of which contribute to large capacity.

There is minimal on-going maintenance.

The performance of the solution is its most valuable feature. The solution is easy to administer as well. It's very user-friendly. On the technical side, the architecture is simple to understand and you don't need too many administrators to handle the solution.