Why And How We Built a Temporal #database System Called SirixDB (Open Source) From Scratch
▻https://hackernoon.com/why-and-how-we-built-a-temporal-database-system-called-sirixdb-open-sour
Pushing Database Versioning to Its Limits by Means of a Novel Sliding Snapshot Algorithm and Efficient Time Travel QueriesAs most current database systems still simply store current state or past states within one big relational table, we investigated what the performance drivers are and how to improve on the current state-of-the-art. We implemented an Open Source storage system called Sirix(.io) from scratch, which stores small sized snapshots as well as supports sophisticated time-travel queries, while competing with the efficiency of non-temporal database systems.Sunbirst view of a resource stored in Sirix (showing file system data)What is a temporal database system?It is a term used to describe, that a system is capable of retrieving past states of your data. Typically a temporal database (...)