
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
Hacker News
6
mentions by 6 people · top 42% of 15,732 books
Open Library
3.00★★★★★★★★★★
1 rating
Wikipedia
—
No article yet
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
In the commenters’ own words
> For example, to store a graph in a RDBMS, the ideal format is probably an adjacency list with a recursive query to iterate it I know this was a minor point…
goal directed programming is the related non-sql programming paradigm. unicorn/icon[1] ---- Use cases:[2] autoparts inventory (book keeping page statics of…
What Open Library readers say 3.00 from 1 rating
- 50
- 40
- 31
- 20
- 10
- 0 want to read
- 0 reading
- 1 have read
Only 1 rating: treat the average as a hint.
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)
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
SQL Design PatternsVadim Tropashko · 2007 · recommended by 2 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
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
Combinatorial optimizationChristos H. Papadimitriou · 1981 · recommended by 1 person · loosely similar by subject
SQL puzzles & answersJoe Celko · 1997 · recommended by 3 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
Build Your Own Programming LanguageClinton L. Jeffery · 2021 · recommended by 1 person · loosely similar by subject
Open Data StructuresPat Morin · 2013 · recommended by 11 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
Database System ConceptsKorth · 2005 · recommended by 4 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
The art of SQLStephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
Annotated GödelHal Prince · 2022 · recommended by 2 people · loosely similar by subject
Foundations of multidimensional and metric data structuresHanan Samet · 2006 · recommended by 11 people · similar by subject and what people say about it
Foundations of databasesSerge Abiteboul · 1994 · recommended by 1 person · similar by subject and what people say about it
Once Upon an algorithmMartin Erwig · 2017 · recommended by 1 person · loosely similar by subject
The Stanford GraphBaseDonald Knuth · 2009 · recommended by 5 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
SQL and relational theoryC. J. Date · 2009 · recommended by 9 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
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
Programming Algorithms in LispVsevolod Domkin · 2021 · recommended by 1 person · loosely similar by subject
Effective Oracle by designThomas Kyte · 2003 · recommended by 1 person · similar by subject and what people say about it