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 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 "completed" so not only is the > tree growing, but data for the given node/leaf is also changing, > > The system is comprised of a parent app which spawns descendant apps > that in turn can spawn descendant apps, and so on.. > > The system is represented in mysql as a parent/child tree, where each > spawned app has an ID, as well as a status for the completion status > of the app. > > I'm trying to find someone I can talk to regarding this, so I can get > clarity on how this can be implemented. > > The process needs to be able to: > -update the tree tbl with updated data from the running apps > -update the tbl with new nodes/leafs as the spawned apps are created > -quickly return 0/1 if the descendants of a node have been complete > > I've created a few different tbl defs, and played with a few different > approaches, but haven't got this right yet. I've looked at a number of > different articles covering hierarchical, adjacency models, closures, > etc... > > **The nested soln isn't applicable to the project, as the data/tree > tbl is continually growing, which would require a complete rebuilding > of the nested tbls, which would impose a computational/time hit on the > process. > > I can provide the sample tbl defs/data that I'm using, as well as more > data on what I'm trying to accomplish. > > So, if you're skilled in this area, let's talk. > > Thanks > > -bruce > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql