dbTalk Databases Forums  

Normalizing Tree Data

comp.databases.theory comp.databases.theory


Discuss Normalizing Tree Data in the comp.databases.theory forum.

Reply
 
Thread Tools Display Modes
  #21  
Old   
Bob Badour
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 02:41 PM






cr113 wrote:

Quote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:


What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.


Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
Division
Manager
Employee
What are your most important queries using the tree?




Reply With Quote
  #22  
Old   
Bob Badour
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 02:41 PM






cr113 wrote:

Quote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:


What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.


Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
Division
Manager
Employee
What are your most important queries using the tree?


Reply With Quote
  #23  
Old   
Bob Badour
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 02:41 PM



cr113 wrote:

Quote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:


What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.


Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
Division
Manager
Employee
What are your most important queries using the tree?


Reply With Quote
  #24  
Old   
Bob Badour
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 02:41 PM



cr113 wrote:

Quote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:


What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.


Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
Division
Manager
Employee
What are your most important queries using the tree?


Reply With Quote
  #25  
Old   
Bob Badour
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 02:41 PM



cr113 wrote:

Quote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:


What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.


Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
Division
Manager
Employee
What are your most important queries using the tree?


Reply With Quote
  #26  
Old   
cr113
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 04:03 PM



On Feb 8, 2:41*pm, Bob Badour <bbad... (AT) pei (DOT) sympatico.ca> wrote:
Quote:
cr113 wrote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:

What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.

Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
* * Division
* * * * Manager
* * * * * * Employee

What are your most important queries using the tree?- Hide quoted text -
I'm not sure. It depends on how I set up my tables. I'll need to be
able to display the entire tree (using a TreeView object in Visual
Studio if you are familiar with that). Add/Edit nodes. Delete a node
and it's underlying children.

Have you looked at the way my tables are set up in my example? Am I at
least in the ballpark? Should I include a "level" field in the ID
table perhaps (root = level 0, children of root = level 1, etc)?



Reply With Quote
  #27  
Old   
cr113
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 04:03 PM



On Feb 8, 2:41*pm, Bob Badour <bbad... (AT) pei (DOT) sympatico.ca> wrote:
Quote:
cr113 wrote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:

What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.

Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
* * Division
* * * * Manager
* * * * * * Employee

What are your most important queries using the tree?- Hide quoted text -
I'm not sure. It depends on how I set up my tables. I'll need to be
able to display the entire tree (using a TreeView object in Visual
Studio if you are familiar with that). Add/Edit nodes. Delete a node
and it's underlying children.

Have you looked at the way my tables are set up in my example? Am I at
least in the ballpark? Should I include a "level" field in the ID
table perhaps (root = level 0, children of root = level 1, etc)?



Reply With Quote
  #28  
Old   
cr113
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 04:03 PM



On Feb 8, 2:41*pm, Bob Badour <bbad... (AT) pei (DOT) sympatico.ca> wrote:
Quote:
cr113 wrote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:

What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.

Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
* * Division
* * * * Manager
* * * * * * Employee

What are your most important queries using the tree?- Hide quoted text -
I'm not sure. It depends on how I set up my tables. I'll need to be
able to display the entire tree (using a TreeView object in Visual
Studio if you are familiar with that). Add/Edit nodes. Delete a node
and it's underlying children.

Have you looked at the way my tables are set up in my example? Am I at
least in the ballpark? Should I include a "level" field in the ID
table perhaps (root = level 0, children of root = level 1, etc)?



Reply With Quote
  #29  
Old   
cr113
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 04:03 PM



On Feb 8, 2:41*pm, Bob Badour <bbad... (AT) pei (DOT) sympatico.ca> wrote:
Quote:
cr113 wrote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:

What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.

Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
* * Division
* * * * Manager
* * * * * * Employee

What are your most important queries using the tree?- Hide quoted text -
I'm not sure. It depends on how I set up my tables. I'll need to be
able to display the entire tree (using a TreeView object in Visual
Studio if you are familiar with that). Add/Edit nodes. Delete a node
and it's underlying children.

Have you looked at the way my tables are set up in my example? Am I at
least in the ballpark? Should I include a "level" field in the ID
table perhaps (root = level 0, children of root = level 1, etc)?



Reply With Quote
  #30  
Old   
cr113
 
Posts: n/a

Default Re: Normalizing Tree Data - 02-08-2008 , 04:03 PM






On Feb 8, 2:41*pm, Bob Badour <bbad... (AT) pei (DOT) sympatico.ca> wrote:
Quote:
cr113 wrote:
On Feb 8, 11:42 am, TroyK <cs_tr... (AT) juno (DOT) com> wrote:

On Feb 8, 10:10 am, cr113 <cr... (AT) hotmail (DOT) com> wrote:

What's the simplest way to set up a relationional database with tree
data? I'm more interested in simplicity vs speed.

snip - see OP

People will be able to guide you better if you can expand more on what
criteria are important to you.

Here are some specifics: I'm using Access. There will only be a few
thousand records maximum in any table. Around 4-6 fields in each
table. Very few concurrent users. The users need to be able to add/
edit/delete any of the nodes in the tree. There are 4 levels in the
tree. Expanding the previous example it would look something like
this:

Company
* * Division
* * * * Manager
* * * * * * Employee

What are your most important queries using the tree?- Hide quoted text -
I'm not sure. It depends on how I set up my tables. I'll need to be
able to display the entire tree (using a TreeView object in Visual
Studio if you are familiar with that). Add/Edit nodes. Delete a node
and it's underlying children.

Have you looked at the way my tables are set up in my example? Am I at
least in the ballpark? Should I include a "level" field in the ID
table perhaps (root = level 0, children of root = level 1, etc)?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.