Michael Kaminsky

Slowly Changing Dimensions in Data Science

Slowly Changing Dimensions in Data Science

Avoiding a common pitfall in data science by enabling history mode.

Star Schema vs. OBT for Data Warehouse Performance

Star Schema vs. OBT for Data Warehouse Performance

Michael Kaminsky of Gradient Metrics takes us through a benchmark comparison of data architectures.

The Modern Data Science Stack

The Modern Data Science Stack

Automated data integration can help you jump-start your machine learning efforts.

Databases Demystified Chapter 10 – Query Planning and Optimization

Databases Demystified Chapter 10 – Query Planning and Optimization

Take a look under the hood to learn how you can help databases execute queries more efficiently.

Databases Demystified Chapter 9 – Indexes

Databases Demystified Chapter 9 – Indexes

Indexes aren’t just for catalogs or textbooks. Learn how indexes make queries faster.

Databases Demystified Chapter 8 – Distributed Databases Part 3

Databases Demystified Chapter 8 – Distributed Databases Part 3

What is “consensus,” and what does it have to do with distributed databases?

Databases Demystified Chapter 7 – Distributed Databases Part 2

Databases Demystified Chapter 7 – Distributed Databases Part 2

Distributed databases are powerful, but they come with lots of complications.

Databases Demystified Chapter 6 – Distributed Databases Part 1

Databases Demystified Chapter 6 – Distributed Databases Part 1

What is the difference between distributed and single-node databases?

Databases Demystified Chapter 5 – Transactions Part 2

Databases Demystified Chapter 5 – Transactions Part 2

Learn about the relationship between isolation and concurrency.

Databases Demystified Chapter 4 – Transactions Part 1

Databases Demystified Chapter 4 – Transactions Part 1

Take a deep dive into transactional databases.

Databases Demystified Chapter 3 – Row Store vs. Column Store

Databases Demystified Chapter 3 – Row Store vs. Column Store

Take a closer look at the differences in architecture between row- and column-based databases

Databases Demystified Chapter 2 – Analytical vs. Transactional Databases

Databases Demystified Chapter 2 – Analytical vs. Transactional Databases

Learn about the differences between databases designed to perform day-to-day operations and those designed for analyzing data.

Databases Demystified Chapter 1 – Databases and SQL

Databases Demystified Chapter 1 – Databases and SQL

Learn about the history of databases, important terminology, and different types of databases you might encounter.

Start analyzing your data in minutes, not months

Launch any Fivetran connector instantly.