Temporal models

Solutions to real-world problems often need time dimensions in the data model. This task seems daunting as there is an endless number of technologies which promise to solve this problem for you. Yet, the core problem is not that complicated because there is a limited amount of theoretical solutions.

This should mark the beginning of my infotainment series.

Links:

• Developing Time-Oriented Database Applications in SQL
• TSQL2 and SQL3 Interactions
• Event store
• Time series
• Append-only
• Immutability
• Mutability needs company, it often hangs around with bugs.