Covering Data Science, Business Intelligence, Technology Industry News Updates and Trends
This tutorial will cover how to install PostGIS on Ubuntu 18.04 Linux for Greenplum 6 clustered setup. PostGIS is an open source PostgreSQL database extension for creating Geographic objects on…
Windows functions are an important tool for data analysis. In this tutorial, we go through windows functions in SQL and provide examples for their use in Greenplum.
Introduction Greenplum follows a master/slave architecture, where data is distributed on segment nodes. Master node is responsible for executing user queries on segment nodes, and getting the results back to…
This tutorial provides, hands on coding examples covering database programming for Greenplum/PostgreSQL using SQLAlChemy library.
This tutorial shares basic database programming code for PostgreSQL and Greenplum using Python and psycopg2 library.
Not many data scientists realize that it is possible and much more beneficial to build data science models directly on top of a data warehouse. Apache MADlib is an open-source…
Greenplum getting started tutorial, covering basic commands to start/stop the database, creating schema, and tables.
Greenplum Architecture The main reason behind adaptation of massively parallel processing(MPP), data warehouse(DWH) solution is MPP architectural principles. These principles aim at removing main drawbacks of traditional DWH, and make…
Understanding Greenplum architecture and use cases for various big data and data science scenarios for business and industry.
Here are top ten reasons for choosing Greenplum for building your data science and business intelligence solution :- It is Open-Source, and completely free. Now considering licensing cost of proprietary…