Database Design for Custom Fields
The ability to allow custom fields to be added to a database is a common requirement. This could be something the user wants to add when using an application, or for defining reports, or something else.
There are many different ways of allowing custom fields in your database design. There is no one right solution though, as it depends on your requirements, amount of data, and the application.
In this video, I'll share 8 different solutions that can achieve this requirement. Each of them has a sample diagram to help visualise it, and a list of the advantages and disadvantages.
The solutions are (with timestamp links):
1:52 - EAV (Entity Attribute Value)
5:17 - Modified EAV
8:06 - Single Table
10:34 - Class Table Inheritance
12:21 - Concrete Table Inheritance
13:36 - Normalised Tables
15:09 - JSON
16:34 - Dynamic Schema
Hope you enjoy the video and find it useful!
Видео Database Design for Custom Fields канала Database Star
There are many different ways of allowing custom fields in your database design. There is no one right solution though, as it depends on your requirements, amount of data, and the application.
In this video, I'll share 8 different solutions that can achieve this requirement. Each of them has a sample diagram to help visualise it, and a list of the advantages and disadvantages.
The solutions are (with timestamp links):
1:52 - EAV (Entity Attribute Value)
5:17 - Modified EAV
8:06 - Single Table
10:34 - Class Table Inheritance
12:21 - Concrete Table Inheritance
13:36 - Normalised Tables
15:09 - JSON
16:34 - Dynamic Schema
Hope you enjoy the video and find it useful!
Видео Database Design for Custom Fields канала Database Star
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to Correctly Define Many-To-Many Relationships in Database DesignLaravel DB Custom Fields with EAV-Model: Worth It?EAV Zero to EAV Hero!5 Tips for System Design InterviewsSaaS Deep Dive: Designing and Building Multi-Tenant Solutions • Tod Golding • GOTO 2020Django multi tenant tutorial using subdomains - basic implementationHow to Fake a Database Design - Curtis Poe (Ovid)Column inheritance: Postgresql PSQL Full Course Teachmedatabase #psql #database #inheritanceSchema Design Anti-Patterns - Part 1UBER System design | OLA system design | uber architecture | amazon interview questionLogical Database Design and E-R DiagramsHow To Quickly Debug AWS Lambda - VS Code & Serverless FrameworkDatabase Design 29 - Foreign Key ConstraintsData in MicroservicesLaravel JSON DB Columns: Worth Using Them?SQL vs NoSQL ExplainedGraph Databases Will Change Your Freakin' Life (Best Intro Into Graph Databases)Microsoft Access 2016 Tutorial: Linking the Tables and Defining the RelationshipsHow to Design Your First DatabaseLearning MySQL - JSON in MySQL