Michael Kaminsky

Demystifying the transactional database

Demystifying the transactional database

Transactional databases are essential to many apps and software. Learn more about them and their benefits with Fivetran.

Data warehouse modeling: Star schema vs. OBT

Data warehouse modeling: Star schema vs. OBT

Which data warehouse schema offers better performance? Let’s find out.

Slowly changing dimensions in data science

Slowly changing dimensions in data science

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

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 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.

No items found.

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.