List:General Discussion« Previous MessageNext Message »
From:Rik Wasmus Date:August 19 2011 11:00am
Subject:Re: Best Way to store Hierarchical Data in Mysql
View as plain text  
> 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
Thread
Best Way to store Hierarchical Data in MysqlAdarsh Sharma19 Aug
  • Re: Best Way to store Hierarchical Data in MysqlRik Wasmus19 Aug
    • Reg...My Hung MYSQL instance Shafi AHMED23 Aug
  • Re: Best Way to store Hierarchical Data in MysqlPeter Brawley19 Aug
Re: Best Way to store Hierarchical Data in MysqlAdarsh Sharma19 Aug
Re: Reg...My Hung MYSQL instanceAndrew Moore23 Aug
  • Re: Reg...My Hung MYSQL instanceDhaval Jaiswal23 Aug
  • Re: Reg...My Hung MYSQL instanceSuresh Kuna23 Aug
    • Re: Reg...My Hung MYSQL instanceJohan De Meersman23 Aug
      • RE: Reg...My Hung MYSQL instanceShafi AHMED25 Aug
Re: Reg...My Hung MYSQL instanceJohan De Meersman25 Aug
  • RE: Reg...My Hung MYSQL instanceShafi AHMED25 Aug
Re: Reg...My Hung MYSQL instanceMySQL)25 Aug