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…
In this article, we discuss key concepts of hadoop and answer various common questions related to hadoop.
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.
Solving data science problems requires systematic thinking and approach, here's some of the key concepts and steps that you need to apply when trying to solve data science problems.
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…