关于双时态（bitemporality），有几本不错的书，Richard Snodgrass 的《Developing time-oriented database applications in SQL》几乎是该领域的圣经，讲得非常详细。Tom Johnston 和 Randall Weis 写的《Managing Time in Relational Databases》也是一本好书，更偏向代码实战。我很想看到有人能把这两本书里的概念转化成一个实用的 postgres package。正如 Snodgrass……
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…
推荐得好；我也从这本书里获益良多：《Managing Time in Relational Databases: How to Design, Update and Query Temporal Data》《How to Design, Update and Query Temporal Data》 > 如果你容易过度设计或者是个完美主义者，那可得小心了 这类书的缺点之一就是……
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…
……《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》。（这本我还没读过。）Tom Johnston 的《Bitemporal Data》。Magnus Hagander 的《A TARDIS for Your ORM》：https://www.youtube.com/watch?v=TRgni5q0YM8 另外我还没见过有人讨论怎么管理……
…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…
有一年夏天我把《managing time in relational databases》重读了大概 3 遍，现在每次在数据库里折腾时间我都快心脏病发作了。讲得通，多谢解答 ;）
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 ;)
关于双时态（bitemporality），有几本不错的书，Richard Snodgrass 的《Developing time-oriented database applications in SQL》几乎是该领域的圣经，讲得非常详细。Tom Johnston 和 Randall Weis 写的《Managing Time in Relational Databases》也是一本好书，更偏向代码实战。我很想看到有人能把这两本书里的概念转化成一个实用的 postgres package。正如 Snodgrass……
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…
推荐得好；我也从这本书里获益良多：《Managing Time in Relational Databases: How to Design, Update and Query Temporal Data》《How to Design, Update and Query Temporal Data》 > 如果你容易过度设计或者是个完美主义者，那可得小心了 这类书的缺点之一就是……
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…
……《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》。（这本我还没读过。）Tom Johnston 的《Bitemporal Data》。Magnus Hagander 的《A TARDIS for Your ORM》：https://www.youtube.com/watch?v=TRgni5q0YM8 另外我还没见过有人讨论怎么管理……
…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…
有一年夏天我把《managing time in relational databases》重读了大概 3 遍，现在每次在数据库里折腾时间我都快心脏病发作了。讲得通，多谢解答 ;）
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 ;)