design multilevel marketing database

Closed Posted Dec 27, 2004 Paid on delivery
Closed Paid on delivery

I am designing a database for a multilevel marketing company. The database will store hiearchical data in child-parent relationships, so that a tree data structure is formed. I specifically need to be able to quickly determine the entire "upline" or "downline" or for a given person. An upline includes all the parent entities, grandparent entities, and great grandparent entities etc., for a given person.

I need your help designing the the best and fastest database structure to do this. Specific instructions on how to design the database, or links to websites that describe how to build this design would be useful.

I have already built a basic "relational" database structure that contains the parent child relationship like this, but I need something better:

parent child

1 2

2 3

2 4

4 5

But in order to find all the parents of 5, you have to recursively loop through the database. This is slow. I need a database structure that would more quickly enable me to find all the parents of 5. (in this example it would be 4,2,1).

thanks for bidding!

## Deliverables

Specific instructions on how to design the database, or links to websites that describe how to build this design.

## Platform

doesn't really matter. I can adapt the design to my specific database.

Database Administration Engineering MySQL PHP Software Architecture Software Testing SQL

Project ID: #3494847

About the project

6 proposals Remote project Active Dec 29, 2004

6 freelancers are bidding on average $11 for this job

phpdevteam

See private message.

$4.25 USD in 4 days
(57 Reviews)
5.4
rajgrandhe

See private message.

$8.5 USD in 4 days
(17 Reviews)
4.8
pramodsinha301

See private message.

$17 USD in 4 days
(6 Reviews)
3.7
yevgenyt

See private message.

$14.45 USD in 4 days
(9 Reviews)
2.6
itproff2004

See private message.

$17 USD in 4 days
(24 Reviews)
2.4
madaanvw

See private message.

$4.25 USD in 4 days
(7 Reviews)
1.6