22-25 April 2026
Book Now
SQLBits 2015

Temporal Databases: Solving todays problems throughout time

Do you need an OLAP database? Do you know how the data changed over time? Do you need an OLTP database? Do you need to write, never block and never lose a change? Then Temporal Databases tick those boxes and are a simple solution to these problems.
Everyone wants to work smarter and not harder. In the database world we are no different. If doesn’t matter if you work on OLTP or OLAP databases, there are fundamental constraints which we all work upon. I would like to present to you, Temporal Databases. They have the benefit of:
  • Always write
  • Never lock
  • Never lose a change
  • See the data at any point in time
A Temporal Database enables you to create a database schema with the Golden 3 properties. This way, your users are happy, management is happy and the system is consistent and clean at all times. How does this work and what is this Holy Grail? Come to the talk and see for yourself, with code examples, database schemas and of course a full explanation. Come and explore the futures, where you have it all!

Speakers

Katherine Bean

Katherine Bean's previous sessions

Temporal Databases: Solving todays problems throughout time
Do you need an OLAP database? Do you know how the data changed over time? Do you need an OLTP database? Do you need to write, never block and never lose a change? Then Temporal Databases tick those boxes and are a simple solution to these problems.
 
Data Security - In a Post Snowden World
Everyone knew how to keep data safe and secure, right up until Edward Snowden revealed this error. Learn how to keep the data secure, by identifying and quantifying the risks. Take away practical tips and advice to apply immediately.