Skip to content
Brief example of creating a temporal database.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
A Brief History of the Creation of a Time Traveling Database.odp
A Brief History of the Creation of a Time Traveling Database.pdf
DemoQueries.sql
LICENSE
README.md
Schema.sql
docker-compose.yml

README.md

A Brief History of the Creation of a Time Traveling Database

A lighting talk I gave at the Edmonton PASS Speaker Idol Contest about creating a temporal database many years ago.

Quickstart

You'll need SQL Server installed to run the demos. If you have Docker installed there is a Docker Compose file to get you up and running quickly:

docker-compose up

You can then run the Schema.sql script to create the database. It has two temporal tables Customers and Addresses with triggers that enforce the temporal rules. The DemoQueries.sql has some example data and queries to play with.

Contributing

If you have any questions, notice a bug, or have a suggestion/enhancment please let me know by opening a issue or pull request.

Acknowledgements

Thanks to Edmonton PASS for inviting me to speak.

You can’t perform that action at this time.