dm: Analyze, build and deploy relational data models
summary
dm reduces an 800-line join-and-filter routine to 800 lines to 6 by tracking primary and foreign keys across multiple tables, and ships on CRAN at version 1.0.0 with a 1.0.1 Shiny UI that generates reusable R code for databases and local data frames. It integrates with dbplyr/tidyverse, supports CRUD workflows in Shiny, adds dm_deconstruct and dm_ptype to export keyed tables and empty prototypes, and experiments with lossless moves between normalized and nested formats.
AI-written summary · about
chapters (18)
- 0:00dm package overview
- 1:11dm package history
- 2:38Install dm
- 3:20Relational models in R
- 4:46Keys in dm objects
- 5:52dm vs manual approaches
- 6:32Build dm with Shiny
- 7:40Define keys in data frames
- 8:46dm consulting cases
- 10:15CRUD in Shiny with dm
- 10:35Data analysis with dm
- 11:20Deconstruct and reconstruct models
- 13:10Adapt dm to workflows
- 13:32Transform whole models
- 14:38Create DB structures with dm_ptype
- 15:19Normalized to nested data
- 16:24Future of data transitions
- 16:46About cynkra
related talks
17mdm: Analyze, build and deploy relational data models
18mduckplyr: Analyze large data with full dplyr compatibility
24mMake data central feature
01h 42mFall in Love with Data Transformation: DBT as Your Weapon
19mIn-Process Analytical Data Management with DuckDB
44mOpenMDM - Data Management for SDV
18mduckplyr: Tight Integration of duckdb with R and the tidyverse
34mDimensional Data Modeling in the Modern Era