An Introduction to Anchor Modeling – Lars Rönnbäck

Anchor Modeling is an Open Source database modeling technique built on the premise that the environment surrounding a data warehouse is in constant change. A large change on the outside of the model will result in a small change within. The technique incorporates the natural conecpts of objects, attributes and relationships making it easy to use and understand. It is based on the sixth normal form, resulting in a highly decomposed implementation, which avoids many of the pitfalls associated with traditional database modeling. Thanks to its modular nature the technique supports separation of concerns and simplifies project scoping. You can start small with prototyping and later grow into an enterprise data warehouse without having to redo any of your previous work.

Even though its origins were the requirements found in data warehousing it is a generic modeling approach, also suitable for other types of systems. Every change is implemented as an independent non-destructive extension in the existing model. As a result all current applications will remain unaffected. Changes in the input to and output from the database can thereby be handled asynchronously, and all versions of an application can be run against the same evolving database. Any previous version of the database model still exists as a subset within an Anchor Model.

A fixed model can rarely survive for any longer periods of time. At some point a change will occur that could not have been foreseen, and if the initial effort was to create an all-encompassing model you may now be facing dramatic alterations to cope with the new situation. Anchor Modeling is built upon the assumption that perfect predictions never can be made. Database models should not be built to last, they should be built to change. Only then can they truly last in an ever changing environment.

Your Instructor

Course Curriculum

An Introduction to Anchor Modeling
Introducing Anchor Modeling

Background (5:01)

Change (3:17)

Total Cost of Ownership (3:05)

Lost in Translation (7:54)

The Identification Dilemma (3:55)

Classification (3:03)

Terminology (6:12)

A Bitemporal Round of Golf (17:32)

Optimizing Joins (11:02)

The Cardinality of Relationships (7:46)

Constraints in Temporal Databases (6:41)

Traditional vs Anchor (5:32)

The Online Modeling Tool (23:18)

Examples of Anchor Modeling

The Leonardo Example (unitemporal) (84:05)

The Iceberg Exercise (concurrent-reliance-temporal) (51:03)

Case Studies

The Case of Big Data (10:17)

Bonus Material

Posits and Assertions (40:04)

Anchor Modeling lecture at Stockholm University (2009) (88:16)

Anchor Modeling lecture at Stockholm University (2010) (79:44)

Creating a key in the online modeler (1:04)

Modeling Closer to Reality (33:32)

Lost in Translation (19:55)

After the Course

Other Resources (5:24)

The sisula ETL framework – part 1 (20:42)

The sisula ETL framework – part 2 (13:45)

The sisula ETL framework – part 3 (18:57)

The sisula ETL framework – part 4 (33:02)

Quick DW (using sisula) (86:26)