What are Temporal Databases? How databases automatically retain history (temporal data).
HTML-код
- Опубликовано: 10 сен 2024
- A temporal database is one that includes special support for the time dimension, allowing it to store data with history and time as an inherent dimension of the data. It supports facilities for storing, querying and updating historical and/or future data. Using libraries like 4DFLib, an open source proof of concept we can easily create and manage time sensitive data stores. This video focuses on temporal databases conceptually, the next video in this series shows how a library like 4DFLib can be created to manage time sensitive data in any database system. You can see that video here: • Creating a Temporal Da...
I personally believe that the reason we do not have full temporal databases as standard today where are all tables / entities automatically retain historical information is because there has not been a good implementation found at the database layer. I believe this implementation can exist as a lower level software layer above or part of the object relational mapping (ORM) layer. My open source library, 4DFLib is intended to be a proof of concept of how such an implementation might happen.
You can find the 4DFLib library here: github.com/bri...
There is also an example java application that implements it to show how it can be used here: github.com/bri...
I created a video tutorial using the example above that walks you through using 4DFLib:
Part 1: • 4DFLib Object Relation...
Part 2: • 4DFLib Object Relation...
Part 3: • 4DFLib Object Relation...
I also have a related short series on ORM if you are not familiar with or would like to refresh on the concepts:
Part 1: • What is object relatio...
Part 2: • What is object relatio...
This video is part of a full semester graduate course given on databases and application integration: • {DBMS - Database Manag...
Additional Reading / References:
Date, Christopher John, Hugh Darwen, and Nikos Lorentzos. Time and relational theory: temporal databases in the relational model and SQL. Morgan Kaufmann, 2014.
Snodgrass, Richard T. Developing time-oriented database applications in SQL. Morgan Kaufmann Publishers, 2000.
Please like this video and subscribe to my channel to receive updates on this project: / @codingcoach
Link to slides used in this presentation: drive.google.c...
Book used in this course: Garcia-Molina, Hector. Database systems: the complete book. Pearson Education India, 2008.
www.amazon.com...
Very good explanation. Thank you.
You are welcome!
Great explanation! I understand now what are the temporal databases :)
Glad it was helpful!