mysql guru??

2012-01-20 Thread bruce
Hi. Got a major pain that I'm trying to solve using mysql. Trying to handle a hierarchical tree structure, where I have a parent/child structure that grows as data is added to the system. The process needs to continuously determine if the overall tree, and all the associated nodes/leafs have

Re: mysql guru??

2012-01-20 Thread Walter Heck - OlinData.com
Relational databases are not very suitable for representing graph-style data. You might want to look into graph databases, or the OQGraph engine for MySQL: http://openquery.com/products/graph-engine good luck! Walter On Fri, Jan 20, 2012 at 13:54, bruce badoug...@gmail.com wrote: Hi. Got a

Re: mysql guru??

2012-01-20 Thread Larry Martell
On Fri, Jan 20, 2012 at 5:08 AM, Walter Heck - OlinData.com li...@olindata.com wrote: Relational databases are not very suitable for representing graph-style data. You might want to look into graph databases, or the OQGraph engine for MySQL: http://openquery.com/products/graph-engine Or take a

Re: mysql guru??

2012-01-20 Thread nigel wood
On 20/01/12 11:54, bruce wrote: Hi. Got a major pain that I'm trying to solve using mysql. Trying to handle a hierarchical tree structure, where I have a parent/child structure that grows as data is added to the system. The process needs to continuously determine if the overall tree,

Re: mysql guru??

2012-01-20 Thread Peter Brawley
On 1/20/2012 5:54 AM, bruce wrote: Hi. Got a major pain that I'm trying to solve using mysql. Trying to handle a hierarchical tree structure, where I have a parent/child structure that grows as data is added to the system. The process needs to continuously determine if the overall tree, and