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

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

Data Model Design 101: Composite vs Surrogate Keys

Towards Data Science

When to know which type of key to use in your data models Continue reading on Towards Data Science »

article thumbnail

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

Data Engineering Podcast

Your host is Tobias Macey and today I'm interviewing Paul Dix about his investment in the Apache Arrow ecosystem and how it led him to create the latest PFAD in database design Interview Introduction How did you get involved in the area of data management? This was the core of your recent re-write of the InfluxDB engine.

Database 162
article thumbnail

Database Refactoring Patterns with Pramod Sadalage - Episode 22

Data Engineering Podcast

You first co-authored Refactoring Databases in 2006. How does the practice of refactoring in the context of a database compare to that of software? How has the prevalence of data abstractions such as ORMs or ODMs impacted the practice of schema design and evolution? You first co-authored Refactoring Databases in 2006.

Database 100
article thumbnail

Top 10 Data Science Websites to learn More

Knowledge Hut

Learning inferential statistics website: wallstreetmojo.com, kdnuggets.com Learning Hypothesis testing website: stattrek.com Start learning database design and SQL. A database is a structured data collection that is stored and accessed electronically. Considering this information database model is fitted with data.

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