
Managing Time in Relational Databases
Tom Johnston, Randall Weis · 2010
Programming and computer science › Databases and distributed data
#8,159 most recommended
Hacker News
4
mentions by 4 people · top 54% of 15,732 books
Open Library
—
No ratings yet
Wikipedia
—
No article yet
About the book
A practical guide to representing and handling time in relational database design, covering how to store, update, and query temporal data. It focuses on valid time (when facts hold in the modelled world) and transaction time (when the database recorded them), and on how those are modelled in ordinary relational tables. Time should be treated as an explicit part of the data model rather than an afterthought handled by ad hoc columns in application code. The book contends that temporal designs can be built on standard relational features and SQL, with careful schema choices and update rules, so that history is preserved and queries about past and present states stay correct. It presents these design and query patterns as a workable method for practitioners.
Written by Claude from what it knows of this book.
What Hacker News says 50% recommend · 0% critical
In the commenters’ own words
Temporal tables are a pet interest of mine, so here are some links that people might find useful: Richard Snodgrass, Developing Time-Oriented Database…
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…
What Open Library readers say
No Open Library reader has rated it yet.
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
Details
- First published
- 2010
- ISBN
- 9780080963372
- Editions known
- 2 at Open Library
- Open Library
- OL26474927W
Databases
Read next: its neighbours on the mosaic
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · named together in 2 comments
Time and Relational TheoryC. J. Date · 2014 · 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
Time Management for System AdministratorsThomas Limoncelli · 2005 · recommended by 19 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 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
Database in depthC. J. Date · 2005 · recommended by 4 people · similar by subject and what people say about it
Managing gigabytesIan H. Witten · 1999 · recommended by 26 people · loosely similar by subject
Database systemsHector Garcia-Molina · 2001 · recommended by 11 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
An introduction to database systemsC. J. Date · 1975 · recommended by 14 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
Architecture of a database systemJoseph M. Hellerstein · 2007 · recommended by 7 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
Seven Databases in Seven WeeksEric Redmond · 2012 · recommended by 8 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
Managing HumansMichael Lopp · 2007 · recommended by 76 people · similar by subject and what people say about it
SlackTom DeMarco · 2002 · recommended by 24 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
SQL and relational theoryC. J. Date · 2009 · recommended by 9 people · similar by subject and what people say about it
Time and the art of livingRobert Grudin · 1982 · recommended by 2 people · similar by subject and what people say about it
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · similar by subject and what people say about it
PeoplewareTom DeMarco · 1987 · recommended by 276 people · similar by subject and what people say about it
Manage It!Johanna Rothman · 2007 · recommended by 2 people · similar by subject and what people say about it