The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Java Buzz Forum
Optimize Hierarchy Queries with a Transitive Closure Table

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Kyle Cordes

Posts: 100
Nickname: kylecordes
Registered: Sep, 2003

Kyle Cordes leads a small band of software developers at Oasis Digital Solutions Inc.
Optimize Hierarchy Queries with a Transitive Closure Table Posted: Jan 13, 2008 7:53 PM
Reply to this message Reply

This post originated from an RSS feed registered with Java Buzz by Kyle Cordes.
Original Post: Optimize Hierarchy Queries with a Transitive Closure Table
Feed Title: Kyle Cordes
Feed URL: http://kylecordes.com/category/java/feed
Feed Description: Kyle Cordes's Software Site - Java category 		Latest Java Buzz Posts
Latest Java Buzz Posts by Kyle Cordes
Latest Posts From Kyle Cordes

Advertisement
Last year I posted about the use of a Joe Celko-style nested set hierarchy representation, for fast hierarchy queries. Here I will describe another approach which is simpler to query, but more wasteful of space. I did not invent this transitive closure approach, I learned of it from several directions: Celko wrote about it as [...]

Read: Optimize Hierarchy Queries with a Transitive Closure Table

Topic: October 2007 New Java Performance Tips Previous Topic   Next Topic Topic: High Horses
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use