DeepRead
Cover of Developing time-oriented database applications in SQL

Developing time-oriented database applications in SQL

Richard T. Snodgrass, Christian S. Jensen · 1999

Programming and computer science › Databases and distributed data

#4,052 most recommended

About the book

The book covers designing, building, and querying database applications whose data changes over time, using SQL. It treats valid time (when facts hold in the modeled world) and transaction time (when the database recorded them), and how to combine the two in one design. Its scope runs from data modeling and schema design through integrity constraints and query techniques. Time-varying data is hard to manage when developers handle history ad hoc, so time should be made an explicit part of the schema and of queries. The book argues that past and current data can be integrated systematically with techniques for temporal modeling, constraints, and queries that work within SQL. It also makes the case that recording both valid and transaction time supports correcting past records and auditing what the database showed at a given moment.

Written by Claude from what it knows of this book.

What Hacker News says 67% recommend · 0% critical

02420132015202020252016 peak · 3
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

The threads it came up in

Details

First published
1999
ISBN
9781558604360
Editions known
4 at Open Library
Open Library
OL19841631W

Banco de dadosDatabase designGerenciadores de banco de dadosSQL (Computer program language)Sql

Explore in the mosaic

Read next: its neighbours on the mosaic