DeepRead
Cover of Joe Celko's Trees and Hierarchies in SQL for Smarties,

Joe Celko's Trees and Hierarchies in SQL for Smarties,

Joe Celko · 2004

Programming and computer science › Databases and distributed data

#6,134 most recommended

About the book

Joe Celko's book covers how to store and query tree and hierarchical data in relational databases using SQL. It works through the standard representations, including the adjacency list, path enumeration, and nested set models, with a chapter devoted to each. The material is aimed at working SQL developers who need to model organizational charts, bills of materials, or similar structures. The book contends that the choice of hierarchy model should follow from the queries an application needs, such as finding ancestors, descendants, or levels, rather than from habit. It favors set-oriented SQL over procedural or row-by-row approaches for traversing and aggregating trees. It also weighs the update costs and query trade-offs of each model, with nested sets presented as especially useful for read-heavy retrieval.

Written by Claude from what it knows of this book.

What Hacker News says 83% recommend · 0% critical

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

In the commenters’ own words

What Open Library readers say 3.00 from 1 rating

  1. 50
  2. 40
  3. 31
  4. 20
  5. 10
  • 0 want to read
  • 0 reading
  • 1 have read

Only 1 rating: treat the average as a hint.

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
2004
ISBN
9780123877338
Editions known
10 at Open Library
Open Library
OL2629224W

COMPUTERSC♯Graph theoryJavaPascalProgramming LanguagesSQL (Computer program language)Sql (computer program language)Trees (Graph theory)

Explore in the mosaic

Read next: its neighbours on the mosaic