Tag Archives: analytics

Enabling Netezza Analytics for use in a database

Many of Netezza’s analytic functions require the presence of some metadata tables/views in order to work.  These tables/views are created when you initialize the analytic libraries in a particular database. SYSTEM(ADMIN)=> call nza..kmeans(‘intable=t1,id=int1,k=10,model=kmeans,outtable=out,maxiter=5’); ERROR:  The metadata tables are not initialized. … Continue reading

Posted in administration, analytics, General | Tagged , , , , , | Leave a comment

Dropping a Netezza Analytics model

The result of most of Netezza’s analytic functions are a series of tables.  The tables produced vary from function to function.  We schedule jobs to run the analytic functions and want to reuse the same model name so that our … Continue reading

Posted in administration, analytics, General | Tagged , , , | Leave a comment

Netezza in-database modeling with SPSS Modeler 14.2: K-Means 35x faster

Leveraging Netezza’s in-database analytic capabilities can significantly reduce the amount of time required to execute SPSS streams.  By pushing the analytics to the data, we eliminate the need to pull the data out of the table and onto our SPSS … Continue reading

Posted in analytics, General, Uncategorized | Tagged , , , | Leave a comment

Error 126 when connecting SPSS Modeler to Netezza using 64bit ODBC driver

I installed IBM SPSS Modeler 14.1 today and the first thing I wanted to do was to connect it to Netezza and compare performance: in-database analytics and without. It didn’t take long for me to run into my first issue … Continue reading

Posted in analytics, Uncategorized | Tagged , , , | Leave a comment

Assessing query performance … by table?

While looking for performance optimization opportunities, I decided to look at things from a slightly different perspective: by table.  I’m not entirely sure how helpful this will be – but since I wrote the query I figured I’d put it … Continue reading

Posted in administration, General, Performance | Tagged , , | 2 Comments

Linear Regression with IBM Netezza’s Analytics package

In the IBM Netezza Analytics suite exists a Linear Regression function that you can use (very easily) to identify intercept and slope between a dependent and any number of independent variables.  I’m no math nut, but the presentation of this … Continue reading

Posted in analytics, General | Tagged , | Leave a comment

Market Basket Analysis with IBM Netezza Analytics

PLEASE NOTE: This article is outdated and does not reflect changes made in IBM Netezza Analytics V2   IBM Netezza’s analytics package became available earlier this year.  The documentation on it is okay but I think they went a little … Continue reading

Posted in analytics | Tagged , , , | Leave a comment