In this episode, Shane Gibson sits down with anchor modeling co-creator Lars Rönnbäck and data modeling practitioner Christian Kaul.

The conversation explores the foundational principles of anchor modeling, an agile, sixth normal form (6NF) ensemble modeling technique developed in 2004 to achieve data warehouse longevity and cope with rapid business changes without degrading into unmaintainable “just a bunch of tables”. The group examines the architecture’s core constructs—anchors (representing immutable entity identities), attributes (isolated in separate tables per field), ties (relationships with flexible arity), and knots (shared finite value sets)—as well as the newly introduced nexus, which translates activity schema concepts into 6NF. They contrast these constructs with other ensemble methods such as Data Vault and Focal, emphasizing how strict separation of immutable surrogate identities from natural business keys provides a consistent, opinionated framework suited for automated schema generation.

The discussion also dives deep into anchor modeling’s advanced temporal capabilities, contrasting standard unitemporal progression with bitemporal architectures that use annex tables to track orthogonal historical corrections, as well as complex concurrent reliance temporal models that record conflicting source statements alongside confidence ratings. Lars shares practical deployment insights, including Nikolay Golov’s 500-terabyte implementation for an online marketplace in Russia, and the panel reflects on why ensemble techniques have gained stronger traction in European and Australasian Inmon-aligned environments compared to US Kimball patterns. Looking forward, the panel explores the concept of the model-driven organisation, evaluating how pre-joined perspective views, hybrid operational/analytical databases, and open-source anchor modeling LLM skills enable AI agents to safely generate code and navigate multi-table schemas.

Whether you are curious about sixth normal form ensemble modeling, strategies for handling bitemporal and multi-source historical corrections, or how AI agents and LLM skills can interact with highly decomposed data architectures, this episode is packed with valuable insights for data architects and modeling practitioners.