Re: Best Way to store Hierarchical Data in Mysql
On 8/19/2011 5:10 AM, Adarsh Sharma wrote: Dear all, 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. Several ways, see http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html. PB - Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Best Way to store Hierarchical Data in Mysql
> 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
Re: Best Way to store Hierarchical Data in Mysql
Its Ok, it happen sometimes. Alex Schaft wrote: Apologies. I hid reply to on the wrong message On 2011/08/19 12:10 PM, Adarsh Sharma wrote: Dear all, 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. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Best Way to store Hierarchical Data in Mysql
Dear all, 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. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
