用SQL开发面向时间的数据库应用
Developing time-oriented database applications in SQL
Richard T. Snodgrass、Christian S. Jensen · 初版 1999 年
6人推荐
9位读者提及
14次提及
“无论你是数据库设计人员、程序员、分析师还是管理人员，你大概都曾遇到过与时变数据相关的挑战，并深感挫败。你该向何处求助以解决问题并防止其再次发生？在 Developing Time-Oriented Database Applications in SQL 一书中，一位顶尖的 SQL 研究学者将传授你用于设计和构建必须整合历史与当前数据的数据库应用的高效技术。本书旨在满足一项普遍而持久的需求，如果你正好置身于这股热潮之中，它将成为你的不可或缺之选……”
Hacker News 上怎么说
正在加载完整评论……
关于 bitemporality 有几本好书，Richard Snodgrass 的《Developing time-oriented database applications in SQL》基本上就是这个领域的圣经，讲得非常详尽。Tom Johnston 和 Randall Weis 写的《Managing Time in Relational Databases》也是一本好书，在代码实操上讲得更多一点……
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.…
Temporal tables 是我的个人兴趣所在，所以这里分享一些大家可能会用得上的链接：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……
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…
……建议一些处理随时间发生 DDL 变更的方法（比如添加一个新的 NOT NULL 列，或者将关系从一对多改成多对多）。这是给你起步的参考书目：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，《Bitemporal Data》；Magnus……
…suggest some ways to handle DDL changes over time (e.g. adding a new NOT NULL column, or changing a relationship from one-to-many to many-to-many). Here is your starting bibliography: 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, Bitemporal Data Magnus…
……叫做 Andl，是另一种非 SQL 的关系查询语言。就我个人而言，虽然我不是研究人员，但我对我们在关系型数据库中对随时间变化进行建模的方式越来越感兴趣。Snodgrass 的书《Developing Time-Oriented Database Applications in SQL》是进入这一切的绝佳切入点，而且最近我们还有了 SQL:2011 的 Temporal 标准。我自己在这方面也还有很多东西要读，但我很期待看到未来十年关系型……
…called Andl that is another non-SQL relational query language. Personally, although I'm not a researcher, I've become intrigued by ways we model change-over-time in relational databases. Snodgrass's book _Developing Time-Oriented Database Applications in SQL_ is a good entry point to all that, and more recently we have SQL2011's Temporal standard. I still have a lot to read here myself, but I am keen to see what happens in the next ten years in how the relational…
如果我有六个月时间做研究，我会去搞时态数据库，从《Developing Time-Oriented Database Applications in SQL》这本书开始。我会研究尝试将其引入 SQL 标准的历史，包括 Snodgrass 和 Date 之间的争论，以及最终写入 SQL:2011 的内容。然后我会看看 Postgres 在多大程度上……
If I had six months to research something, I'd work on temporal databases, starting with the book Developing Time-Oriented Database Applications in SQL. I'd look at the history of attempts to bring this into the SQL standard, including the arguments between Snodgrass and Date, and what was eventually put in SQL2011. Then I'd see how much of this Postgres…
……transaction time，你就可以重建任意时间点的 belief 状态。使用 valid time，你可以对过去、现在或未来范围内关于任何事实做出 assertion。我认为 Snodgrass 的《Developing Time-Oriented Database Applications in SQL》[0] 依然是最好的全面入门读物，尽管里面用的 SQL 已经相当过时了（哈）。相关的 Wikipedia 条目也不错[1]。[0] https://www2.cs.arizona.edu/~rts/tdbbook.pdf [1] https://en.wikipedia.org/wiki/Temporal_database
…transaction time you can then reconstruct your state of belief from any point in time. Using valid time you can make assertions about any fact in ranges over the past, present or future. I think Snodgrass's Developing Time-Oriented Database Applications in SQL[0] is still the best overall introduction, though the SQL used is fairly dated (ha). The relevant Wikipedia entry is OK too[1]. [0] https://www2.cs.arizona.edu/~rts/tdbbook.pdf [1] https://en.wikipedia.org/wiki/Temporal_database