I'm working for a retail client. We have a lot of reports, which are for store managers. The store managers used to get all the reports using the SSIS package, which was built upon our back end and they would have a lot of performance issues. When I say performance issues, in the morning when there are almost 2,000 users trying to connect to the same report, there were a lot of problems because it was a relational database. People were trying to get information out of it and it would break the flow, actually bottleneck the flow. That's why they were getting the impact.

What we did is, we did a PoC and found this client is well built. Because of that, we were able to create a separate layer for reporting. There was a simple requirement for the DBA, where we don't need to build an index or anything like that. Those reports were improved from a couple of hours to minutes. That was the biggest benefit we've had from this appliance.

For me, mainly, it reduces my costs. It's not only the appliance cost. There are also support costs and a maintenance costs. It does reduce the costs very drastically.

Any in db machine, learning functions help by eliminating the data transport issue. NZA goes one better by allowing you to utilize a tuned engine (software + hardware) to run the functions. The result is that we can run algorithms that would be impossible to run on other platforms.

I can't because we're using it in a fashion such that a traditional RDMS could have been used in place of it. Our data was relatively small so we didn't see a huge benefit in transitioning new subject areas into production.

Earlier there was high latency to query extraction but Netezza has improved the speed for all OLAP operations. This has helped the organization to get the business answers right on time.

Faster data processing compared to commodity servers.

There were some reports we couldn't get because of performance, but with Netezza we could get more of them.