> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org