Database Design

Who designed this database?

Towards Data Science

A well designed database and up to date documentation is the ideal, but if that is not the case and you are not in the position to improve the database design, what are some workarounds? You’re…

Designing Database Storage and Retrieval

Towards Data Science

Database is an integral part of any application design where processes store and manage data. Although, one may never need to design a database from scratch but understanding its design and how…

Database Design Considerations — Questions answered

Analytics Vidhya

Database design can be a tricky and laborious project and is often associated with stringent timelines. Below are some questions that you need to have answered before starting a database design…

8 Practical Guidelines for Designing Databases That Don’t Land You in Hot Water

Towards Data Science

Designing databases presents a conundrum: How are you supposed to design a database when you’ve never designed something similar? Like, how are you supposed to know what works and what doesn’t when…

Good Database Design Starts Here

Towards Data Science

Rules to follow when you start a new database project: usage, model selection, process and testing.

SQL Database Design Basics with Example

Towards Data Science

It is a common practice that a DB architect has to design a relational database tailored to a particular solution. One Friday evening, I was coming home from work on a commuter train, and I was…

Building Your First Data Pipeline: Smart Database Design for Clean, Usable Data (Part 2/4)

Level Up Coding

Bad database design doesn’t just make queries ugly or inefficient. It can derail entire pipelines. You might see tables that don’t connect, messy relationships, or fields crammed into the wrong place....

Best Database design tools for Forward and Reverse Engineering

Towards Data Science

The first and foremost thing that a database design software must ensure are forward and reverse engineering. One way to achieve it is visual design. It generates code when changes are introduced…

Tips for Good Database Design and Concurrent Requests

ArjanCodes

In this short, I’ll give you tips on how to design a SQL database schema better to avoid blocking by concurrent processes, which write update requests frequently. 🚀 Next-Level Python Skillshare Class...

Designing your database schema — best practices

Towards Data Science

Good database schema design is essential for any company leveraging relational database management systems. If time isn't spent designing a logical and intuitive database schema now, it will be spent…...

Database Indexing Anti-Patterns

Towards Data Science

Index design is one of the most important things you do when working with a database. Effective index design can have dramatic effects on database performance. Well-designed indexes can make your…

Deep into partitioning in databases

Towards Data Science

Database is an integral part of any application design where processes write and manage the data. Although, one may never need to design a database from scratch, understanding its design and how…