
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
Hacker News
14
mentions by 9 people · top 22% of 15,732 books
Open Library
—
No ratings yet
Wikipedia
—
No article yet
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
In the commenters’ own words
A bitemporal data model in SQLite ... for a little SaaS app, because my friend-and-sponsor hasn't given me a deadline, nor sent irate letters asking for…
If I had six months to research something, I'd work on temporal databases, starting with the book Developing Time-Oriented Database Applications in SQL. I'd…
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
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
Read next: its neighbours on the mosaic
Managing Time in Relational DatabasesTom Johnston · 2010 · recommended by 2 people · named together in 2 comments
SQL antipatternsBill Karwin · 2010 · recommended by 31 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
The data warehouse toolkitRalph Kimball · 1996 · recommended by 23 people · 2 people recommended both
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
PostgreSQL 9.0 High PerformanceGregory Smith · 2010 · recommended by 12 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
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
Database design and implementationEdward Sciore · 2008 · recommended by 7 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
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
The art of capacity planningArun Kejariwal · 2018 · recommended by 1 person · loosely similar by subject
Database System ConceptsKorth · 2005 · recommended by 4 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 management systemsRaghu Ramakrishnan · 2001 · recommended by 7 people · similar by subject and what people say about it
Rapid developmentSteve McConnell · 1996 · recommended by 27 people · similar by subject and what people say about it
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 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
Performance modeling and design of computer systemsMor Harchol-Balter · 2013 · recommended by 5 people · similar by subject and what people say about it
Dealers of LightningMichael A. Hiltzik · 1999 · recommended by 74 people · 3 people recommended both
Transaction processingGray, Jim · 1993 · recommended by 13 people · similar by subject and what people say about it
The Art of PostgreSQLDimitri Fontaine · 2019 · recommended by 20 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
The Mythical Man-MonthFrederick P. Brooks · 1975 · recommended by 383 people · 3 people recommended both