3 ms·
Aha, well it's certainly been a learning curve for me! I found the public MIT lectures on "retroactive data structures" (by Erik Demaine) very helpful to clari
by refset 6y ago
Aha, well it's certainly been a learning curve for me!
I found the public MIT lectures on "retroactive data structures" (by Erik Demaine) very helpful to clarify the mental model and properties of temporal databases. Point-in-time bitemporal queries are fairly simple compared to the kinds of things some organisations use data warehouses for (e.g. temporal range queries across N dimensions), but surprisingly few teams think about representing time so clearly within their transactional OLTP/HTAP systems, so even point-in-time queries seem more novel than they really should.
Everything is moving in the right direction though as immutable data becomes the default.
- lukashrb 6y agoTy for the link. Do you have more material that helped you with your work on crux? And do you mind sharing?
- refset 6y agoThe best place to start for context would be Håkan's ClojuTRE talk: https://www.youtube.com/watch?v=YjAVsvYGbuU https://www.youtube.com/watch?v=YjAVsvYGbuU And here are the slides for that talk, which include a few references: https://juxt.pro/hakan-raberg-the-design-and-implementation-of-a-bitemporal-dbms.pdf https://juxt.pro/hakan-raberg-the-design-and-implementation-... Feel free to reach out to the team, or find us on Zulip/Slack, if you want to hear more or just chat :)