banner

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

img

An agile information modeling technique for evolving data environments

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

Lars Rönnbäck

Lars Rönnbäck

Lars Rönnbäck is a consultant at Up To Change (www.uptochange.com) and research affiliate with Stockholm University. He has a degree in mathematics from Uppsala University and is a specialist in information modeling and customer intelligence. He has been working with some of the largest companies in the Swedish insurance and retail businesses, with ten years experience from the field of Business Intelligence and Anchor Modeling.

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)

Access download Lars Rönnbäck – An Introduction to Anchor Modeling at coursesblock.com right now!

Salepage: https://anchor.teachable.com/p/an-introduction-to-anchor-modeling
Archive: https://archive.ph/wip/P0oj5

Delivery Method

– After your purchase, you’ll see a View your orders link which goes to the Downloads page. Here, you can download all the files associated with your order.
– Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from coursesblock.com
– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.
– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible at 8:00 AM – 8:00 PM (UTC 8).

Thank You For Shopping With Us!

Original price was: $199.00.Current price is: $54.00.

Digital Download: You will receive a download link via your order email Should you have any question, please contact us: support@coursesblock.com