Full working example of connecting Netezza from Java and python

Before start connecting you must make sure you can access the Netezza database and table from the machine where you are trying to run Java and or Python samples. Connecting Netezza server from Python Sample Check out my Ipython Jupyter Notebook with Python Sample Step 1: Importing python jaydebeapi library import jaydebeapi Step 2: Setting Database […]

Continue reading


Oracle Differentiates its MySQL Cloud Service

MySQL is available as a service on every major public cloud. Here’s how Oracle MySQL Cloud Service is different. You’ll find MySQL available as a service on every major public cloud (and plenty of minor ones). So what’s different about the Oracle MySQL Cloud Service, introduced on Oracle Cloud last fall by the owner and […]

Continue reading


PostGIS Error: Operation on mixed geometries

PostGIS usually raises “operations on mixed geometries” while trying to use topological functions (such as st_intersects, st_within, etc). There can be many different reasons because of which one might encounter this error. Below are the steps that I found useful in resolving this error. 1. Validate Geometries: Make sure all the geometries are valid. psql> […]

Continue reading


“Size does matter” – using cursor to sequentially process large database

Recently, I started working on a new project which uses postgres database and contains more than 3 million addresses. One of my first task was to geocode address. To do so, I wanted to sequentially access all the records ordered by address. As I never dealt with such a large database before, my first attempt was a […]

Continue reading


Dummy’s guide for converting character set of a web application

When developing a web application, one has to be careful about the “character encoding”. There are many options such as latin1, utf8, etc, and the best character encoding depends on the language that your targeted audience use for writing. Since most  web applications are required to handle all types of languages and, thus, are required to handle all different types […]

Continue reading


An identifying relationship

An identifying relationship “describes a situation in which the existence of a row in the child table depends on a row in the parent table.” “if a child identifies its parent, it is an identifying relationship.” The technical definition of an identifying relationship is that a child’s foreign key is part of its primary key. […]

Continue reading


Oracle Open World 2015: Three Important Cloud Services

Oracle Open World 2015 announcements included three data-related standouts: Oracle Cloud Platform For Big Data, Oracle Data Visualization Cloud Service, and Oracle Data Cloud. Here’s a deeper dive on what stands out. Our cloud is integrated, it’s ready, and it’s bigger than and superior to any rival cloud. That was the big-picture message Oracle offered […]

Continue reading


AWS re:Invent: Five Takeaways On New Services

Amazon challenges ‘old-guard’ IBM, Microsoft and Oracle with QuickSight, Kinesis Firehose, Snowball, and new database services. Here’s a quick rundown with cautions for would-be adopters. Make no mistake: Amazon Web Services (AWS) is doing everything it can to make it easy for enterprises large and small to bring all, or at least part, of their data […]

Continue reading


Couchbase Intros 4.0 Release, Highlights Enterprise Wins

Couchbase Live New York event puts new features, NoSQL adoption in the spotlight. Watch for basics and the best fit for NoSQL in the enterprise. This week’s Couchbase Live New York marked the general availability of Couchbase Server 4.0 and a coming out party of sorts for enterprise customers including Marriott, GE, Cox Automotive and […]

Continue reading