This is work in progress and constructive feedback via e-mail (chris.cumming@saturdaymp.com) is most appreciated.

Sections

• What is a Temporal Database?
• Degrees of Temporalness
  • Type of Table Temporalness
    • Effective Historical Temporalness
    • Entered Historical Temporalness
    • Combing Table Temporalness
  • Table Temporalness with Auditing
• Timelines
• Creating Temporal Tables
• Querying Temporal Tables
• Temporal Foreign Keys
• User’s Thinking Temporally

What is a Temporal Database?

You can read the official Wikipedia definition but for our purposes it’s a database where you can query for historical data using SQL.