Featured
Learnings from Pursuing High Data Quality: A Reflective Piece
Cover Photo by Claudio Schwarz on Unsplash Before diving in, let us discuss what data quality...
Read More
The evolution of the Modern Data Stack: From RDBMS to the LakeHouse
This post aims to provide a historical picture of the evolution of the typical data stack over a span...
Read More
Data Compression, Types and Techniques in Big Data
Cover Photo by Tim Mossholder on Unsplash Introduction This article will discuss...
Read More
Custom Data Types in SQL
Cover Photo by Xavi Cabrera on Unsplash Before, we dive in, this post focuses on Oracle databases....
Read More
Understanding Database Indexes And Their Data Structures: Hashes, SS-Tables, LSM Trees And B-Trees
There's often a huge fuss about making data-driven decisions, leveraging data analytics, using data...
Read More
Functions in SQL
Functions are very similar to procedures in databases. In this article, I will try to break down...
Read More
Database Triggers in PostgreSQL: A Deep Dive using AWS RDS
Photo by Jr Korpa on Unsplash Database triggers are special types of objects. They look like...
Read More
How to write Database Procedures
What are Database Procedures Procedures are commonplace across several different...
Read More
Mastering Common Database Objects - Series 1 .. n
In the series, I hope to cover some common database objects such as procedures, functions, triggers...
Read More
Energy Forecasting with LSTM Neural Network
Several methods have been used in energy forecasting over the years. Methods from different...
Read More
What to think about when designing, building, managing and operating data systems.
This post draws extensively from a book I am currently reading and my experience managing data...
Read More