The IBM Puredata System for Analytics appliances are build to store and process large amounts of data efficiently in a massively parallel processing architecture. An appliance can store many TB of compressed data and distributes the work over many CPU cores....

Usually, for moving data into a Data Warehouse system like Netezza, there is an extract, transform and loading phase involved commonly referred to as ETL. Extraction is extracting data from various transactional sources, transformation involves operations like...

(This blog is posted on behalf of Leslie Wiggins , Product Marketing Manager at IBM. This blog was originally published on LinkedIn and is being re-posted here to ensure wider access.) On Friday, February 21, 2014, IBM expanded its data integration and...

I recently did a Virtual Enzee presentation and listed the Top Ten requirements for scalable bulk data processing inside a Netezza machine. I'll come back periodically and elaborate on them 1. Platforms easily scale for increasing stress We...

As with all analysis of implementations, please accept the following as a composite commentary (much like the Case Studies in Netezza Transformation). The names have been changed largely to protect the guilty. The innocent have already been punished. So...

I have noted in prior posts several of the "banes" of in-the-box data processing, not the least of which is harnessing the mechanics and nuances of the SQL statement itself. After all, the engine of in-the-box is a series of insert/select SQL...

BigInsights v1.3 released in Nov adds support for data exchange with Informix. http://publib.boulder.ibm.com/infocenter/bigins/v1r3/index.jsp?topic=%2Fcom.ibm.swg.im.infosphere.biginsights.doc%2Fdoc%2Fwhatsnew.html This is done via JDBC module: ...

For a brief history of why ELT (that is, in-box-data-processing) is even a topic of discussion, we must recognize that the high-powered appliances such as Netezza have not only made such implementation viable, but even desirable. Just so we level-set on what...

When processing in bulk, leading us to scale (that is, tens of billions of rows) we can trust Netezza to pull this off rather handily. With hardware and architecture in the bag for us, is there anything we can do wrong, or perhaps inefficiently, that would...

Since XML has become so pervasive in enterprise computing and service-oriented architectures, it is a given that XML capabilities are required in all parts of an IT environment. Closely related to the area of databases is ETL - to extract, transform, and...