Managing Time in Relational Databases

What Hacker News says

1. sa46Oct 2021
   Good recommendation; I also got a lot of mileage out of:

   Managing Time in Relational Databases: How to Design, Update and Query Temporal Data How to Design, Update and Query Temporal Data

   > be careful if you tend to over-engineer or are perfectionist

   One of the downsides of these books is that I see bitemporal data everywhere now but its quite difficult to write bitemporal queries in Postgres.

   thread
2. michelppApr 2019
   There are a couple of good books on bitemporality, Richard Snodgrass' "Developing time-oriented database applications in SQL" is pretty much the bible on the subject and goes into great detail. "Managing Time in Relational Databases" by Tom Johnston and Randall Weis is another great book, a little more hands on with the code.

   I'd love to see someone translate the concepts in both books to a useful postgres package. As Snodgrass points out, "Unfortunately, due to the noncompliance of all existing DBMSs, a few of these fragments run on no existing platform" and thus only discusses how they can be applied to DB2, MSSQL, Sybase, Oracle8 and UniSQL.

   Show morethread
3. pjungwirJul 2017
   Temporal tables are a pet interest of mine, so here are some links that people might find useful:

   Richard Snodgrass, Developing Time-Oriented Database Applications in SQL.

   Hugh Darwen & C.J. Date, "An Overview and Analysis of Proposals Based on the TSQL2 Approach".

   Krishna Kulkarni & Jan-Eike Michels, "Temporal features in SQL:2011".

   Tom Johnston, Managing Time in Relational Databases. (I haven't read this one yet.)

   Tom Johnston, Bitemporal Data.

   Magnus Hagander, "A TARDIS for Your ORM": https://www.youtube.com/watch?v=TRgni5q0YM8

   Also I've yet to see anyone even talk about managing DDL changes in temporal databases (well Magnus mentions that he won't cover it), but it's the same problem as discussed here. It's very practical, but you could write a dissertation or a book about it.

   Show morethread
4. nickpetersonApr 2017
   I reread 'managing time in relational databases' like 3 times one summer and now every time I mess with time in databases I have a heart attack.

   That makes sense, thanks for answering ;)

   thread