Re: Ancestry program
On Tuesday 28 October 2003 11:24 am, Dathan Vance Pattishall wrote: > Think of a binary tree. > > Parent_id auto increment > Child_id > > Details of the famly > > The head of the family has a child_id == parent_id > > All members of the family have different child_ids but the same > parent_id > > Then you can do some really cool recursive fast searches. But this does NOT work well for real life genealogy. Think of step/half families, etc. No, better to look at system's that deal with this. Look at GEDCOM, genxml, or similar systems. I know I have seen several gedcom -> sql schema's out there, some for mysql even. There are also several systems for archiving information such as family events or media, and linking those people to that data. -- Jayce^ pgp0.pgp Description: signature
Re: Ancestry program
Thanks for all your help, but my main problem now is, how to show the relationships. I mean, OK, I trace the names in my database, but how to show the relationship to the user, searching for it? Should I draw a complete tree that means all the people involved between the actual two, or I dont really understand it. Any ideas? Anyway thanx again for your great help. Nitin - Original Message - From: "Brad Teale" <[EMAIL PROTECTED]> To: "'Dan Greene'" <[EMAIL PROTECTED]>; "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 29, 2003 1:39 AM Subject: RE: Ancestry program > It has been a while since I have looked, but I believe the National > Genealogical Society has a data model for family tree software. The > following links are to the NGS and GEDCOM is the file format standard. > I think it should be an easy conversion to a database structure. If you > do something that exports the data, it should probably export in the > GEDCOM format because that is what most software packages will import. > > http://www.ngsgenealogy.org/ > http://www.gentech.org/ngsgentech/main/Home.asp > > GEDCOM seems to be the standard file format: > http://www.gendex.com/gedcom55/55gctoc.htm > > Brad > > -Original Message- > From: Dan Greene [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 28, 2003 12:49 PM > To: Nitin; [EMAIL PROTECTED] > Subject: RE: Ancestry program > > > well... when I do db design, I tend to start with the objects of my system. > The one that comes to mind in your case is people. > > so you'll need a people table. > > well what are the details of a person? > first_name > Last_name > Middle_name1 > Middle_name2 > Maiden_name > [any other basic bio data] > > > so you'll need those columns > > Well to keep track of each person, each one will need an ID... id's are > usually numbers, so now you add a: > person_id > field. This field would likely have an auto_increment attribute to help > number them for you > > ok... now that we have people, what else do we need? relationships between > them well... in terms of human beings, everyone has one biological > mother and one biological father, so we add in > > mother_id > father_id > > leaving the values of these as null would be equivalent of being 'unknown' > > and we now have, data-wise, a system that can trace biological heritage, can > handle siblings and half-siblings. > > Other ideas for objects: > > Marrages > - this one would be tricky/interesting, as marrages can change over time, > and people can have multiple marrages (although usually not two at a time, > unless bigamy is allowed in your user's state/country). Strictly speaking, > marrages are not necessary to trace heritage, but are good info... > > > > > > -->From: Nitin [mailto:[EMAIL PROTECTED] > > -->Sent: Monday, October 27, 2003 10:46 PM > > -->To: [EMAIL PROTECTED] > > -->Subject: Ancestry program > > --> > > -->Hi all, > > --> > > -->I'm developing a web based ancestry program. The user > > wants it to be > > -->static, that means, it isn't for all to use, but his family. Better > > to > > -->say, it'll contain only his family tree. > > --> > > -->Now, I cant think of the proper db design, which will help any user > > to > > -->find his or her relationship with any other person in the tree. > > Though, I > > -->can design a simple database, where everything will have to be done > > -->through queries and scripts, but I want those queries to keep as > > simple > > -->as possible. > > --> > > -->Any help will be appreciated, as I'm new to such a problem. > > --> > > -->Thanx in advance > > -->Nitin > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ancestry program
Around Tue,Oct 28 2003, at 12:15, Nitin, wrote: > Hi all, > > I'm developing a web based ancestry program. The user wants it to be static, that > means, it isn't for all to use, but his family. Better to say, it'll contain only > his family tree. > > Now, I cant think of the proper db design, which will help any user to find his or > her relationship with any other person in the tree. Though, I can design a simple > database, where everything will have to be done through queries and scripts, but I > want those queries to keep as simple as possible. > > Any help will be appreciated, as I'm new to such a problem. > There's a 'ged2db' utility that converts from GED format to a database. I believe it converts from GED to mysql, postgresql and other formats. -- Roger Morris [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Ancestry program
It has been a while since I have looked, but I believe the National Genealogical Society has a data model for family tree software. The following links are to the NGS and GEDCOM is the file format standard. I think it should be an easy conversion to a database structure. If you do something that exports the data, it should probably export in the GEDCOM format because that is what most software packages will import. http://www.ngsgenealogy.org/ http://www.gentech.org/ngsgentech/main/Home.asp GEDCOM seems to be the standard file format: http://www.gendex.com/gedcom55/55gctoc.htm Brad -Original Message- From: Dan Greene [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:49 PM To: Nitin; [EMAIL PROTECTED] Subject: RE: Ancestry program well... when I do db design, I tend to start with the objects of my system. The one that comes to mind in your case is people. so you'll need a people table. well what are the details of a person? first_name Last_name Middle_name1 Middle_name2 Maiden_name [any other basic bio data] so you'll need those columns Well to keep track of each person, each one will need an ID... id's are usually numbers, so now you add a: person_id field. This field would likely have an auto_increment attribute to help number them for you ok... now that we have people, what else do we need? relationships between them well... in terms of human beings, everyone has one biological mother and one biological father, so we add in mother_id father_id leaving the values of these as null would be equivalent of being 'unknown' and we now have, data-wise, a system that can trace biological heritage, can handle siblings and half-siblings. Other ideas for objects: Marrages - this one would be tricky/interesting, as marrages can change over time, and people can have multiple marrages (although usually not two at a time, unless bigamy is allowed in your user's state/country). Strictly speaking, marrages are not necessary to trace heritage, but are good info... > -->From: Nitin [mailto:[EMAIL PROTECTED] > -->Sent: Monday, October 27, 2003 10:46 PM > -->To: [EMAIL PROTECTED] > -->Subject: Ancestry program > --> > -->Hi all, > --> > -->I'm developing a web based ancestry program. The user > wants it to be > -->static, that means, it isn't for all to use, but his family. Better > to > -->say, it'll contain only his family tree. > --> > -->Now, I cant think of the proper db design, which will help any user > to > -->find his or her relationship with any other person in the tree. > Though, I > -->can design a simple database, where everything will have to be done > -->through queries and scripts, but I want those queries to keep as > simple > -->as possible. > --> > -->Any help will be appreciated, as I'm new to such a problem. > --> > -->Thanx in advance > -->Nitin > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Ancestry program
well... when I do db design, I tend to start with the objects of my system. The one that comes to mind in your case is people. so you'll need a people table. well what are the details of a person? first_name Last_name Middle_name1 Middle_name2 Maiden_name [any other basic bio data] so you'll need those columns Well to keep track of each person, each one will need an ID... id's are usually numbers, so now you add a: person_id field. This field would likely have an auto_increment attribute to help number them for you ok... now that we have people, what else do we need? relationships between them well... in terms of human beings, everyone has one biological mother and one biological father, so we add in mother_id father_id leaving the values of these as null would be equivalent of being 'unknown' and we now have, data-wise, a system that can trace biological heritage, can handle siblings and half-siblings. Other ideas for objects: Marrages - this one would be tricky/interesting, as marrages can change over time, and people can have multiple marrages (although usually not two at a time, unless bigamy is allowed in your user's state/country). Strictly speaking, marrages are not necessary to trace heritage, but are good info... > -->From: Nitin [mailto:[EMAIL PROTECTED] > -->Sent: Monday, October 27, 2003 10:46 PM > -->To: [EMAIL PROTECTED] > -->Subject: Ancestry program > --> > -->Hi all, > --> > -->I'm developing a web based ancestry program. The user > wants it to be > -->static, that means, it isn't for all to use, but his family. Better > to > -->say, it'll contain only his family tree. > --> > -->Now, I cant think of the proper db design, which will help any user > to > -->find his or her relationship with any other person in the tree. > Though, I > -->can design a simple database, where everything will have to be done > -->through queries and scripts, but I want those queries to keep as > simple > -->as possible. > --> > -->Any help will be appreciated, as I'm new to such a problem. > --> > -->Thanx in advance > -->Nitin > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Ancestry program
Think of a binary tree. Parent_id auto increment Child_id Details of the famly The head of the family has a child_id == parent_id All members of the family have different child_ids but the same parent_id Then you can do some really cool recursive fast searches. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Nitin [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 10:46 PM -->To: [EMAIL PROTECTED] -->Subject: Ancestry program --> -->Hi all, --> -->I'm developing a web based ancestry program. The user wants it to be -->static, that means, it isn't for all to use, but his family. Better to -->say, it'll contain only his family tree. --> -->Now, I cant think of the proper db design, which will help any user to -->find his or her relationship with any other person in the tree. Though, I -->can design a simple database, where everything will have to be done -->through queries and scripts, but I want those queries to keep as simple -->as possible. --> -->Any help will be appreciated, as I'm new to such a problem. --> -->Thanx in advance -->Nitin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ancestry program
Try doing a web search for the program geneweb. It's done by someone in France but there are English versions as well. It's freeware. It's a web based genealogy program and has a built-in database. No need to reinvent the wheel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]