DeepRead
Cover of SQL Design Patterns

SQL Design Patterns

Vadim Tropashko · 2007

Programming and computer science › Databases and distributed data

#11,316 most recommended

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

01220152016201720182015 peak · 1
This bookAverage book in Databases and distributed data

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…

    chx · 2015 · in Tree structure query with PostgreSQL

  • 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…

    mci · 2018 · in User-defined Order in SQL

What Open Library readers say

No Open Library reader has rated it yet.

  • 4 want to read
  • 0 reading
  • 0 have read

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
2007
ISBN
9780977671540
Editions known
2 at Open Library
Open Library
OL8847460W

SQL (Computer program language)

Explore in the mosaic

Read next: its neighbours on the mosaic

  • Joe Celko's SQL for Smarties
    Joe 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 antipatterns
    Bill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
  • Inner loops
    Rick Booth · 1996 · recommended by 4 people · loosely similar by subject
  • Pro SQL Server Internals
    Dmitri Korotkevitch · 2014 · recommended by 2 people · similar by subject and what people say about it
  • C interfaces and implementations
    David R. Hanson · 1996 · recommended by 46 people · loosely similar by subject
  • The art of SQL
    Stephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
  • SQL puzzles & answers
    Joe Celko · 1997 · recommended by 3 people · similar by subject and what people say about it
  • Practical SQL, 2nd Edition
    Anthony DeBarros · 2021 · recommended by 5 people · similar by subject and what people say about it
  • Design Patterns
    Erich Gamma · 1994 · recommended by 95 people · similar by subject and what people say about it
  • SQL for Dummies
    Allen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
  • Database systems
    Peter Rob · 2006 · recommended by 4 people · similar by subject and what people say about it
  • Design Patterns in Ruby
    Russ Olsen · 2007 · recommended by 15 people · similar by subject and what people say about it
  • SQL for Web Nerds
    Philip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
  • Effective Oracle by design
    Thomas Kyte · 2003 · recommended by 1 person · similar by subject and what people say about it
  • My system
    Aron Nimzowitsch · recommended by 5 people · loosely similar by subject
  • Database System Concepts
    Korth · 2005 · recommended by 4 people · similar by subject and what people say about it
  • Design Patterns. Elements of Reusable Object-oriented Software
    Erich Gamma, Richard Helm, Ralph Johnson, John Vlissides · 1999 · recommended by 4 people · similar by subject and what people say about it
  • Learning SQL
    Alan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
  • Database Design for Mere Mortals
    Michael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
  • Developing time-oriented database applications in SQL
    Richard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
  • Analysis Patterns
    Martin Fowler · 1996 · recommended by 6 people · similar by subject and what people say about it
  • Database systems
    Hector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
  • Node. js Design Patterns
    Mario Casciaro · 2014 · recommended by 2 people · similar by subject and what people say about it