
Time and Relational Theory
C. J. Date, Nikos Lorentzos, Hugh Darwen · 2014
Programming and computer science › Databases and distributed data
#14,214 most recommended
Hacker News
2
mentions by 2 people · top 79% of 15,732 books
Open Library
—
No ratings yet
Wikipedia
—
No article yet
About the book
This book covers how to store and query time-varying data in relational databases, including valid time (when facts hold in the modelled world) and transaction time (when the database recorded them). It is a second edition, written with Hugh Darwen and Nikos Lorentzos, of the authors' earlier treatment of temporal data and the relational model. The authors argue that temporal support belongs inside the relational model itself, built on rigorous foundations such as interval types, periods, and well-defined operators, rather than on ad hoc workarounds. They contend that current SQL temporal features fall short in ways that cause errors and complexity, and they propose a more consistent alternative that keeps the relational principles intact.
Written by Claude from what it knows of this book.
What Hacker News says 50% recommend · 0% critical
In the commenters’ own words
Codd's paper is not that hard. [0] is a PDF copy. One of the pros to reading primary sources is you then know "the whole story": what if anything is missing…
I found Time and Relational Theory a very interesting read on this topic: https://www.oreilly.com/library/view/time-and-relational/978...
What Open Library readers say
No Open Library reader has rated it yet.
- 0 want to read
- 0 reading
- 1 have read
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
Details
- First published
- 2014
- ISBN
- 9780128006313
- Editions known
- 4 at Open Library
- Open Library
- OL21086893W
Database managementTemporal databases
Read next: its neighbours on the mosaic
SQL and relational theoryC. J. Date · 2009 · recommended by 9 people · similar by subject and what people say about it
Database Design and Relational TheoryC. J. Date · 2012 · recommended by 1 person · similar by subject and what people say about it
Database in depthC. J. Date · 2005 · recommended by 4 people · similar by subject and what people say about it
Managing Time in Relational DatabasesTom Johnston · 2010 · recommended by 2 people · similar by subject and what people say about it
An introduction to database systemsC. J. Date · 1975 · recommended by 14 people · similar by subject and what people say about it
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
The relational model for database managementE. F. Codd · 1990 · recommended by 2 people · similar by subject and what people say about it
Foundations of databasesSerge Abiteboul · 1994 · recommended by 1 person · similar by subject and what people say about it
UNIX relational database managementRod Manis · 1988 · recommended by 2 people · similar by subject and what people say about it
Data and RealityWilliam Kent · 1978 · recommended by 15 people · similar by subject and what people say about it
Database system implementationHector Garcia-Molina · 1999 · recommended by 3 people · similar by subject and what people say about it
Architecture of a database systemJoseph M. Hellerstein · 2007 · recommended by 7 people · similar by subject and what people say about it
Readings in database systemsMichael Stonebraker · 1998 · recommended by 11 people · similar by subject and what people say about it
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
Database management systemsRaghu Ramakrishnan · 2001 · recommended by 7 people · similar by subject and what people say about it
Applied Mathematics for Database ProfessionalsLex deHaan · 2007 · recommended by 2 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · loosely similar by subject
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · loosely similar by subject
Graph DatabasesIan Robinson · 2013 · recommended by 1 person · loosely similar by subject
Seven Databases in Seven WeeksEric Redmond · 2012 · recommended by 8 people · loosely similar by subject
Database systemsPeter Rob · 2006 · recommended by 4 people · loosely similar by subject
Applied mathematics for database professionalsLex de Haan · 2007 · recommended by 5 people · loosely similar by subject
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · loosely similar by subject
Parasite RexCarl Zimmer · 2000 · recommended by 13 people · loosely similar by subject