There are a number of nested set solutions that have been found using standard SQL. Have you done a google search for "sql nested sets"?
Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Eugene Sent: Sunday, February 29, 2004 10:44 AM To: cfczone; CF-Talk Subject: [CFCDev] OT: A Good Data Structure for a Large Binary Tree I am trying to solve a Binary Tree data structure problem, i think this can be done from a DataBase Perspective with relations but then that might involve doing something like a matrix to develop the relations between nodes. The other thought i have is solve the problem by using some native(Java/C++) data Structure (Binary Tree /TreeMap) and store keys of the database structure as keys of the Binary Tree... that might relate to a simple select. Any ideas are much appreciated. Thanks, Joe Eugene ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
