Blog

Data Warehouse Engineering and Technology

machine learning

Introduction to Machine Learning with Tensorflow and Deepgreen Transducer

by Eric Lam

Today, we will show you how to build machine learning models with tensorflow and transducer.

Deepgreen Transducer is the scripting relational database engine that is tightly integrated with relation engine, including query optimizer, query executor and can be executed in parallel with other query operators. With transducer, we can efficiently execute queries that are very difficult to express in SQL. See Scripting Relational Database Engine Using Transducer.

Read more...

greenplum

Catalog Corruption in Greenplum DB

by CK Tan

Recently one of our clients experienced catalog corruption in Greenplum DB after a power outage.

Read more...

postgres sql

Comparing Tables in Postgres

by CK Tan

How to tell if two tables are exactly the same?

Read more...

data warehouse

Date Dimension Table in Postgres

by CK Tan

One of the first dimension tables required for any Data Warehouse project is the Date Dimension table. See Calendar Date Dimensions @kimballgroup.

Read more...