Anchor Modelling: Sixth Normal Form Databases!

on YouTube ↗01h 07m

" summary

Anchor Modelling implements sixth normal form to store each attribute as its own table while emitting idempotent SQL scripts and 3NF views so applications keep familiar queries. The system ships a GUI plus a JavaScript tool that converts XML models into deployable SQL, fits into CI/CD, and supports three concepts of time (event, recorded, evaluated) with optional reliability flags and full version history. It is cross‑platform (SQL Server, Postgres, Oracle, MySQL), enables additive, no‑downtime schema changes, but requires CLR for its checksum optimizations.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 24:19Key features
3. 38:09Use 3NF interfaces
4. 44:19Change schema

" related talks

• 36mNormalisation: Friend Or FoeBeth Tucker Long · PHP UK Conference 2014
• 18mGermany's Next Top Data ModelIan Plosker · Berlin Buzzwords 2012
• 39mDatabase Design for BeginnersDavid Copeland · RailsConf 2019
• 27mMaking Relational Cool Again (or: JavaScript on ACID)Tim Griesser · JSConf US 2015
• 26mNoSQL Data Modeling for Front-end DevelopersStanimira Vlaeva · EnterpriseNG 2021
• 01h 02mDesign Good Schemas - Get a Better DatabaseNuri Halperin · NDC Oslo 2023
• 42mNORM_GEN: an alternative to ORMHenrietta Dombrovskaya, Boris Novikov · PGConf NYC 2022
• 20mDomain Driven Design & NoSQLLucas Dohmen · Red Dot Ruby Conference 2014