JSON Data Modeling

on YouTube ↗48m

" summary

Explains concrete modeling choices for JSON with Couchbase: embed when an entity owns related data, refer when many-to-many or frequent writes, prefer consolidation until document size hits limits (mentions 20 MB document limit and Cosmos ~2 MB); use key-value for microsecond lookups and the subdocument API to update parts without transferring whole documents; SQL++ and built-in search (Blevy) enable joins and full-text queries; recommends cooperative re-versioning, tools like Hackolade/Erwin/jsoneditoronline.org, and trying Capella via couchbase.live for quick experiments.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 5:26Making the Same Change With a Document Database
3. 38:20Summary
4. 42:58Versioning approach 1: Version Numbers

" related talks

• 59mData Modeling forClarence J M Tauro · Voxxed Days Singapore 2017
• 01h 02mNext Generation Data Storage with CouchDBJan Lehnardt · MountainWest RubyConf 2008
• 26mNoSQL Data Modeling for Front-end DevelopersStanimira Vlaeva · EnterpriseNG 2021
• 55mData Modeling in a Non-Relational WorldOren Eini · Build Stuff 2017
• 45mNoSQL Data Modeling for Front-end DevelopersStanimira Vlaeva · angularday 2021
• 44mThe Developer's Guide to Data Modelling with Document DatabasesAdrienne Braganza Tacke · NDC Porto 2022
• 25mAzure Cosmos DB Modeling MethodologyAndriy Zabavskyy · Azure Cosmos DB Conf 2022
• 46mFrom Tables to Documents -- Changing Your Database MindsetLauren Schaefer · NDC Oslo 2020