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 al

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 t

Re: mysql guru??

2012-01-20 Thread Larry Martell
On Fri, Jan 20, 2012 at 5:08 AM, Walter Heck - 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 look at Gremlin

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 wrote: > Hi. > > Got a major pain that I'

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 "co