Single surname database

[John Ellingsworth]

Hello.

Does anyone know of a 'single surname database' for managing their
information?

Does anyone use one? Is it in a relational database, or a gedcom?

Anyone have a template? I will eventually do it myself if I need to,
but I'd hate to reinvent the wheel.

Is anyone interested in starting such a project, if there isn't one
available?

Any thoughts most appreciated.

Thanks in advance.

John

[Lesley Robertson]

"John Ellingsworth" <[email protected]> wrote in message
news:[email protected]...

Hello.

Does anyone know of a 'single surname database' for managing their
information?
Does anyone use one? Is it in a relational database, or a gedcom?
Anyone have a template? I will eventually do it myself if I need to, but
I'd hate to reinvent the wheel.
Is anyone interested in starting such a project, if there isn't one
available?

Your best bet is to have a look at what's happening with GOONS (the Guild of

One Name Studies) since they've been doing this sort of thing for a long
time.
They have a mailing list whose deatils are here:
http://lists.rootsweb.com/index/other/G ... GOONS.html
Their web site is here http://www.one-name.org/intro.html
Lesley Robertson

[Steve Hayes]

On Tue, 25 Jan 2005 11:55:12 -0500, John Ellingsworth
<[email protected]> wrote:

Hello.

Does anyone know of a 'single surname database' for managing their
information?

It's not clear what you mean.

Are you talking about an actual collection of data, or a database progam?

Does anyone use one? Is it in a relational database, or a gedcom?

Do you want to know how other people collect and manage data relating to a
single surname? Do you want to know what software they use, or how they
designed the database, or both?

Anyone have a template? I will eventually do it myself if I need to,
but I'd hate to reinvent the wheel.

Is anyone interested in starting such a project, if there isn't one
available?

Do you mean a project for collecting data on a particular surname, or
designing a database for holding the information?


--
Steve Hayes from Tshwane, South Africa
http://www.geocities.com/Athens/7734/stevesig.htm
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

[John Ellingsworth]

Hi Steve.

Thanks for replying.

It's not clear what you mean.

Are you talking about an actual collection of data, or a database progam?

SQL (not necessarily any particular RDBMS) for storing their surname
collection - not just of their family but of an entire surname - that is
what I am interested in.

Does anyone use one? Is it in a relational database, or a gedcom?


Do you want to know how other people collect and manage data relating to a
single surname? Do you want to know what software they use, or how they
designed the database, or both?

I want to know if someone has created (or knows of) a SQL based
application for managing their single surname information.

Anyone have a template? I will eventually do it myself if I need to,
but I'd hate to reinvent the wheel.

Is anyone interested in starting such a project, if there isn't one
available?


Do you mean a project for collecting data on a particular surname, or
designing a database for holding the information?

Designing a database for holding the information on the surname of the
users choice.

Sorry for not being clear.

John

[Gjest]

On Wed, 26 Jan 2005 08:48:47 -0500, John Ellingsworth
<[email protected]> wrote:

Designing a database for holding the information on the surname of the
users choice.

Why not just use one of the available genealogy applications like Legacy? It
uses MSAccess as its underlying database.

I use it for my one name studies ... all individuals with surname XXX in a
particular village in central europe. When I see connections I then can easily
piece families together.

--

Dennis K.

[John Ellingsworth]

Thanks Dennis.

Why not just use one of the available genealogy applications like Legacy? It
uses MSAccess as its underlying database.

I use it for my one name studies ... all individuals with surname XXX in a
particular village in central europe. When I see connections I then can easily
piece families together.

How does it handle large groups of unconnected individuals except surname?

I have read a little about Custodian (thanks Steve Hayes) and am looking
into it further.

The most important thing to me is that the data be stored in a
relational database so that I can access it through whatever API I
choose (such as web or RDBMS interface).

[Gjest]

On Wed, 26 Jan 2005 09:42:44 -0500, John Ellingsworth
<[email protected]> wrote:

How does it handle large groups of unconnected individuals except surname?

There is a free version of the program if you want to play around with it.

http://www.legacyfamilytree.com/

--

Dennis K.

[Charlie]

On Wed, 26 Jan 2005 09:42:44 -0500, John Ellingsworth
<[email protected]> wrote:

Thanks Dennis.


Why not just use one of the available genealogy applications like Legacy? It
uses MSAccess as its underlying database.

I use it for my one name studies ... all individuals with surname XXX in a
particular village in central europe. When I see connections I then can easily
piece families together.


How does it handle large groups of unconnected individuals except surname?

I have read a little about Custodian (thanks Steve Hayes) and am looking
into it further.

The most important thing to me is that the data be stored in a
relational database so that I can access it through whatever API I
choose (such as web or RDBMS interface).

Dennis' suggestion is a good one, but you needn't limit yourself to
Legacy. Just about any genealogy program can be utilized with a little
bit of effort. For example, any program that will allow you to
generate a custom report (like even FTM, for example). Just generate
the report with the fields you want to search with your database, then
import that report into the database. I use Access and it is
incredibly easy to start with a 20,000 individual database in FTM or
RM, and have all the pertinant data into Access within a half hour.
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

[Bob Melson]

On Wed, 26 Jan 2005 08:48:47 -0500, John Ellingsworth wrote:

Hi Steve.

Thanks for replying.

It's not clear what you mean.

Are you talking about an actual collection of data, or a database
progam?


SQL (not necessarily any particular RDBMS) for storing their surname
collection - not just of their family but of an entire surname - that is
what I am interested in.


Does anyone use one? Is it in a relational database, or a gedcom?


Do you want to know how other people collect and manage data relating to
a single surname? Do you want to know what software they use, or how
they designed the database, or both?


I want to know if someone has created (or knows of) a SQL based
application for managing their single surname information.


Anyone have a template? I will eventually do it myself if I need to,
but I'd hate to reinvent the wheel.

Is anyone interested in starting such a project, if there isn't one
available?


Do you mean a project for collecting data on a particular surname, or
designing a database for holding the information?



Designing a database for holding the information on the surname of the
users choice.

Sorry for not being clear.

John

John:

You might want to look at something like the Genes database, which you can
find at http://genes.sourceforge.net. While the application is intended
primarily for Linux systems, the schema appears to be well thought out and
could be what you're looking for in order to avoid reinvention of the
wheel.

Keep in mind that SQL is a language describing operations on a
database and that no two RDBMSs share exactly the same dialect of that
language. The real utility of a database lies in the schema by which
information is stored and "related". From what you describe, I think the
genes schema may meet your needs without significant modification. Give
it a look.

HTH,
Bob Melson


--
Robert G. Melson | Nothing is more terrible than
Rio Grande MicroSolutions | ignorance in action.
El Paso, Texas | Goethe
melsonr(at)earthlink(dot)net

[John Ellingsworth]

Thanks Bob.

That is a great start.

John:

You might want to look at something like the Genes database, which you can
find at http://genes.sourceforge.net. While the application is intended
primarily for Linux systems, the schema appears to be well thought out and
could be what you're looking for in order to avoid reinvention of the
wheel.

Keep in mind that SQL is a language describing operations on a
database and that no two RDBMSs share exactly the same dialect of that
language. The real utility of a database lies in the schema by which
information is stored and "related". From what you describe, I think the
genes schema may meet your needs without significant modification. Give
it a look.

HTH,
Bob Melson

[Steve Hayes]

On Wed, 26 Jan 2005 08:48:47 -0500, John Ellingsworth
<[email protected]> wrote:

Do you mean a project for collecting data on a particular surname, or
designing a database for holding the information?



Designing a database for holding the information on the surname of the
users choice.

OK, so if I understand you correctly you want to know what database structure
(fields etc) people use for one-name studies, and if there is any widely used
structure?

Here's one I have used:

Define Data Structure
Name of structure: FAMHIST
Description line (optional): Family history - people notes
Record ID field(s): RECID
Order key field(s): NAME
LABEL NAME INDEX SORT EMPHASIS
ID RECID T 7 1
NA NAME Y 5 1
RIN * T 7 1
BO BORN Y 4 1
BA BAPTISED Y 4 1
DI DIED Y 4 1
BU BURIED Y 4 1
FA FATHER Y 5 1
FR FRIN T 7 1
MO MOTHER Y 5 1
MR MRIN T 7 1
SP SPOUSE Y 9 1
CH CHILD Y 9 1
OR OTHERREL Y 9 1
KE KEYWORDS K 9 1
UD UPDATED T 4 1
BI BIOGRAPHY K 9 1
SO SOURCES N
QU QUERIES K 9 1
NO NOTES K 9 1
RE RESEARCH K 9 1
AD ADDRESS N
RES RESIDENCE N
PH PHONE N
EM EMAIL N
WE WEB N

Stop words: A AN AND BY FOR FROM IN OF ON THE TO WITH
Leading articles: THE A AN

It's not SQL, and I actually use it for different surnames, but it could just
as easily be used for a one-name study.

I just wondered if that was the kind of thing you are looking for?


--
Steve Hayes from Tshwane, South Africa
http://www.geocities.com/Athens/7734/stevesig.htm
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

[Sam Dellit]

g'day john and the list

i am working on a worldwide one
name study of the dellit surname
including variants dellith, dellitt,
dellet, dellett, dellette, dellid (with
more to follow). the name is primarily
germany based, but there are also
small groups of the same name in
ireland and france. all 3 sources
also migrated to america, and the
germans also came to australia.

the name is very scarce (perhaps only
3000 persons have ever carried the
name over 5 centuries, so my approach
may not work for larger studies. also
the vast majority of those persons
descend from a single individual living
in kleinschmalkalden germany 1550s
and my main interest is linking as many
as possible back to that hans urban dellith.
i am using a standard genie program
(PAF5.2) and double entering the data,
once into the multiple lineage trees, and
once into an indexed structure within the
program using the standard family groups.
eg :
USA Soundex Dellit
USA Dellit
USA Dellit (Social Security DI)
Each Dellit in the SSDI
USA Dellit (Census 1930)
Each Dellit USA Census 1930
USA Dellit (Census 1920)
USA Dellit (Census 1910)
USA Dellit (Census 1900)
USA Dellit (Census 1880)
USA Dellit (Census 1870)
USA Dellit (Census 1860)
USA Dellit (Census 1850)
USA Dellit (Census 1840)
USA Dellith
USA Dellith (SSDI)
USA Dellith (Census 1930)
USA Dellith (Census 1920)
USA Dellith (Census 1910)
USA Dellith (Census 1900)
USA Dellith (Census 1880)
USA Dellith (Census 1870)
USA Dellith (Census 1860)
USA Dellith (Census 1850)
USA Dellith (Census 1840)
USA Dellitt
USA Dellet
USA Dellett
USA Dellette
While a custom access database might
give me more flexibility with data entry
and analysis, i prefer doing everything
within one program and the reality is
that it is the data extraction which is the
most time consuming, not the data entry
and analysis. have a look at my structure
on rootsweb and see if it suits your needs :
http://worldconnect.rootsweb.com/cgi-bi ... t&id=I9334
regards

sam dellit tamborine australia

[LaBear]

KeyNote: Tabbed notebook and personal information manager, with tree
structure and strong encryption. Open source.
KeyNote: Features overview
A list of features and functions, no matter how detailed, will not do
full justice to KeyNote. The program has been carefully designed to be
very flexible yet easy to use. One of the most important qualities of
an application is what it doesn't do: get in your way as you're doing
your work. KeyNote's power becomes visible through its use; you can
combine functions to achieve novel results and bend the program to your
needs.
KeyNote is used by screenwriters to draft screenplays, by medical
doctors to keep patient databases, by developers to store source code
snippets - and to everyone it serves as a place to put all the random
pieces of information that have no particular structure of relationship
to other data, and do not fit easily in task-specific applications such
as word-processors, databases or spreadsheets. As you use KeyNote, it
will tend to grow on you and every day you will discover more ways to
use it. Store many separate notes within one file; each note is
displayed on its own, easily accessible tab. This is a much more
convenient solution than opening several files on disk. Each note has
independent font, color and editor settings.
Choose between two types of notes: a simpler, editor-only note, or a
tree-type note, which is a multi-level hierarchy of "branches", each
with its own note. The two types of notes can be mixed freely within
one file
Tree type notes can be arranged horizontally (tree panel to the left of
editor) or vertically (tree panel above the editor)
Ability to create user-defined styles for text and paragraph properties

Convenient keyboard shortcuts for all editing and file management
commands
Option to minimize to system tray
Configurable activation hotkey to bring the program window to front
after it was minimized to the system tray