473,395 Members | 2,443 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Tree Structure

So I know you can't outright make a simple tree structure in SQL, but I
could sure use some help figuring out how get around it. I wanted to develop
a simple picture gallery where you put picture in categories, and each
category can have subcatergories, and each subcategory can have
subcategories...and so on. I want to try and keep the processing minimal
since this is just a simple picture gallery. Anyone have any suggestions?
Jul 19 '05 #1
6 6653
The following link contains an excellent article titled explaining the
two majow methods to of dealing with heirarchical data in databases:
http://www.sitepoint.com/article/1105

I had the same problem and found this very useful. Hope it gets you on
the right track.
Jul 19 '05 #2
The following link contains an excellent article titled explaining the
two majow methods to of dealing with heirarchical data in databases:
http://www.sitepoint.com/article/1105

I had the same problem and found this very useful. Hope it gets you on
the right track.
Jul 19 '05 #3
The following link contains an excellent article titled explaining the
two majow methods to of dealing with heirarchical data in databases:
http://www.sitepoint.com/article/1105

I had the same problem and found this very useful. Hope it gets you on
the right track.
Jul 19 '05 #4
Ray
"Amit Varia" <sp**@amitvaria.com> wrote in message news:<bu**********@geraldo.cc.utexas.edu>...
So I know you can't outright make a simple tree structure in SQL, but I
could sure use some help figuring out how get around it. I wanted to develop
a simple picture gallery where you put picture in categories, and each
category can have subcatergories, and each subcategory can have
subcategories...and so on. I want to try and keep the processing minimal
since this is just a simple picture gallery. Anyone have any suggestions?


I have a genealogy database in MySQL, with 40k records of
inter-related people. So a tree is definitely do-able. Basically
just have a field that references the primary key of another record.
Jul 19 '05 #5
Ray
"Amit Varia" <sp**@amitvaria.com> wrote in message news:<bu**********@geraldo.cc.utexas.edu>...
So I know you can't outright make a simple tree structure in SQL, but I
could sure use some help figuring out how get around it. I wanted to develop
a simple picture gallery where you put picture in categories, and each
category can have subcatergories, and each subcategory can have
subcategories...and so on. I want to try and keep the processing minimal
since this is just a simple picture gallery. Anyone have any suggestions?


I have a genealogy database in MySQL, with 40k records of
inter-related people. So a tree is definitely do-able. Basically
just have a field that references the primary key of another record.
Jul 19 '05 #6
Ray
"Amit Varia" <sp**@amitvaria.com> wrote in message news:<bu**********@geraldo.cc.utexas.edu>...
So I know you can't outright make a simple tree structure in SQL, but I
could sure use some help figuring out how get around it. I wanted to develop
a simple picture gallery where you put picture in categories, and each
category can have subcatergories, and each subcategory can have
subcategories...and so on. I want to try and keep the processing minimal
since this is just a simple picture gallery. Anyone have any suggestions?


I have a genealogy database in MySQL, with 40k records of
inter-related people. So a tree is definitely do-able. Basically
just have a field that references the primary key of another record.
Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Steve Johnson | last post by:
Been banging my head on this for two days now. Hope someone can help! My test program below is in the form of a single JSP, with a Node class build in. (All the coded needed to run is below.) ...
2
by: ragha | last post by:
Dear friends I am emulating thr tree structure mentioned in the article http://www.15seconds.com/issue/010921.htm I have succesfully created the folder structure for level 2 I need this...
1
by: googleo | last post by:
Hi, in my application I want to handle and store data in a hierarchic data structure. For example: persons who manage houses; houses have various numbers of floors; floors have various numbers...
1
by: Srihari | last post by:
I'm trying to develop a tree structure using javascript. The node values of the tree are generating from a mysql table depending on login. The tree structure contains 3 sub levels. I developed...
4
by: Stephan Tobies | last post by:
Hi everyone, I am looking for a good data structure that could be used to represent families of trees with shared sub-trees and copy-on-write semantics. On a very abstract level, I would like...
3
by: _DS | last post by:
Problem with mapping a directory tree to a tree control: It takes a while to recurse subdirs and map them to nodes. This is solved in some books I've seen (MacDonald, Albahari) by reading the...
1
by: David Hirschfield | last post by:
I've written a tree-like data structure that stores arbitrary python objects. The objective was for the tree structure to allow any number of children per node, and any number of root nodes...and...
5
by: hankypan1 | last post by:
Hi All, I need a tree data structure for my application. It is the non -cyclic simple tree where i can have any number of children node and each child can recursively become a sub tree like a...
8
by: =?ISO-8859-1?Q?m=E9choui?= | last post by:
Problem: - You have tree structure (XML-like) that you don't want to create 100% in memory, because it just takes too long (for instance, you need a http request to request the information from...
0
by: mac | last post by:
I found that with memory allocating techniques used nowadays (addresses alignment, eg. on 32bit machines) one can detect loops in a tree structure very fast, without using extra memory. This is due...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.