[HN Gopher] Temporal Databases (1986) [pdf]
___________________________________________________________________
Temporal Databases (1986) [pdf]
Author : LAC-Tech
Score : 18 points
Date : 2023-10-26 08:51 UTC (14 hours ago)
(HTM) web link (www2.cs.arizona.edu)
(TXT) w3m dump (www2.cs.arizona.edu)
| synthc wrote:
| XTDB is a recent implementation of these ideas. In their docs
| they call it a bitemporal database, but it seems to match what is
| called a temporal database in the paper
| dragonwriter wrote:
| Right, "bitemporal" later became established for the two-time-
| dimensions model here, with "temporal" being broader and
| including valid-time-only systems.
| refset wrote:
| Agreed, this is accurate. I work on XTDB and was able to
| speak with Richard Snodgrass (author of the paper) a couple
| of years ago. During our conversation we discussed how his
| research was primarily focused on handling valid-time, with
| transaction-time (a.k.a. system-time per SQL:2011) as a
| secondary concern. In contrast XTDB was inspired by the
| functional programming / immutability / database-as-a-value
| vision behind Datomic but with a desire for something more
| powerful than just the transaction-time capabilities.
| Essentially we arrived at 'bitemporal' from the opposite
| direction. This blog post covers the perspective somewhat:
| https://vvvvalvalval.github.io/posts/2017-07-08-Datomic-
| this...
| withinboredom wrote:
| Oh oh! I built one of these at work a 3-4 years ago! It was
| awesome! We were using it to store features for the AI which
| needed to query them as of a specific time. It was built on top
| of Hadoop/HBase.
|
| AMA, it was scrapped eventually, so I don't think anyone cares if
| I share details.
| fipar wrote:
| I found Time and Relational Theory a very interesting read on
| this topic: https://www.oreilly.com/library/view/time-and-
| relational/978...
___________________________________________________________________
(page generated 2023-10-26 23:00 UTC)