Nothing to do with relational databases, but if you are developing for a future animal husbandry environment I would plan on supporting clones. Like it philosophically or not.
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Ibrahim A Sent: Thursday, June 04, 2009 5:59 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Db design question (so. like a tree) Jan schrieb: > Hi, > > I am planning a database for animal breeding. I need to store the > relations between individuals and therefore I have to build something > like a tree structure. But of course with two parents (There wont be > cloned animals in the database .-) afaik) > > I read a little bit about > > - adjacency list (not very difficult to understand) > - nested sets (hm, more difficult) > - b tree (to difficult) > - ? (something I missed?) > > Could anyone give me an advice what to use or what else to read? Maybe > someone has already done something similar e.g. genealogy. > > Bye > Jan > ... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
