Netezza

How Netezza Update Records in Tables?

Netezza update records operation is costlier. IBM Netezza does not perform updates, but rather does deletes the records and inserts updated values. When you run nzsql command to update record, Netezza marks the record being updated as logically deleted by setting current transaction value to the deletexid field, but does not delete it. This ensures that the database system adheres to the ACID properties of RDBMS SQL standards. How Netezza Update Records in Tables? Each record in Netezza contains two slots, one for createxid another for deletexid. Deletexid allows you…

Comments Off on How Netezza Update Records in Tables?
October 5, 2016
Netezza

Netezza Encrypt Password with nzpassword Command Utility

Database user accounts must be authenticated during access requests to the IBM Netezza database. You can secure the password by using Netezza encrypt password facility. Local authentication requires a password for every account which connects to the Netezza server. You must enter the clear text password, when you use Netezza CLI commands. You can set the environment variable NZ_PASSWORD to avoid the type of password every time but this variable also stores the clear text password. Read: Commonly used Netezza Utility Netezza Best Practices to Improve Performance Netezza nzsql Commands and…

Comments Off on Netezza Encrypt Password with nzpassword Command Utility
October 4, 2016
Netezza

Netezza Fixed-Width File Loading and Examples

Fixed width text files are special cases of text files where the format is specified by column widths, pad character and left or right alignment. In this format column width are in terms of units of characters. In this post we will learn about Netezza Fixed-Width file loading. Fixed-Width File Overview All data is a series of byte-sequences and has an associated data type, used here as a conceptual or abstract attribute of the data. Fixed-length format files use ordinal positions, which are offsets to identify where fields are within…

Comments Off on Netezza Fixed-Width File Loading and Examples
October 3, 2016
Netezza

Netezza Best Practices to Improve Performance

Today there is a increased demand in advanced analytics on big data. Netezza is designed with built in functionalities to perform advanced analytics on really big data sets. To improve the performance, you should follow some Netezza best practices. Best practice should not mean hundreds of rules and regulations to follow. Recommended that basic principles are followed on following features of Netezza: Distribution Data types Statistics Zone maps Clustered base tables Groom table command Netezza Best Practices on Distributions In a Netezza data warehouse appliance good distribution is fundamental element…

Comments Off on Netezza Best Practices to Improve Performance
October 2, 2016
General

IBM Bluemix Speech TO Text Transcription in Python – Tutorial

Speech recognition and sentimental analysis are very important part of machine learning. In this tutorial, we will learn IBM Bluemix Speech to Text Transcription file in Python and copy those files to Hadoop ecosystem for further analysis. Once you have data in HDFS format you can torture the data to get the desired results. In this post will walk you through creating speech to text transcription file using IBM Bluemix and copy that file to Hadoop HDFS. IBM Bluemix Speech to Text Transcription in Python - Steps Below are the…

2 Comments
October 1, 2016
Netezza

Netezza Cross Database Access and its Restrictions

Netezza cross database access does allows you to execute the objects such as tables, view, synonyms that are available on the same Netezza server. You can can INSERT, UPDATE or DELETE data from current database by referring objects in other database on same server. For example, TRAINING1.ADMIN(ADMIN)=>SELECT * FROM TRAINING1..TEST1; Read: Access Netezza Database, Tools and Examples Netezza nzsql Command and its Usage Netezza Synonym Best Practices and Examples Referencing Database Object from other Database To access objects in other databases on the same Netezza system, you must use three-level…

Comments Off on Netezza Cross Database Access and its Restrictions
September 28, 2016
BigData

Migrating Netezza to Impala SQL Best Practices

Now a days everybody wants to migrate to Hadoop environment for their analytics that includes real-time or near real-time. In this post i will explain some best practices in Migrating Netezza to Impala SQL. Impala uses the standard SQL but still you might need to modify the source SQL when bringing specific application to Hadoop Impala due to variations in data types, built-in function and obviously Hadoop specific syntax. Even if the SQL is working correctly in Impala, you might consider rewriting it to improve performance. Read: Netezza Hadoop Connector…

2 Comments
September 24, 2016
Netezza

Netezza Advanced Date Functions and Examples

Netezza Advanced Date Functions are available in Netezza SQL extensions tool kit. You have to download it from IBM fix central and install it in required database. You cannot access these functions otherwise. Read: how to download and Install Netezza SQL extensions toolkit These advanced functions are different than standard Netezza data time functions. You can read about the standard Netezza date functions from below post: Netezza Data Functions and Examples You may want to read: nzsql command and its Usage Netezza Analytics Functions and Examples IBM Netezza Conversion Functions…

Comments Off on Netezza Advanced Date Functions and Examples
September 24, 2016
Netezza

Netezza Interval Data Types and Conversion Examples

Netezza interval data types are supported in different way. Netezza accepts the interval syntax, but ignores the unit specification. All intervals are the same, and can contain values of any combination of units. Netezza server internally normalizes all intervals to units of seconds. It considers a month to be 30 days for the purposes of interval comparisons and this approximation may lead to inaccuracy. Netezza Interval Data Types Implementation IBM Netezza implements the INTERVAL data type in a different way compared to other databases. Netezza allows you to specify interval…

Comments Off on Netezza Interval Data Types and Conversion Examples
September 23, 2016
Netezza

Netezza Internal DataTypes: rowid, createxid, deletexid and datasliceid

Netezza supports internal datatypes that are used by system to perform internal tasks on the table records. Netezza internal datatypes includes: rowid, transaction ID (createxid, deletexid), and dataslice. Shows Netezza internal Datatypes: Internal Datatype Column Name rowid rowid transaction ID Createxid deletexid dataslice datasliceid Netezza Internal DataTypes: Rowid Identifies a specific and unique record in the database. These row numbers are not necessarily sequential within a table. Usually, the initial rowid value is 100,000. The Netezza host assigns a range of sequential rowids to each SPU in the system. When…

Comments Off on Netezza Internal DataTypes: rowid, createxid, deletexid and datasliceid
September 23, 2016