Time and Relational Theory, 2/e : Temporal Databases in the Relational Model and SQL (Paperback)

C.J. Date, Hugh Darwen, Nikos Lorentzos

  • 出版商: Morgan Kaufmann
  • 出版日期: 2014-07-16
  • 售價: $2,160
  • 貴賓價: 9.5$2,052
  • 語言: 英文
  • 頁數: 560
  • 裝訂: Paperback
  • ISBN: 0128006315
  • ISBN-13: 9780128006313
  • 相關分類: SQL
  • 立即出貨 (庫存=1)



Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because:

  • Cheap storage enables retention of large volumes of historical data in data warehouses
  • Users are now faced with temporal data problems, and need solutions
  • Temporal features have recently been incorporated into the SQL standard, and vendors have begun to add temporal support to their DBMS products

Based on the groundbreaking text Temporal Data & the Relational Model (Morgan Kaufmann, 2002) and new research led by the authors, Time and Relational Theory is the only book to offer a complete overview of the functionality of a temporal DBMS. Expert authors Nikos Lorentzos, Hugh Darwen, and Chris Date describe an approach to temporal database management that is firmly rooted in classical relational theory and will stand the test of time.

This book covers the SQL:2011 temporal extensions in depth and identifies and discusses the temporal functionality still missing from SQL.

  • Understand how the relational model provides an ideal basis for taming the complexities of temporal databases
  • Learn how to analyze and evaluate commercial temporal products with this timely and important information
  • Be able to use sound principles in designing and using temporal databases
  • Understand the temporal support recently added to SQL with coverage of the new SQL features in this unique, accurate, and authoritative reference
  • Appreciate the benefits of a truly relational approach to the problem with this clear, user friendly presentation


- 廉價的存儲使得在數據倉庫中保留大量歷史數據成為可能
- 用戶現在面臨時間數據問題,需要解決方案
- 時間功能最近已納入SQL標準,供應商已開始將時間支持添加到其DBMS產品中

基於開創性的著作《時間數據與關聯模型》(Morgan Kaufmann,2002)和作者領導的新研究,《時間與關聯理論》是唯一一本提供完整概述時間DBMS功能的書籍。專家作者Nikos Lorentzos、Hugh Darwen和Chris Date描述了一種根植於經典關聯理論並經得起時間考驗的時間數據庫管理方法。


- 瞭解關聯模型如何成為馴服時間數據複雜性的理想基礎
- 通過這些及時且重要的信息,學習如何分析和評估商業時間產品
- 能夠在設計和使用時間數據庫時遵循合理原則
- 瞭解SQL最近新增的時間支持,並涵蓋這個獨特、準確且權威的參考資料中的新SQL功能
- 通過這種清晰、用戶友好的介紹,體會到真正關聯方法帶來的好處。