Re: Best Way to store Hierarchical Data in Mysql

[Rik Wasmus]

> I researched a lot on storing Hierarchical data in mysql tables.
> Below links :
> 
> http://scvinodkumar.wordpress.com/2011/01/30/managing-hierarchical-data-in-
> mysql/ http://www.sitepoint.com/hierarchical-data-database-2/
> 
> shows different ways to store.
> 
> But is there any standard way of doing this fore.g storing twitter
> tweets or comments on a link etc.

Most used is de adjacency model, but it depends on how you are going to use 
it, and how deep hierarchical data goes / can go. Also a good source of 
information: 
- http://www.slideshare.net/billkarwin/models-for-hierarchical-data (nice 
concise comparison of 4 alternatives)
- http://www.amazon.com/Hierarchies-Smarties-Kaufmann-Management-
Systems/dp/1558609202/ref=ntt_at_ep_dpt_2
-- 
Regards,

Rik