
SQL Design Patterns
Vadim Tropashko · 2007
Programming and computer science › Databases and distributed data
#11,316 most recommended
Hacker News
3
mentions by 3 people · top 64% of 15,732 books
Open Library
—
No ratings yet
4 want to read
Wikipedia
—
No article yet
About the book
SQL Design Patterns is a 2007 book on recurring problem-solving techniques for writing SQL queries and structuring relational data. Its scope is the relational model as it is used in practice, with attention to hierarchies, interval data, set-based logic and aggregation. Tropashko's central claim is that SQL solutions are not ad hoc. He argues they can be derived from the mathematics behind the relational model, such as set theory and relational algebra, and that a small number of patterns recur across many business problems. The book uses interval and nested-set representations of hierarchical and range data as its main examples, and argues that knowing these structures lets a practitioner recognise a problem's shape and choose a query design to match it.
Written by Claude from what it knows of this book.
What Hacker News says 67% recommend · 0% critical
In the commenters’ own words
I am not sure of performance. What I do know is that Vadim Tropashko's SQL Design Patterns has a few ideas on how to encode a materialized path see…
Vadim Tropashko wrote a book "SQL Design Patterns" that, among others, presents non-trivial approaches to storing trees and graphs in SQL databases. I highly…
What Open Library readers say
No Open Library reader has rated it yet.
- 4 want to read
- 0 reading
- 0 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
- 2007
- ISBN
- 9780977671540
- Editions known
- 2 at Open Library
- Open Library
- OL8847460W
SQL (Computer program language)
Read next: its neighbours on the mosaic
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
Joe Celko's Trees and Hierarchies in SQL for Smarties,Joe Celko · 2004 · recommended by 5 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
Inner loopsRick Booth · 1996 · recommended by 4 people · loosely similar by subject
Pro SQL Server InternalsDmitri Korotkevitch · 2014 · recommended by 2 people · similar by subject and what people say about it
C interfaces and implementationsDavid R. Hanson · 1996 · recommended by 46 people · loosely similar by subject
The art of SQLStephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
SQL puzzles & answersJoe Celko · 1997 · recommended by 3 people · similar by subject and what people say about it
Practical SQL, 2nd EditionAnthony DeBarros · 2021 · recommended by 5 people · similar by subject and what people say about it
Design PatternsErich Gamma · 1994 · recommended by 95 people · similar by subject and what people say about it
SQL for DummiesAllen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
Database systemsPeter Rob · 2006 · recommended by 4 people · similar by subject and what people say about it
Design Patterns in RubyRuss Olsen · 2007 · recommended by 15 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
Effective Oracle by designThomas Kyte · 2003 · recommended by 1 person · similar by subject and what people say about it
My systemAron Nimzowitsch · recommended by 5 people · loosely similar by subject
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
Design Patterns. Elements of Reusable Object-oriented SoftwareErich Gamma, Richard Helm, Ralph Johnson, John Vlissides · 1999 · recommended by 4 people · similar by subject and what people say about it
Learning SQLAlan Beaulieu · 2005 · recommended by 3 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
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
Analysis PatternsMartin Fowler · 1996 · recommended by 6 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
Node. js Design PatternsMario Casciaro · 2014 · recommended by 2 people · similar by subject and what people say about it