DeepRead
Cover of Managing Time in Relational Databases

Managing Time in Relational Databases

Tom Johnston, Randall Weis · 2010

Programming and computer science › Databases and distributed data

#8,159 most recommended

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

024201720182019202020212017 peak · 2
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say

No Open Library reader has rated it yet.

Open Library’s page for the book

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

Explore in the mosaic

Read next: its neighbours on the mosaic