article thumbnail

Best Practices for Technical Columns in Database Design

Towards Data Science

When architecting a transactional database or a data warehouse, it’s important not to forget about various types of technical columns… Continue reading on Towards Data Science »

article thumbnail

Unapologetically Technical Episode 17 – Semih Salihoglu

Jesse Anderson

Semih is a researcher and entrepreneur with a background in distributed systems and databases. He then pursued his doctoral studies at Stanford University, delving into the complexities of database systems. Dont forget to subscribe to my YouTube channel to get the latest on Unapologetically Technical!

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Find Out About The Technology Behind The Latest PFAD In Analytical Database Development

Data Engineering Podcast

Summary Building a database engine requires a substantial amount of engineering effort and time investment. In this episode he explains how he used the combination of Apache Arrow, Flight, Datafusion, and Parquet to lay the foundation of the newest version of his time-series database.

Database 162
article thumbnail

Database Refactoring Patterns with Pramod Sadalage - Episode 22

Data Engineering Podcast

Summary As software lifecycles move faster, the database needs to be able to keep up. You first co-authored Refactoring Databases in 2006. What was the state of software and database system development at the time and why did you find it necessary to write a book on this subject?

Database 100
article thumbnail

SQL vs NoSQL: 7 Key Takeaways

KDnuggets

Instead, it’s a different type of database designed for use-cases where SQL is not ideal. The differences between the two are many, although some are so crucial that they define both databases at their cores. People assume that NoSQL is a counterpart to SQL.

NoSQL 160
article thumbnail

Classwords?—?My Favorite Convention for Naming Database Columns

Towards Data Science

With over two decades in Data Engineering, I’ve uncovered a secret to clear and consistent database columns: classwords. This favorite… Continue reading on Towards Data Science »

article thumbnail

Exploring The Nuances Of Building An Intential Data Culture

Data Engineering Podcast

austin) Podcast Episode Data Community Fund DataHub Podcast Episode Database Design For Mere Mortals by Michael J. austin) Podcast Episode Data Community Fund DataHub Podcast Episode Database Design For Mere Mortals by Michael J.

Building 147